PostgreSQL Database Administrator
- Location
- Greater London, England, United Kingdom
targets. Monitoring and alerting with PEM. Register and manage servers and agents, configure meaningful metrics and alert thresholds, investigate alerts and performance trends using graphs, and maintain notification and escalation integrations. Automation and version control. Use TPA and Ansible/Spacelift to build repeatable PostgreSQL/EDB environments … streaming and logical replication, replication slots, WAL retention, lag, and timeline issues; use pg_rewind when appropriate to resynchronize a node after timelines diverge. Performance engineering. Analyze execution plans and wait or lock behavior, tune SQL and indexes, and optimize PostgreSQL and operating-system settings, including autovacuum, memory, storage ...