Database Ops

PostgreSQL backup and restore with pgBackRest — full/incremental/WAL, PITR, K8s CronJob scheduling, and restore verification.

PostgreSQL query performance — EXPLAIN ANALYZE, index design, pg_stat_statements, slow query detection, connection pool tuning.

Safe database migrations in production — expand-and-contract, lock-safe DDL, timing estimation, rollback SQL.

Redis operational runbooks — memory management, eviction policy, persistence config, Sentinel/Cluster, K8s-hosted Redis ops.

PostgreSQL operational runbooks — health checks, vacuum, bloat, locks, PITR, connection pool management.