Database Engineer (PostgreSQL & GoldenGate)

5 - 10 years

Bengaluru

Posted:4 hours ago

Job Description

1. Job Details

Job Title:

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:

Specific Remarks:

Certification:

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

Skills Required

Amazon Rds Query Oracle Postgresql DBMS Python AWS RAC

Learn the skills this job asks for

See your skill gap for Database Administrator →

Free courses, interview questions and practice for each skill.

Work Mode

Work from Office

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now
Golden Opportunities logo
Golden Opportunities

Career Services

Opportunities City

RecommendedJobs for You