Senior PostgreSQL Platform Engineer - Zero-Downtime Migrations

Idme

McLean, Mountain View (VA, CA)

On-site

USD 180,000 - 280,000

Full time

9 days ago

Get a reply from this employer

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

Get past ATS filters

Job summary

ID.me seeks a Staff Software Engineer (SDE5), PostgreSQL Specialist to drive PostgreSQL internals, performance, and safe evolution across CloudSQL, AlloyDB, and AWS RDS. You’ll build automated schema-change pipelines, guardrails, and data migrations with product teams, ensuring reliability of identity systems at scale.

Based in Mountain View, CA or McLean, VA, this highly technical role requires in-office attendance, strong software engineering skills, and leadership in data platform

Qualifications

Bachelor's or graduate degree in CS, Software Engineering, or related field.
8+ years of professional software development and data infrastructure experience.

Responsibilities

Lead PostgreSQL internals at scale and be the primary escalation point.
Design and maintain automated schema change pipelines with zero downtime.
Plan and execute large-scale data migrations and major version upgrades.
Improve query performance, indexing, and partitioning strategies.
Build observability tooling for telemetry, metrics, and alerting.

Skills

PostgreSQL internals

MVCC

vacuum/autovacuum tuning

lock management

WAL/checkpoint behavior

buffer management

query planner/optimizer internals

bloat remediation

observability & diagnostics

CDC architectures

Education

Bachelor's or Graduate degree in Computer Science or related field

Tools

Liquibase

CI/CD workflows

Job description

Based in Mountain View, CA or McLean, VA, this highly technical role requires in-office attendance, strong software engineering skills, and leadership in data platform

Get your free, confidential resume review.

or drag and drop your file here.