PostgreSQL DBA: Performance, HA & Automation (Montreal)

Explorance

Montreal (administrative region)

On-site

CAD 90,000 - 130,000

Full time

2 days ago
Be an early applicant
Application generator

An application made for this job — a tailored resume and cover letter that speak straight to the posting.

Get past ATS filters

Job summary

Explorance is seeking a PostgreSQL Database Administrator to join our Global CloudOps team in Montreal. This hands-on role focuses on managing PostgreSQL environments behind our SaaS applications, with responsibilities spanning performance optimization, high availability, automation, security, backup, and disaster recovery.

You will collaborate with CloudOps, development, and other technical teams to ensure databases are reliable, secure, and scalable as our applications grow.

Qualifications

  • Professional experience administering PostgreSQL databases in production environments.
  • Strong understanding of PostgreSQL architecture, administration, and troubleshooting.
  • Experience with database performance tuning and query optimization.
  • Knowledge of PostgreSQL backup, recovery, replication, and high-availability concepts.
  • Experience with Patroni and streaming/logical replication.
  • Experience with Linux environments and Bash scripting.
  • Understanding of database security and access-management best practices.

Responsibilities

  • Administer and maintain PostgreSQL databases across development, testing, and production environments.
  • Ensure databases remain highly available, reliable, secure, and performant.
  • Participate in upgrades, migrations, and infra-improvement projects.
  • Contribute to database architecture and design decisions as infrastructure evolves.
  • Monitor health and identify performance bottlenecks; optimize queries.
  • Automate routine DBA tasks and improve monitoring and docs.

Skills

PostgreSQL
Performance tuning
High availability
Backup & recovery
Automation
Bash scripting
Security & access
Linux
Troubleshooting

Education

Bachelor's degree in CS/IT

Tools

Patroni
pgBackRest
PostgreSQL tools (EXPLAIN/ANALYZE)
psql

Job description

Explorance is seeking a PostgreSQL Database Administrator to join our Global CloudOps team in Montreal. This hands-on role focuses on managing PostgreSQL environments behind our SaaS applications, with responsibilities spanning performance optimization, high availability, automation, security, backup, and disaster recovery.

You will collaborate with CloudOps, development, and other technical teams to ensure databases are reliable, secure, and scalable as our applications grow.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Database Administrator – PostgreSQL
Database Administrator – PostgreSQL

Explorance • Montreal (administrative region)

On-site
CAD 90,000 - 130,000
Senior PostgreSQL DBA - HA, Performance & Automation
Senior PostgreSQL DBA - HA, Performance & Automation

Galent • Toronto

On-site
CAD 90,000 - 120,000
Mentoring opportunities
Career growth and development
Collaborative work environment
Senior PostgreSQL Lead DBA - Remote & AWS-Ready
Senior PostgreSQL Lead DBA - Remote & AWS-Ready

Canadian Inclusion • Quebec

Hybrid
CAD 80,000 - 110,000
Hybrid SQL DBA — Performance & HA/DR (Montreal)
Hybrid SQL DBA — Performance & HA/DR (Montreal)

CloudVital • Montreal (administrative region)

Hybrid
CAD 90,000 - 120,000
Administrateur PostgreSQL — Cloud, HA et Télétravail
Administrateur PostgreSQL — Cloud, HA et Télétravail

Go RH • Quebec

Hybrid
CAD 90,000 - 120,000
Télétravail hybride 4 jours
Télétravail 100% possible (à >100km)
Assurance santé 100% payée
+2
Senior PostgreSQL DBA — HA & Performance Leader
Senior PostgreSQL DBA — HA & Performance Leader

Galent • Markham

On-site
CAD 90,000 - 120,000
Senior PostgreSQL & MongoDB DBA - Hybrid (Toronto)
Senior PostgreSQL & MongoDB DBA - Hybrid (Toronto)

Delpath • Toronto

Hybrid
CAD 100,000 - 130,000
Senior PostgreSQL System Administrator
Senior PostgreSQL System Administrator

Galent • Toronto

On-site
CAD 90,000 - 120,000
Mentoring opportunities
Career growth and development
Collaborative work environment
PostgreSQL DBA
PostgreSQL DBA

Delpath • Toronto

On-site
CAD 100,000 - 130,000
Administrateur(trice) de bases de données (intermédiaire) – PostgreSQL / Database Administrator (Intermediate) – PostgreSQL
Administrateur(trice) de bases de données (intermédiaire) – PostgreSQL / Database Administrator (Intermediate) – PostgreSQL

Explorance Inc. • Montreal (administrative region)

On-site
CAD 95,000 - 130,000