Database Administrator – PostgreSQL

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 strong 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.
• Strong 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.