Asmath Shaik

Results-driven Oracle Database Administrator with 5 years of experience administering mission-critical Oracle 12c/19c databases in 24x7 production environments across healthcare, IT services, and global travel-technology domains. Skilled in Oracle RAC, Data Guard, RMAN backup and recovery, ASM storage management, and performance tuning using AWR, ASH, and ADDM. Proven track record in database installation, upgrade, migration, cloning, and quarterly PSU/RU patching using OPatch, consistently sustaining 99.9%+ uptime for production systems.

Adept at incident management, root cause analysis, and production support within ITIL-aligned change management frameworks. Strong background in Linux administration and shell-scripting automation that reduced manual monitoring effort and SQL query execution times significantly. Hands-on experience with Oracle Enterprise Manager (OEM), disaster recovery drills, and high-availability architecture. strong troubleshooting ability under pressure, and effective collaboration with cross-functional application and infrastructure teams.

Seeking to leverage proven Oracle DBA expertise in a challenging, high-availability enterprise environment.

Oracle Database Administrator at PricewaterhouseCoopers (PwC) (2024-10 – 2026-07)

Administered Oracle 12c/19c RAC databases on Linux for global travel-technology client Amadeus, sustaining 99.95% uptime for critical booking systems.

• Migrated production databases from non-ASM standalone storage to Automatic Storage Management (ASM), improving I/O throughput by 25%.
• Configured and maintained Physical Standby databases using Oracle Data Guard; executed quarterly switchover/failover drills, achieving zero data loss.
• Led RMAN-based backup and recovery operations, restoring a production database after control file loss with recovery time (RTO) under 2 hours.
• Installed and configured 12c/19c RAC environments; applied quarterly PSU/RU patches using OPatch with a rolling-patch methodology to minimize downtime.
• Automated shell scripts for RAC cluster health checks and alert log monitoring, reducing manual monitoring effort by 40%.
• Administered cluster resources using SRVCTL and CRSCTL, maintaining high availability across multi-node RAC configurations.
• Resolved production database incidents within SLA, performing root cause analysis for control file, data file, and tablespace failures.
• Performed database installation and creation using DBCA, OMF, and ASM to support new application onboarding.
• Collaborated with test and application teams to troubleshoot database-related issues, ensuring timely resolution of client-reported tickets.

Oracle Database Administrator at AssureCare Healthtech LLP Pvt Ltd (2022-10 – 2024-04)

Managed end-to-end administration of Oracle 19c databases supporting healthcare applications for 200+ application users.

• Implemented automated backup and restoration procedures using RMAN, reducing the backup window from 6 hours to 2.5 hours through an incremental strategy.
• Performed database upgrade from Oracle 12c to 19c using the AutoUpgrade utility with minimal downtime.
• Created and managed users, roles, profiles, and privileges for 200+ application users, ensuring SOX-compliant access control.
• Monitored database performance using OEM 13c, AWR, and ADDM; tuned critical SQL queries, reducing execution time from 20 minutes to 4 minutes.
• Handled RAC-to-non-RAC cloning and database refreshes for UAT/Dev environments using RMAN DUPLICATE.
• Created and administered ASM instances and ASM disk groups on core production environments.
• Applied quarterly patches using OPatch and coordinated Service Requests (SRs) with Oracle Support for issue resolution.
• Configured and maintained Physical Standby databases using Data Guard, including OCR and voting disk backups for cluster resiliency.
• Automated health-monitoring UNIX shell scripts and performed daily alert log reviews to proactively identify database issues.

Oracle Database Administrator at Microgate Technologies Private Limited (2019-09 – 2021-07)

Administered Oracle databases for an IBM client engagement, managing tablespace growth and resizing data files to prevent space-related outages.

• Created and managed users, groups, roles, and profiles, granting appropriate privileges in line with security policy.
• Performed data migration between databases using Export/Import (Exp/Imp) and Transportable Tablespace utilities.
• Executed weekly and monthly online/offline database backups to ensure data recoverability.
• Performed RMAN, logical, and hot backup procedures to safeguard production data.
• Monitored alert log and trace files, troubleshooting database issues to maintain system stability.
• Administered Oracle RAC databases using SRVCTL and CRSCTL for cluster resource management.
• Supported day-to-day database operations, contributing to consistent uptime for client systems.

Bachelor of Technology in B.Tech – Jawaharlal Nehru Technological University, Anantapur (2018)