Hybrid Database Administrator – PostgreSQL

Posted 5 days ago

Apply now

About the role

  • PostgreSQL Database Administrator for SaaS product evolution focusing on AI initiatives. Collaborating within an Agile team to optimize database performance and structure.

Responsibilities

  • 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.

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.

Job title

Database Administrator – PostgreSQL

Job type

Experience level

Mid levelSenior

Salary

Not specified

Degree requirement

Bachelor's Degree

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job