Senior PostgreSQL Database Administrator

Position: PostgreSQL System Admin
Location: Canada
Work Mode: Hybrid

Job Summary:

We are looking for a seasoned Senior PostgreSQL Database Administrator with 5–7 years of hands-on experience in managing large-scale PostgreSQL environments. The ideal candidate will ensure high performance, scalability, and security of mission-critical databases, mentor junior DBAs, and contribute to architectural decisions for high availability and business continuity.

Key Responsibilities:

• Lead installation, configuration, and administration of PostgreSQL servers across production and non-production environments.
• Design and implement High Availability (HA), Disaster Recovery (DR), and replication strategies.
• Monitor and analyze database performance; identify bottlenecks and optimize queries/configurations.
• Perform database upgrades, patching, and migrations with minimal downtime.
• Implement and maintain robust backup and recovery solutions (e.g., pgBackRest, Barman).
• Ensure database security through access control, auditing, and encryption.
• Automate routine DBA tasks using Bash, Python, or Ansible.
• Collaborate with development, DevOps, and infrastructure teams for scalable architecture.
• Document processes, standards, and best practices.
• Mentor junior DBAs and act as a PostgreSQL SME across teams.
• Participate in on-call rotations and handle critical production incidents.

Required Skills & Qualifications:

• Bachelor’s degree in Computer Science, Engineering, or related field.
• 5–7 years of PostgreSQL DBA experience in production; exposure to MongoDB preferred.
• Strong knowledge of PostgreSQL internals, architecture, and advanced features (v14).
• Hands-on experience with streaming/logical replication, clustering, and performance tuning.
• Proficient in backup/recovery strategies and tools.
• Advanced Linux/Unix skills and scripting (Bash or Python preferred).
• Familiarity with monitoring tools like Prometheus, Grafana, Zabbix.
• Experience managing PostgreSQL on cloud platforms (AWS RDS, Google Cloud Platform Cloud SQL, Azure).

Preferred Skills / Good to Have:

• Containerization/orchestration experience (Docker, Kubernetes).
• Knowledge of other databases (MySQL, Oracle, NoSQL).
• Exposure to CI/CD pipelines and DevOps practices.
• Infrastructure-as-Code (Ansible, Terraform) experience.

Soft Skills:

• Strong analytical, problem-solving, and troubleshooting abilities.
• Excellent communication and documentation skills.
• Leadership, mentoring, and team collaboration mindset.
• Proactive approach with focus on process improvements and automation.