Role Summary
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 safe 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 alerting for performance, replication, capacity, and availability
Partner with SRE and infrastructure teams to improve platform reliability, alert 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