Database Engineer – PostgreSQL, PostGIS, TimescaleDB

🕒 March 25

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

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

Upload Resume

TEHORA inc.

WebsiteLinkedInAll Job Openings

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