Oracle Golden Gate DBA

About the role

We are looking for a seasoned Oracle Database Administrator with strong expertise in Oracle GoldenGate and PostgreSQL to manage mission critical database environments. The role requires hands on experience in high availability replication, backup recovery, performance tuning and production support across on‑prem and cloud platforms.

Responsibilities

• Administer Oracle databases 11g,12c,18c,19c across production and non‑production environments
• Design, implement and support Oracle GoldenGate Classic Microservices for real‑time data replication
• Install, configure and manage PostgreSQL databases on‑prem and cloud (AWS RDS, Aurora, Azure, OCI)
• Perform backup, recovery and DR operations using RMAN, Data Pump and PostgreSQL tools
• Monitor and tune database performance using AWR, ASH, OEM, pgstat, EXPLAIN plans
• Manage high availability solutions: Oracle RAC, Data Guard, Active Data Guard, PostgreSQL replication
• Apply patching, upgrades and security fixes while ensuring minimal downtime
• Support database migrations and upgrades, including Oracle to PostgreSQL
• Automate routine DBA activities using shell scripting, Python, Ansible
• Provide L2/L3 production support, RCA and on‑call support for critical incidents
• Work closely with application, infrastructure and cloud teams

Requirements

• Oracle DBA – 7 years enterprise experience
• Oracle GoldenGate – installation, configuration, monitoring, troubleshooting
• PostgreSQL DBA – administration, backup, replication, performance tuning
• Backup & Recovery – RMAN, Data Pump, pg_dump, pg_restore
• Performance Tuning – SQL tuning, AWR, ASH, PostgreSQL monitoring
• High Availability – Oracle RAC, Data Guard, PostgreSQL streaming/logical replication
• Linux/Unix administration
• Production support in 24×7 enterprise environments

Skills

• Cloud databases – AWS RDS, Aurora, PostgreSQL, OCI, Azure
• Oracle GoldenGate Classic Microservices migration
• Oracle to PostgreSQL migration tools – ORA2PG, DMS
• Automation – Ansible, Terraform, CI/CD pipelines
• Monitoring tools – OEM, Dynatrace, CloudWatch, Prometheus
• BFS domain experience – Banking, Financial Services
• Certifications – Oracle Certified Professional (OCP); PostgreSQL or Cloud certifications (AWS, Azure, OCI)
• Soft skills – strong troubleshooting and analytical skills
• Soft skills – excellent communication and stakeholder coordination
• Soft skills – ability to work in high‑pressure production environments

Benefits

• Comprehensive Medical Plan covering Medical, Dental, Vision
• Short Term and Long‑Term Disability Coverage
• 401(k) Plan with Company match
• Life Insurance
• Vacation Time, Sick Leave, Paid Holidays
• Paid Paternity and Maternity Leave