SUMMARY

• 11 years of Oracle database administration on multiple operating systems in Finance and Auto industry.
• Extensive experience with Oracle database (12c/11g/10g/9i) administration including backup and recovery, database monitoring, performance tuning and troubleshooting, Golden Gate Replication, high availability including RAC and DataGuard, database architecture, modeling and implementation of technology solutions.
• Excellency in PL/SQL coding, UNIX Shell scripting.
• Expertise with GoldenGate.

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle DBA

Responsibilities:

• Worked as the primary DBA in the application DBA team to support the development and QA teams, and helped build and delivery applications according to the physical DBA team's requirements. Working as one key member of the technical resources pool to support the Front Line Support oncall team according emergence requirements and issues
• Setup High Availability Oracle GoldenGate (OGG) systems on Oracle Clusterware 11.2 Oracle 11gR2 RAC environments. Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Logdump / discard file analysis etc. Performance Tuning OGG in extremely high data volume environments. Installing and configuring OGG heterogeneous environments (from Oracle to MS SQL Server / DB2).
• Configured and implemented Oracle Goldengate replication.Performed database replication for multiple production databases to DEV/QA databases.
• Developed automation scripts for refresh, monitoring, RMAN backup, and DATAPUMP.
• Established database backup/recovery strategy for different databases.
• Utilized RMAN for backup and recovery strategy.
• Completed export and import of different databases using Oracle datapump utilities and SQL*Loader.
• Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure.
• Participated in the data modeling sessions to understand the data model and provided inputs based on the existing data to make sure designed model is technically feasible.
• Performed daily Oracle Application DBA tasks such as Oracle network trouble shooting, tablespace usage monitoring, rebuild index / tables etc.
• Provided 24x7 on - call supports for more than 20 mission critical OLTP(RAC and non RAC) production databases on Linux and Solaris platforms covering all global markets and several huge data warehouse systems with data sizes of 20-30T including one full rack EXADATA.
• Duplicated all the non-production databases on Exadata server according to the Data Warehouse development project's requirement. Helped compress large volume partition table by using Oracle HCC Hybrid Columnar Compression techniques.
• Performed software and firmware maintenance of the Exadata storage servers in the Database machine including routine health check, patching and upgrades according to the suggestions from Oracle support department.
• Integrated Exadata monitoring into our existing IT monitoring framework. Provided and implemented performance and tuning recommendations of all components in the Exadata machines.
• Developed and recorded certified processes/procedures for all potential IT downstream support group to maintain and upgrade the Exadata servers.

Confidential, Warren, MI

Senior Oracle DBA

Responsibilities:

• Designed and built Warren/Milford data centers for OnStar, and provided ZERO DOWNTIME Data centers cutover solution and implemented it successfully.
• Designed ZERO DOWNTIME active data guard Data center cutover solution and implemented it successfully for critical billing application.
• Responsible for DB design and building data centers for next generation Onstar system.
• Responsible for providing data synchronization solution, and implementing, maintaining and monitoring Real Time replication environments using Golden Gate and Active Data Guard.
• Installed and configured of Goldengate on 11g database for the bi-directional replication.
• Resolved the issues in conflicts between the target and source database in Goldengate.
• Responsible for providing 7x24 On-call Onstar Sustain production support.
• Responsible for data partitioning, encryption, auditing and purge.
• Responsible for DB backup/recovery policy and effective policy management, establishing access control.
• Migrated databases from 10.2g to RAC 11.2g to provide high availability and better performance.
• Joined EXADATA training and support EXADATA dataware house for more than one year. Lead some performance tuning tasks about EXADATA long query jobs. Patch bundle patches provided by oracle.

Confidential

Oracle DBA

Responsibilities:

• Worked on upgrading oracle from 10g and 11.2.0.2 to 11.2.0.4 version in DEV/QA/Pre-Prod and PROD environments.
• Created many Physical Standby databases and supported disaster recovery by opening the standby databases in read write mode.
• Worked on switchover and failover process in the DataGuard environments.
• Configured Fast start failover in the required environments and tested automatic failover involving the application team.
• Installed, configured and maintained Golden Gate for both DDL and DML replications.
• Worked on restoring and recovering pluggable database using RMAN point in time recovery.
• Used SQL performance analyzer (SPA) to compare the performance of SQL statements before and after implementing TDE encryption.
• Expertise in Data guard administration. Familiar with DR environment and build up nearly 50 local standbys and remote standbys.
• Joined the tool team and took part in coding and testing the shell scripts for local monitoring, remote monitoring, stats collection and RMAN backup.
• SQL tuning expert and a long and close cooperation with Dev teams. Excellency in SQL, PL/SQL and JAVA coding helps to understand the database from the application side.
• Refreshed QA databases in different ways based on database sizes: export/import, datapump, RMAN.
• Created and migrated database using Real Application Clusters.
• Trained in Goldengate replication and streams by Oracle experts.