Postgresql Database Administrator

PostgreSQL Architecture & Design

• Design and maintain scalable, faulttolerant PostgreSQL architectures aligned with Fareportals business and growth strategy
• Define standards for PostgreSQL cluster design, configuration, versioning, and lifecycle management
• Architect and operate highavailability 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 largescale production workloads

Operations & Production Support (Primary Focus)

• Own the daytoday operational health of PostgreSQL platforms across production and nonproduction environments
• Lead major incident response, including failovers, performance degradation, replication issues, and data consistency problems
• Perform deep rootcause analysis (RCA) and drive longterm 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 pointintime recovery strategies (pgBackRest, Barman, or equivalent)
• Act as a senior escalation point during oncall rotations and highseverity production events

Patroni & High Availability

• Design, configure, and operate Patronibased PostgreSQL clusters in production
• Troubleshoot and resolve complex HA scenarios such as:
• Leader election failures
• Splitbrain 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

CrossDatabase 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