PostgreSQL Cluster & Disaster Recovery Setup

Job ID: 38420864

Budget: ₹600 – ₹1,500 INR

[DO NOT APPLY IF YOU DO NOT HAVE AN EXPERIENCE IN IT]
[ELSE I WILL REPORT YOU]

I'm seeking a database expert to set up a PostgreSQL Cluster in AWS EC2 integrated with Barman, Repmgr, and HAProxy. The main goal of this project is to ensure our PostgreSQL database is robust, reliable, and well-prepared for potential data loss or corruption scenarios due to hardware failure or cybersecurity attacks.

Key Responsibilities:
- Implement a PostgreSQL Cluster for high availability, load balancing, and disaster recovery purposes.
- Configure Barman for online backups and recovery management.
- Configure Repmgr for automated failover and cluster management.
- Integrate HAProxy for load balancing and high availability.
- Implement monitoring and alerting mechanisms for the entire setup.

Required skills and experience:
- Proficient in PostgreSQL database administration, and in particular, setting up and managing PostgreSQL Clusters.
- Experience with Barman for backup and restore operations.
- Proficiency in Repmgr for cluster management and failover.
- Experience with HAProxy for load balancing and high availability is essential.
- Expertise in designing disaster recovery plans and handling data loss scenarios due to hardware failure and cybersecurity attacks.

As the data stored in our PostgreSQL database is highly critical, this project demands a reliable and experienced individual who can not only set up the cluster but also prepare it for potential disaster scenarios. If you're confident in your skills and have a track record of similar projects, I'm eager to hear from you.