Hot-Standby Disaster Recovery for 50 TB PostgreSQL with Patroni, S3 WAL-E & Route 53 Failover <2 min
Posted 10 months ago · 0 proposals
Budget
$2,800.00
Level
Senior
Location
France
Posted
Sep 26, 2025
Proposals
0
Job Type
Fixed Price
Crisis Scenario:
You run a 50 TB PostgreSQL 14 cluster on bare-metal in London. Last fiber cut gave 7 h outage and $2 M lost bookings. Board now mandates hot-standby DR site in Frankfurt with automatic failover <2 min and zero data loss.
Senior Solution Deliverables:
- Patroni 3-node cluster ( London leader, Frankfurt sync standby, Frankfurt async ).
- Continuous WAL archiving to S3 Glacier via WAL-E ( 30-day retention ).
- Route 53 health-check + Patroni REST API → DNS flip in <90 s.
- Chaos test : iptables DROP on primary → measured failover 1 min 47 s.
Jean Dupont
Client · France
We are hiring a Business Continuity Planner to develop a comprehensive strategy for maintaining oper...
We are looking for a Backup Automation Specialist to automate and optimize our data backup processes...
We are seeking a Data Recovery Expert to implement and manage data recovery solutions, ensuring data...
We are hiring a Backup Security Analyst to secure our backup systems, ensuring data integrity and pr...
Login as a freelancer to apply
Jean Dupont
France