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
Valuable 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 PostgreSQL Database Administration
AWS Infrastructure Management
SQL Performance Optimization
Data Security and Compliance
Fluency in French
Hard Skills PostgreSQL Schema Design
SQL Queries
Stored Procedures
Database Performance Tuning
Backup and Recovery Strategies
Data Migration Planning
Debugging and Problem-Solving
Multi-Tenant Architecture Management
API Integrations
AI-Assisted Development Tools
Soft Skills Clear Communication
Self-Motivated
Detail-Oriented
Team Collaboration
Industry Keywords SOC 2 Compliance
Quebec Law 25
Regulated Environments
Financial Environments
Tools & Technologies AWS RDS
AWS EC2
AWS VPC
AWS IAM
AWS Security Groups
AWS CloudWatch
Git

#J-18808-Ljbffr

📌 Database Administrator, PostgreSQL (Quebec City)
🏢 Jobtailor
📍 Quebec City