Database Administrator, PostgreSQL

Jobtailor

Quebec

On-site

CAD 90,000 - 140,000

Full time

6 days ago

Be an early applicant

Application generator

Don’t send a generic resume — generate a resume and cover letter tailored to this exact role.

Get past ATS filters

Job summary

Jobtailor seeks an experienced PostgreSQL-focused Database Administrator in Canada to lead schema design, performance tuning, and reliability initiatives across production databases. You will work with AWS RDS/EC2 environments, implement robust backup and DR plans, and ensure strict data security and compliance, including SOC 2 Type 2 and Quebec Law 25.

You will collaborate with cross-functional teams on migrations, multi-tenant architectures, and integrations, while maintaining high standards

Qualifications

10+ years of professional experience in database administration, with deep PostgreSQL expertise.
Fluency in spoken and written French required; English is an asset
Strong understanding of relational database design, SQL queries, stored procedures, indexes, and performance optimization
Experience maintaining and improving commercial or enterprise production databases
Experience with multi-tenant architectures and managing multiple databases in parallel is preferred
Experience with AWS or another cloud platform (RDS, EC2, VPC, IAM, Security Groups) is preferred
Experience in regulated or financial environments is preferred
Experience with AI-assisted development tools (Claude Code) is preferred
Experience with API integrations and interfaces with third-party systems is preferred
Experience optimizing performance in large-scale database environments is preferred
Knowledge of security best practices for business-critical applications is preferred
PostgreSQL skills (architecture, tuning, high availability, replication)

Responsibilities

Troubleshoot and resolve production issues
Design and review PostgreSQL schema architecture and data models for existing and new products
Optimize query and database performance through tuning, indexing, and execution plan analysis
Ensure operational reliability through backup and recovery strategies, high availability, replication, and disaster recovery plans
Plan and execute production schema and data migrations while minimizing service disruptions
Analyze and resolve complex database-related technical issues, including locks, timeouts, and data integrity problems
Collaborate with development teams on triggers, functions, and schema constraints
Contribute to data compliance requirements (SOC 2 Type 2, Quebec Law 25), including audits, traceability, and access management
Establish best practices, standards, and documentation for PostgreSQL database management
Assist with the AWS infrastructure surrounding the databases, including RDS configuration, security groups, and CloudWatch monitoring
Support the infrastructure team

Skills

PostgreSQL Database Administration

SQL Performance Optimization

AWS Infrastructure Management

Data Security and Compliance

French language proficiency

Tools

AWS RDS

AWS EC2

AWS VPC

AWS IAM

AWS Security Groups

AWS CloudWatch

Git

Job description

Troubleshoot and resolve production issues
Design and review PostgreSQL schema architecture and data models for existing and new products
Optimize query and database performance through tuning, indexing, and execution plan analysis
Ensure operational reliability through backup and recovery strategies, high availability, replication, and disaster recovery plans
Plan and execute production schema and data migrations while minimizing service disruptions
Analyze and resolve complex database-related technical issues, including locks, timeouts, and data integrity problems
Collaborate with development teams on triggers, functions, and schema constraints
Contribute to data compliance requirements (SOC 2 Type 2, Quebec Law 25), including audits, traceability, and access management
Establish best practices, standards, and documentation for PostgreSQL database management
Assist with the AWS infrastructure surrounding the databases, including RDS configuration, security groups, and CloudWatch monitoring
Support the infrastructure team

Requirements

10+ years of professional experience in database administration, with deep PostgreSQL expertise
Fluency in spoken and written French required; English is an asset
Strong understanding of relational database design, SQL queries, stored procedures, indexes, and performance optimization
Experience maintaining and improving commercial or enterprise production databases
Excellent debugging, diagnostic, and problem-solving skills
Good understanding of source control, version management, and quality assurance processes
Ability to communicate clearly with technical and non-technical stakeholders
Self-motivated, detail-oriented, and comfortable working as part of a distributed team
Experience with multi-tenant architectures and managing multiple databases in parallel is preferred
Experience with AWS or another cloud platform (RDS, EC2, VPC, IAM, Security Groups) is preferred
Experience in regulated or financial environments is preferred
Experience with AI-assisted development tools, such as Claude Code, is preferred
Experience with API integrations and interfaces with third-party systems is preferred
Experience optimizing performance in large-scale database environments is preferred
Knowledge of security best practices for business-critical applications is preferred
PostgreSQL skills (architecture, tuning, high availability, replication)
AWS skills (RDS, EC2, VPC, IAM, Security Groups, CloudWatch)
SQL performance optimization
Claude Code or similar AI-assisted development tools
REST APIs and system integrations
Git or other source control systems
Data security and compliance (SOC 2, Quebec Law 25)

Core Competencies

Demonstrates extensive expertise in PostgreSQL database administration, including schema design, performance optimization, and compliance with data security standards. Proficient in AWS infrastructure management and capable of troubleshooting complex database issues while ensuring operational reliability.

Highest-signal resume keywords