Key skills
AWSAzureCloudETLPostgresSQLAIGitHub ActionsECSLambdaS3RDSIAMAzure DevOpsPostgreSQLGitHubSaaSAgileScrumCI/CDCollaboration
About this role
Role Overview
- Design, model, and evolve PostgreSQL database schemas.
- Optimize SQL queries, functions, indexes, and execution plans.
- Establish and improve partitioning, replication, maintenance, and monitoring strategies.
- Implement and document migration strategies, including requirements specific to our AI modules (data pipelines, transformations, data historization, etc.).
- Work closely with our DBAs to improve standards and provide tooling for the rest of the team.
- Configure, manage, and optimize AWS RDS Aurora for PostgreSQL.
- Support the team in using cloud services (AWS S3, IAM, ECS, Lambda, Secrets Manager).
- Contribute to improving CI/CD pipelines related to databases and backend services.
- Work within a multidisciplinary Agile (Scrum) team.
- Participate in Agile ceremonies and actively contribute to planning, estimation, and technical collaboration.
- Document solutions, share best practices, and help raise the team's maturity in data-driven development.
Requirements
- Strong expertise in PostgreSQL (complex queries, optimization, indexing, execution plans, performance).
- Experience in data modeling and designing large-scale relational databases.
- Comfortable working with AWS environments, particularly RDS.
- Experience with SaaS environments or distributed architectures (a plus).
- Familiarity with CI/CD pipelines (Azure DevOps or GitHub Actions) (a plus).
- Experience with AI-related workloads (ETL, data transformations, pipeline preparation) (a plus).
- A basic knowledge of English is required.
Tech Stack
- AWS
- Azure
- Cloud
- ETL
- Postgres
- SQL
Benefits
- 3 to 5 weeks of vacation per year, depending on experience.
- 1 week of personal time off per year.
- Employer-paid insurance plan.
- Employer RRSP matching contribution program.
- Employee stock ownership plan.
- Company computer purchase program.
- Employee wellness program with an annual allowance.
- Employee assistance program (EAP).
- A passionate, experienced, and collaborative team.
- Exciting technical challenges: modernization, AWS cloud, AI, platform scaling.
- A culture that values continuous improvement, code quality, and autonomy.
- Meaningful projects that reach thousands of users across Quebec.