SUMMARY

Over 8 years of experience in enterprise-wide management and administration on distributed platforms and database infrastructure. Hands on Experience on multi-agent deployment, implementation, migration, support management using Tools - IBM InfoSphere Guardium SQLGuard , BMC Patrol, BPPM, and HP DMA

Professsional Expertise

Database Auditing

• Using IBM InfoSphere Guardium SQLGuard we provide Real-time database activity monitoring DAM for identifying unauthorized or suspicious activities, preventing attacks and blocking unauthorized access by privileged users
• Designed and Implemented Database auditing solution for Oracle, MSSQL, Sybase and DB2 on 10000 servers.
• Expertise in creating and providing security solutions for Monitor Enforce, Audit Reports and Compliance Workflow automation.
• Guardium administration -End to End setup like Build, Patch update, Migration to new versions, Configuration, Centralize management of SQLGuard Appliances.
• Provided Auditing solution and simplifying validation activities related to data integrity, data privacy
• Implementation, Maintenance and troubleshooting of Agents STAP,GIM Guardium appliances and provides root cause analysis with step by step documentation for complex problems
• Integration with internal compliance process, ArcSight.
• Identify the product bugs and liaise with support to fix the issue.

Vulnerability Assessment

• Predefine and custom tests to Assess and identify database vulnerabilities using FortiDB IP Locks and IBM Infosphere Guardium.
• Assess environment, find threats, recommended and prioritize action plan.
• VA Administration tasks like user management, Configuration of policy and different RDBMS to Portal and generate reports

Monitoring Event Management

• Design and Implement Database Monitoring solutions using BMC Products
• Rules and class development for better and custom event processing
• BMC Patrol KM development and modification to meet custom requirement of the customers
• Maintenance and troubleshooting of monitoring products, root cause analysis for complex problems
• BPPM event cell configuration propagation
• Design solution to monitor the monitors with shell PSL scripts which helps to avoid monitoring outage.
• Requirement gathering and proactive monitoring parameter baseline design Patrol Event Management Rules, BPPM Thresholds
• Ticketing system and Event integration with cross platform tools Service Now
• Minimize DBA support man hours by implementing tools

Automation

• HP DMA Infrastructure Maintenance and troubleshooting
• Design DMA workflow to simplify Database Tools agent installation Patrol, STAP

Technical SKILLS

• Database Auditing : IBM InfoSphere Guardium SQLGuard
• Vulnerability Assessment : FortiDB IP Locks , IBM InfoSphere Guardium SQLGuard
• ESM Monitoring Tools :BMC Performance Manager Patrol ,BMC ProactiveNet Performance Manager BPPM ,BMC Patrol Configuration Manager, BMC Performance Manager Portal, BMC Patrol Console and RT Server
• Automation Tool : HP Database and Middleware Automation
• Operating System : Microsoft Windows, Oracle Solaris, IBM AIX, Red Hat Enterprise Linux
• RDBMS : Oracle, MSSQL Server, Sybase ASE, IBM DB2

Work EXPERIENCE Details

Confidential

Summary : Ensuring global consistency, operational readiness and support of database tools used to support business aligned databases 10000 which includes Database Monitoring BPPM, BMC Patrol , Database Automation HP DMA , and Database Auditing/VA SQLGuard and FortiDB

BPPM/BMC Patrol

• Designed and implement monitoring solutions for Oracle, MSSQL, Sybase and DB2 on 10000 servers
• Installation and configuration of BMC Patrol agent based monitoring for database servers
• Maintenance and support of the BMC patrol monitoring infrastructure, the associated alerting system Alarm Point and the Reporting tools.
• Maintenance and troubleshooting of Patrol agents, Console server and RT server
• Deployment of BMC Agent less BMC portal monitoring solution.
• Trouble shoot the Production management reports like Health check, Critical parameters based on Patrol.
• User Management and Impersonation tables in Patrol Central Operator
• Patrol Configuration for high availability Database setup like ORACLE RAC, UNIX Cluster aware agent, MSSQL cluster configuration.
• Analyzing the past issues and bringing possible, implement able solutions, keeping in view the business security process.
• Liaise with BMC Support for custom monitoring request, complex and unknown issues.
• Configuring the monitors with required threshold values for various parameters.
• Maintenance and troubleshooting of Patrol agents and Console server
• Daily health check activities like Applying blackout for monitors during maintenance period
• and performance tuning
• Documenting, tracking, communicating test plans, test results, analysis, unresolved problems.

Confidential

Role : System and DBA Administrator Level I

Responsibilites

• Administrating the Database activities such as Creating Database, tables, indexes, triggers, store procedures, views and user groups.
• Assigning Logins to the users, mapping permissions and monitoring Users Access to the Objects.
• Maintain the databases such as monitoring Database size, usage and maintaining free space.
• Spanning Distributing the database files over different Storage Devices.
• Database Back up and restoring using schedule devices with minimum down time.
• Monitoring the Performance of the server and maintaining resources efficiently.
• Created some basic reports by using SQL Server2005 Reporting Service
• Transfer the logins over the different databases while database maintenance modes.
• Installation, configuration and patch update of SQL server software and related products.
• Done some System Administrator tasks like build new window servers, patch update of operating system MS windows 2003.
• Creating users and giving permission like disking quota, security policy and profiling creation in Windows 2003 server.