Database Engineer (PostgreSQL & GoldenGate) (Bengaluru)

Database Engineer (PostgreSQL & GoldenGate) (Bengaluru)

19 Nov
|
Golden Opportunities
|
Bengaluru

19 Nov

Golden Opportunities

Bengaluru

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
- Candidate Industry: IT

Mandatory 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

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

About the Role

Looking for a Database Engineer with solid 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

📌 Database Engineer (PostgreSQL & GoldenGate) (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) (bengaluru) / bengaluru

Subscribe to this job alert:

Get the latest job offers by email for: database engineer (postgresql & goldengate) (bengaluru) / bengaluru