Job Overview
An ideal candidate will be responsible for ensuring high availability, security, and performance of databases. This includes delivering day-to-day support across multi-cloud environments, managing and optimizing PostgreSQL databases to meet service level agreements (SLAs), implementing and maintaining high availability, clustering, and replication solutions using Patroni, and performing reliable backup and recovery operations using pgBackRest.
Key Responsibilities:
* Database Support:
* Deliver day-to-day PostgreSQL support across multi-cloud environments
* Database Optimization:
* Manage and optimize PostgreSQL databases to meet service level agreements (SLAs)
* High Availability Solutions:
* Implement and maintain high availability, clustering, and replication solutions using Patroni
* Backup and Recovery:
* Perform reliable backup and recovery operations using pgBackRest
* Performance Troubleshooting:
* Diagnose and resolve database performance issues
Required Skills and Qualifications:
* Extensive hands-on experience in PostgreSQL administration, performance tuning, and issue resolution
* Proven expertise with Crunchy PostgreSQL and Patroni clustering
* Proficient in pgBackRest for backup and recovery
* Deep understanding of PostgreSQL architecture, replication strategies, and HA configurations
* Strong Linux/Unix system administration background, including advanced Bash scripting
* Experience operating in multi-cloud environments
* Proficiency in monitoring and alerting for large-scale, mission-critical systems