PostgreSQL DBA Internship Interview Questions for Freshers (with Answers)
By K. Boopathikumar, CEO & Founder · 16 November 2026 · 7 min read
PostgreSQL DBA interns help keep databases fast, safe and recoverable. Interviews test PostgreSQL internals at a basic level, query tuning and backup and recovery.
Internals
- What is MVCC? Multi-version concurrency control: each update creates a new row version, so readers do not block writers.
- Why is VACUUM needed? To clean up old row versions, reclaim space and prevent transaction ID wraparound. Autovacuum does this automatically when tuned.
- What is the WAL? The write-ahead log records changes before they reach data files, enabling crash recovery and replication.
- What are tablespaces and schemas? Tablespaces set where data is stored on disk; schemas group objects logically inside a database.
Performance
- How do you find a slow query? Use pg_stat_statements to find heavy queries, then EXPLAIN ANALYZE to see the plan.
- B-tree vs GIN vs BRIN index? B-tree for equality and ranges; GIN for arrays, JSONB and full-text search; BRIN for very large tables with naturally ordered data.
- Why might an index not be used? Low selectivity, functions on the column, type mismatches or outdated statistics.
- What is connection pooling? Reusing database connections with a tool such as PgBouncer, because each connection uses memory.
Backup and security
- pg_dump vs physical backups? pg_dump creates logical backups of databases; physical backups (pg_basebackup) copy files and, with WAL, allow point-in-time recovery.
- What is streaming replication? A standby server applies WAL from the primary to stay in sync for failover and read scaling.
- How do you manage access? Roles with least privilege, grants per schema and table, and pg_hba.conf rules for connections.
- How do you know a backup works? Restore it regularly on another server and check the data.
How to answer well in the interview
- Show an EXPLAIN plan you improved.
- Talk about restore tests, not just backups.
- Know common monitoring views.
- Practise on Docker PostgreSQL locally.
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.