Senior PostgreSQL System Administrator

Senior Postgre

SQL System Administrator

Location: Markam, ON, Canada

Mode of Work: Hybrid (3 days a week)

Job Summary: We are seeking an experienced and highly skilled Senior Postgre

SQL System Administrator with 5 to 7 years of hands‑on experience in managing large-scale Postgre

SQL environments. The ideal candidate will be responsible for database performance, optimization, scalability, and security across mission‑critical systems. You will mentor junior DBAs and support architectural decisions to ensure high availability and business continuity.

Key Responsibilities:

• Lead the installation, configuration, and administration of Postgre
  
  SQL database servers across production and non‑production environments.
• Design and implement high‑availability (HA), disaster‑recovery (DR), and replication solutions.
• Monitor and analyze 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 such as 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 Dev Ops 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 Postgre
  
  SQL in cross‑functional teams.
• Support on‑call rotation and handle critical incidents as needed.

Required Skills &

Qualifications:

• Bachelor’s degree in Computer Science, Engineering, or a related field.
• 5–7 years of Postgre
  
  SQL DBA experience, including Mongo
  
  DB experience in production environments.
• Deep understanding of Postgre
  
  SQL internals, architecture, and advanced features.
• Experience with Postgre
  
  SQL V14.
• Proven experience with streaming/logical replication and clustering.
• Expertise in performance tuning, query optimization, and index strategy.
• Strong experience with backup and recovery tools and strategies.
• Advanced knowledge of Linux/Unix systems and scripting (Bash, Python preferred).
• Familiarity with monitoring tools such as Prometheus, Grafana, or Zabbix.
• Experience managing Postgre
  
  SQL on cloud platforms (AWS RDS, GCP Cloud SQL, Azure).

Preferred/Good to Have:

• Experience with containerization and orchestration tools (Docker, Kubernetes).
• Knowledge of other database technologies (MySQL, Oracle, or No
  
  SQL solutions).
• Exposure to CI/CD pipelines and Dev Ops practices.
• Experience with Infrastructure as Code (IaC) using Ansible, Terraform, etc.

Soft Skills:

• Excellent problem‑solving, analytical, and troubleshooting skills.
• Strong communication and documentation abilities.
• Leadership and mentoring capabilities.
• Proactive mindset with a focus on process improvements and automation.

Seniority Level: Mid‑Senior level

Employment Type: Contract

Job Function: Information Technology

Industries: Technology, Information and Internet