Job Summary
We are looking for an experienced Oracle DBA L2 Support professional with strong expertise in Oracle Database Administration, Data Guard, and GoldenGate. The candidate should have hands-on experience in database monitoring, troubleshooting, performance tuning, replication, backup and recovery, and production database support.
Key Responsibilities
- Provide L2 support for Oracle databases in a production environment.
- Perform database administration activities, including installation, configuration, patching, and upgrades.
- Monitor and maintain Oracle database availability, performance, and stability.
- Manage Oracle Data Guard configuration, monitoring, troubleshooting, and failover/switchover activities.
- Handle Oracle GoldenGate configuration, monitoring, replication, and troubleshooting.
- Troubleshoot replication lag, synchronization issues, and database connectivity problems.
- Perform database backup and recovery activities using RMAN.
- Monitor database performance and perform SQL query tuning and optimization.
- Manage tablespaces, datafiles, users, roles, privileges, and database objects.
- Handle database incidents, service requests, and problem management within defined SLAs.
- Perform database health checks and proactive monitoring.
- Coordinate with L1, L3, application, and infrastructure teams for production issues.
- Participate in disaster recovery (DR) drills and database recovery activities.
- Maintain technical documentation, SOPs, and operational reports.
Mandatory Technical Skills
- Minimum 5+ years of experience in Oracle Database Administration.
- Strong hands-on experience in Oracle Database 11g/12c/19c.
- Good expertise in Oracle Data Guard (Physical Standby, Switchover, Failover).
- Strong knowledge of Oracle GoldenGate replication and troubleshooting.
- Experience in L2 production database support.
- Good knowledge of RMAN backup and recovery.
- Experience in database performance monitoring and SQL tuning.
- Knowledge of RAC architecture and troubleshooting.
- Strong understanding of database troubleshooting and incident management.
Additional Skills
- Knowledge of Linux/Unix commands and shell scripting.
- Experience with OEM (Oracle Enterprise Manager).
- Understanding of high availability (HA) and disaster recovery (DR) concepts.
- Knowledge of ITIL processes and ticketing tools.
- Good communication and coordination skills.
Candidate Requirements
- 5+ years of relevant Oracle DBA experience.
- Strong hands-on experience in Data Guard and GoldenGate is mandatory.
- Should have experience supporting mission-critical production databases.
- Willingness to work in rotational shifts, if required.
Chennai-based candidates or candidates willing to work from Chennai preferred.