I

ID.me

Runs a digital ID wallet for online sign-ins

Staff Software Engineer - PostgreSQL Specialist

Database AdministrationConfirmed live in the last 24 hours
Full-time

About the Job

Requirements

  • A Bachelor's or Graduate degree in Computer Science, Software Engineering, or a related technical field, or equivalent practical experience.
  • At least 8 years of professional software development and data infrastructure experience, including at least 5 years working deeply with PostgreSQL in high-volume production environments.
  • Deep hands-on knowledge of PostgreSQL internals, including MVCC, vacuuming, locking semantics, query execution plans, indexing structures, WAL, and replication.
  • Strong programming proficiency in one or more backend languages such as Go, Python, Ruby, or Java, alongside expert-level SQL and PL/pgSQL.

Responsibilities

  • Serve as the primary technical escalation point and subject-matter expert on PostgreSQL internals, including MVCC, vacuum/autovacuum tuning, transaction ID wraparound prevention, lock management, WAL/checkpoint behavior, buffer management, query planner/optimizer internals, and table/index bloat remediation.
  • Design, build, and maintain automated database schema change management pipelines, including Liquibase/CI-CD workflows, automated DDL validation, lock/timeout guardrails, and pre-flight migration checks, enabling engineers to deploy schema and data changes safely with zero downtime.
  • Architect and execute complex, large-scale data migrations accounting for data skew, batching, and index performance, as well as major version upgrades and platform transitions across PostgreSQL, GCP CloudSQL, AlloyDB, and AWS RDS.
  • Partner with engineering teams to review and optimize high-throughput queries, indexing strategies, partitioning/sharding designs, connection management, and role/permission models across operational and graph-adjacent relational workloads.
  • Build and enhance custom PostgreSQL telemetry, statistics collection, query performance monitoring, and alerting to proactively detect lock contention, replication lag, slow queries, and capacity bottlenecks before they impact production SLAs.
  • Design and maintain reliable Change Data Capture (CDC), logical replication, and outbox/streaming integrations bridging transactional PostgreSQL databases with the broader event-driven and analytical data ecosystem.
  • Build automated workflows and enforcement mechanisms for database access controls, cross-schema permissions, secret rotation, data retention/pruning, and regulatory compliance, including FedRAMP, NIST 800-63, and GDPR.
  • Establish and codify PostgreSQL best practices, conduct architectural and high-risk migration reviews, and mentor engineers across the company to decentralize database expertise and elevate database engineering standards.

Desired Qualifications

  • Demonstrated experience building software, automation, and CI/CD pipelines for safe database schema changes, migrations, and developer guardrails, including automated database change management and schema migration frameworks such as Liquibase, Flyway, custom DDL linters, or zero-downtime migration tooling across a large engineering organization.
  • Extensive hands-on experience managing and upgrading managed cloud PostgreSQL platforms at scale, particularly GCP CloudSQL, Google AlloyDB, AWS RDS, or Aurora PostgreSQL.
  • Proven success planning and executing near-zero-downtime major PostgreSQL version upgrades and multi-terabyte table migrations or normalizations under strict availability SLAs.
  • Deep experience with PostgreSQL extensions, custom statistics/diagnostics tooling, logical replication, and Change Data Capture (CDC) pipelines such as Debezium, pglogical, Airbyte, or Pub/Sub/Kafka integrations.
  • Experience automating database infrastructure and lifecycle management using Terraform, Kubernetes, or Helm.
  • Strong understanding of data security, encryption, role-based access control, and compliance requirements in regulated environments, including FedRAMP, NIST, and GDPR.
  • Fluency with AI-assisted engineering tools and workflows to accelerate tooling development, query analysis, and migration validation.
  • Track record of acting as a force multiplier by turning tribal database knowledge into self-service tools, documentation, and paved paths for other engineers.

About the Company

ID.me

Runs a digital ID wallet for online sign-ins

ID.me runs a digital identity wallet that lets people prove who they are online once, then sign in to government agencies, health systems, and online stores without repeating the check. In 2018, it became the first identity provider certified to the federal standard for proving a person's identity online, and in 2021 the IRS adopted it for taxpayers' online accounts. Users photograph a government ID and take a selfie, or confirm who they are with an ID.me agent on a video call, and the result is saved for reuse on other sites. Organizations that accept ID.me pay for each check or through subscriptions, and people use it for free. ID.me was founded in 2010 to verify military members for online discounts and is based in McLean, Virginia.

Company size
1,001-5,000
Company stage
Series E
Total funding
$727.3M
Headquarters
McLean, VA
Founded
2010

Recently Posted Jobs

Explore more opportunities at ID.me

See more jobs