22 Nov
|
Jobgether
|
Gold Coast
22 Nov
Jobgether
Gold Coast
This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Software Engineer – Postgres Tooling based in Australia.
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. You will collaborate with globally distributed engineering teams and open-source contributors to improve developer workflows and establish robust tooling standards. 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 setting 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.
- Identify potentially destructive schema changes and implement mechanisms to detect them and generate safer alternatives wherever possible.
- Contribute to the development of a stable 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.
- Experience designing advanced testing strategies for correctness, including differential testing, property‐based testing, and test corpus validation across multiple PostgreSQL versions.
- Familiarity with compiler‐style engineering challenges, including dependency graphs, topological sorting, cycle detection, and schema comparison algorithms.
- Ability to review and understand complex code changes within sophisticated codebases, including contributions generated with AI‐assisted development tools.
- Proven experience owning and maintaining production software, including staged releases, error monitoring, incident investigation, and responding to real‐world user feedback.
- Demonstrated ability to lead complex technical initiatives across multiple teams, from initial problem definition and architectural planning through production implementation.
- Excellent written communication skills and
📌 Software Engineer (Gold Coast)
🏢 Jobgether
📍 Gold Coast