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)
CPI position in building electrical engineering at EXP. Involvement in electrical design projects for various sectors with collaborative and innovative work environment.
Project Engineer specializing in water and wastewater treatment for infrastructure projects. Collaborating with cross - functional teams and overseeing project delivery in Brampton, Canada.
Principal Wind Turbine Technology Engineer enhancing wind power plants reliability and performance with data - driven analysis. Opportunity to work at the forefront of wind energy technology with DNV.
Environmental Engineer/Geoscientist at a forensic engineering firm in Halifax. Responsible for overseeing environmental investigations and liaising with clients.
Senior Project Engineer overseeing capital project execution for Agropur in Bedford, Nova Scotia. Leading multidisciplinary teams and ensuring alignment with business objectives in a fast - paced environment.
Lead Verification Engineer developing high - performance physical IP at Cadence. Responsible for digital RTL verification and developing re - usable verification components and environments.
Senior Digital Verification Engineer at Ciena focusing on implementing innovative strategies for validating Forward Error Correction IP subsystems. Collaborating with design engineers to ensure functional integrity.
Ingénieur(e) en mécanique du bâtiment concevant des systèmes (plomberie, chauffage, ventilation). Coordination des projets dans le cadre du développement des trains à grande vitesse au Canada.