Database Engineer (PostgreSQL & GoldenGate)- Bangalore
Location: Bengaluru • Level: Mid Level • Openings: 1 • Type: Full-time
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
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.
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