1Designing scalable, highly available databases

• 1.1Capacity planning and HA/DR design

  Understand database capacity/usage planning from current workload metrics and future requirements, performance/cost tradeoffs, multi-regional/regional/zonal deployment strategies, maintenance windows, and designing high availability and disaster recovery to meet RTO/RPO/PITR.

• 1.2Connectivity, access, and choosing databases

  Understand network connectivity, key management, encryption, and security for databases, using session poolers, auditing policies, and choosing the right database solution by managed/unmanaged, SQL/NoSQL/vector, cost, regulation, and generative AI/LLM support.