Clover Infotech logo

Oracle DBA Administrator L2 _ Chennai

Clover Infotech

2 - 5 years

Chennai

Posted:1 day ago

Job Description

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.

Skills Required

Database administration RMAN Dataguard Administration Oracle Golden Gate Oracle DBA L2

Learn the skills this job asks for

See your skill gap for Database Administrator →

Free courses, interview questions and practice for each skill.

Work Mode

Work from Office

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Clover Infotech logo
Clover Infotech

RecommendedJobs for You

Clover Infotech logo
Clover Infotech logo