Skip to main content

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

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.

Back to the full PostgreSQL DBA roadmap