PostgreSQL DBA – Performance & High Availability Expert

Central Business Solutions, Inc; Montreal (administrative region); On-site; CAD 90,000 - 110,000; Full time

Job summary

Central Business Solutions, Inc in Montreal, QC is seeking a skilled PostgreSQL Database Administrator (DBA) to manage and optimize our PostgreSQL systems. You will ensure availability, performance, and security across the database infrastructure.

Responsibilities include installation, backups, performance tuning, replication, and HA setup, plus collaboration with developers to optimize schemas and queries, and keeping documentation current.

Qualifications

• Bachelor's degree in computer science, information technology, or related field.
• Proven experience as a PostgreSQL DBA with installation, configuration, and administration.
• Strong SQL and relational database concepts.
• Performance tuning, troubleshooting, backup/recovery.
• Experience with replication, clustering, and high availability.
• Knowledge of Linux/Unix and shell scripting.
• Excellent problem-solving and communication skills.

Responsibilities

• Install, configure, and upgrade PostgreSQL database software and related tools.
• Design and implement backup and recovery strategies to ensure data integrity and availability.
• Monitor and tune database performance to optimize query execution and improve overall system efficiency.
• Perform database capacity planning and resource management to ensure scalability and high availability.
• Manage database security, including user access control, authentication, and data encryption.
• Collaborate with development teams to design, implement, and optimize database schemas and queries.
• Troubleshoot and resolve database-related issues, including performance bottlenecks, data corruption, and system failures.
• Implement and maintain database replication, clustering, and high-availability solutions.
• Develop and maintain documentation, including database design, installation procedures, and configuration details.
• Stay up‑to‑date with the latest PostgreSQL features, technologies, and best practices.

Skills

PostgreSQL

DBA

Performance tuning

Backup & recovery

Security

Replication

Clustering

High availability

Linux/Unix

Shell scripting

SQL

Communication skills

Education

Bachelor's degree in Computer Science or related field

Tools

Pgpool-II

Patroni

Ansible

Terraform

Docker

Kubernetes

Job description

Central Business Solutions, Inc in Montreal, QC is seeking a skilled PostgreSQL Database Administrator (DBA) to manage and optimize our PostgreSQL systems. You will ensure availability, performance, and security across the database infrastructure.

Responsibilities include installation, backups, performance tuning, replication, and HA setup, plus collaboration with developers to optimize schemas and queries, and keeping documentation current.