Postgre SQL DBA

📋 Description

• Manage the complete database lifecycle, including standard installations, version upgrades
• Optimize database performance through advanced query tuning, index optimization, and the
• Develop and maintain robust backup and recovery strategies to meet strict Recovery Point Objective
• Collaborate closely with infrastructure teams on Red Hat Enterprise Linux (RHEL) system
• Design and implement Patroni and etcd streaming-replication HA architectures for both
• Design and implement shared-storage Active-Passive clusters utilizing Pacemaker, Corosync, qdevice

🎯 Requirements

• 6-8 years of proven experience as an Enterprise Database Administrator (Extensive PostgreSQL
• Demonstrated, hands-on engineering experience with both shared-storage clusters (Pacemaker
• Strong bash scripting proficiency, demonstrating the capability to navigate existing deployment
• Working technical knowledge of SAN/NAS shared storage architectures, MPIO multipathing, WWID
• Deep understanding of database internals, MVCC (Multi-Version Concurrency Control), vacuuming
• Proven ability to independently author complex HLD documents, articulate technical strategies, and