PostgreSQL Database Administrator / Developer (Intermediate to Senior Level)
| Job Type | Contract |
| Area | South Africa, Africa |
| Sector | IT - DevelopmentIT - Data |
| Salary | Negotiable |
| Start Date | |
| Job Ref | VR/26615 |
- Description
Swan iT is searching for a PostgreSQL Database Administrator / Developer (Intermediate to Senior Level) for a remote opportunity in South Africa. This position will manage and optimize our PostgreSQL environments across development, test, and production systems.
Responsibilities:
- Install, configure, upgrade, and manage PostgreSQL database servers (community or enterprise editions).
- Ensure high availability, failover, and disaster recovery using solutions like streaming replication, logical replication, Patroni, or pgpool-II.
- Monitor database performance and resource utilization, tuning PostgreSQL settings for optimal performance.
- Develop and maintain backup and recovery strategies using tools like pgBackRest, Barman, or pg_dump.
- Test and document disaster recovery procedures to meet RTO and RPO requirements.
- Implement role-based access control, data encryption (at rest and in transit), and security patches.
- Collaborate with application developers on schema design, indexing strategies, and data modeling.
- Develop automation scripts in SQL, Bash, Python, or Ansible for routine maintenance and deployments.
- Set up and manage database monitoring and alerting systems (e.g., pg_stat_statements, Prometheus, Grafana, pgBadger).
- Proactively address performance issues, deadlocks, long-running queries, and vacuum/analyze processes.
- Provide 2nd/3rd line support for PostgreSQL database issues.
Requirements:
- Bachelor’s Degree in Computer Science, Information Systems, Software Engineering, or related field.
- PostgreSQL certifications (e.g., from EDB, CrunchyData, or Cloud vendors) are advantageous.
- Linux system administration knowledge or certifications are a plus
- 4–8 years of experience in PostgreSQL database administration and/or development roles.
- Experience managing large-scale PostgreSQL databases in production environments.
- Hands-on experience with replication (physical/logical), partitioning, and performance tuning.
- Familiarity with database CI/CD pipelines and version control (e.g., Flyway, Liquibase, Git).
- Scripting languages: Bash, Python (preferred).