About the role

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

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