PrepZone Logo
PrepZone
All project ideas

Expert · 4–5 weeks

Zero-Downtime Database Migration Platform

Tooling and runbooks to migrate from monolith DB to service-owned DBs using expand-contract, dual-write, and verification jobs — demonstrated on a sample schema split.

Why this project

Migration strategy is a top staff/architect topic. Shows you have shipped real production changes safely.

Tech stack

Java 17Spring Boot 3PostgreSQLFlywayFeature flags

Skills demonstrated

  • Expand-contract migrations
  • Dual-write pattern
  • Data verification
  • Rollback planning

Interview talking points

  • Expand-contract example on a real table
  • Dual-write consistency window
  • When to stop and rollback
  • Team coordination during migration

Problem statement

Tooling and runbooks to migrate from monolith DB to service-owned DBs using expand-contract, dual-write, and verification jobs — demonstrated on a sample schema split.