CareerPlane subject · v1
portal
subject · Database Administrator (DBA)

Database Administration

Database Administration for Database Administrator (DBA) on CareerPlane — 5 practical, sandbox-driven topics. Pick a topic to open its interactive lesson.

5 / topics
in the subject
5 / pages
topic pages
L1–L2 / priority
core fundamentals

Topics in Database Administration

05 topics · 05 pages
TOPIC · 01

Database Backup & Recovery Strategies (pg_dump / WAL / PITR)

priority 1 Professional databasebackuprecoverywalpitrpg_dumpdisaster-recovery
TOPIC · 02

Replication & High Availability (Streaming / Logical / Patroni)

priority 1 Professional databasereplicationhigh-availabilitypatronistreamingfailover
TOPIC · 03

Table Partitioning & Sharding Strategies

priority 1 Professional databasepartitioningshardingrangelisthashperformance
TOPIC · 04

Database Monitoring & Performance Tuning (pg_stat / slow queries)

priority 1 Professional databasemonitoringperformancepg_statautovacuumbloat
TOPIC · 05

Migration Planning & Version Upgrades (Zero-Downtime)

priority 2 Professional databasemigrationupgradezero-downtimeblue-greenschema-change
Keep exploring
Back to portal — search every topic across every field, career, and subject. Or browse the full sitemap.xml graph of index + topic pages.