Staff Software Engineer, PostgreSQL Specialist

Idme; McLean, Mountain View (VA, CA); Presencial; USD 180.000 - 280.000; Jornada completa

Descripción de la vacante

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

Formación

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

Responsabilidades

• 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.

Conocimientos

PostgreSQL internals

MVCC

vacuum/autovacuum tuning

lock management

WAL/checkpoint behavior

buffer management

query planner/optimizer internals

bloat remediation

observability & diagnostics

CDC architectures

Educación

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

Herramientas

Liquibase

CI/CD workflows

Descripción del empleo

Company Overview

ID.me is the next-generation digital identity wallet that simplifies how individuals securely prove their identity online. Consumers can verify their identity with ID.me once and seamlessly login across websites without having to create a new login and verify their identity again. Over 175 million users experience streamlined login and identity verification with ID.me at 22 federal agencies, 50 state government agencies, and more than 100 healthcare organizations. Over 600 consumer brands use ID.me to verify communities and user segments to honor service and build more authentic relationships. ID.me’s technology meets the federal standards for consumer authentication set by the Commerce Department and is approved as a NIST 800-63-3 IAL2 / AAL2 credential service provider by the Kantara Initiative. ID.me is committed to “No Identity Left Behind” to enable all people to have a secure digital identity. To learn more, visit https://network.id.me/ . ID.me is a full-time, in-office culture. Unless a specific job description explicitly states otherwise, all roles are on-site five days per week at one of our offices in McLean, VA; Mountain View, CA; New York City, NY; or Tampa, FL. Certain roles — such as field-based sales or other remote-by-design positions — may have different work arrangements as noted in their individual postings. At ID.me, we embrace the thoughtful use of AI tools in our daily work and there are even occasions where we leverage AI in our hiring process. However, during the interview process, we want to understand your individual skills and experiences. Therefore, we have guidelines on how AI can be appropriately used during your application and interviews which can be found here .

Role Overview

ID.me is seeking a Staff Software Engineer (SDE5), PostgreSQL Specialist to lead the engineering, evolution, and operational excellence of our PostgreSQL-based data platform . This role sits at the intersection of deep database internals and platform software engineering—focused on scaling our core relational databases (across CloudSQL, AlloyDB, and AWS RDS) and building the developer tooling, safe change deployment pipelines, and automated guardrails that protect ID.me’s mission-critical identity systems.

As a Staff Engineer on the Core Platform Data team, you will serve as the organization’s foremost technical authority on PostgreSQL internals, performance engineering, and safe database evolution at scale . Beyond tuning queries and managing high-scale database infrastructure, you will act as a force multiplier for the entire engineering organization by designing and maintaining automated schema change pipelines, migration linters, and self-service guardrails that enable product engineers to ship database changes safely, rapidly, and without production disruption. You will also lead high-stakes database engine upgrades, large-scale data migrations, and Change Data Capture (CDC) initiatives in partnership with Product Engineering, SRE, Security, and Compliance teams. This is a highly technical, hands‑on role that combines deep mastery of PostgreSQL internals with strong software engineering skills to build resilient systems and developer‑facing database automation. This role is based out of our Mountain View, CA or McLean, VA offices and requires full-time in‑office attendance .

Responsibilities

• Master & Optimize PostgreSQL Internals at Scale: 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.
• Build Safe Change Deployment Pipelines & Developer Guardrails: Design, build, and maintain automated database schema change management pipelines (e.g., Liquibase/CI‑CD workflows, automated DDL validation, lock/timeout guardrails, and pre‑flight migration checks) that empower engineers across ID.me to deploy schema and data changes safely with zero downtime.
• Lead Zero‑Downtime Migrations & Engine Upgrades: Architect and execute complex, large‑scale data migrations (accounting for data skew, batching, and index performance) as well as majorversion upgrades andplatform transitions across PostgreSQL, GCP CloudSQL, AlloyDB, andAWSRDS.
• DriveQuery Performance & Schema Hygiene: Partnerwith engineering teamsto review and optimize high‑throughputqueries, indexing strategies, partitioning/sharding designs, connection management, and role/permission models across operational and graph‑adjacent relational workloads.
• Engineer Database Observability&DiagnosticsTooling: Buildand enhance custom PostgreSQLtelemetry,statistics collection,query performance monitoring, andalertingto proactivelydetect lockcontention, replication lag, slowqueries, andcapacitybottlenecks beforethey impactproduction SLAs.
• EnableEvent‑Driven&CDC Architectures: Design andmaintain reliable Change Data Capture(CDC), logical replicationandoutbox/streaming integrations that bridge transactional PostgreSQL databaseswith ID.me’sbroaderevent‑drivenandanalytical data ecosystem.
• Automate Governance, Security & Compliance: Build automated workflowsand enforcementmechanismsfordatabaseaccess controls, cross‑schema permissionsand secret rotation, data retention/pruningand regulatory compliance(FedRAMP, NIST 800-63, GDPR).
• ActasProduction StabilityGuardian&Multiplier: This re‑po…/control… ,…

Minimum Qualifications

Bachelor’s or Graduate degree in Computer Science, Software Engineering, or a related technical field (or equivalent practical experience). 8+ years of professional software development and data infrastructure