Database Administrator - Postgresql

Are you a PostgreSQL DBA who enjoys solving complex performance problems, improving database reliability, and working with systems that support SaaS applications used at scale?Explorance is looking for a
PostgreSQL Database Administrator
to join our Global CloudOps team in Montreal.In this hands-on role, you'll help manage and continuously improve the PostgreSQL environments behind our SaaS applications. You'll work on everything from performance optimization and high availability to automation, security, backup and recovery — collaborating closely with CloudOps, development, and other technical teams.We're looking for someone with solid PostgreSQL experience who enjoys troubleshooting, takes ownership of problems, and wants to continue developing their expertise in database and cloud operations.What you'll be working on
Administer and maintain PostgreSQL databases across development, testing, and production environments.Help ensure our databases remain highly available, reliable, secure, and performant.Participate in database upgrades, migrations, and infrastructure improvement projects.Contribute to database architecture and design decisions as our applications and infrastructure evolve.Performance & optimization
Monitor database health and identify performance bottlenecks before they become problems.Investigate and optimize queries using PostgreSQL tools such as EXPLAIN and ANALYZE.Improve indexing, schemas, configurations, and deployment scripts to increase performance and reliability.Partner with development teams on database design and query optimization.High availability, backup & recovery
Support and improve PostgreSQL high-availability environments, including replication and automated failover technologies.Maintain backup, recovery, and disaster recovery processes.Regularly validate backups and recovery procedures to ensure we're prepared when it matters.Automation & monitoring
Automate repetitive DBA activities using Bash, PowerShell, or similar tools.Improve database monitoring and observability.Support capacity planning and resource utilization analysis.Continuously improve our operational processes and technical documentation.Security & production support
Manage database access, permissions, auditing, logging, and other security controls.Help maintain database security and support organizational security standards.Troubleshoot and resolve database-related production issues.Participate in scheduled maintenance and release activities when required.What we're looking for
You don't need to check every box. If you have strong PostgreSQL experience and most of the following, we'd like to hear from you: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.Patroni, streaming replication, or logical replicationExperience working with Linux environments and Bash/shell scripting.Understanding of database security and access-management best practices.Strong troubleshooting and problem-solving skills.Ability to communicate and collaborate effectively with developers and other technical teams.Comfortable taking ownership of work while contributing to a collaborative team environment.A degree in Computer Science, Information Technology, or a related discipline is welcome, but equivalent practical experience is equally valuable.Nice to have
Experience in any of the following would be an asset —
but isn't required :Cloud-hosted database environmentsMicrosoft SQL ServerRedis or distributed caching technologiesDatabase monitoring and observability toolsPL/pgSQLETL and data integrationPowerShell or other automation technologiesCapacity planning for growing database environmentsWhy Explorance?
You'll be joining a global CloudOps team where database reliability directly contributes to the performance of our SaaS products and the experience of our customers.This role offers the opportunity to work across database administration, performance engineering, automation, high availability, security, and cloud operations rather than being limited to a narrow area of database support.You'll also collaborate directly with technical teams across the organization, giving you the opportunity to influence how our database environments evolve as we continue to grow.This is a
full-time, on-site position based in our Montreal office .We believe in the value of working together in person and have built an engaged, collaborative office environment. Candidates should therefore be located in Montreal or the surrounding area and be comfortable working from the office five days per week.Interested? We'd love to hear from you — even if your experience doesn't match every item listed above.
#J-18808-Ljbffr