SUMMARY

• Lead Oracle DBA with 10+ years of experience in Oracle Database Administration providing support to Production and Development databases running on different platforms with practices for Oracle Database Infrastructure, Standards and Implementation.
• Excellent experience inproduction support as well as development DBA support, installation, configuration, upgrades, migrations, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing.
• Expertise includesOracle Databases (12c, RAC/11g RAC/10g RAC),onUNIX (IBM AIX)/LINUX and Windows environments.
• Upgradeddatabases from Oracle 10g to 11G, Oracle 11g to 12c.
• Experienced in maintaining very largeProduction, TESTandDEV - OLTP and Data Warehousing environments.ss
• Implemented Oracle 11gR2 Physical/Logical Standby DatabasesincludingActive Data Guard.
• Experience in Oracle Database and SQL tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, SQL Plan Management, SQL Performance Analyzer, AWR, and ADDM.
• Excellent experience in backup and recoverys. Cold backups, hot backups, Logical backups, Native, Storage level (EMC/BCV) and RMANbackups (Full, Incremental Backups, Differential, Cumulative Backups).
• Implemented data transfer usingExport/Import, SQL Loader andData Pump.
• Installation, Configuration and Maintenance of 11g and 12c Grid Control (OEM). Configured alerts to monitor various metrics. Automated database periodic maintenance and activities and monitoring alerts usingShell Scripts.
• Extensive Experience writing StoredProcedure, Functions, TriggerandpackagesusingPL/SQL.
• EnforcedSecurity Administration, systemmonitoringby adding and removing users, configuring quotas,auditing, and analyzingsecurityproblems.
• Replication using Materialized Views and Golden Gate.
• Experience inCapacity Planningand benchmarking.
• Experience inPartitioning and Compression.
• Experience inLogical Database Design, Physical Database design.
• Excellentcommunication skills, with strongtroubleshooting, and problem-solving ability, performing RCA and Incident/Change/Problem Management.
• Leadership, mentoring and managing resources.

TECHNICAL SKILLS

Operating System: UNIX, RHEL 3/4, Sun OS 5.x, Windows 9x/XP

Databases: Oracle 9i/10g/11g/12CR1/12cR2.

High Availability: Data Guard, RACs, Golden gate

Tools: OEM Grid control, Oracle 12c, TOAD, Remedy, HPOVO, Putty, Oracle SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Peapack Gladstone NJ

Database Administrator - Engineering L2/L3 Support

Environment: Oracle 11gR2/12c R1, R2 RAC/ASM, RHEL5, OEM12c/13c, RMANExadata X4 and Super cluster M7.

Responsibilities:

• 24*7Production Database Administration Support.
• Currently working as Primary Dba support for more than 50+ applications for leading Pharma client in USA applying knowledge from oracle 10g to 12c Software’s.
• Rich experience proving solutions and support in high availability and advance technologies in oracle like OEM GRID, RAC, Data guard, OID, RMAN Backup and Recovery, Data center Migration, upgrades.
• Having knowledge on Logical standby DB setup and troubleshooting issues.
• Has very good understanding and exposure to Incident Management, Problem Management and Change Management in ITIL processes.
• Experience in data center migration related activities - server/application migration, co-ordinate server virtualization/retirement activities, database check outs, and establish Business continuity for application stakeholders.
• As a Lead Primary DBA for nearly 50+ applications in BBT portfolio, my responsibilities include working as Single Point of contact for all database issues related to Database Design, Code Review, Planning for Database changes, Upgrades, Migrations, Troubleshooting escalated issues, OAT testing, Performance Benchmarking, DR Drills, Database Software components Validation and Testing etc. am also responsible for design and build of complex database systems including cross platform migrations, Dataguard etc.
• Upgrade Grid Infrastructure & Database from 11.2.0.3 to 11.2.0.4 with Jan2016 PSU Patch.
• Upgrade Grid Infrastructure and Databases from 11.2.0.4 to 12.1.0.2 and 12.2.0.1.
• Upgrade databases from Oracle 11.2.0.4 to 12.1.0.2 in primary and DR site.
• Configured OEM Grid Control and monitored database health using OEM 12c.
• Migrate databases from AIX to Linux using cross platform incremental backup in Oracle 12c.
• Create / invisible / Drop indexes in Engineering system to gain advantage with smart scan.
• Deploy partition and parallel processing in Engineering system to enhance performance.
• Perform Real Application Testing (RAT) using SQL Performance Analyzer for changes in the production environment that impacts database performance.
• Deploy quarterly PSU patches in Oracle 12c/11gR2.
• Consolidate databases as pluggable database in Oracle 12c.
• Configure and setup data guard for pluggable database in 12c.
• Configure TDE
• Performance monitoring and tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM, Hints.
• Resize Memory parameter for optimal database performance.
• Plan stability using SQL Plan Management. Enforce SQL plan for different SQLs using Custom profiling.
• Performed Database Refresh from Production to QA, UAT and Development databases.
• Provided instance level performance monitoring and tuning, Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Deploy incremental stats gather and concurrent stats gather.
• Backup and recovery - Perform RMANbackups and Logical Backups.
• Monitoring Day-Day Backups, Log’s.
• Data Archival and Replication using Golden Gate.
• Partitioned and compressed large tables for better performance and manageability.
• Problem management, Change Management, Incident Management, RCA and metrics. Weekly status reporting to Client.
• Performed Work allocation, project monitoring and tracking, status reporting to client.

