SUMMARY

• Sr Oracle Database Engineer with over 8 years of experience in managing Oracle 10g/11g/12c database in multiple platforms like Linux, HP - UX, Solaris, IBM-AIX and Windows. Hands on experience working with replication tools such as Oracle goldengate 11g/12c and shareplex 7,8. Good hands on experience in oracle high availability products such as oracle datagurad and Oracle Real application cluster.
• Hands on experience in working with Oracle 12c/11g/10g on multiple platforms like Linux, IBM AIX, Windows, Sun Solaris and HP-UX in various domains like Financial, Health Care and Telecom.
• Experienced in setting up a Grid Infrastructure, Installing and configuring Real Application Clusters on Oracle 12c/11g/10g with ASM and NON-ASM.
• Upgraded grid and rdbms from 11.2.0.4 to 12.1.0.2.
• Experience in applying PSU, one off patches.
• Experienced with very largescale Database environment and mission critical applications.
• Hands on experience in working with Active-active oracle goldengate 11g and 12c.
• Hands on experience in upgrading goldengate from 11g to 12c.
• Hands on experience in working with three-way replication using Shareplex 7.0, 7.6, 8.0.
• Upgraded Shareplex from 7.0 to 7.6 in complex three-way replication environment.
• Experience in setting up a Physical Standby Dataguard and Active Dataguard.
• Hands on experience in building RMAN virtual catalog database and manages recovery catalog for 35 production databases.
• Hands on Experience in managing and configuring RMAN backups in oracle 12c/11g/10g
• Hands on experience on Oracle grid control oracle 11g and 12c cloud control.
• Experience in writing scripts proactive monitoring like monitoring the disk usage and the memory usage of the server and monitoring Tablespace.
• Worked with oracle support to resolve the ongoing issues. Worked closely with oracle support on pro-active SR and successfully resolve the issues.
• Monitored indexes and analyzed their status for performance tuning and query optimization.
• Experience in database tuning and Sql tuning using utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ASH, ADDM
• Experience in Extracting, Transforming and Loading data from various Flat Files using SQL loader utility.

TECHNICAL SKILLS

Operating Systems: Sun Solaris 10, RHEL 6&7, HP-UX, IBM AIX

RDBMS: Oracle 12c/11g/10g RAC with ASM/Non ASM

Replication Tools: Oracle Golden Gate v 11.1/ 11.2/12.1/12.2/12.3 , Shareplex 7.0/7.76/8.0

DB Utilities: RMAN, OEM Grid Control 10g/11g and 12c cloud control, Data Guard

10g/11g/12c, Data guard broker.:

Languages: SQL, PL/SQL, Shell Scripting, python scripting

Tools: SQL*Loader, EXP/IMP, Datapump Utilities, TOAD, SQL Developer

Other: Hummingbird, Putty, FTP, SFTP, SSH, SCP, TELNET, MobaXtemVNC client, Toad

PROFESSIONAL EXPERIENCE

Confidential, Bellevue, WA

Sr. Oracle Database Engineer

Environment: Oracle 12c/11g. Cloud control 12c, Goldengate 12c and 11g., Linux, RMAN, RAC, DataGuard, ASM, SCP/SFTP, TKPROF, Explain plan, AWR, ASH, ADDM, and TOAD 12.

Responsibilities:

