SUMMARY:

• A qualitative professional with over 12+ years of experience in supporting database issues for critical production sites and closely working with the application support team.
• Expertise noledge of oracle architecture, performance tuning, database monitoring, database backups and recovery, troubleshooting performance bottlenecks for both standalone & RAC databases in the production sites.
• Good noledge on planning and implementing the production databases to avoid any critical performance problems in future after site goes live.
• Having cross platform noledge across multiple RDBMS (Oracle, SQL Server, PostgreSQL, Sybase ASE/ IQ & AWS)

PROFESSIONAL EXPERIENCE:

Confidential

Lead DBA

Responsibilities:

• Serving as a role of Oracle SME, involving high priority issues, provide solution and recommendations.
• Managing DBA team in offshore with micro strategy, coordinating between Application team, onshore and offshore DBA team.
• Good noledge on tuning bad SQL query and DB performance, strong noledge on analyzing the AWR,ADDM, SQL - T reports, SPM and identifying the performance bottleneck.
• Having the noledge on SQL tuning advisor, OEM, 12c RAC, DB replication (Dataguard, Shareplex, gloden gate & MMR).
• Handling issues with related to tables and indexes as well as good understanding of optimizer join methods (like nested loop, hash join etc).
• Able to perform daily DBA activities such as resolving the ORA errors, RMAN backups, redirect db restore, daily monitoring of database etc.
• Dealing with different types of wait events and analyzed for solution for it and also good noledge on memory tuning for the instance.
• Coordinating new projects & initiatives from LOB team and driving it for completion.
• Setting up regular connects between LOB team and offshore team.
• Generating the monthly metrics and analyze the data for process improvement and resource optimization.
• Added new scope of work by implementing automation and process improvement without additional FTE.
• Developed the capability of the associates by identifying the gaps and addressed it with proper, development and mentoring.
• Participating and coordinating in the DR test & INDIA out exercise for various Infrastructure functions.

Lead DBA

Confidential

Responsibilities:

• Datawarehsouse Database Conversion to Teradata/Exadata and Shareplex V7/Gloden Gate Replication.
• Configuring Standby database (Real Application Cluster RAC) for High Availability and Disaster Recovery Solutions.
• Scheduling Quarterly Disaster Recovery Tests for all Critical Databases by bringing down the primary database and switching over to Disaster Recovery Site.
• Fine tuning poor performing SQL Statements using indepth precise, SQL Tuning Lab, FogLight, SpotLight and Oracle Enterprise Tuning Pack.
• Capacity Planning and Forecasting for Storage Space and CPU utilization.
• Database Health Checkup, applying Vulnerability patches, Database Maintenance using Oracle Enterprise Manager/Grid Control.
• Performing HOT and COLD Database backups using RMAN and SQL Backtrack for Oracle and Litespeed for SQL Server.
• Performing Dry Run backups to test integrity of the backups.
• Performing Point in Time database recovery as needed by application.
• Generate work load metrics for Incident Management, Change Management Problem Management on weekly basis and provide graphs to Senior Management.
• Diagnose and resolve Performance, Connectivity, Security and database corruption issues in critical production environments.
• Provide solutions for Data Masking for Non Public rmation (NPPI) Data like SSN, etc.
• Expert Server build/Managing Sybase ASE 15.0, 15.5,15.7 and Sybase Replication server 15.5 Administration
• Proficient in Trouble shooting, Scheduling Maintenance Jobs like DBCC, Update Stats, Monitoring Error Logs, Space management are part of my activities
• Configuring table level Replication and Multisite availability using Sybase Replication server
• Creating Replication Definition, subscriptions, configuring Rep Agents
• Trouble shooting Problems Raised Due to Replication thread
• Doing periodical health checks and tuning database for better performance

Primary DBA

Confidential

Responsibilities:

• Database Design and Creation of Databases, Schemas and Users.
• Backing up and restoring the Database.
• Rebuilding Index Segments to clear Fragmentation through automated UNIX shell script.
• Controlling and monitoring user access to the database.
• Configuring high availability (RAC) & Disaster Recovery site.
• Creation of Maintenance Plans for Backups, Statistics Updates and TSM
• To Check Event Log errors and to make necessary actions to rectify them.
• Export/Import of objects
• File system / Disk Space Monitoring
• Tuning the poor SQL Queries.
• Migrated 7 production databases size about 4 TB to Exadata.
• Performed partition of tables

Primary DBA

Confidential

Responsibilities:

• Installation, Configuration of ASM and Creation of Oracle 12c RAC database.
• Design Database and Creation of Users/Schemas.
• Configured Oracle Replication - Data Guard.
• Applied Disaster Recovery setup.
• Applied Security Patches for this Oracle database.
• Configured Database encryption.
• DB migration from EPH to LIM.

Secondary DBA

Confidential

Responsibilities:

• Ensure performance and scalability of PostgreSQL databases.
• Implement, refine and maintain database replication and failover.
• Install, tune and monitor Postgres database instances.
• Develop, refine and monitor recurring database jobs/scripts.
• Participate in database design for new features/functionality.
• SQL and PL/pgSQL coding.
• Query analysis and optimization.
• Data import and data migration.