Hot-Standby Disaster Recovery for 50 TB PostgreSQL with Patroni, S3 WAL-E & Route 53 Failover <2 min

Job Overview

Budget

$2,800.00

Level

Senior

Location

France

Job Posted

26 Sep, 2025

Category

backup

Total Proposals

0

Job Description

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.

Skills

  • Recovery and restoration
  • Virtual storage disaster recovery

Tags

Recovery and restoration Virtual storage disaster recovery

Author Spotlight

Jean Dupont

Jean Dupont

Client

No description available.

Related Jobs

1 year ago Senior
$70.00 Hourly

We are hiring a Business Continuity Planner to develop a comprehensive strategy for maintaining operations during disrup...

Risk assessment and analysis
View More
1 year ago MidLevel
$65.00 Hourly

We are looking for a Backup Automation Specialist to automate and optimize our data backup processes. This role involves...

Backup automation for different backup types (e.g., file backup, database backup, application backup)
View More
1 year ago MidLevel
$60.00 Hourly

We are seeking a Data Recovery Expert to implement and manage data recovery solutions, ensuring data can be restored eff...

Data recovery tools and technologies
View More
1 year ago MidLevel
$60.00 Hourly

We are hiring a Backup Security Analyst to secure our backup systems, ensuring data integrity and protection against ran...

Backup data encryption
View More
Jean Dupont

Jean Dupont

France


Member Since
Oct 26, 2024
Total Created Jobs
5