Database Engineer with expertise in PostgreSQL and geospatial technologies for TEHORA. Designing and optimizing data layers for weather observation management.
Responsibilities
Design the data model required to manage weather observations, historical records and associated metadata
Implement PostgreSQL / PostGIS / TimescaleDB structures tailored to performance and retention requirements
Optimize schemas, indexes, queries and retention or archival mechanisms
Support integration of geospatial data, time series and traceability/provenance rules
Contribute to historical migration and validation of ingested data
Define backup, restore, recovery and resilience strategies for the data layer
Collaborate with backend, GIS and architecture teams to ensure solution consistency
Produce technical documentation for the database and operational procedures
Participate in performance analysis and stabilization prior to production deployment
Requirements
Hold a bachelor's degree in computer science or a related field, or have equivalent experience
At least 5 years of PostgreSQL experience in production environments
Hands-on experience with PostGIS in geospatial or mapping projects
Experience with TimescaleDB or other time-series technologies (strong asset)
Strong proficiency in query optimization, indexing, retention and performance tuning
Experience with backup, restore and disaster recovery strategies
Ability to model complex technical and operational data
Attention to data quality, robustness and data traceability
Good communication skills in French and/or English
Benefits
Remote work and flexibility to accommodate family obligations
An entrepreneurial culture that encourages creativity and innovation
Flexible working hours (depending on the type of employment contract)
AI Agent Engineer developing LLM - based AI solutions for cybersecurity at CrowdStrike. Leading AI agent development and optimizing performance with modern frameworks and technologies.
Lead engineering work following AtkinsRéalis procedures on Candu instrumentation and control systems. Collaborate with clients and design disciplines to ensure project delivery and compliance.
Process Engineer responsible for improving cloud system reliability at PointClickCare. Collaborating with engineering teams to enhance SaaS operations and incident response practices.
Intermediate Acoustical Engineer/Specialist providing environmental noise and vibration assessment services. Conducting field investigations and supporting project delivery with multidisciplinary teams.
Senior Fire Protection Engineer designing complex fire protection systems for various projects across Canada. Mentoring junior staff and contributing to the technical direction of projects.
Ingénieur(e) en géotechnique chez EXP, soutenant des projets à Montréal et Laval. Vous travaillerez sur des études géotechniques variées en environnement collaboratif.
Ingénieur.e en Structure du bâtiment chez EXP, contribuant à des projets variés et stimulants. Mode de travail hybride à Salaberry - de - Valleyfield, QC, Canada.
Ingénieur en environnement réalisant des évaluations environnementales et gérant des projets de surveillance environnementale. Collaborant avec une équipe dynamique pour des solutions durables à Montréal ou Laval.
Data Center Facilities Engineer maintaining operational and regulatory integrity of data center systems. Ensuring reliability and efficiency of critical facility operations.
Licensing Engineer contributing to IP development and analysis at WiLAN. Engaging in patent evaluation, licensing support, and technical research in telecommunications.