SUMMARY

• 15+ years of experience managing Oracle databases versions 9i to 19c
• Experience as On - Call 24x7 production DBA support, application/development DBA
• Oracle 9i/10g/11g/12c/18c/19c Database Administration including GI/RDBMS installation, configuration, patching and upgrading
• Oracle 10g/11g/12c/18c/19c Real Application Clusters (RAC) including
• Installing, configuring and upgrading Oracle RAC software
• Installing and testing Oracle Transparent Application Failover (TAF)
• Performance tuning for Oracle Real ApplicationClusters (RAC)
• Partitioning tables and indexes.
• Strong experience and skills in Exadata environment including configuration, monitoring, storage management, patching and upgrade, reviewing health by EXACHK report
• Automatic Storage Management (ASM) maintenance
• Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM
• Partition large tables and create material view for better performance
• Design and implementation of various Oracle backup/ recovery strategies using RMAN, Active Data Guard
• Database Disaster Recovery design by using Data Guard Broker
• Clone and refresh DEV/QA databases from PROD databases using RMAN and datapump
• Setup and configure Oracle Enterprise Manager Grid Control (11g), Enterprise Manager Cloud Control 12c/13c for database monitoring/performance/diagnostics
• Experience in cloud platform like AWS and OCI
• Setup/Configure/Manage GoldenGate Bi-directional replication
• Experience in OID/LDAP installation, replication and configuration
• SQL*Plus, SQL and PL/SQL programming and development like Stored procedure, packages, functions and Triggers.
• Oracle Unbreakable Linux administration, Linux/ Unix, HP-UX, Solaris and Shell scripting
• Familiar with multiple ticket systems like Jira, Service Now, Confluence and DISCO

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Consultant

Responsibilities:

• Maintaining over 1000 USA based client's databases from 9i to 19c
• Upgrading the client’s databases from 11g/12c/18c to 19c
• Automatic Storage Management (ASM) maintenance like patching and upgrading
• Prepared Exadata quarterly patch and upgrade (12c to 21c) action plan and guided the team members to implement the maintenance from X2 to X9M
• Maintain client’s Exadata servers including storage servers, computer nodes, infiniband, EXACHK, TFA and ASR
• Provided assistance for Oracle Field Engineer onsite maintenance like replacing failed disks, flash disks, network cable and batteries.
• Deployed Exadata from the scratch on X8M and X9M
• Converted the client’s databases from NON-CDB into PDB
• Discussion with the clients on their database infrastructure design
• Active database duplication using RMAN (11g/12c/18c/19c database)
• Backup and recovering databases using RMAN, Active Data Guard, datapump
• Refreshed the client’s DEV/QA databases
• Assisted the client migrating the database to AWS or OCI
• Provide 24x7 database monitoring using 12c & 13c OEM, Pythian monitoring tool called Avail
• Upgraded client’s OID
• Performance troubleshooting and tuning
• Setup/Configure/Maintain GoldenGate Bi-direcotional replication

Environment: Oracle 9i/10g/11g/12c/18c/19c RAC, Grid Control, Cloud control, ASM, Golden Gate, DataGuard, Exadata, Linux/Unix/HP-UX/Solaris, AWS, OCI

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Upgrading production and development databases from 9i to 11gR2 RAC hosted on Oracle Unbreakable Linux Servers with Sun Storage 7310
• Maintaining and monitoring 1.5TB OTLP production database which has over 10 million transactions every day
• Setup GoldenGate Uni-directional replication from OLTP database to Report database
• Installing and configuring development and QA, pre production databases.
• Optimizing and troubleshooting production database performance issues.
• Using Oracle 11gR2 RAT (Real Application Testing) to capture production database work load and replay in test databases before database changes like upgrades, patches, schema changes, storage and network changes, etc.
• Configuring Native Oracle XML DB Web Services for external systems
• Backup and recovering databases using RMAN, Active Data Guard
• Writing Linux shell scripts to copy production data into Report Systems and Sales Demo databases
• Using Oracle LogMiner to analyze Redo Log Files.
• Writing advanced SQL and creating Stored Procedures
• Supporting developers with database expertise and helping them on codes optimization
• Reviewing scripts before rolling out into production database

Environment: Oracle 9i/10g/11g RAC, Oracle Enterprise Manager, TOAD, PLSQL Developer, LogMiner, SQL Examiner, ORACLE RAT, Golden Gate

Confidential

Senior Oracle / MSSQL Database Administrator

Responsibilities:

• Installing, configuring, upgrading production and development databases (ORACLE & MSSQL)
• Maintaining and monitoring 3LOG development and clients’ production databases (ORACLE & MSSQL)
• Optimizing and tuning 3LOG and clients’ production databases performance issues using EXPLAIN PLAN, AUTOTRACE, TKPROF and STATSPACK. (ORACLE)
• Backup and recovering databases using RMAN,EXP/IMP,EXPDP/IMPDP (ORACLE)
• Writing advanced SQL and creating Stored Procedures (ORACLE).
• Supporting our team of developers with database expertise (ORACLE & MSSQL)

Environment: Oracle 9i/10g/11g, Oracle Grid Control, TOAD, PLSQL Developer, MSSQL Enterprise Manager, MSSQL 2000/2005/2008