Database Engineer – PostgreSQL, PostGIS, TimescaleDB

Posted 4 days ago

Apply Now

Resume Score

Check how well your resume matches this job before you apply.

Sign in to check score

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

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)
  • 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

Job title

Job type

Full Time

Experience level

Mid levelSenior

Salary

Not specified

Degree requirement

Bachelor's Degree

Tech skills

PostGISPostgres

Location requirements

RemoteCanada

Report this job

Found something wrong with the page? Please let us know by submitting a report below.