Database Engineer (PostgreSQL & GoldenGate)- Bangalore

Location: Bengaluru  •  Level: Mid Level  •  Openings: 1  •  Type: Full-time
Apply on GO Jobs

Job description

1. Job Details
Job Title: Database Engineer (PostgreSQL & GoldenGate)- Bangalore
Job Location: Bangalore
Work Model: Hybrid (client/project dependent; may require US shift overlap)
2. Candidate Expectations
 
Total and Relevant Experience: 5 to 10 years
Candidate Location: Bangalore
Skills – Mandatory- : PostgreSQL DBA, Oracle GoldenGate, Extract/Replicat/Pump, Uni-directional Replication, Bi-directional Replication, Active-Active Replication, PostgreSQL Performance Tuning, EXPLAIN/ANALYZE, pg_stat_statements, Query Optimization, Indexing, Backup & Recovery, pg_dump, pg_restore, pg_basebackup, WAL Archiving, PITR, HA/DR, Streaming Replication, Shell Scripting, Python, AWS RDS, Aurora PostgreSQL.
Candidate Industry – IT

3. Education and Certification
Qualification: Bachelor's degree in computer science, Information Technology, or related field (or equivalent experience)
Specific Remarks: Distance education not accepted
Certification: No certification required.

4. Detailed Job Description
 
About the Role-
Looking for a Database Engineer with strong hands-on expertise in PostgreSQL and Oracle Goldengate to support mission-critical, high-availability database environments for our enterprise clients.
This role will manage production database operations, replication architectures, performance tuning, and migration initiatives across on-prem and cloud (AWS) environments.
Key Responsibilities
  • Administer, monitor, and support PostgreSQL databases across Production, QA, and Development environments, ensuring high availability and performance.
  • Design, configure, and troubleshoot Oracle GoldenGate replication (uni-directional and bi-directional/active-active) for real-time data synchronization across heterogeneous environments. 
  • Perform database performance tuning using EXPLAIN/ANALYZE, pg_stat_statements, query optimization, and indexing strategies.
  • Manage backup and recovery operations using pg_dump, pg_restore, pg_basebackup, WAL archiving, and Point-in-Time Recovery (PITR).
  • Resolve GoldenGate replication issues including lag, sync-up failures, long-running transactions, and archive log gaps.
  • Support database migrations (Oracle-to-PostgreSQL, on-prem to AWS RDS/Aurora) including schema conversion and data validation using tools such as AWS SCT and DMS.
  • Implement routine maintenance: VACUUM, ANALYZE, autovacuum tuning, partitioning, and bloat management.
  • Configure and maintain PostgreSQL security: roles, privileges, SSL/TLS, pg_hba.conf, and least-privilege access models.
  • Set up and maintain High Availability/Disaster Recovery using streaming replication and automated failover.
  • Collaborate with application, cloud, DevOps, and infrastructure teams to design scalable, secure, and resilient database solutions.
  • Develop automation scripts (Shell/Python/Ansible) to improve operational efficiency and reduce manual intervention.
  • Provide production support, including participation in on-call rotations for 24x7 critical operations.
Required Skills
  • Strong hands-on experience administering PostgreSQL (or Aurora PostgreSQL) in production environments.
  • Proven experience with Oracle GoldenGate — installation, configuration, and troubleshooting of Extract/Replicat/Pump processes.
  • Solid understanding of replication architectures (uni/bi-directional, active-active).
  • Experience with performance tuning tools: pg_stat_statements, EXPLAIN/ANALYZE, query optimization, indexing
  • Backup/recovery expertise: pg_dump, pg_restore, pg_basebackup, WAL-based PITR.
  • Scripting experience in Shell and/or Python for database automation.
  • Familiarity with cloud database platforms (AWS RDS, Aurora); AWS DMS/SCT experience a plus.
Preferred / Nice-to-Have
  • Oracle DBA background (RAC, ASM, Data Guard, RMAN) — useful for hybrid Oracle/Postgres environments.
  • Exposure to MongoDB administration.
  • Oracle Certified Professional (OCP) or equivalent certification.
  • Experience with Exadata, ZDLRA, or large-scale enterprise migrations.
  • Experience with monitoring tools (OEM, CloudWatch, Performance Insights).
Qualifications
  • Bachelor's degree in computer science, Information Technology, or related field (or equivalent experience).
  • 5+ years of database administration/engineering experience, with demonstrable PostgreSQL and GoldenGate work.
 5. Key Skills
Mandatory Key Skills:
PostgreSQL DBA, Oracle GoldenGate, Extract/Replicat/Pump, Uni-directional Replication, Bi-directional Replication, Active-Active Replication, PostgreSQL Performance Tuning, EXPLAIN/ANALYZE, pg_stat_statements, Query Optimization, Indexing, Backup & Recovery, pg_dump, pg_restore, pg_basebackup, WAL Archiving, PITR, HA/DR, Streaming Replication, Shell Scripting, Python, AWS RDS, Aurora PostgreSQL.

Good to Have Skills: Oracle DBA, Oracle RAC, ASM, Data Guard, RMAN, MongoDB, OCP Certification, Exadata, ZDLRA, AWS DMS, AWS SCT, OEM, CloudWatch, Performance Insights, Ansible.

 
 

Job ID: 2132