PostgreSQL DBA: Performance, HA & Automation (Montreal)

Explorance; Montreal (administrative region); On-site; CAD 90,000 - 130,000; Full time

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.