Troubleshoot and resolve production issues

Design and review PostgreSQL schema architecture and data models for existing and recent 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

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

📌 Database Administrator, PostgreSQL (Winnipeg)
🏢 Jobtailor
📍 Winnipeg