Oracle Certified Database Administrator with 3+ years of hands-on experience in managing mission-critical Oracle database environments in both cloud (OCI) and on-premise setups. Proficient in installation, configuration, patching, performance tuning, and troubleshooting of Oracle Databases. Skilled in Oracle GoldenGate (Microservices & Classic), Oracle Data Guard, RMAN, RAC/Grid Infrastructure, and SQL/PLSQL. Experienced in 24x7 production support, backup & recovery, and monitoring via OEM and ServiceNow. Adept at collaborating with cross-functional teams and ensuring database availability, security, and performance. Passionate about database automation and cloud technologies with certifications in OCI and Azure.
1. Managing Oracle 19c/12c databases on Oracle Cloud Infrastructure (OCI), and on-premise setups.
2. Performing installation, configuration, and upgrade of Oracle databases in production and pre-production environments.
3. Hands-on experience with Oracle GoldenGate (Microservices and Classic) for real-time replication and disaster recovery.
4. Managing Oracle Data Guard for standby configuration, switchovers, failovers, and DR drills.
5. Implementing RMAN-based backup and recovery strategies, including cloning, and disaster recovery testing.
6. Monitoring database performance using AWR, ADDM, and ASH reports; performing tuning and optimization activities.
7. Creating and managing users, roles, privileges, and tablespaces as part of daily DBA tasks.
8. Proactively monitoring databases using Oracle Enterprise Manager (OEM), and internal scripts.
9. Managing ServiceNow tickets for incident, problem, and change management.
10. Applying patch sets and PSU updates across multiple database environments.