Fareportal is seeking a Senior PostgreSQL Database Administrator to design, operate, and evolve highly available, scalable PostgreSQL platforms that support Fareportal’s global travel technology ecosystem. This role is critical to ensuring the availability, performance, and resilience of mission critical database systems powering Fareportal’s high volume, customer facing applications.

The ideal candidate brings deep PostgreSQL expertise, hands on Patroni experience, and a strong background in production operations and advanced troubleshooting. Experience with MySQL in enterprise environments is highly desirable.

Key Responsibilities

PostgreSQL Architecture & Design

Design and maintain scalable, fault tolerant PostgreSQL architectures aligned with Fareportal’s business and growth strategy

Define standards for PostgreSQL cluster design, configuration, versioning, and lifecycle management

Architect and operate high availability PostgreSQL environments using Patroni with distributed consensus systems (etcd / Consul)

Lead PostgreSQL upgrades, migrations, and platform modernization initiatives with minimal downtime

Evaluate and implement PostgreSQL extensions, features, and best practices suitable for large scale production workloads

Operations & Production Support (Primary Focus)

Own the day to day operational health of PostgreSQL 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 PostgreSQL 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 (pgBackRest, 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 PostgreSQL clusters in production

Troubleshoot and resolve complex HA scenarios such as:

Leader election failures

Split brain conditions

Network partitions and fencing issues

Define and tune HA behavior (failover, switchover, synchronous replication settings)

Establish protected maintenance, patching, and upgrade procedures for HA environments

Automation, Monitoring & Reliability

Drive automation initiatives for PostgreSQL provisioning, configuration, patching, and deployments

Implement proactive monitoring and ing for performance, replication, capacity, and availability

Partner with SRE and infrastructure teams to improve platform reliability, quality, and operational tooling

Develop and maintain operational documentation, runbooks, and standard operating procedures

Cross Database Expertise (Desired)

Provide architectural and operational guidance for MySQL platforms where applicable

Troubleshoot MySQL performance, replication, and availability issues

Support coexistence or migration strategies between PostgreSQL and MySQL environments

Infrastructure & Tooling

Strong Linux fundamentals

Experience with cloud or hybrid environments (AWS / Azure / GCP)

Familiarity with monitoring tools (Prometheus, Grafana, Datadog, etc.)

Scripting skills in Bash, Python, or similar

📌 Senior Database Administrator – PostgreSQL (Chennai)
🏢 Bahwan Cybertek
📍 Chennai