Confidential, Raritan, NJ

Database Administrator - Database L2 Support

Environment: Oracle 9i/10g/11g - OEM, Sun OS / Linux / HP-Unix

Responsibilities:

• Providing L2 support to more than 100 plus databases which includes 5 Business critical global applications and SOX/GxP compliance databases.
• Installation, configuration, and maintenance of Oracle 10g on RHEL/OEM 4 and 11g on RHEL/OEM 5.
• Implemented and managed Oracle Data Guard on Oracle 10g/11g.
• Data Guard setup for all business-critical databases and performed switchover and failover operations on demand.
• Participating in Various Annual DR Exercises to test backup strategies @ DR site.
• Worked on SOX critical databases and applications auditing with external auditors for getting data change evidence, Half yearly password change, yearly restoration of tape backups and getting business sign off.
• Recovered the physical standby databases from missing archive log files using RMAN incremental backup on Oracle 10g/11g Dataguard.
• Identified, resolved, or provided recommendations to different kinds of the performance problems ranging from Database performance problems to I/O hardware performance problems.
• Worked and managed RMAN Backups and their Scripts for Production databases.
• Monitoring the Oracle databases daily for any errors or performance bottlenecks using OEM Grid control. Adding new instances to OEM Grid control, Installing OEM Agent on new servers.
• Performing daily support requests, Monitoring Standby database archival apply status, Mview refresh, DB Object reorganization during global maintenance window.
• Monitoring the table growth, database growth, current users, and system resource usage.
• Periodic Database Refresh/CLONING from production to Development and QA environments, maintaining Database Standards, Reviews, Documentation, Quality Assurance.
• Prepare Root Cause Analysis (RCA) for Sev1 and Sev2 tickets.
• Instituting Permanent Corrective Actions (PCA) for high priority tickets.
• Interfaced with the Application support teams for addressing and rectifying critical performance issues.
• Interacting with customers Manager and client executives on regular basis .
• Preparing and sharing end to end technical document for customer on their need.
• Preparing database analysis reports and providing suggestion to customers to improve their database issue and performance.
• Interact with Oracle support on regular basis to resolve mission critical DB issue and get suggestions.

Confidential, Raritan, NJ

Database Administrator - Database L1/L2 Support

Environment: Oracle 9i/10g/11g - OEM, Sun OS / Linux / HP-Unix

Responsibilities:

• Provided L2/L3 support to more than 300 plus databases which includes 5 Business critical global applications and SOX/GxP compliance databases.
• Installation, configuration, and maintenance of Oracle 10g on RHEL/OEM 4 and 11g on RHEL/OEM 5.
• Implemented and managed Oracle Data Guard on Oracle 10g/11g.
• Physical/Logical sData Guard setup for all business-critical databases and performed switchover and failover operations on demand.
• Participating in Various Annual DR Exercises to test backup strategies @ DR site.
• Worked on SOX critical databases and applications auditing with external auditors for getting data change evidence, half yearly password change, yearly restoration of tape backups and getting business sign off.
• Recovered the physical standby databases from missing archive log files using RMAN incremental backup on Oracle 10g/11g Dataguard.
• Identified, resolved, or provided recommendations to different kinds of the performance problems ranging from Database performance problems to I/O hardware performance problems.
• Worked and managed RMAN Backups and their Scripts for Production databases.
• Monitoring the Oracle databases daily for any errors or performance bottlenecks using OEM Grid control. Adding new instances to OEM Grid control, Installing OEM Agent on new servers.
• Performing daily support requests, Monitoring Standby database archival apply status, Mview refresh, DB Object reorganization during global maintenance window.
• Monitoring the table growth, database growth, current users, and system resource usage.

Confidential

Environment: Oracle9i/10g and Linux AS 4.0ss

Responsibilities:

• Physical and logical database design and migration from Oracle 9i to 10g.
• Suggested and implemented backup and recovery strategy.
• Taking export backups, refresh DEV, QA environments etc.
• Worked with developers to implement database deployment on production, development and QA servers.
• Worked on migration of data and implementing structural changes from development servers to production servers using export, import and database links.
• SQL script tuning, tuning of memory and tuning of disk utilization to improve performance.
• Used SQL Loader for loading external data into Oracle tables.
• Creation/management of Oracle databases, management of datafiles, redo log files, control files, tablespaces, segments, extents and data blocks/physical storage, creation, monitoring and management of database users, creation/management of user profiles, granting/revoking of system/object privileges, management of roles and resources and tuning of init.ora parameters.