PostgreSQL Database Administrator
- Location
- Greater London, England, United Kingdom
retention, lag, and timeline issues; usepg_rewindwhenappropriate toresynchronize a node after timelines diverge. Performance engineering.Analyze execution plans and wait or lock behavior, tune SQL and indexes, andoptimizePostgreSQL and operating-system settings, includingautovacuum, memory, storage, and checkpoint or WAL behavior. Connectivity and security.OperatePgBouncerand manage roles, privileges, authentication,pg_hba.conf, TLS, secrets … full restore or disaster-recovery testing. Strong knowledge of PostgreSQL internals, including WAL, MVCC, vacuum andautovacuum, checkpoints, memory management, locking, and transaction behavior. Strong SQL performance-tuning skills, including EXPLAIN (ANALYZE, BUFFERS), index design, query-plan analysis, and diagnosis of blocking or resource contention. Solid Linux administration and troubleshooting skills ...