Competencies: Databases > Database Administration
Database Administration
Body of Knowledge
| Topic | Description | Relevance | Career Tracks |
|---|---|---|---|
Backup & Recovery |
Backup strategies, point-in-time recovery, disaster recovery, backup testing |
Critical |
DBA, SRE, Infrastructure Engineer |
Performance Tuning |
Query analysis, index optimization, configuration tuning, resource allocation |
Critical |
DBA, Backend Developer, SRE |
High Availability |
Clustering, failover, load balancing, replication, health monitoring |
Critical |
DBA, SRE, Infrastructure Engineer |
Security Hardening |
Authentication, authorization, encryption, audit logging, compliance |
Critical |
DBA, Security Engineer |
Monitoring & Alerting |
Database metrics, slow query analysis, connection monitoring, alerting |
High |
DBA, SRE |
Capacity Planning |
Growth forecasting, resource sizing, scaling strategies, cost optimization |
High |
DBA, Infrastructure Engineer |
Schema Migration |
Migration tools, version control, zero-downtime migrations, rollback |
High |
DBA, Backend Developer, DevOps Engineer |
Connection Management |
Connection pooling, connection limits, timeout configuration, PgBouncer |
High |
DBA, Backend Developer |
Database Upgrades |
Major version upgrades, compatibility testing, upgrade strategies |
High |
DBA, Infrastructure Engineer |
Maintenance Operations |
VACUUM, ANALYZE, reindexing, table bloat, routine maintenance |
High |
DBA |
Personal Status
| Topic | Level | Evidence | Active Projects | Gaps |
|---|---|---|---|---|
To be populated |
— |
— |
— |
— |