SOFTWARE DEVELOPMENT ENGINEER (IT) (H/F)

SOFTWARE DEVELOPMENT ENGINEER (IT) (H/F)

22 Nov
|
Jobgether
|
Canada

22 Nov

Jobgether

Canada

Our partner is looking for a Software Engineer – Postgres Tooling based in Canada. As a Software Engineer specializing in PostgreSQL tooling, you will play a key role in building and maintaining open-source tools that help developers manage database schemas and migrations safely and efficiently. You will contribute to the evolution of a powerful schema comparison and migration engine, ensuring the accuracy, reliability, and security of generated SQL. Working at the intersection of database internals, software engineering, and compiler-style problem-solving, you will tackle complex technical challenges involving dependency management, permissions, and data integrity. The role offers the opportunity to take technical ownership of a widely used project and help drive it toward a stable, standalone release. You will thrive in an asynchronous, open-source-first environment that values technical excellence, independent thinking, and engineering precision. Accountabilities: - Co-maintain and progressively take technical ownership of an open-source PostgreSQL schema comparison and migration engine, reviewing contributions and eventually growing into its lead maintainer. - Review, evaluate, and merge code contributions, including AI-generated pull requests, while ensuring high standards of correctness, maintainability, and security. - Investigate and resolve reported issues related to schema differences, dependency ordering, migration generation, and PostgreSQL compatibility. - Expand automated testing and validation coverage across multiple PostgreSQL versions to ensure consistent and reliable behavior. - Ensure generated database migrations are safe, privilege-aware, and designed to prevent unintended data loss or security regressions.



- Contribute to the development of a reliable 1. 0 release, including defining public APIs, establishing semantic versioning contracts, improving documentation, and expanding PostgreSQL extension support. - Engage with the open-source community by managing issue reports, reviewing external contributions, providing technical guidance, and maintaining constructive discussions with contributors. - Collaborate with internal engineering teams to ensure consistent migration generation and execution across products, platform services, database branching, and AI-powered workflows. - Write technical design documents, define architectural direction, and establish engineering strategies for the continued evolution of the tooling. - Participate in the engineering team's on-call rotation, helping investigate and resolve production-related issues while supporting reliable software delivery. Requirements: - At least 8 years of professional software engineering experience, including extensive hands-on experience with PostgreSQL. - Deep understanding of PostgreSQL internals, particularly system catalogs such as pg_catalog and pg_depend , object ownership, permissions, grants, default privileges, Row-Level Security (RLS) policies, and extension membership. - Strong knowledge of PostgreSQL DDL operations and database migration semantics, including locking behavior, transactional limitations, dependency management, and the identification of potentially destructive changes. - A security-conscious engineering mindset, with particular attention to preventing unauthorized privilege changes, accidental access exposure, and unintended data loss. - Strong proficiency in TypeScript and the ability to develop reliable, maintainable, and well-tested software.

📌 SOFTWARE DEVELOPMENT ENGINEER (IT) (H/F)
🏢 Jobgether
📍 Canada

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: software development engineer (it) (h/f) / canada

Subscribe to this job alert:

Get the latest job offers by email for: software development engineer (it) (h/f) / canada