Source description
About the role
Experience : 4 to 6 years Job Description: We are looking for a Senior PostgreSQL Database Administrator to manage and scale highly available, high-performance database systems supporting mission-critical, customer-facing applications. The ideal candidate should have solid PostgreSQL expertise, hands-on experience with Patroni, and proven experience in production support and database performance optimization. Experience with MySQL is an added advantage. Key Responsibilities: PostgreSQL Administration & Architecture Design and manage scalable, high-availability PostgreSQL environments Work on Patroni-based HA clusters (etcd/Consul) Perform database upgrades, migrations, and patching Production Support (Primary Role) Handle database incidents, failover, and performance issues Perform query tuning, performance optimization, and RCA Manage backup and recovery strategies (pgBackRest/Barman) Performance Tuning Optimize memory, storage, WAL, autovacuum Analyze execution plans and improve query efficiency Automation & Monitoring Implement monitoring using Prometheus, Grafana, Datadog Automate DBA tasks using Bash/Python High Availability (Patroni) Handle failover, split-brain, replication issues Configure and tune HA and replication settings Required Skills: PostgreSQL Administration (Mandatory) Patroni & High Availability Setup Performance Tuning & Query Optimization Backup & Recovery Linux/Unix Systems Monitoring Tools (Prometheus, Grafana, etc.) Scripting (Bash/Python) Preferred Skills: MySQL Administration Cloud Platforms (AWS / Azure / GCP) Automation & DevOps exposure Experience : 4 to 6 years Job Description: We are looking for a Senior PostgreSQL Database Administrator to manage and scale highly available, high-performance database systems supporting mission-critical, customer-facing applications. The ideal candidate should have solid PostgreSQL expertise, hands-on experience with Patroni, and proven experience in production support and database performance optimization. Experience with MySQL is an added advantage. Key Responsibilities: PostgreSQL Administration & Architecture Design and manage scalable, high-availability PostgreSQL environments Work on Patroni-based HA clusters (etcd/Consul) Perform database upgrades, migrations, and patching Production Support (Primary Role) Handle database incidents, failover, and performance issues Perform query tuning, performance optimization, and RCA Manage backup and recovery strategies (pgBackRest/Barman) Performance Tuning Optimize memory, storage, WAL, autovacuum Analyze execution plans and improve query efficiency Automation & Monitoring Implement monitoring using Prometheus, Grafana, Datadog Automate DBA tasks using Bash/Python High Availability (Patroni) Handle failover, split-brain, replication issues Configure and tune HA and replication settings Required Skills: PostgreSQL Administration (Mandatory) Patroni & High Availability Setup Performance Tuning & Query Optimization Backup & Recovery Linux/Unix Systems Monitoring Tools (Prometheus, Grafana, etc.) Scripting (Bash/Python) Preferred Skills: MySQL Administration Cloud Platforms (AWS / Azure / GCP) Automation & DevOps exposure
More at Bahwan CyberTek