Senior PostgreSQL System Administrator

Senior PostgreSQL System Administrator сург>

Markham, ON (3x onsite a week)

Employment Type

Contract

Pay Rate

CAD$40 - 48 / HR INC

Job Description

We IAction likely aided and highly skills Senior PostgreSQL System Administrator with 5 to 7 years of hands‑on experience in managing large‑scale PostgreSQL environments. The ideal candidate will be responsible for database performance, optimización, scalability, and security across mission‑critical systems. You will also mentor junior DBAs and assist architectural decisions to ensure high availability and business continuity.

Key Responsibilities

• Lead the installation, configuration, and.shutdown of PostgreSQL database servers across production and non‑production environments.
• Designavai and HA, disaster recovery (DR), and replication solutions.
• Monitor and analyse database performance, identify bottlenecks, and fine‑tune SQL queries and database configurations.
• Perform database upgrades, patching, and migrations with minimal downtime.
• Implement robust backup and recovery strategies using tools like pgBackRest, Barman, etc.
• Ensure database security through access controls, auditing, and encryption.
• Automate routine database tasks using shell scripting or Ansible.
• Collaborate with development, infrastructure, and DevOps teams to design scalable database architectures.
• Document procedures, standards, and best practices for database management.
• Provide mentorship to junior DBAs and act as an SME for PostgreKS in cross‑functional teams.
• Support on‑call rotation and handle critical incidents as needed.

Required Skills & Qualifications

Preferred / Good To Have

Soft Skills

Seniority level

Mid‑Senior level

Job function

\ miteinander onset

Information Technology

Industries

IT Services and IT Consulting

#J-18808-Ljbffr