PostgreSQL Database Server Maintenance

Our production systems run on a dedicated PostgreSQL database server that needs ongoing, professional management to keep performance high and downtime at zero. I need an experienced PostgreSQL administrator to take charge of routine upkeep, monitoring, and rapid incident response so the team can stay focused on product development. Scope of work You’ll handle version updates, configure and verify automated backups, watch key metrics, fine-tune queries and indexes when bottlenecks appear, and strengthen security by keeping roles, permissions, and network rules tight. The server is Linux-based and accessed via SSH; fluency with psql, pgAdmin, and common monitoring stacks (Prometheus, Grafana, or similar) will make the job straightforward. Deliverables • Initial health audit with actionable findings • Fully tested automated backup & restore workflow • Performance tuning changes applied and documented • Security hardening checklist completed and signed off Acceptance criteria All deliverables must be published in a succinct report, include before/after benchmarks where relevant, and be reproducible through provided scripts or configuration files. When you reply, focus on your direct PostgreSQL experience—especially any production-level database server work involving high availability, replication, or large data sets. A concise summary of past roles or projects is all that’s needed; no lengthy proposals required at this stage.