Software Engineer - Postgres Internals

PlanetScale

$120K — $290K *
US-AnywhereRemote in San Francisco, CA
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Strong C programming skills in large codebases
  • Deep knowledge of PostgreSQL internals such as MVCC and query planners
  • Demonstrated open-source contributions to PostgreSQL or similar projects
  • Fluency with Git and PostgreSQL patch workflow
  • Comfortable in Linux/BSD environments, able to profile database workloads

Responsibilities

  • Author and review patches for performance, features, and bug fixes in PostgreSQL
  • Maintain both open-source and proprietary Postgres extensions
  • Review community patches for correctness and stability
  • Engage with the PostgreSQL community during design discussions and Commitfests
  • Root-cause issues affecting Planetscale customers and provide upstream fixes
  • Improve PostgreSQL documentation with each change contributed

Benefits

  • Flexible work environment
  • Opportunities for professional development
  • Engagement with the PostgreSQL community
  • Exposure to diverse technical challenges
  • Potential for attending conferences and events
Full Job Description

About the role

As a PostgreSQL Core Engineer, you will spend most of your time contributing upstream to the PostgreSQL core engine and maintaining the Postgres extensions - both open-source community projects and Planetscale's proprietary extensions - that power our Postgres offering.

What You'll Do

  • Author and review patches to the PostgreSQL core engine: performance, features, bug fixes, and security - landed through the pgsql-hackers mailing list and the Commitfest process.
  • Maintain Postgres extensions, both open-source (community projects we depend on) and proprietary (Planetscale-owned). Includes feature work, bug fixes, performance tuning, and major-version compatibility.
  • Review community patches with rigor on correctness, stability, and PostgreSQL coding conventions.
  • Engage the PostgreSQL community in design discussions, the 5 (five) annual Commitfests, and conferences.
  • Root-cause Postgres issues affecting Planetscale customers and turn fixes into upstream patches when applicable.
  • Improve documentation for PostgreSQL and our extensions as part of every change.

What We're Looking For

Required:
  • Strong C programming skills in large, established codebases.
  • Deep knowledge of PostgreSQL internals: MVCC, query planner/executor, WAL, vacuum, replication, memory contexts.
  • Demonstrated open-source contributions to PostgreSQL or comparable database projects (accepted patches, reviews, or extensions).
  • Fluency with Git and the PostgreSQL patch workflow.
  • Comfortable in Linux/BSD development environments; able to profile and benchmark database workloads.
Nice to Have:
  • PostgreSQL contribution history.
  • Experience authoring or maintaining a Postgres extension end-to-end (e.g., pgvector, pg_stat_statements, PostGIS).
  • Background in distributed systems, storage engines, or query optimization.
  • Public talks, papers, or blog posts in the Postgres ecosystem.

About You

You're someone who deeply understands what it takes to evolve PostgreSQL responsibly - both upstream and through extensions. You've shipped patches to Postgres or authored extensions before, and have strong opinions about what makes a change land cleanly versus stall in review

You enjoy wearing many hats and get energized by working on diverse problems across the stack. You ship quickly and iterate based on feedback. You collaborate effectively with engineers in different domains. You're excited about leveraging AI tools to move faster. You make pragmatic technical decisions and can work independently with minimal direction.

Total Compensation and Pay Transparency

An employee's total compensation consists of base salary + variable comp where appropriate + benefits + equity. A member of our Talent Acquisition team will be happy to answer any further questions when we engage with you to begin the interview process.

Base salary range: $120,000 - $290,000 USD

Similar Jobs

More Jobs at PlanetScale

More Information Technology Jobs

Find similar Software Engineer - Postgres Internals jobs: