Software Engineer - Postgres Tooling

Jobgether

Canada

Remote

CAD 120,000 - 180,000

Full time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Fully remote India
WeWork allowance
ESOP
Tech budget
Health benefits
Team off-sites
Flexible hours
Education allowance
Global collaboration
Open-source tooling

Job summary

Jobgether is seeking a Software Engineer – Postgres Tooling in Canada to help build and maintain open-source PostgreSQL tooling for schema comparison and migrations. You will own parts of a migration engine, review AI-assisted contributions, and work with distributed teams to ensure correctness, security, and reliability across multiple PostgreSQL versions.

The role emphasizes independent work, strong design decisions, and delivering a stable 1.0 release while collaborating with open-source

Qualifications

  • 8+ years of professional software engineering experience with PostgreSQL.
  • Deep knowledge of PostgreSQL internals: pg_catalog, pg_depend, permissions, and extension membership.
  • Strong knowledge of DDL operations and migration semantics, including locking and dependencies.
  • Security-conscious mindset to prevent privilege changes and data loss.
  • Proficiency in TypeScript and maintainable, well-tested code.
  • Experience designing testing strategies for correctness across multiple PostgreSQL versions.
  • Familiarity with compiler-style challenges: dependency graphs, topological sorting, cycles.
  • Ability to review complex code changes, including AI-assisted contributions.
  • Proven experience owning production software and incident response.
  • Ability to lead initiatives across multiple teams and document decisions clearly.
  • Excellent written communication and ability to work asynchronously with distributed teams.

Responsibilities

  • Co-maintain and progressively take technical ownership of an open-source PostgreSQL schema comparison and migration engine.
  • Review, evaluate, and merge code contributions, including AI-generated pull requests, with emphasis on correctness and security.
  • Investigate and resolve issues related to schema differences, dependency ordering, and migration generation across PostgreSQL versions.
  • Expand automated testing and validation coverage to ensure reliable behavior.
  • Ensure generated migrations are safe, privilege-aware, and minimize data loss risk.
  • Identify potentially destructive changes and implement safer alternatives.
  • Contribute to a stable 1.0 release, including APIs, versioning, documentation, and extension support.
  • Engage with the open-source community by managing issues and reviewing external contributions.
  • Collaborate with internal teams to ensure consistent migration generation across products and services.
  • Write technical design docs and set architectural direction for tooling evolution.
  • Participate in on-call rotations to support production deliveries.

Skills

PostgreSQL
TypeScript
Go
AI-assisted development
Open-source tooling

Tools

migra
pg-schema-diff
Atlas
pgroll
Sqitch
Prisma Migrate
Flyway
Liquibase
Git

Job description

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 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. 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 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.
  • 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 the ability to document technical decisions clearly.
  • Ability to work independently, manage priorities effectively, and collaborate successfully within asynchronous, globally distributed engineering teams.

Nice to Have:

  • Previous experience developing or maintaining database schema comparison and migration tools such as migra, pg‑schema‑diff, Atlas, pgroll, sqitch, Prisma Migrate, Flyway, or Liquibase.
  • Familiarity with PostgreSQL backup and schema extraction internals, particularly pg_dump.
  • Open‑source project maintenance experience, including managing public APIs, semantic versioning, technical documentation, and community contributions.
  • Knowledge of PostgreSQL extensions such as pg_cron, pgmq, pg_partman, vault, pg_net, pgvector, or PostGIS.
  • Experience with Go programming language.
  • Contributions to PostgreSQL itself or experience developing and maintaining PostgreSQL extensions.
  • Previous experience working with PostgreSQL‑based products or managed database platforms.
Benefits:
  • Fully Remote Work: Work from anywhere in India within a globally distributed team, with no mandatory office attendance.
  • Co‑working Support: Access to a WeWork membership or co‑working allowance to support a productive remote working environment.
  • Equity Ownership (ESOP): Employee stock ownership opportunities, allowing team members to share in the company's long‑term growth and success.
  • Technology Allowance: Dedicated budget to purchase equipment and improve your workspace, including laptops, monitors, headphones, and other essential tools.
  • Health Benefits: Comprehensive health insurance covering 100% of employee premiums and 80% of dependent premiums, subject to applicable plan terms and local eligibility.
  • Annual Team Off‑Sites: Opportunities to connect and collaborate with colleagues during company‑wide gatherings in different cities around the world.
  • Flexible Working Arrangements: Asynchronous work culture that encourages autonomy, flexibility, and ownership of your schedule.
  • Professional Development: Annual learning and education allowance for courses, books, conferences, and other professional growth opportunities.
  • International Collaboration: Opportunity to work alongside a globally distributed engineering team representing more than 60 countries and 20 languages.
  • Open‑Source Innovation: Work on impactful developer tools, contribute to the open‑source ecosystem, and help shape the future of PostgreSQL development.

We appreciate your interest and wish you the best!

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Product Manager - Postgres
Product Manager - Postgres

Jobgether • Canada

Remote
CAD 110,000 - 170,000
Fully Remote
Equity (ESOP)
Tech Allowance
+4
Engineering Manager - Pipelines
Engineering Manager - Pipelines

Jobgether • Canada

Remote
CAD 150,000 - 190,000
Fully remote work
Coworking allowance
Equity ownership (ESOP)
+5
Software Engineer - Database
Software Engineer - Database

Jobgether • Canada

Remote
CAD 96,000 - 192,000
Equity participation
Bonus program eligibility
Wellness allowance
Senior Software Engineer - RDB/SPO
Senior Software Engineer - RDB/SPO

Jobgether • Canada

Remote
CAD 154,000 - 236,000
Remote work within Canada
Volunteer Time Off (VTO)
Professional development
Principal Software Engineer - Postgres
Principal Software Engineer - Postgres

clickhouse • Toronto

Remote
CAD 314,000 - 443,000
Flexible remote environment
Healthcare contributions
Equity in the company
+3
PostgreSQL Database Administrator (Production DBA)
PostgreSQL Database Administrator (Production DBA)

Centric Software • Toronto

Remote
CAD 160,000 - 217,000
Senior Software Engineer - Postgres
Senior Software Engineer - Postgres

clickhouse • Toronto

Remote
CAD 272,000 - 372,000
Remote-friendly
Healthcare
Equity
+3
PostgreSQL Database Administrator
PostgreSQL Database Administrator

Apptoza Inc. • Toronto

Hybrid
CAD 90,000 - 130,000
Remote Postgres‑Focused Database Engineer (Equity + Bonus)
Remote Postgres‑Focused Database Engineer (Equity + Bonus)

Jobgether • Canada

Remote
CAD 96,000 - 192,000
Equity participation
Bonus program eligibility
Wellness allowance
Software Engineer - AI Tooling
Software Engineer - AI Tooling

Jobgether • Canada

Remote
CAD 120,000 - 190,000
Fully remote
WeWork membership or co-working
ESOP
+8