Oracle Database Administrator + GoldenGate

Advance Career Solutions; India; On-site; INR 1,400,000 - 2,100,000; Full time

Job summary

Advance Career Solutions is seeking an experienced Oracle Database Administrator (DBA) with strong hands-on expertise in Oracle Database Administration and Oracle GoldenGate. The candidate will be responsible for database installation, configuration, performance tuning, backup and recovery, high availability, replication, and production support.

This permanent position is PAN India and targets candidates with 5–8 years of experience.

Qualifications

• Oracle Database Administration and GoldenGate expertise required.
• Experience with RMAN backup, recovery, and high availability.
• Strong SQL/PL-SQL, performance tuning, and security skills.
• Production support and on-call experience.

Responsibilities

• Install, configure, patch, and maintain Oracle databases.
• Monitor health, performance, storage, and availability.
• Tune SQL/PL-SQL and optimize performance.
• Manage replication via GoldenGate Extract/Data Pump/Replicat.
• Provide L2/L3 production support and incident RCAs.

Skills

Oracle Database Administration

Oracle GoldenGate

SQL/PLSQL

Performance tuning

RMAN Backup & Recovery

Replication

Linux/Unix

Shell scripting

Data Guard

Oracle RAC

OEM

Production support

Cloud database platforms

Tools

Oracle Enterprise Manager (OEM)

Job description

Job Description Oracle Database Administrator + GoldenGate

Job Title: Oracle Database Administrator + GoldenGate
Experience: 5–8 Years
Location: PAN India
Employment Type: Permanent

Job Summary

We are looking for an experienced Oracle Database Administrator (DBA) with strong hands‑on expertise in Oracle Database Administration and Oracle GoldenGate. The candidate will be responsible for database installation, configuration, performance tuning, backup and recovery, high availability, replication, and production support.

Key Responsibilities

Oracle Database Administration

• Install, configure, upgrade, patch, and maintain Oracle databases.
• Perform day-to-day administration across development, test, and production environments.
• Monitor database health, availability, storage, and performance.
• Perform SQL/query performance tuning, indexing, and database optimization.
• Manage users, roles, privileges, and database security.
• Troubleshoot database connectivity, performance, locking, and space-related issues.
• Support database migration, refresh, and environment-related activities.

Oracle GoldenGate

• Install, configure, and administer Oracle GoldenGate environments.
• Configure and manage Extract, Data Pump, and Replicat processes.
• Monitor replication lag, trail files, processes, and data synchronization.
• Troubleshoot replication failures, abends, latency, and data consistency issues.
• Perform GoldenGate upgrades, configuration changes, and maintenance activities.
• Support real‑time and near‑real‑time data replication between Oracle databases.
• Perform recovery and restart of GoldenGate processes while maintaining data integrity.

Backup, Recovery & High Availability

• Manage RMAN backup and recovery activities.
• Support disaster recovery and business continuity initiatives.Perform database recovery, restore, and failover-related activities.
• Monitor database availability and ensure SLA compliance.

Production Support

• Provide L2/L3 production support for critical Oracle databases and replication environments.
• Analyze incidents and perform root‑cause analysis.
• Participate in change, release, and maintenance activities.
• Coordinate with application, infrastructure, network, and support teams.
• Participate in on‑call and weekend support as required.

Mandatory Skills

• Oracle Database Administration
• Oracle GoldenGate
• Oracle installation, configuration, patching, and upgrades
• GoldenGate Extract, Pump, and Replicat
• Replication monitoring and troubleshooting
• RMAN Backup & Recovery
• SQL and PL/SQL
• Performance tuning
• Database security and user management
• Production support

Good to Have

• Oracle RAC
• Oracle Data Guard
• Oracle Enterprise Manager (OEM)
• Linux/Unix administration
• Shell scripting
• Cloud database platforms
• Data migration and upgrade experience
• High Availability and Disaster Recovery

Candidate Profile

• 5–8 years of experience in Oracle Database Administration.
• Strong hands‑on experience with Oracle GoldenGate in enterprise environments.
• Good understanding of database performance, backup/recovery, replication, and production support.
• Strong troubleshooting and problem‑solving skills.
• Good communication and collaboration skills.

Key Skills

Oracle DBA | Oracle Database | GoldenGate | Extract | Data Pump | Replicat | RMAN | SQL | PL/SQL | Performance Tuning | Replication | Backup & Recovery | Oracle RAC | Data Guard | Linux | Production Support