Database Administrator roadmap
SQL, database internals, backup and recovery, tuning, replication and cloud databases.
Interview questions for this role0% complete0 done · 0 skipped · ~160h left
- 1
Foundations
SQL and OS.
SQL in depth
basic~40hWhy it matters: All DBA work builds on SQL.
Linux administration
basic~25hWhy it matters: Databases run on Linux servers.
Milestone: Can you write joins, aggregates and window queries and explain the plan?
- 2
Core skills
Administration.
Backup, restore and recovery
intermediate~25hWhy it matters: Data loss is the career-ending failure.
Users, roles and security
intermediate~15hWhy it matters: Least privilege and auditing are expected.
Milestone: Can you restore a database to a point in time from backups?
- 3
Job-ready
Performance and HA.
Indexing and query tuning
intermediate~30hWhy it matters: Performance work is the most visible DBA value.
Replication and high availability
intermediate~25hWhy it matters: Uptime requirements drive architecture.
Milestone: Can you diagnose a slow query with indexes and EXPLAIN?