• Installed configured and maintained 2 set of 4 nodes and 8 set of 2 nodes oracle 12c RAC and setup active-active oracle goldengate replication.
• Maintained multitenantarchitecture with one CDB (Container Database) and PDB (Pluggable database).
• Hands on experience managing critical replication setup using oracle 12c goldengate.
• Installed and configured active-active setup of oracle goldengate 12c in PDB architecture with RAC high available.
• Configure goldengate xagent to maintain cluster highavailability and deployed Jagent.
• Set up goldengate monitoring using oracle 12c cloud control.
• Setup Oracle GoldenGateConflict Detection and Resolution (CDR) feature to resolved conflicts.
• Installed and maintained oracle 12c cloud control and deployed agents. Installed oracle 12c goldengate monitoring plug-in to oracle 12c cloud control.
• Involved in production released and changes management.
• Created ACFS file system and Installed and configure grid services to support SAP landscape.
• Performed database upgrade from oracle 11.2.0.4 to 12.1.0.2.0 on linux
• Performed database upgrade from 11.2.0.3 to oracle 11.2.0.4 on linux.
• Applied oracle PSU + OJVM patch on oracle 12c.
• Upgraded oracle goldengate 11g to 12c and applied goldengate patch.
• Worked on both classic/intergrade extract and replication.
• Hands on experience oracle down stream capture setup.
• Configured rman backup and worked with Netbackup team to test the restore scenarios.
• Written shell script to monitor database and oracle goldengate replication.
• Upgraded TFA.
• Worked on critical performance issues.
• Actively monitor database performance.
• Hands on experience in solving performance issue and analyzing awr/ash/statspack report.
• Worked with oracle support 24/7 SR on critical issues.
• Worked closely with application team to understand the business requirement.

Confidential, Irvine, CA

Sr. Oracle DBA

Environment: Oracle 11g/12c. Grid Control 11g/12c, Shareplex, Goldengate, IBM AIX, Oracle Solaris, Linux, RMAN, RAC, DataGuard, ASM, Oracle, SCP/SFTP, TKPROF, Explain plan, SQLT, AWR, ASH, ADDM, SQL* Plus, PL/SQL, SQL* Loader and TOAD 12.

Responsibilities:

• Managing Oracle 11g/12c database’s on RAC/Standalone with ASM/NON-ASM.
• Managing two-site of Physical Standby database with database size of 30TB.
• Currently working on configuring two way active-active replication using oracle golden gate 11.2.1.0.2
• Managing multi sites (2 way and 3 way) replication environment using shareplex 7.6.
• Build and Configure from the scratch shell script to monitor major DB alerts such as Active sessions, long running query, Backup failure reports etc.
• Working on oracle 12c New features such as adaptive query optimization and online stats gathering, multiple indexes on one column and table restore using rman.
• Experience on SQL plan management techniques to fix the plan.
• Good experience on how to handle the critical situation such as High active session, CPU high or slowness in the application or any major replication, dataguard latency issues and etc
• Applied PSU/JAVAVM component patch on physical standby dataguard and 11.2.0.4 RAC cluster environment.
• Supporting very large development teams and supporting the release and plan SR changes.
• Currently working on building shell scripts for complex application load jobs to load the data using sql-loader using flat files.
• Supporting on call, releases, production support and etc.

Confidential, SFO, CA

Sr. Oracle DBA

Environment: Oracle 11gR1/R2, Grid Control 11g/12c, RMAN, RAC, DataGuard, ASM, Oracle GoldenGate, Multi Master Replication, SCP/SFTP, TKPROF, Explain plan, SQLT, AWR, ASH, ADDM, SQL* Plus, PL/SQL, SQL* Loader, Oracle Solaris 10, Linux 6.0 and TOAD 10.0/11.0, HP - UX.

Responsibilities:

• Install and configure Oracle 12c RAC and Standalone on RHEL6 with ASM.
• Testing new feature of Oracle 12c like pluggable database and online table partitioning.
• Install and configure 2 nodes RAC Cluster on 11.2.0.3 with ASM.
• Involved in Migration project from hp-ux to linux from oracle 10.2.0.4 to 11.2.0.3
• Hands on experience in managing Bi-directional/Uni-directional replication using Oracle GoldenGate.
• Performed Initial loads and configured replication using oracle GoldenGate.
• Experience in using GoldenGate director, use logdump utility to analyze GoldenGate extracts in trail files and setting up GoldenGate monitoring.
• Experience in configuring GoldenGate process with cluster configuration for high availability in oracle RAC environment.
• Configure Oracle Advanced Multimaster replication active-active replication.
• Worked on complex script to configure application jobs.
• Applied PSU patch on single standalone database and Grid Infrastructure patches on RAC environments.
• Applied Jan psu on active Dataguard and physical standby environments.
• Worked on change control, release management and successfully applied the changes in the database.
• Configure RMAN backups on the production.
• Experience in SQL tuning based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ASH, ADDM, SQLT and worked with oracle support to trouble shoot the performance issues.
• Worked on oracle partitioning.
• 24/7 Oncall support to manage mission critical application.
• Manage and Supported oracle active Dataguard and physical standby Dataguard.
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiles and Privileges.
• Used various methods like SCP, SFTP, FTP and PSFTP (from windows) to transfer files from legacy server to DCC servers.
• Provided troubleshooting and problem solving support to application developers.

