Postgresql Dba: Performance, Ha & Automation (Montreal)
Explorance
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 onAdminister 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 & optimizationMonitor 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 & recoverySupport 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 & monitoringAutomate 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 supportManage 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 forYou 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 haveExperience 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
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 onAdminister 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 & optimizationMonitor 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 & recoverySupport 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 & monitoringAutomate 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 supportManage 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 forYou 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 haveExperience 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
Vacancy posted 1 hour ago
Similar jobs that could be interesting for youBased on the Postgresql Dba: Performance, Ha & Automation (Montreal) in Winnipeg, MB vacancy
- A technology company is seeking a Senior PostgreSQL System Administrator with 5 to 7 years of hands-on experience managing large-scale PostgreSQL... ..., and administration of database servers, optimizing performance, and mentoring junior DBAs. Ideal candidates will have deep knowledge...PostgreSQLPerformance
- ...is seeking a senior SQL Server and Azure DBA to administer and optimize databases across... ...and Azure environments. You will lead performance diagnostics, tuning, and capacity... ..., backups, and database migrations, plus automation skills using PowerShell, T‑SQL, and IaC practices...Performance
- ...Duration: 6 Months Possibility of extension: Yes, based on performance and business needs Conversion to FTE: May be, based on performance... ...Number of Positions: 2 Typical Day in Role: Implementing PostgreSQL database clusters with replication Manage database security/...PostgreSQLPerformanceContract workWork at office
- ...production and non-production environments. The role emphasizes reliability, security, and performance with a focus on backups, DR, and automation. You will monitor and tune workloads, design HA/DR strategies, and collaborate with application teams, infrastructure, and vendors to...Performance
- ...nous recherchons un(e) Administrateur(trice) de base de données PostgreSQL. Dans ce rôle, tu agiras comme le pilier technique responsable... ...PostgreSQL pour les produits existants et nouveaux. Optimiser la performance des requêtes et des bases de données (réglage, indexation,...PostgreSQLPerformanceDaily paidPermanent employmentFull timeWork at officeRemote workMonday to fridayDay shift
- ...Administrator for a 6-month contract. The role involves managing PostgreSQL and MongoDB installations, ensuring database security, and... ...increase in office days in the future. Opportunities for extension and conversion to full-time are possible based on performance. #J-18808-LjbffrPostgreSQLPerformanceFull timeContract workWork at office
- ...platform support, application upgrades, and collaboration with cloud teams on deployments. Requirements include extensive experience in automation and middleware management, with strong skills in Kubernetes and ETL tools. The role offers various benefits that promote diversity...
- ...Administrateur(trice) de bases de données intermédiaire en PostgreSQL chez Explorance, une entreprise fiable à Montréal. Ce poste exige des compétences en gestion de... ...systèmes PostgreSQL • Surveiller et optimiser la performance des bases de données • Mettre en œuvre des...PostgreSQLPerformance
- ...SWAT software engineer to own production database troubleshooting, platform performance, and multi-tenant scale. You will work on PostgreSQL/MariaDB fleets, implement observability, and drive automation to prevent incidents in a fast-paced SaaS environment. The role...PostgreSQLPerformance
- .... is seeking a Senior Azure SQL DBA to manage SQL Server environments... ...on Azure VMs. You will diagnose performance bottlenecks, optimize queries, and implement robust HA/DR strategies.... ...tuning, capacity planning, and automation using PowerShell and Azure CLI,...PerformanceFull time
- ...will ensure high availability, security, and performance across development, QA, and production landscapes. You will collaborate with DBA, middleware, and application teams, lead deployment activities, and contribute to automation and CI/CD pipelines while adhering to...Performance
- Alteo is looking for a DBA for a permanent position based in Montreal.*** Hybrid Work ***You will play a key role in... ...responsible for optimizing their performance, strengthening their security, and... ...environments (Oracle, SQL Server, PostgreSQL, etc.).Automate processes related...PostgreSQLPerformanceLong term contractPermanent employment
- ## PostgreSQL Database Administrator (Production DBA)Apply: Toronto, ON: Full time: Posted 30+ Days Ago: JR192**About... ...production database environments, perform root cause analysis on issues ranging... ...Google Cloud SQL.* Scripting or automation experience in Python, PowerShell,...PostgreSQLPerformanceFull timeRemote work
- ...applications and provide technical expertise across teams. The position offers a blend of operational responsibilities, including performance tuning, disaster recovery planning, and database monitoring. If you thrive in a dynamic environment and are passionate about optimizing...PerformanceRemote work
- ...solutions and implementation service for Performance Management, Data Management, Data... ...SQL and or NoSQL database technologies (PostgreSQL, Cassandra, MariaDB/MySQL, etc.) is preferred... ...MongoDB. Understanding of Ops Manager automation builds/management Experience with design...PostgreSQLPerformance
- Key Skills: T-SQL +Azure SQL MI, Performance Tuning + Always On + HA/DR + Backup/Recovery + SSIS +ADF Brampton... ...Skills 7+ years of SQLServer DBA and Database Development experience.... ...Synapse. PowerShellscripting and automation experience. Azure or MicrosoftSQL...Performance
- ...technologies that address complex scientific challenges to improve our world. They have engaged ROSS to recruit a Test Automation Developer with a focus on Performance Automation Testing.This is a stable, long-term 12-month contract with the possibility of extension or conversion...PerformanceLong term contractPermanent employmentWork at office
- Production PostgreSQL expertise meets remote work across the US and Canada, focused on performance, availability, and reliable customer deployments. Analyze incidents and improve... ...its R&D Customer Support team. The Production DBA will troubleshoot complex systems, perform...PostgreSQLPerformanceRemote work
- PostgreSQL clustering expertise defines this Database Administrator position, focused on enterprise... ...to cloud platforms, backup and recovery, automation, and monitoring. Collaboration across... ...and recoveryFamiliarity with Oracle DBA technologiesKnowledge of database automation...PostgreSQL
- ...Azure Virtual Machines. Lead performance diagnostics and tuning using... ...and compliance controls. Automate provisioning, configuration,... ...with strong L3 MSSQL and Azure DBA expertise. Advanced hands‑... ..., upgrades, and patching. Automation capability using PowerShell,...PerformanceLocal area
$75 - $80 per hour
...Type: 6 Month Contract (based on 7.25 hours/day, 36.25 hours/week) Work Experience: Playwright, TypeScript, Test Automation Frameworks, Performance Testing, k6, JMeter, API Testing, GitLab, Bamboo, CI/CD, Agile, UAT, QA Leadership DESCRIPTION: We are seeking a highly...PerformanceLong term contractContract workRemote work- Automate enterprise application testing with Python and performance engineering at Compugen, supporting cloud applications and Agile delivery environments.As a Senior Automation and Performance Test Engineer, you will build scalable frameworks and reusable automation components...Performance
- Must Haves: 7+ years of experience in Quality Assurance, Test Automation, or Quality Engineering. 5+ years of experience developing and maintaining automation frameworks. 3+ years of hands‑on performance testing experience. 5+ years of experience working in Agile/Scrum environments...Performance
- US Tech Solutions in Canada is seeking a Senior Automation & Performance Test Engineer to design, develop, and implement enterprise-level test automation frameworks and performance tests across web, API, database, and cloud environments. You will integrate automated testing...Performance
- Lead automation and performance testing in Toronto’s hybrid environment, applying API testing and CI/CD pipeline experience. Work three office days weekly.This six-month contract suits a senior quality professional with seven-plus years in Quality Assurance, Test Automation,...PerformanceContract workWork at office
- Senior Automation & Performance Test EngineerContract Opportunity - 6-month termPossibility of Extensions: Yes, optional extension of 6 months.Job Location : Toronto - M5V 2X4, ON, Canada | Hybrid Work - 3 days/week in the office required.Work Hours : 7.25 Hours a Day or...PerformanceWork at office3 days per week
- ...infrastructure. Monitor database health, capacity, availability, and performance; investigate abnormal conditions and take preventive or... .... Experience with Windows Server, virtualization, scripting or automation, certificates, service accounts, Kerberos, and Active Directory...PerformanceWork at officeWorldwideFlexible hours
- Test Automation LeadEnterprise Systems - IFS ERP - Multi-site ManufacturingROLE PURPOSE Build and lead a pragmatic test automation and performance assurance program that improves the reliability of enterprise systems while reducing the cost and effort of repetitive...Performance
- Overview Join to apply for the Platform DBA role at Intact .We are looking for a forward thinking Oracle DBA who will contribute... ...cloud based database solutions.Contribute in the development of automation activities to improve daily database operations on Cloud...Permanent employmentApprenticeshipRemote workWork from homeFlexible hoursDay shift
- ...Qualifications Proven experience as a PostgreSQL Database Administrator in... ....Working knowledge of:Performance & Troubleshooting Strong... ...recoveryFamiliarity with Oracle DBA technologies, including:... ...Experience with database automation tools:Knowledge of database monitoring...PostgreSQLPerformance
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Postgresql Dba: Performance, Ha & Automation (Montreal). Be the first to apply!
Related searches
- data administrator Winnipeg, MB
- dba Winnipeg, MB
- database manager Winnipeg, MB
- database administrator Winnipeg, MB
- junior database administrator Winnipeg, MB
- acting performance Winnipeg, MB
- performance engineer Winnipeg, MB
- performance testing Winnipeg, MB
- building performance specialist Winnipeg, MB
- industrial automation Winnipeg, MB

