Design a Multi-Region Blue/Green Database Deployment for an EdTech Platform
Overview
What this challenge is about.
Design the migration: source PostgreSQL 14 (primary in São Paulo) to target PostgreSQL 16 (primary in Mexico City, replica in Bogotá). Use logical replication for zero-downtime cutover. Plan: (1) standing up target with schema migrated, (2) bootstrapping logical replication, (3) lag monitoring, (4) cutover sequence (DNS switch, write fence, replication lag drain), (5) rollback procedure, (6) per-stage validation. Include a connection-pooler (PgBouncer) story. Deliver a 14-page deployment plan, runbook, validation checklist, and a tabletop-exercise script for the SRE team.
The Brief
What you'll do, and what you'll demonstrate.
Design a zero-downtime multi-region PostgreSQL 14-to-16 blue/green migration with logical replication, cutover, rollback, and tabletop exercise.
Earning criteria — what you'll demonstrate
- Plan logical replication for a major-version PostgreSQL migration
- Design a blue/green cutover with a write-fence and lag-drain step
- Write a rollback procedure that can actually be executed under pressure
- Run a tabletop exercise that surfaces hidden assumptions
Program Fit
Where this fits in your program.
Sharpens the same skills your degree expects you to demonstrate.
Skills
Skills you'll demonstrate.
Each one shows up on your verified credential.
Careers
Roles this prepares you for.
Real titles. Real skill bridges. Pick the one closest to your trajectory.
Career mappings coming soon.