Design a Zero-Downtime Multi-Region PostgreSQL Migration for an EdTech Platform
Overview
What this challenge is about.
Design a Zero-Downtime Multi-Region PostgreSQL Migration for an EdTech Platform. Advanced challenge in design. Designing real products under real constraints...
The Brief
What you'll do, and what you'll demonstrate.
Design a zero-downtime, blue/green migration of Aprende's product database from a single-region PostgreSQL 14 primary to a multi-region PostgreSQL 16 active-passive setup, complete with logical replication, a safe cutover, a rollback path, and a rehearsal script.
This is not a design exercise. It is the work a product designer does between a brief and a shipped interface. That distinction matters to every hiring manager who has seen candidates redesign Spotify's homepage and none who have worked under real product constraints.
When you finish, you will have something most graduates do not: a real-world deliverable, verified by Ewance, that you can show to a hiring manager and say "I did this. Here is the proof."
Earning criteria — what you'll demonstrate
- Design a blue/green database cutover that keeps an application online while two database stacks run in parallel
- Configure PostgreSQL logical replication correctly for a major-version upgrade, including handling of tables without primary keys and sequence synchronization
- Sequence a safe cutover using a write fence, replication-lag drain, and validation gates with a defined rollback at every stage
- Translate a migration design into an executable runbook and validation checklist a small on-call team can follow under pressure
- Author a tabletop exercise that surfaces migration-specific failure modes rather than generic incident-response steps
Program Fit
Where this fits in your program.
Sharpens the same skills your degree expects you to demonstrate.
Aligned coursework coming soon.
Skills
Skills you'll demonstrate.
Each one shows up on your verified credential.
- Blue Green Deployment
Apply blue green deployment to solve real industry problems and demonstrate production-level capability.
- Logical Replication
Apply logical replication to solve real industry problems and demonstrate production-level capability.
- Postgresql
Apply postgresql to solve real industry problems and demonstrate production-level capability.
- Zero Downtime Migration
Apply zero downtime migration to solve real industry problems and demonstrate production-level capability.
- Runbooks
Apply runbooks to solve real industry problems and demonstrate production-level capability.
- Tabletop Exercise
Apply tabletop exercise to solve real industry problems and demonstrate production-level capability.
Careers
Career paths this challenge builds toward
Completing this challenge demonstrates skills that transfer directly to these roles:
Site Reliability Engineer
Designing a reversible, multi-region database cutover is core reliability work. This challenge builds the judgment to plan zero-downtime migrations, gate risky operations behind validation, and write runbooks a small on-call team can execute without surprises.
This challenge sharpens
- zero-downtime-migration
- runbooks
- blue-green-deployment
Database Reliability Engineer
Database reliability engineers own major-version upgrades and replication topologies. Here you handle PostgreSQL 14-to-16 logical replication, sequence and primary-key edge cases, and lag-aware cutover planning, exactly the skills these roles screen for.
This challenge sharpens
- logical-replication
- postgresql
- zero-downtime-migration
Platform Engineer
Platform engineers ship safe change to shared infrastructure. This challenge develops blue/green deployment patterns, runbook authoring, and rehearsal-driven readiness that translate directly to rolling out high-risk platform changes with confidence.
This challenge sharpens
- blue-green-deployment
- runbooks
- tabletop-exercise