Staff PostgreSQL Engineer: Zero Downtime Migrations

iDme Technologies Corp; Mountain View (WY); On-site; USD 174,000 - 253,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

401(k) with company match

Paid time off

Life insurance

Disability insurance

Parental leave

Job summary

ID.me seeks a Staff Software Engineer (SDE5) to lead PostgreSQL-oriented data platform evolution, development, and operations. You will ensure scalable internals, automated schema changes, and robust tooling across CloudSQL, AlloyDB, and AWS RDS.

Based in Mountain View, CA or McLean, VA, this full-time role requires in-office attendance and deep expertise in PostgreSQL internals, performance, and safe database evolution at scale.

Qualifications

• 8+ years of software development and data infrastructure experience.
• 5+ years PostgreSQL in high-volume production.
• Strong backend programming and SQL/PLpgSQL proficiency.

Responsibilities

• Serve as PostgreSQL internals expert and escalation point.
• Design safe schema changes and CI/CD pipelines for zero-downtime deployments.
• Lead large-scale migrations and major PostgreSQL upgrades.
• Optimize queries, indexing, partitioning and access patterns.
• Build observability tooling for PostgreSQL telemetry and alerts.
• Enable CDC, logical replication, and event-driven workflows.
• Enforce governance, security, and regulatory compliance in data stores.
• Mentor engineers to raise the organization’s database engineering standards.

Skills

PostgreSQL internals

MVCC

Performance tuning

Go

Python

Ruby

Java

SQL

Education

Bachelor’s or Graduate degree in CS/SE or related field

Tools

Liquibase

Flyway

DDL linters

Terraform

Kubernetes

Helm

Job description

ID.me seeks a Staff Software Engineer (SDE5) to lead PostgreSQL-oriented data platform evolution, development, and operations. You will ensure scalable internals, automated schema changes, and robust tooling across CloudSQL, AlloyDB, and AWS RDS.

Based in Mountain View, CA or McLean, VA, this full-time role requires in-office attendance and deep expertise in PostgreSQL internals, performance, and safe database evolution at scale.