Database Engineer (PostgreSQL & GoldenGate)- Bangalore - GO/JC/5031/2026 (Bengaluru)

Database Engineer (PostgreSQL & GoldenGate)- Bangalore - GO/JC/5031/2026 (Bengaluru)

19 Nov
|
Golden Opportunities
|
Bengaluru

19 Nov

Golden Opportunities

Bengaluru

- Job Details

Job Title: Database Engineer (PostgreSQL & GoldenGate)- Bangalore Job Location: Bangalore Work Model: Hybrid (client/project dependent; may require US shift overlap)

- 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

- 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.

- Detailed

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

- Solid 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.
- 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.

📌 Database Engineer (PostgreSQL & GoldenGate)- Bangalore - GO/JC/5031/2026 (Bengaluru)
🏢 Golden Opportunities
📍 Bengaluru

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: database engineer (postgresql & goldengate)- bangalore - go/jc/5031/2026 (bengaluru) / bengaluru

Subscribe to this job alert:

Get the latest job offers by email for: database engineer (postgresql & goldengate)- bangalore - go/jc/5031/2026 (bengaluru) / bengaluru