PostgreSQL DBA Internship Roadmap: What to Learn Before You Apply
By K. Boopathikumar, CEO & Founder · 16 November 2026 · 6 min read
This PostgreSQL DBA roadmap takes you from the basics to internship-ready in about four months of steady practice. Finish each stage's project before moving on; the projects are what interviewers ask about.
Stage 1: SQL (3 weeks)
- Queries.
- Joins.
- Transactions.
- Build: a sample database with queries.
Stage 2: Internals (3 weeks)
- MVCC and VACUUM.
- WAL.
- Configuration.
- Build: notes with experiments.
Stage 3: Tuning (3 weeks)
- EXPLAIN.
- Indexes.
- pg_stat_statements.
- Build: an index tuning report.
Stage 4: Recovery and HA (3 weeks)
- Backups and PITR.
- Replication.
- Roles and access.
- Build: a tested restore and a replica.
You are ready to apply when you can
- Explain MVCC.
- Read an EXPLAIN plan.
- Restore to a point in time.
- Set up a replica.
Next steps
- Study the free PostgreSQL DBA learning path and take its module quizzes for a free certificate.
- Follow the PostgreSQL DBA skill track from basic to advanced.
- Do real, reviewed work in a PostgreSQL DBA internship and keep every project in your own GitHub.