Staff Software Engineer, PostgreSQL Specialist

IDMe

Where
McLean, Virginia; Mountain View, California, United States
Pay
$174K to $229K a year
Type
Full time

Posted 24 days ago· Checked live at IDMe 1 hour ago

Stale: open 24 daysUp for more than two weeks. It may already be filled.

See how you score for this job

One sentence and your resume. We score it against what IDMe asks for, line by line.

See my score
Is this job still open?
Yes. We checked it live on IDMe's own hiring page 1 hour ago.
What is the job?
IDMe is the next-generation digital identity wallet that simplifies how individuals securely prove their identity online. Consumers can verify their identity with IDMe once and seamlessly login across websites without having to create a new login and verify their identity again.
What does it pay?
$174K to $229K a year, as the posting states.
Our verdict
Stale. Up for more than two weeks. It may already be filled.

What the job is

IDMe is the next-generation digital identity wallet that simplifies how individuals securely prove their identity online. Consumers can verify their identity with IDMe once and seamlessly login across websites without having to create a new login and verify their identity again.

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 IDMe 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 major version upgrades and platform transitions across PostgreSQL, GCP CloudSQL, AlloyDB, and AWS RDS.
  • Drive Query Performance & Schema Hygiene: 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.
  • Engineer Database Observability & Diagnostics Tooling: 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.
  • Enable Event-Driven & CDC Architectures: Design and maintain reliable Change Data Capture (CDC), logical replication, and outbox/streaming integrations that bridge transactional PostgreSQL databases with IDMe’s broader event-driven and analytical data ecosystem.
  • Automate Governance, Security & Compliance: Build automated workflows and enforcement mechanisms for database access controls, cross-schema permissions, secret rotation, data retention/pruning, and regulatory compliance (e.g., FedRAMP, NIST 800-63, GDPR).
  • Act as Production Stability Guardian & Multiplier: 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 the organization’s database engineering bar.

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 experience, including 5+ years working deeply with PostgreSQL in high-volume production environments.
  • Deep, hands-on knowledge of PostgreSQL internals (e.g., 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.

Preferred Qualifications

  • Proven track record of building software, automation, and CI/CD pipelines for safe database schema changes, migrations, and developer guardrails.Demonstrated experience designing and operating automated database change management and schema migration frameworks (e.g., 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 (e.g., 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 (e.g., FedRAMP, NIST, 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—turning tribal database knowledge into self-service tools, documentation, and paved paths for other engineers.

The annual base salary listed does not include a company bonus, incentive for sales roles, equity and benefits which will be determined based on experience, skills, education, relevant training, geographic location and role.

IDMe offers comprehensive medical, dental, vision, health savings account, flexible spending accounts (medical, limited purpose, dependent care, commuter benefit accounts), basic and voluntary life and AD&D insurance, 401(k) with company match, parental leave, ability to participate in unlimited paid time off subject to the terms and conditions of the PTO policy, including 8 company wide holidays, short and long-term disability insurance, accident and critical illness insurance, referral bonus policy, employee assistance program, pet insurance, travel assistant program, wellbeing and childcare discounts, benefit advocates, and a learning and development benefit.

Final offers may vary from the amount listed based on qualifications, professional experiences, skills, education, relevant training, geographic location, and other job related factors.

U.S. Pay Range

$174,000 - $229,000 USD

Mountain View, CA Pay Range

$194,000 - $253,000 USD

IDMe maintains a work environment free from discrimination, where employees are treated with dignity and respect. All IDMe employees share in the responsibility for fulfilling our commitment to equal employment opportunity. IDMe does not discriminate against any employee or applicant on the basis of age, ancestry, color, family or medical care leave, gender identity or expression, genetic information, marital status, medical condition, national origin, physical or mental disability, political affiliation, protected veteran status, race, religion, sex (including pregnancy), sexual orientation, or any other characteristic protected by applicable laws, regulations and ordinances. IDMe adheres to these principles in all aspects of employment, including recruitment, hiring, training, compensation, promotion, benefits, social and recreational programs, and discipline. In addition, IDMe's policy is to provide reasonable accommodation to qualified employees who have protected disabilities to the extent required by applicable laws, regulations and ordinances where a particular employee works. Upon request we will provide you with more information about such accommodations.

Please review our Privacy Policy, including our CCPA policy, at id.me/privacy. If you provide IDMe with any personally identifiable information you confirm that you have read and agree to be bound by the terms and conditions set out in our Privacy Policy.

IDMe participates in E-Verify.

Similar open jobs

Software engineer jobs in San Jose (1462)Jobs in San Jose (7796)