SUMMARY

• Over 9 years of experience as DBA in 24×7 environment for 7.x to 12c on Unix/Windows.
• Strong expertise Backups and Recovery using RMAN or logical like Export and Import Datapump.
• Expertise in Golden Gate Replications UNIDIRECTIONAL/BIDIRECTINAL.
• Install, upgrade Oracle Databases 8i and higher.
• Experience in Oracle Real Application Cluster (RAC) with Active Dataguard.
• Configured/support NoSQL/Mongo databases.
• Support Informatica and OBIEE for Dev support.
• Managed Teradata database with Teradata SQL Assistant.
• Working on RazorSQL tools for export schemas/tables.
• Experience in Shell scripts for database.
• Install, upgrade Oracle Enterprise Manager (OEM) for 10g/11g/12c.
• Transparent Data Encryption (TDE) on Database.
• Experience in modifying Storage for tablespaces in Capacity Planning.
• Design Logical & Physical data model for the database for application.
• Experienced with database security on tablespace level, object level, TDE, etc.
• Experience in coding in PL/SQL blocks, Packages,Triggers on database.

TECHNICAL SKILLS

Databases: OLAP, OLTP, Data Mining, Oracle 7.X till 12c

DBA Tools: Oracle Enterprise Manager (OEM) 12c/11g/10g Grid, RAC, Golden Gate, Active Data Guard, Putty, SQL*Plus, Toad, SQL Developer, RMAN,RazorSQL,SQLLines.

Operating Systems: Solaris 10/9/8/2.7/2.6 ; Red Hat Linux EL 4.0, UNIX 5.1/5.1a/4.0, IBM AIX 4.3.2/4.3.3 , Windows XP/NT/2000, HP UX 11.00/ 10.20 , Veritas Clusters.

Languages: Shell Scripts, COBOL, SQL, PL/SQL.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr. Oracle Application DBA

Responsibilities:

• Deploy various codes for Confidential databases.
• 24x7 supports for very large Database.
• Upgrade Oracle Databases and install Patches.
• Editing/writing shell scripts for Oracle database.
• Design Logical database design with Application as per their requirement.
• Compare roles/privileges for various USERS/SCHEMAS post migrate.
• Configure RMAN on databases and schedule in cron jobs.
• Gather DDL for various Tables/Indexes/Schemas/Procedures.
• Support various Physical Dataguard and monitor and troubleshoot.
• Enable and support encryption Transparent Data Encryption (TDE) on databases.
• Perform schema/table refresh via EXPDP/EXP and IMP/IMPDP.
• Install, upgrade Oracle Enterprise Manager (OEM) for 11g/12c.
• Tune SQLs if needed for application team.
• Install and maintain Oracle Real Application Cluster (RAC) on Cluster for failover testing.
• Setup Oracle Golden Gate on schema/table level.
• Performance tuning on Golden Gate.
• Setup and Troubleshooting Golden Gate issues.
• Install and maintain Golden Gate on Oracle Real Application Cluster (RAC).
• Apply Oracle Security Patches to adhere to the security policy.
• Performance Tuning for various databases/applications.
• Gathering statistic, analyzing tables and indexes.

Confidential, Dallas, TX

Sr. Oracle DBA

Responsibilities:

• Decide database server as part of Cost Analysis and Performance.
• Migrate Teradata 14.10 database to the new Linux Oracle 12c RAC.
• 24x7 supports for very large Database.
• Compare table structures between Teradata 14.10 and Oracle 12c RAC.
• Upgrade Oracle Databases and install Patches.
• Editing/writing shell scripts for ETL jobs for Teradata to Oracle database.
• Design Logical database design with Application as per their requirement.
• Compare roles/privileges for various USERS/SCHEMAS post migrate.
• Configure RMAN on databases and schedule in cron jobs.
• Support various Physical Dataguard and monitor and troubleshoot.
• Enable encryption Transparent Data Encryption (TDE) on database.
• Install, upgrade Oracle Enterprise Manager (OEM) for 11g/12c.
• Rewrite complex table views from Teradata to Oracle.
• Load Teradata schema to Oracle database and Convert Teradata SQL into Oracle database.
• Install and maintain Oracle Real Application Cluster (RAC) on Cluster for failover testing.
• Setup Oracle Golden Gate on schema/table level.
• Performance on Golden Gate.
• Setup and Troubleshooting Golden Gate issues.
• Install and maintain Golden Gate on Oracle Real Application Cluster (RAC).
• Performed schema/table refresh via EXPDP/IMPDP.
• Apply Oracle Security Patches to adhere to the security policy.
• Performance Tuning for various databases/applications.
• Gathering statistic, analyzing tables and indexes.

Confidential, Dallas, TX

Sr. Oracle Application DBA

Responsibilities:

