Training Trains logo

PostgreSQL DBA Internship Project Ideas: Beginner to Advanced

By K. Boopathikumar, CEO & Founder · 16 November 2026 · 6 min read

Run PostgreSQL in Docker or a VM for these projects. Load a sample database with enough rows (a million or more) to make tuning meaningful.

Beginner

  • Install and secure: Install PostgreSQL, create roles and restrict connections. You learn: setup and access control.
  • Backup and restore: Nightly pg_dump with a restore test. You learn: logical backups.
  • Sample database design: Design and load a normalised schema. You learn: schema design.

Intermediate

  • Index tuning study: Measure query times before and after indexes. You learn: EXPLAIN and indexing.
  • Autovacuum tuning: Observe table bloat and tune settings. You learn: maintenance.
  • Monitoring dashboard: Track connections, slow queries and cache hits. You learn: monitoring.

Advanced

  • Streaming replica and failover: Set up a standby and practise failover. You learn: high availability.
  • Point-in-time recovery: Recover to a time before a mistaken delete. You learn: PITR with WAL archiving.
  • Partitioning: Partition a large table by date and compare performance. You learn: scaling large tables.

How to make any of these projects stand out

  • Show timings before and after.
  • Document recovery steps.
  • Keep scripts in GitHub.
  • Test every backup by restoring.

Next steps

Looking for an internship near Erode?

10 days to 6 months, online or at our Erode and Perundurai branches, with a verifiable certificate.

See internships →

More guides