Staff PostgreSQL Engineer: Scale & Safe Migrations

ID.me, Inc.; McLean, Mountain View (VA, CA); On-site; USD 174,000 - 229,000; Full time

Job summary

ID.me is seeking a Staff Software Engineer (SDE5), PostgreSQL Specialist, to lead the PostgreSQL-based data platform. You will own internals tuning, high-scale repairs, and safe production deployments while building developer tooling and automated guards for schema changes.

You’ll drive large migrations, upgrades, and CDC efforts across cloud and on‑prem environments, mentoring others and shaping engineering best practices in a highly technical, hands‑on role.

Qualifications

• 8+ years of professional software development and data infrastructure experience.
• Deep PostgreSQL internals knowledge including MVCC, vacuum, locking, WAL, replication.
• Strong backend programming proficiency and SQL expertise.

Responsibilities

• Lead PostgreSQL internals optimization and capacity planning at scale.
• Build safe change deployment pipelines and guardrails with zero downtime.
• Manage zero-downtime migrations, upgrades, and CDC initiatives.
• Enhance observability, diagnostics tooling, and performance monitoring.
• Drive governance, security, and regulatory compliance in database ops.

Skills

PostgreSQL internals

Backend languages (Go / Python / Ruby)

SQL / PL/pgSQL

Database performance tuning

Education

Bachelor’s or Graduate degree in Computer Science / Software Engineering

Tools

Liquibase

Flyway

DDL linters

Terraform

Kubernetes

Helm

Debezium / Debezium-like CDC

Airbyte / Pub/Sub / Kafka integrations

Cloud PostgreSQL platforms (CloudSQL / AlloyDB / AWS RDS)

Job description

ID.me is seeking a Staff Software Engineer (SDE5), PostgreSQL Specialist, to lead the PostgreSQL-based data platform. You will own internals tuning, high-scale repairs, and safe production deployments while building developer tooling and automated guards for schema changes.

You’ll drive large migrations, upgrades, and CDC efforts across cloud and on‑prem environments, mentoring others and shaping engineering best practices in a highly technical, hands‑on role.