Projects for PostgreSQL DBAs
PostgreSQL DBA projects are hands-on exercises that show production skills: tuning a slow workload from seconds to milliseconds, building a highly available cluster with automated failover, and running a disaster recovery drill with point-in-time recovery. Each one produces measurable evidence for a portfolio.
Stage: Capstone and Career · Part of the PostgreSQL DBA roadmap · Last reviewed 19 November 2026
What to learn in Projects
- Capture a baseline, then tune a slow workload with plans, indexes and statistics
- Build a primary and replicas with Patroni and test failover
- Restore a database to a chosen timestamp from a base backup and WAL archive
- Record before and after metrics for every change
- Document the setup so another person can rebuild it
Projects interview questions
How do you prove a tuning project improved performance rather than relying on a single run?
Capture a repeatable workload with pgbench or recorded queries, measure latency percentiles and pg_stat_statements totals before and after each change, test warm and cold cache, and change one thing at a time so gains map to specific fixes.
What should a disaster recovery drill demonstrate?
That you can restore to a specific point in time within the stated RTO, that the data is consistent after recovery, and that the team can follow the written steps. Record durations, problems found and the fixes made.
Where Projects fits in the PostgreSQL DBA roadmap
Projects belongs to the Capstone and Career stage (advanced level), which takes about 6 hours. Operate a real database.
Other units in this stage
Back to the full PostgreSQL DBA roadmap