Senior PostgreSQL DBA — HA & Performance Leader

Galent; Markham; On-site; CAD 90,000 - 120,000; Full time

Job summary

A technology company is seeking a Senior PostgreSQL System Administrator with 5 to 7 years of hands-on experience managing large-scale PostgreSQL environments. Responsibilities include leading installation, configuration, and administration of database servers, optimizing performance, and mentoring junior DBAs. Ideal candidates will have deep knowledge of PostgreSQL internals and experience with cloud platforms like AWS and GCP. This role is an opportunity to ensure database availability and security in mission-critical systems while collaborating across teams.

Qualifications

• 5–7 years of PostgreSQL DBA experience in production environments.
• Deep understanding of PostgreSQL internals, architecture, and advanced features.
• Strong experience with backup and recovery tools and strategies.
• Advanced knowledge of Linux/Unix systems and scripting (Bash, Python preferred).

Responsibilities

• Lead the installation, configuration, and administration of PostgreSQL database servers.
• Monitor and analyze database performance and fine-tune SQL queries.
• Perform database upgrades, patching, and migrations with minimal downtime.
• Implement robust backup and recovery strategies.

Skills

PostgreSQL administration

Performance tuning

Database security

SQL query optimization

Shell scripting

Monitoring tools

Cloud platforms management

Education

Bachelor's degree in Computer Science, Engineering, or related field

Tools

pgBackRest

Barman

AWS RDS

GCP Cloud SQL

Azure

Docker

Kubernetes

Ansible

Terraform

Job description

A technology company is seeking a Senior PostgreSQL System Administrator with 5 to 7 years of hands-on experience managing large-scale PostgreSQL environments. Responsibilities include leading installation, configuration, and administration of database servers, optimizing performance, and mentoring junior DBAs. Ideal candidates will have deep knowledge of PostgreSQL internals and experience with cloud platforms like AWS and GCP. This role is an opportunity to ensure database availability and security in mission-critical systems while collaborating across teams.