About the job
gorh seeks a PostgreSQL Database Administrator to support its SaaS products and AI-focused projects in Québec, QC. The team includes over 40 software development professionals working to modernize and streamline the company's architecture.
What you will do
- Design, model, and evolve PostgreSQL database schemas to meet product needs.
- Optimize SQL queries, functions, indexes, and execution plans for strong performance.
- Develop and refine strategies for partitioning, replication, maintenance, and monitoring of databases.
- Document and execute migration strategies, including those for AI modules such as data pipelines, transformations, and historization.
- Work with fellow DBAs to set standards and deliver database tools to the broader team.
Cloud and infrastructure
- Configure, manage, and optimize AWS RDS Aurora for PostgreSQL.
- Support use of AWS services like S3, IAM, ECS, Lambda, and Secrets Manager.
- Contribute to improving CI/CD pipelines for databases and backend systems.
Team collaboration
- Work as part of a multidisciplinary Agile (Scrum) team.
- Participate in Agile activities such as planning, estimation, and technical discussions.
- Document solutions, share best practices, and help advance data-driven development across the team.
Requirements
- Strong expertise in PostgreSQL, including complex queries, optimization, indexing, execution plans, and performance tuning.
- Experience in data modeling and designing large-scale relational databases.
- Comfort working in cloud environments and with infrastructure.

