We are looking to add a Database Administrator (Intermediate) with a solid background in PostgreSQL to join our growing CloudOps team.

As an Explorance DBA, you will be joining the Global CloudOps Team out of our Montreal office . You will be responsible for the implementation, configuration, maintenance, and performance of critical PostgreSQL database systems to ensure the availability, performance, and security of our SaaS applications. This is a hands-on position requiring strong technical and troubleshooting skills, as well as excellent interpersonal and communication skills.

Key Responsibilities:

Database Administration & Implementation

- Install, configure, administer, and maintain PostgreSQL databases across development, testing, and production environments.
- Design and implement database architectures and data models that align with business and application requirements.
- Ensure high levels of database performance, availability, reliability, and security.
- Participate in database upgrades, migrations, and infrastructure improvement initiatives.

High Availability & Disaster Recovery

- Configure, monitor, troubleshoot, and optimize PostgreSQL high-availability solutions, including streaming replication, logical replication, Patroni, and other automated failover technologies.
- Develop, document, and implement backup and recovery strategies
- Ensure disaster recovery readiness and data protection standards are maintained.
- Regularly validate backup integrity and recovery procedures. Performance Tuning & Optimization
- Monitor database performance and proactively identify bottlenecks and optimization opportunities.
- Analyze and optimize query execution plans using PostgreSQL tools such as EXPLAIN and ANALYZE.




- Recommend and implement indexing, schema, and configuration improvements.
- Review deployment scripts and provide recommendations to improve performance and reliability.

Security & Compliance

- Implement and manage database security controls, including encryption, auditing, and logging capabilities.
- Manage user access, permissions, and database security policies.
- Support compliance with organizational security standards and best practices.
- Monitor databases for security vulnerabilities and unauthorized access.

Monitoring & Automation

- Develop and enhance database monitoring solutions to improve visibility and operational efficiency.
- Automate routine database administration tasks using shell scripting, PowerShell, and other appropriate tools.
- Continuously improve database operations, maintenance procedures, and documentation.
- Support capacity planning and resource utilization analysis. Troubleshooting & Support
- Diagnose and resolve production database issues in support of service-level objectives.
- Support application development teams with database design, query optimization, and troubleshooting.
- Perform scheduled maintenance and support release deployment activities as required.
- Follow and participate in Explorance development standards and guidelines.

Qualifications





- Bachelor's degree in Computer Science, Information Technology, or a related field.
- 5+ years of experience as a Database Administrator with a solid focus on PostgreSQL.
- Strong knowledge of PostgreSQL architecture, administration, and troubleshooting.
- Proficiency with PL/pgSQL and PostgreSQL database programming concepts.
- Working knowledge of Linux operating systems and proficiency with shell scripting (Bash).
- Experience with database performance tuning and optimization techniques.
- Experience with backup, recovery, and disaster recovery planning.
- Solid understanding of database security principles and best practices.
- Strong analytical, troubleshooting, and problem-solving skills.
- Ability to organize and plan work independently.
- Results-oriented team player with strong communication skills
- Ability to manage multiple priorities across geographically distributed teams.

Preferred Skills

- Experience with Microsoft SQL Server administration.
- Knowledge of Redis and distributed caching technologies.
- Experience with database monitoring and observability solutions.
- Experience with ETL processes and data integration.
- PowerShell scripting and process automation experience.
- Understanding of fundamental design principles behind scalable applications.
- Experience supporting cloud-hosted database environments.
- Experience with database capacity planning, performance monitoring, and operational optimization.

Other Requirements: This is an on-site position. Only apply if you are a Montreal (or surroundings) resident that is interested in being part of a vibrant and highly engaged at-the-office culture.

📌 Database Administrator – PostgreSQL (Montreal)
🏢 Explorance
📍 Montreal