LESSON 2 — What a SQL Server DBA Actually Does (Real Responsibilities)

A SQL Server DBA is responsible for database reliability. Reliability includes:

1) Availability (Is it up and running?)

• Prevent downtime

• Respond to incidents quickly

• Keep services stable

2) Recoverability (Can we restore when something breaks?)

• Backups that actually work

• Restores that are tested

• Point-in-time recovery readiness (when required)

3) Security (Is data protected?)

• Access control (logins/users/roles)

• Least privilege

• Auditing and policy discipline

4) Performance (Is it fast and stable?)

• Monitoring CPU/memory/I/O

• Identifying slow queries, blocking, deadlocks

• Indexing and tuning safely

5) Operations (Is it maintained and automated?)

• SQL Server Agent jobs

• Maintenance tasks (integrity checks, stats, index strategy)

• Alerts and reporting

Three DBA “tracks” you will eventually combine

Operations DBA

• backups/restore, jobs, alerts, security basics, maintenance automation

Performance DBA

• query plans, indexing, waits, blocking, tempdb, Query Store

Platform DBA

• upgrades, migrations, HA/DR, capacity planning, patching

A job-ready DBA can do a little of all three, and is strong in at least one.

Daily / Weekly / Monthly DBA Work (what companies expect)

Daily (quick health checks)

• Did backups run successfully?

• Did any critical jobs fail?

• Are there errors in the SQL Server error log?

• Is disk space low?

• Any blocking storms or deadlocks?

• Is anything unusually slow?

Weekly (prevent problems)

• Review performance trends

• Review job history

• Validate at least one restore in a test environment (if possible)

• Check growth patterns (data/log/tempdb)

Monthly (risk control)

• Access review (who should and should not have permissions)

• Maintenance review (integrity checks, stats/index strategy)

• Patch/upgrade planning (if applicable)

• Disaster recovery readiness review

Try it now (5 minutes):
In your DBA Notebook, write:

• 3 daily checks you will always do

• 2 weekly checks

• 1 monthly check