• Decide database server as part of Cost Analysis and Performance.
• Design database architecture with installation Oracle 11.2.0.4 on Linux.
• Migrate/Upgrade OLTP/OLAP database to the new Linux Oracle 11.2.0.2 to 11.2.0.4 RAC.
• 24x7 supports for very large Database.
• Compare table structures between production and lower environment databases.
• Upgrade Oracle Databases and install Patches.
• Install/configure Oracle 12c clouds on databases.
• Writing shell scripts for report for database.
• Design Logical database design with Application as per their requirement.
• Apply Physical database once Logical design approved.
• Compare roles/privileges for various USERS/SCHEMAS post migrate.
• Configure RMAN on databases and schedule in cron jobs.
• Support various Physical Dataguard and monitor and troubleshoot.
• Perform schema/table refresh via EXPDP/IMPDP.
• Install, upgrade Oracle Enterprise Manager (OEM) for 11g/12c.
• Build and support Informatica to help Dev team.
• Troubleshoot issues on ETL on Appl/Dev team request.
• Subject Matter Expert (SME) for over 100 databases.
• Help Application/Dev team in OBIEE.
• Setup Oracle Golden Gate Replication for non - Oracle to Oracle.
• Troubleshoot Oracle Golden Gate issues source and target.
• Install and maintain Golden Gate on Oracle Real Application Cluster (RAC).
• Deployed applications for various production databases.
• Performed schema/table refresh via EXPDP/IMPDP.
• Apply Oracle Security Patches to adhere to the security policy.
• Worked on database security like database files in encryption Transparent Data Encryption (TDE).
• Performance on Golden Gate.
• Performance Tuning for various databases/applications with DBMS PROFILER.
• Gathering statistic, analyzing tables and indexes.

Confidential, Richardson, TX

Sr. Oracle Application DBA

Responsibilities:

• Design Architecture of the database and supported 24x7 Production DBA for critical databases.
• Writing shell scripts for report for database.
• Upgrade Oracle Databases and install Oracle Patches.
• Setup Golden Gate for Oracle databases and Non-Oracle Database.
• Install/Support NoSQL/Mongo databases.
• Subject Matter Expert (SME) for over 100 databases.
• Installed/Configured Oracle Enterprise Manager (OEM) 11g / 12c Grid for databases.
• Installed/upgrade Oracle 11.2.0.2 to Oracle 11.2.0.4 databases.
• Trained team for Oracle RAC (RAC) databases with Physical Data Guard.
• Mentored/Worked to team on RMAN Backups and Recovery scenarios.
• Deal on Disaster Recovery (DR).
• Design Logical database design with Application as per their requirement.
• Apply Physical database once Logical design approved.
• Recover databases/objects using RMAN/logical backups.
• Configure RMAN on databases and schedule in cron.
• Clone database on application request.
• Experienced on Encryption (TDE)for databases.
• Experience in Creation and managing Table partitioning and Rebuilding, validating the Indexes.
• Mentored new team members of 20 team members.

Confidential, Dallas, TX

Oracle Application DBA

Responsibilities:

• Design Architecture of the database and supported 24x7 Production DBA for critical databases.
• Writing shell scripts for report for database.
• Create/Upgrade and support databases and install Patches and bug fix.
• Build and maintain Golden Gate Processes for replicating purposes including Oracle Real Application Cluster (RAC) databases. Troubleshoot with Golden Gate ERRORS.
• Major/Minor upgrades databases and also CPU/One Off Patches and bug fixes.
• Design Logical database design with Application as per their requirement.
• Apply Physical database once Logical design approved.
• Install Oracle Enterprise Manager (OEM) for 11.2.0.3.
• Tablespace management and capacity planning.
• Recover databases/objects using RMAN/logical backups.
• Troubleshoot errors in ETL on Appl/Dev team request.
• Configure RMAN on databases and set in cron jobs.
• Clone database on application request.
• Enable Transparent Data Encription (TDE) on databases on Application request.
• Writing PL/SQL blocks for tuning and reporting uses to help Dev team.
• Mentored to team.
• Installation and Incidental support for Physical Standby database.
• Provide EXPDP/IMPDP script to Application DBA for schema/user backup.
• Experience in Creation and managing Table partitioning and Rebuilding, validating the Indexes.
• Tuning SQL query, generating Explain plan, Statspack, DBMS PROFILER with Log miner.
• Gather Statistic on table, analyzing tables and indexes.
• Creation of Service Request to Oracle.
• Mentored/Knowledge Share new team members of 15.

Confidential, Bedmister, NJ

Sr. Oracle DBA

Responsibilities:

• Production DBA in 10g/11.2.0.2 in 24x7.
• Major/Minor upgrades databases and also CPU/One Off Patches and bug fixes.
• Setup Golden Gate for Oracle Databases and troubleshoot.
• Write shell scripts for report for database.
• Write/Tune PL/SQL blocks for reporting.
• Install Oracle Enterprise Manager (OEM) for 11.2.0.
• Tablespace management and capacity planning.
• Supported Oracle Real Application Cluster (RAC) systems.
• Recover databases/objects using RMAN/logical backups.
• Troubleshoot Backup issues
• Configure RMAN on databases and schedule in cron.
• Clone database on application request.
• Disaster Recovery for various databases as regular exercise.
• Creating and managing table partitioning and rebuilding and validating the indexes.
• Performance Tuning for SQL Query for various databases/applications.
• Tested TDE (Transparent Data Encryption) database for testing of data security.
• Gather Statistic on table, analyzing tables and indexes.