Skip to content
All roadmaps

Database Administrator roadmap

SQL, database internals, backup and recovery, tuning, replication and cloud databases.

Interview questions for this role
0% complete0 done · 0 skipped · ~160h left
  1. 1

    Foundations

    SQL and OS.

    Milestone: Can you write joins, aggregates and window queries and explain the plan?

  2. 2

    Core skills

    Administration.

    Milestone: Can you restore a database to a point in time from backups?

  3. 3

    Job-ready

    Performance and HA.

    • Indexing and query tuning

      intermediate~30h

      Why it matters: Performance work is the most visible DBA value.

    • Replication and high availability

      intermediate~25h

      Why it matters: Uptime requirements drive architecture.

    Milestone: Can you diagnose a slow query with indexes and EXPLAIN?