Staff Software Engineer, PostgreSQL Specialist
Company websiteid.me (ID.me, opens in new tab)
Base salary $194K – $253K
Employer-published annual base salary, USD. Advertised base range in McLean, VA +1 more
Pay shown applies to McLean, VA +1 more; this posting also lists other locations.
This opportunity has 2 location variants. Pay shown applies only to the location named; other locations may differ.
You apply on the employer's own site. Six Figure Work does not handle applications.
- LocationMcLean, VA +1 more
- WorkplaceWorkplace not stated
- Status at last checkSource accepting applications when checked
- Last checked (19 min ago) · observed since
All places named
- McLean, VA
- Mountain View, CA
About this job
Company Overview
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. Over 175 million users experience streamlined login and identity verification with IDMe at 22 federal agencies, 50 state government agencies, and more than 100 healthcare organizations. Over 600 consumer brands use IDMe to verify communities and user segments to honor service and build more authentic relationships. IDMe’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. IDMe 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/.
IDMe 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 IDMe, 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
IDMe 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 IDMe’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 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.
Source: ID.me on Greenhouse · View original posting (opens in new tab)
How this pay compares
Base floor $194,000, above 74% of the 826 Software Engineering roles in Virginia on this site. The employer's range is $59,000 wide, 30% of the floor. Observed open for 24 days so far (since Oct 27, 2026).
Pay in context
Among 826 Software Engineering roles in Virginia listed on this site, the median base floor is $160,809 and the middle half runs from $131,267 to $197,225. This role's floor ($194,000) is above 74% of them; 1 other lists the same floor.
Base floors of 826 Software Engineering roles in Virginia
Table
| Floor band | Share | Postings |
|---|---|---|
| $100K to $125K | 18.6% | 154 |
| $125K to $150K | 22.2% | 183 |
| $150K to $175K | 14.9% | 123 |
| $175K to $200K | 28.8% | 238 |
| $200K to $225K | 8.4% | 69 |
| $225K to $250K | 5.2% | 43 |
| $250K to $275K | 1.0% | 8 |
| $275K and up | 1.0% | 8 |
How this is calculated
- Statistic
- Base floor distribution of the cohort
- Formula
- count of cohort postings in each $25K band of published base floor / postings in the cohort
- Denominator
- 826 open postings with this job family in Virginia
- Sample size
- 826
- Hidden when
- the cohort has fewer than 30 postings
- Calculation version
- jobpage-analysis-v1
- Data as of
- 2026-11-20
- Employer set
- Open jobs on this site that publish a base salary of $100,000 or more
Only jobs on this site count, and each one publishes a base salary of $100,000 or more, so this compares six-figure jobs with each other, not with the whole market. Computed Nov 20, 2026.
State against nationwide
Median base floor in Virginia vs nationwide
Table
| Value | postings | |
|---|---|---|
| Software Engineering, Virginia | $160,809 | 826 |
| Software Engineering, all states | $160K | 13,248 |
| This job's base floor (marked) | $194K |
How this is calculated
- Statistic
- Median floor, state vs nationwide
- Formula
- median published base floor of each cohort
- Denominator
- open postings of this job family
- Sample size
- 826 in Virginia; 13248 nationwide
- Hidden when
- either cohort has fewer than 30 postings
- Calculation version
- jobpage-analysis-v1
- Data as of
- 2026-11-20
- Employer set
- Open jobs on this site that publish a base salary of $100,000 or more
How ID.me pays
4 of ID.me's 23 live roles on this site list a higher base floor and 11 list a lower one. Across them the median floor is $194,000; the middle half runs from $163,000 to $194,000.
Base floors of ID.me's 23 live roles
Table
| Floor band | Share | Roles |
|---|---|---|
| $100K to $125K | 4.3% | 1 |
| $125K to $150K | 17.4% | 4 |
| $150K to $175K | 26.1% | 6 |
| $175K to $200K | 34.8% | 8 |
| $200K to $225K | 0.0% | 0 |
| $225K to $250K | 17.4% | 4 |
How this is calculated
- Statistic
- Employer base floor distribution
- Formula
- count of the employer's open roles in each $25K band of published base floor / its open roles
- Denominator
- 23 open public roles at this employer
- Sample size
- 23
- Hidden when
- this employer has fewer than 5 roles
- Calculation version
- jobpage-analysis-v1
- Data as of
- current
- Employer set
- Open jobs on this site that publish a base salary of $100,000 or more
Similar pay elsewhere
Other employers' Software Engineering roles in Virginia with the nearest published base floor to $194,000, one per employer.
- Principal Software Engineer, Data Architecture Mastercard · base floor $195,000
- Software Engineer- Springfield, VA Barbaricum · base floor $195,000
- Sr Staff Production Engineer- Public Sector Databricks · base floor $195,400
- Senior/Staff DevOps Engineer Twenty · base floor $192,000
- Senior Ground Software Engineer, Space Anduril Industries · base floor $191,000
This listingStaff Software Engineer, PostgreSQL Specialist$194K – $253K
Lead Designer - Design Systems$194K – $253K
Staff Engineer, Wallet Authentication$194K – $253K
Staff Software Development Engineer – Wallet - Authentication$194K – $253K
Staff Software Engineer – Trust Service Team$194K – $253K
Staff Software Engineer – Testing & Evals Frameworks$194K – $253K
Staff Product Manager, Wallet Authentication$194K – $253K
Chart as a table
| Role | Published base |
|---|---|
| Staff Software Engineer, PostgreSQL Specialist (this listing) | $194K - $253K |
| Lead Designer - Design Systems | $194K - $253K |
| Staff Engineer, Wallet Authentication | $194K - $253K |
| Staff Software Development Engineer – Wallet - Authentication | $194K - $253K |
| Staff Software Engineer – Trust Service Team | $194K - $253K |
| Staff Software Engineer – Testing & Evals Frameworks | $194K - $253K |
| Staff Product Manager, Wallet Authentication | $194K - $253K |
Observed changes
No changes to the pay or listing since we first observed this role on Oct 27, 2026 (24 days ago).
- First observed on the employer's board
- Began meeting the published-salary criteria
- Began meeting the published-salary criteria
- Observed since
- Employer-stated posting date
- 2026-10-26
Where this pay comes from
$194K - $253K in McLean, VA +1 more
Location as the employer wrote it: Mountain View, CA Pay Range
USD 194,000 – 253,000 · interval unstated · pay_input_range · Mountain View, CA Pay Range
- Method
- Structured pay field published by the employer
- Checked
- Rule set
- us-base-v2
The employer's job board publishes this pay as a dedicated data field. We read the field directly; no interpretation was needed.
$174K - $229K in McLean, VA +1 more
Location as the employer wrote it: U.S. Pay Range
USD 174,000 – 229,000 · interval unstated · pay_input_range · U.S. Pay Range
- Method
- Structured pay field published by the employer
- Checked
- Rule set
- us-base-v2
The employer's job board publishes this pay as a dedicated data field. We read the field directly; no interpretation was needed.
What we verified
- The pay figures come from the employer's own listing, quoted exactly above.
- The pay is an annual base salary in US dollars with a minimum of at least $100,000.
- The role was publicly listed on the employer's job board when last checked.
We do not verify what the employer will actually offer, whether the employer is still recruiting for the role, or anything beyond what the employer published. Full methodology.
