Senior PostgreSQL System Administrator

TorontoContractsenior

OtherSystem Administrator

0 views0 saves0 applied

Apply Now

Quick Summary

Overview

Job Summary We are looking for an experienced Senior PostgreSQL System Administrator with 5–7 years of hands-on experience managing large-scale, mission-critical PostgreSQL environments.

Key Responsibilities

Lead installation, configuration, and administration of PostgreSQL databases across production and non-production environments Design and implement High Availability (HA), Disaster Recovery (DR), and replication solutions Monitor database…

Technical Tools

ansibleawsazurebashdockergcpgrafanakubernetesmongodbmysqlpostgresqlprometheuspythonsqlterraformci-cdlinuxmentoringperformance-optimizationsql-optimization

We are looking for an experienced Senior PostgreSQL System Administrator with 5–7 years of hands-on experience managing large-scale, mission-critical PostgreSQL environments. This role is ideal for someone who thrives in performance tuning, high availability design, and database security, and who enjoys mentoring junior DBAs while influencing architectural decisions.

Responsibilities

~1 min read

→Lead installation, configuration, and administration of PostgreSQL databases across production and non-production environments
→Design and implement High Availability (HA), Disaster Recovery (DR), and replication solutions
→Monitor database performance, identify bottlenecks, and optimize queries and configurations
→Perform database upgrades, patching, and migrations with minimal downtime
→Implement and manage backup and recovery strategies (pgBackRest, Barman, etc.)
→Ensure database security through access control, auditing, and encryption
→Automate routine DBA tasks using Shell scripting, Ansible, or similar tools
→Collaborate with Development, Infrastructure, and DevOps teams on scalable architectures
→Create and maintain documentation, standards, and best practices
→Mentor junior DBAs and act as a PostgreSQL Subject Matter Expert
→Participate in on-call rotation and resolve critical incidents

Requirements

~1 min read

Bachelor’s degree in Computer Science, Engineering, or related field
5–7 years of PostgreSQL DBA experience (MongoDB exposure required)
Strong knowledge of PostgreSQL internals and architecture
Experience with PostgreSQL v14
Expertise in streaming/logical replication and clustering
Advanced performance tuning, query optimization, and indexing strategies
Strong Linux/Unix skills with scripting (Bash, Python preferred)
Experience with monitoring tools such as Prometheus, Grafana, or Zabbix
Experience managing PostgreSQL on cloud platforms (AWS RDS, GCP Cloud SQL, Azure