Database Engineer – PostgreSQL, PostGIS, TimescaleDB

Role Overview

• 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

Tech Stack

• PostGIS
• Postgres

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)
• Sick leave and leave for family events
• Appropriate IT equipment
• A fulfilling and motivating workspace
• Social and environmental initiatives
• On-the-job learning program
• Career development path