Database Engineer – PostgreSQL, PostGIS, TimescaleDB

Job not on LinkedIn

🕒 March 25

🗣️🇫🇷 French Required

Apply Now
Find Similar Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Logo of TEHORA inc.

TEHORA inc.

11 - 50 employees

TEHORA inc. is a company focused on offering enduring solutions through a strong ethos of observation, analysis, creation, innovation, sustainability, and preservation for future generations. Led by President Emmanuelle Soudé, TEHORA inc. operates with a commitment to long-term growth and partnership. The company's services and growth opportunities are a testament to their dedication to these principles, making them an appealing place for prospective employees. They have their headquarters in Québec, Canada, and encourage spontaneous applications from potential candidates.

📋 Description

• 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

Apply Now

Similar Jobs

🕒 March 25

Montrose Environmental Group

1001 - 5000

📋 Compliance

⚡ Energy

Senior/Associate Environmental Scientist managing site assessment and remediation projects for Montrose Environmental. Collaborating with teams to deliver high-quality solutions and driving project scopes and budgets.

🕒 March 25

CruxOCM

11 - 50

⚡ Energy

🏢 Enterprise

☁️ SaaS

Lead hydraulic modeling component of automation platform for heavy industry. Collaborate with multidisciplinary teams on product development and deployment.

🕒 March 24

Lateral Group

201 - 500

🤖 Artificial Intelligence

🤝 B2B

🏢 Enterprise

Senior Snowflake Engineer developing scalable data solutions for a tech company. Focused on data pipelines, SQL optimization, and collaboration with cross-functional teams.

Airflow

AWS

Azure

Cloud

ETL

Google Cloud Platform

Matillion

SQL

Tableau

Vault

🕒 March 20

Sargent & Lundy

1001 - 5000

⚡ Energy

Lead Engineer specializing in underground transmission line design for voltages up to 500kV. Managing complex projects involving routing, duct bank configurations, and collaborative vendor engagements.

🕒 March 20

Sargent & Lundy

1001 - 5000

⚡ Energy

Senior Engineer designing underground transmission lines up to 500kV for Sargent & Lundy. Responsibilities include physical design, cost analysis, and project team coordination.