Software Engineer - Postgres Tooling

Jobgether

Australia

Remote

AUD 150,000 - 210,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Fully remote work
Equity (ESOP)
Tech/ equipment allowance
Health benefits
Annual team off-sites
Flexible working
Professional development
Open-source involvement

Job summary

Jobgether is seeking an experienced Software Engineer – PostgreSQL Tooling based in Australia. You will co-maintain an open-source schema engine, review AI-assisted contributions, and expand testing across PostgreSQL versions to ensure safe migrations and strong security.

You’ll lead discussions, write design docs, and drive toward a stable 1.0 release with robust APIs. The role emphasizes independent, async collaboration across globally distributed teams and a focus on engineering precision in

Qualifications

  • At least 8 years of professional software engineering experience with PostgreSQL.
  • Deep understanding of PostgreSQL internals including pg_catalog, pg_depend, permissions and extensions.
  • Strong knowledge of DDL operations, migration semantics and destructive-change detection.
  • Security-conscious engineering mindset to prevent privilege changes or data loss.
  • Proficiency in TypeScript and reliable, well-tested software development.
  • Experience designing advanced testing strategies for correctness across PostgreSQL versions.
  • Ability to review complex code and work with AI-assisted development tools.
  • Proven track record owning and maintaining production software and releases.
  • Excellent written communication and ability to document decisions clearly.
  • Ability to work independently within distributed engineering teams.

Responsibilities

  • Co-maintain and progressively take ownership of an open-source PostgreSQL schema tool.
  • Review, evaluate and merge contributions, including AI-generated PRs.
  • Investigate and resolve issues related to schema differences and compatibility.
  • Expand automated testing and validation across multiple PostgreSQL versions.
  • Ensure migrations are safe, privilege-aware and data-preserving.
  • Identify destructive schema changes and propose safer alternatives.
  • Contribute to a stable 1.0 release with public APIs and documentation.
  • Engage with the open-source community and manage external contributions.
  • Coordinate with internal teams for consistent migration generation and execution.
  • Write design documents and set architectural direction.
  • Participate in on-call rotation for production issues.

Skills

PostgreSQL internals
TypeScript
Open-source collaboration
Testing strategies
Technical ownership

Tools

Migra
pg-schema-diff
Atlas

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 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 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‑Sits: 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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Remote PostgreSQL Tooling Engineer Open-Source Migrations
Remote PostgreSQL Tooling Engineer Open-Source Migrations

Jobgether • Australia

Remote
AUD 150,000 - 210,000
Fully remote work
Equity (ESOP)
Tech/ equipment allowance
+5
Engineering Manager - Pipelines
Engineering Manager - Pipelines

Jobgether • Australia

Remote
AUD 180,000 - 260,000
Fully remote work
Coworking allowance
Equity ownership
+7
Postgresql Database Administrator
Postgresql Database Administrator

People Connect Ict Solutions • Melbourne

Hybrid
AUD 140,000 - 200,000
Senior Database Reliability Engineer (PostgreSQL)
Senior Database Reliability Engineer (PostgreSQL)

Arctic Fox • Canberra

On-site
AUD 176,000 - 251,000
Senior PostgreSQL Database Administrator - Government
Senior PostgreSQL Database Administrator - Government

APG Workforce • Sydney

Hybrid
AUD 152,000 - 207,000
PostgreSQL Database Administrator
PostgreSQL Database Administrator

Showtime Consulting • Australia

On-site
AUD 120,000 - 150,000
Postgres Deployment Engineer
Postgres Deployment Engineer

Gleexa • Australia

Remote
AUD 140,000 - 210,000
Fully Remote
ESOP
Tech Allowance
+4
Database Administrator Experts
Database Administrator Experts

Exclaim IT • Canberra

On-site
AUD 120,000 - 165,000
Platform Engineer, Managed Postgres
Platform Engineer, Managed Postgres

Gleexa • Australia

Remote
AUD 120,000 - 180,000
Fully Remote
ESOP
Tech Allowance
+4
PostgreSQL Database Administrator
PostgreSQL Database Administrator

Vertical Scope Group • Canberra

On-site
AUD 140,000 - 200,000
$1,000 referral program
Top locations