SUMMARY

Seasoned and certified Oracle DBA with expertise on Oracle advanced features such as RAC, Data Guard, RMAN, Exadata, GoldenGate. Looking for challenging and complex database environments for project implementation, performance tuning and support of critical production database systems either on premises or on Cloud.

TECHNICAL SKILLS

• Oracle (7/8/8i/9i/10g/11g/12c)
• Data Guard
• RMAN
• Data Warehouse PL/SQL Shell scripting SQL Server AWS
• RAC Cloud Control / OEM ASM AWR/Statspack Unix(AIX/HP/Solaris) Java Spark Oracle Cloud/DBCS racle GoldenGate Exadata / SuperCluster Partitioning SQL Linux Scala
• Azure Cloud

PROFESSIONAL EXPERIENCES

Confidential, San Ramon, CA

Senior Oracle DBA

• Investigate critical issues of OLTP and reporting databases escalated by clients / Support and presented solutions based on performance stats and analysis.
• Upgrade Oracle 11gR2 databases to Oracle12c using different options including DataGuard and GoldenGate to minimize downtime.
• Support software developers both in US and offshore in database setup, configuration and application releases based on Oracle best practice.
• Coordinate with other departments and offshore developers / DBA team thru various releases and projects.
• Develop procedures/programs to implement database changes thru releases, enhancements and patches.
• Performe regular DBA responsibilities including stats refreshing, index monitoring, routine DB backups and monitor of critical databases either on premises or on Cloud environments.

Confidential, Pleasanton, CA

Senior Principal Consultant

Responsibilities:

• Configured Golden Gate 11gR2 to migrate data from IBM DB2 to Oracle 11gR2 database and successfully test thru all the application functions.
• Reviewed 11gR2 RAC on Solaris 10 on 2 2 - node clusters and helped client with GI upgrade from 11.2.0.1 to 11.2.0.2.
• Tuned top SQLs and Golden Gate configurations in Exadata environment of Monsanto and improved Golden Gate throughput 6 times to exceed the SLA.
• Reviewed hundreds of Golden Gate replications at ADP and presented recommendations to improve the performance and stability.
• Reviewed 11gR1 11.1.0.7 RAC on AIX 6.1 on a 3-node cluster and presented recommendations to improve the performance as well as manageability.
• Added the 3 rd node to 3 clusters of 10gR2 on Solaris 10 and went thru RAC survivability test to verify the added node and RAC configurations.
• Worked on shopping season readiness for one of the largest eCommence websites in the world.
• Performed DB health check of a 2-node cluster on Solaris 10 and evaluated/prioritized the critical patches including PSU/CPU and merge patches recommended in RAC Assurance reports.
• Monitored database and system performance during load tests and presented recommendations based on the AWR reports and other stats generated during the load tests.
• Enabled index usage monitoring and reviewed index strategies with additional indexes recommendations.
• Recommended partitioning of the big tables and their indexes as well as other app changes such as data load redesign and commit in batch to reduce index contentions.

Confidential, San Francisco, CA

Independent Consultant working as Senior Oracle DBA

Responsibilities:

• Supported development and integration databases for Bill Pay, Direct Pay, Paydirt and other in­house developed online financial applications.
• Supported mission-critical database systems like NMarket, CC&B, FAS, RSS, UAC.
• Worked with app teams on projects including MRTU, SmartMeter WACS.
• Worked on performance tuning of CC&B which is 8-node RAC db of 25TB supporting multiple applications.
• Mentored junior DBAs on RAC, Data Guard, Grid Control setup and configurations.
• Upgraded Grid Control OMS/OMA from from 10.2.0.3 to 10.2.0.4 and fine tuned the alert thresholds.
• Performed 24x7 Support of 10 cluster and 5 stand-alone databases that run online shopping applications like Confidential .com, Confidential .com, Confidential .com, Confidential .com, etc.
• Changed Cluster interconnect configurations from using public to using interconnect interface.
• Worked with Oracle support on production database outages and critical issues, and prepared root cause analysis.

Confidential, Costa Mesa, CA

Senior Principal Consultant

Responsibilities:

• Installed Oracle10gR2 RAC on Red Hat Linux 4 (64-bit) with ASM configurations on several clusters and upgraded to the latest patchset.
• Installed 10g RAC with ASM on HP-UX 11.11 and set up Data Guard configuration over a dedicated WAN with both primary and standby running 10g RAC.
• Enabled flashback database features and configured RMAN for the MAA architecture backups.
• Tested switchover and failover of the Data Guard configuration with both Data Guard Broker and SQL*PLUS.
• Tuned the RAC databases to meet the application requirements.
• Led an effort to improve performance of a 9i production database supporting Remedy application of a large services company.
• Successfully improved performance and resolved numerous database issues.
• The client was highly impressed and commented “the application is faster than speeding bullet”.
• Installed 10g RAC with ASM configurations on AIX 5.3 on 2 clusters and applied patchset and Critical Patch Update.
• Tuned the performance of RAC databases including OLTP and data warehouse.
• Configured Grid Control to report alerts based on client’s requirements.
• Installed Grid Control 10gR3 in both production and test environments
• Configured and tested HA features of Grid Control
• Created monitoring templates to reflect client’s monitoring and alerts requirements
• Customized monitoring rules to satisfy paging and email alerts requirements.
• Created used defined metrics to monitor Streams.
• Implemented a DR solution for the Grid Control including a Data Guard configuration for the OMR.

Confidential, Dallas, TX

Oracle DBA or Senior Oracle

Responsibilities:

• Analyzed, tested, and implemented physical database design supporting various business applications including base definition, structure, documentation, and operational guidelines.
• Ensured data recovery, maintenance, data integrity, and space requirements for physical database are met through formulations and monitoring of policies, procedures, and standards relating to database management
• Evaluated and reviewed new technologies and production features on database management systems and security improvements such as Oracle RAC, Data Guard, Streams, Advanced Replications, Private databases and Fine Grained Security, and present recommendations to upper management.
• Worked with application developers, performance engineers and data architect on database designs and performance tuning.
• Worked with application vendor and other related teams on performance tune on a very dynamic critical production system and resolved the issues by tracking the IO issues to specific tables/ indexes.
• Tuned critical production database systems of IBM’s clients such as Confidential State of Michigan, etc.
• Worked extensively and closely with Oracle tech support and application vendors on performance tuning of critical production systems, ad hoc queries, routine SQL and PL/SQL scripts by using Statspack, RDA, SQL Trace, explain plan, OEM and DBArtisan.
• Tuned RMAN backup of a database with 1.5 Terabytes of data and successfully cut the full backup and recovery time from 20 hours to 8 hours.
• Designed the Disaster Recovery Data Center in Addison, TX to replace the out-sourced Disaster Recovery Service by using Hot Standby Databases and DataGuard in Maximum Performance Mode.
• Used third-party database administration software like DBArtisan, TOAD, SQL Navigator, BMC’s Patrol for Oracle, SQL Backtrack, Web DBA, etc.