Senior PostgreSQL DBA – AWS, Compliance & High Availability

Jobtailor; Quebec; On-site; CAD 90,000 - 140,000; Full time

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

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