18 Nov
|
Clover Infotech
|
Chennai
18 Nov
Clover Infotech
Chennai
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).
- Solid 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.
📌 Oracle DBA Administrator_ Chennai
🏢 Clover Infotech
📍 Chennai