PostgreSQL Database Administrator
- Location
- Greater London, England, United Kingdom
agreed RPO and RTO targets. Monitoring and alerting with PEM.Register and manage servers and agents, configure meaningful metrics and alert thresholds, investigate alerts and performance trendsusing graphs, andmaintainnotification and escalation integrations. Automation and version control.Use TPA and Ansible/Spaceliftto build repeatable PostgreSQL/EDB environments andmaintainplaybooks and configuration … recovery.Configure and troubleshoot physical streaming and logical replication, replication slots, WAL 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 ...