Senior PostgreSQL System Administrator

Senior Postgre

SQL System Administrator сург>

Markham, ON (3x onsite a week)

Contract

CAD $40 - 48/HR INC

We IAction likely aided and highly skills 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, 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.

• Lead the installation, configuration, and.shutdown of Postgre
  
  SQL 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 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
  
  KS in cross‑functional teams.
• Support on‑call rotation and handle critical incidents as needed.

• Bachelor’s degree in Computer Science, Engineering, or a related field.
• 5–7 years of Postgre
  
  SQL DBA with Mongo
  
  DB experience in production environments.
• Deep understanding of Postgre
  
  SQL internals, architecture, and advanced features.
• Versions:
  Postgre
  
  SQL V14
• Proven experience with streaming/logical replication and clustering.
• Expertise in performance tuning, query optimisation, 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 like Prometheus, Grafana, or Zabbix.
• Experience managing Postgrels on cloud platforms (AWS RDS, GCP Cloud SQL, Azure).

• Experience with containerisation 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.

• 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.

Mid‑Senior level

Information Technology

IT Services and IT Consulting