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