Senior Database Engineer

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 .

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

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

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