Confidential, NJ

Sr. Oracle DBA

Environment: Oracle 10g and 11gR1/R2, Grid Control 11g/12c, Enterprise Manager, RMAN, RAC, DataGuard, ASM, GoldenGate, Shareplex, SCP/SFTP, TKPROF, Explain plan, SQLT, AWR, ASH, ADDM, SQL* Plus, PL/SQL, SQL* Loader, Oracle Solaris 10, AIX 5.2/5.3, Red Hat Linux 5.0/6.0and TOAD 10.0/11.0

Responsibilities:

• Experience in supporting a critical production environments with RAC, Standalone, ASM or NON-ASM environments.
• Successfully upgraded 5 nodes RAC cluster from 10.2.0.4 non-ASM to 11.2.0.3 ASM.
• Upgraded standalone database from 11.2.0.2 to 11.2.0.3.
• Installation, configuration, maintenance and tuning on Oracle11g and 10g on Solaris, IBM-AIX 5.3 and RHEL 5/6.
• Installed and configure more than 10RAC cluster on 11.2.0.3 with ASM, non-ASM.
• Installed and configure one node Oracle 11.2.0.3 RAC cluster database with ASM on RHEL 6.
• Involved in upgrading 10.2.0.4 to 11.2.0.3.
• Installed and setup a three way replication using Shareplex 7.6 on oracle 11.2.0.3 and worked on complex replication environment.
• Experience in creating, configuring and maintaining DataGuard using Physical Standby and Active DataGuard physical standby on 11gR2.
• Evaluated database performance for investigation of issues and further resolution for efficiency on Oracle exadata applications.
• Executed processes for evaluation of system space, database allocation and storage metrics on Oracle Exadata.
• Successfully upgraded Oracle RAC 10g (10.2.0.4) to Oracle 11g (11.2.0.2) on Solaris
• Worked on multi way replication supported a VLDB database’s with a maximum size of 50 terabyte.
• Configure RMAN backup for database for ASM, non-ASM environments. Worked with IBM Tivoli team to configure table backup.
• Create and manage RMAN VIRTUAL CATALOG database that is currently running a central repository for all production environments.
• Applied CPU/PSU and interim patches on Grid infrastructure, rdbms, clusterware on 10.2.0.5, 10.2.0.5,11.2.0.2, 11.2.0.3 for RAC and standalone environments.
• SQL tuning and Database performance tuning based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ASH, ADDM, SQLT and monitored the database performance on a daily basis.
• Planning Backup/Restoration/Validation Strategy, taking Backups (with RMAN as well as DataPumpexp/imp).
• Created & Managed Database Structures, Storage Allocations, Table/Index segments, Undo management, Constraints, Database Access, Roles, Privileges and Profiles.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Performed SQL and PL/SQL tuning, analyzing automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and automatic session history (ASH) reports.
• Configure gather statistics and copy stats jobs on production environment.
• Configure monitoring jobs like Long running SQL/active session count/inactive session count/full table scan/missing or unusable index/invalid object/partition not available.
• Worked closely Data warehouse teams and automate the feed as per the application requirement.
• Experience in using packages like DBMS SCHEDULER to schedule tasks Involved in developing UNIX shell scripts to automate and scheduled the database backup jobs.
• Involved in code optimization for better performance in production environment.
• Performed complete database recovery using rman backup.