The ideal candidate brings deep Postgre SQL expertise , hands‑on Patroni experience , and a solid background in production operations and advanced troubleshooting. Experience with My SQL in enterprise environments is highly desirable.
Experience: 4 to 6 years
Job location : Chennai, Thoraipakkam
Education Qualification: BE/BTech/ME/Mtech/MCA/BCA
Available for a Face to Face interview on weekdays
Key Responsibilities
Postgre SQL Architecture & Design
Design and maintain scalable, fault‑tolerant Postgre SQL architectures aligned with Fareportal’s business and growth strategy
Define standards for Postgre SQL cluster design , configuration, versioning, and lifecycle management
Architect and operate high‑availability Postgre SQL environments using Patroni with distributed consensus systems (etcd / Consul)
Lead Postgre SQL upgrades, migrations, and platform modernization initiatives with minimal downtime
Evaluate and implement Postgre SQL extensions, features, and best practices suitable for large‑scale production workloads
Operations & Production Support (Primary Focus)




Own the day‑to‑day operational health of Postgre SQL platforms across production and non‑production environments
Lead major incident response , including failovers, performance degradation, replication issues, and data consistency problems
Perform deep root‑cause analysis (RCA) and drive long‑term corrective and preventive actions
Tune Postgre SQL for performance and stability, including:
Memory and storage optimization
WAL and checkpoint tuning
Autovacuum and bloat management
Query optimization and execution plan analysis
Manage and validate backup, restore, and point‑in‑time recovery strategies (pg Back Rest, Barman, or equivalent)
Act as a senior escalation point during on‑call rotations and high‑severity production events
Patroni & High Availability
Design, configure, and operate Patroni‑based Postgre SQL clusters in production
Troubleshoot and resolve complex HA scenarios such as:
Leader election fa

📌 Senior database engineer (Chennai)
🏢 Bahwan Cybertek
📍 Chennai