Senior Database Engineer

As an ideal candidate for the position, you will need to possess deep expertise in PostgreSQL, hands-on experience with Patroni, and a solid background in production operations and advanced troubleshooting. Experience with MySQL in enterprise environments is considered highly desirable. ### Key Responsibilities: - PostgreSQL Architecture & Design: - Design and maintain scalable, fault-tolerant PostgreSQL architectures aligned with Fareportals 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, and query optimization. - 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, and network partitions. - 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. ### Qualification Required: - Education: BE/BTech/ME/Mtech/MCA/BCA - Experience: 4 to 6 years - Job Location: Chennai, Thoraipakkam - Available for a Face to Face interview on weekdays In addition to the above responsibilities and qualifications, you should be well-versed in strong Linux fundamentals, have experience with cloud or hybrid environments (AWS/Azure/GCP), and be familiar with monitoring tools such as Prometheus, Grafana, and Datadog. Additionally, scripting skills in Bash, Python, or similar languages would be beneficial. As an ideal candidate for the position, you will need to possess deep expertise in PostgreSQL, hands-on experience with Patroni, and a solid background in production operations and advanced troubleshooting. Experience with MySQL in enterprise environments is considered highly desirable. ### Key Responsibilities: - PostgreSQL Architecture & Design: - Design and maintain scalable, fault-tolerant PostgreSQL architectures aligned with Fareportals 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, and query optimization. - 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, an