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