SUMMARY:

• Highly motivated, quick learner with over 10 years experiences on Oracle database, Oracle RAC, Exadata machine and Oracle GoldenGate administration and development.
• Solid Hands - on experience with Oracle database (12c/11g/10g) administration including backup and recovery, database monitoring, performance tuning and troubleshooting, replication (Advanced Replication, Streams and Golden Gate Replication), high availability including RAC and Active Data Guard, Exadata, database architecture, modeling and implementation of technology solutions.
• Strong experiences with monitoring, troubleshooting, and resolving database issues in 24x7 production environment.
• Expertise in database administration on Oracle Exadata, Redhat Linux, IBM AIX, Confidential -UX, Oracle Solaris, FreeBSD and Windows.
• Database upgrade and migration from 10g to 11g, and 11g to 12c.
• Extensive hands on experience with 12c CDB/PDB creation, migration and admiration.

TECHNICAL SKILLS:

DATABASE: Oracle 10g/11g/12c, RAC, SQL Server

LANGUAGE: SQL, PL/SQL Perl, Korn/Bash Shell, Java, C/C++

PLATFORM: Exadata, Redhat Linux, IBM AIX, Confidential -UX, Solaris, FreeBSD & Windows

DATA REPLICATION: Golden Gate, Data Guard, Streams, Advanced Replication

TOOLS: OEM, SQL/Plus, Toad, SQL*Loader, SQL Developer, DBArtisan

EXPERIENCE:

Confidential, Troy, MI

Senior Oracle DBA and RAC Admin

• 24/7 on-call support for more than 100 mission critical OLTP (RAC and non RAC) production databases on Linux and AIX platforms with data sizes of 20-30 T including one full rack EXADATA. Database versions are ranging from 10g, 11g and 12c.
• Upgraded Oracle GRID, ASM and Database from 10g and 11g to 12c. Implement Oracle 12c new features in mission-critical production environments.
• Installation, configuration, support and performance tuning of Oracle 10g,11g and 12c Real Applications Clusters (RAC) on Exadata, Linux, AIX, Solaris.
• Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.
• Created Database Services for distributing the applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD.
• Installed and set up High Availability Oracle Golden Gate (OGG) systems on Oracle 11g and 12c environments. Upgraded Oracle Golden Gate (OGG) systems from 11g to 12c.
• Performance load testing and tuning application, SQL code, and database instance by using a wide range of technologies including ADDM, AWR, OEM, TKProf, and Explain Plan.
• Established database backup/recovery strategy for different databases. Utilized RMAN for backup and recovery strategy. Completed export and import of different databases using Oracle data pump 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 providing them inputs based on the existing data to make sure designed model is technically feasible.

Confidential, Buffalo, NY

Senior Oracle DBA and Golden Gate Administrator

• 24/7 on-call support for the production environment
• Installed and set up High Availability Oracle GoldenGate (OGG) systems on Oracle 12c environments. Upgraded Oracle GoldenGate (OGG) systems from 11g to 12c.
• 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.
• Application DBA leader for a large number of tuning projects. Working with third party developers on SQL code review and quality control. Performance load testing and tuning application, SQL code, and database instance by using a wide range of technologies including ADDM, AWR, ASH, OEM Performance Manager and home-cooked scripts by using Korn shell/Perl.
• Daily development / testing environment baseline backup and restore, develop and maintain administration scripts by using Perl/Korn shell.

Confidential, Pontiac MI

Oracle DBA and Golden Gate Administrator

• 24/7 on-call support for the production environment
• Upgraded Oracle GoldenGate from 11gR2 to 12c. Implement OGG 12c new features in mission-critical production environments.
• Troubleshooting typical OGG technical problems.
• Performance Tuning OGG in extremely high data volume environments. Installing and configuring OGG heterogeneous environments (from MS SQL Server to Oracle Exadata).
• Monitor and fully analyze performance issues in production Oracle databases by using AWR/ADDM/OEM 12c
• Installed, configured and maintained Oracle 11g Real Application Cluster (RAC) / ASM on Redhat Enterprise Linux 6.x boxes.
• Implemented 12c DataGuard Physical using DG Broker, and experienced with 12c Data Guard new features Active Data Guard and Snapshot Standby.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Some MS SQL server database management involvement.

Confidential, Columbus, OH

Junior Oracle DBA

• Supporting more than 20 Oracle 10g/11g development/testing environments on Solaris/SPARC and Linux/X64 boxes. Help the developers and QAs to do trouble shooting about database issues.
• Learned the below skills with hands-on experience and widen knowledge
• Oracle Software’s installations, creation of new standalone and RAC clustered databases.
• RMAN backup and duplication, Cross-platform Transportable Tablespace.
• Golden Gate (mainly 1 way and DML) and Materialized view for data replication.
• Data Guard creation and administration using DG Broker and SQL PLUS.
• Performance monitoring and tuning by using AWR/ADDM, statspack, tkprof tools
• General DBA daily jobs such as disk usage monitoring, table/index rebuild and reorganization as needed