🎁 Before you apply, rehearse this interview. Create your free WorkMundi account and get an Interview Training on HelpsYouSpeak — no cost, no card. I want my training →
Role Summary Responsible for administering, monitoring, securing, tuning, backing up, recovering, and supporting PostgreSQL databases in production environments while ensuring highavailability and performance. Key Responsibilities Install, configure, upgrade and patch PostgreSQL servers. Monitor database health, performance, storage, CPU and memory. Perform backup, restore and disaster recovery testing using pgBackRest or similar tools. Administer replication (streaming/logical) and high availability solutions. Troubleshoot locks, slow queries, blocking sessions and database incidents. Optimize SQL queries, indexes and execution plans using EXPLAIN/ANALYZE. Manage users, roles, privileges and database security. Monitor WAL, autovacuum, bloat and routine maintenance. Support production incidents, root cause analysis and change deployments. Automate routine DBA tasks using shell scripting, SQL or Ansible (preferred). Required Skills PostgreSQL 12/13/14/15/16 SQL and PL/pgSQL Backup & Recovery (pgBackRest/Barman) Streaming & Logical Replication Performance Tuning and Query Optimization EXPLAIN / EXPLAIN ANALYZE VACUUM, ANALYZE, Autovacuum Partitioning and Index Management Linux Administration Shell Scripting Monitoring tools (pgAdmin, Prometheus, Grafana) .