Hiring for PostgreSQL Database Administrator (DBA) (Montreal, QC).

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

Hiring for PostgreSQL Database Administrator (DBA) (Montreal, QC).

• Montreal, QC

Job Summary:

We are seeking a skilled and experienced PostgreSQL Database Administrator (DBA) to join our team. As a PostgreSQL DBA, you will be responsible for the management, maintenance, and optimization of our PostgreSQL database systems. Your expertise will be essential in ensuring the availability, performance, and security of our database infrastructure.

Key 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.
• Qualifications and Skills:
• Bachelorʼs degree in computer science, information technology, or a related field (or equivalent work experience).
• Proven experience as a PostgreSQL DBA, including installation, configuration, and administration of PostgreSQL database systems.
• Strong understanding of relational database concepts and SQL.
• Proficiency in performance tuning, query optimization, and troubleshooting database issues.
• Experience with backup and recovery strategies, including point‑in‑time recovery and disaster recovery.
• Familiarity with database security principles and best practices.
• Experience with replication, clustering, and high‑availability solutions for PostgreSQL (e.g., streaming replication, logical replication, Pgpool‑II, Patroni).
• Knowledge of Linux/Unix operating systems and shell scripting.
• Excellent problem‑solving and analytical skills.
• Strong communication and collaboration skills.

Preferred Qualifications:

• PostgreSQL certification (e.g., Certified PostgreSQL Professional).
• Experience with other database systems such as MySQL, Oracle, or SQL Server.
• Knowledge of cloud‑based database services (e.g., Amazon RDS, Google Cloud SQL).
• Familiarity with database automation and orchestration tools (e.g., Ansible, Terraform).
• Understanding of containerization technologies (e.g., Docker, Kubernetes).