Staff Software Engineer, PostgreSQL Specialist

Home > Golang programming jobs

Staff Software Engineer, PostgreSQL Specialist in USA new

ID.me
Full time
Email

USA
10/26/2026
Report

Mountain View, CA

Responsibilities

Optimize PostgreSQL internals and performance, including MVCC, vacuuming, locking, WAL, buffering, query planning, and bloat remediation.
Build automated schema-change deployment pipelines, DDL validation, migration checks, and lock and timeout guardrails for safe zero-downtime releases.
Architect and execute large-scale data migrations, PostgreSQL major-version upgrades, and platform transitions across PostgreSQL, CloudSQL, AlloyDB, and AWS RDS.
Review and optimize queries, indexes, partitioning and sharding strategies, connection management, and database permissions.
Build PostgreSQL telemetry, statistics collection, query monitoring, alerting, and diagnostics tooling.
Design and maintain CDC, logical replication, outbox, and streaming integrations for event-driven and analytical systems.
Automate database access controls, secret rotation, data retention, pruning, and regulatory compliance workflows.
Lead architectural and migration reviews, establish PostgreSQL best practices, and mentor engineers across the organization.

Requirements

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 of deep PostgreSQL experience in high-volume production environments.
Deep hands-on knowledge of PostgreSQL internals, including MVCC, vacuuming, locking semantics, query execution plans, indexing, WAL, and replication.
Strong proficiency in one or more backend languages such as Go, Python, Ruby, or Java, plus expert-level SQL and PL/pgSQL.
Experience building database schema-change automation, migration frameworks, DDL linters, and developer guardrails.
Experience operating and upgrading managed cloud PostgreSQL platforms such as CloudSQL, AlloyDB, AWS RDS, or Aurora PostgreSQL.
Experience with PostgreSQL extensions, diagnostics tooling, logical replication, CDC pipelines, and integrations such as Debezium, pglogical, Airbyte, Pub/Sub, or Kafka.
Experience automating database infrastructure and lifecycle management with Terraform, Kubernetes, or Helm.
Understanding of data security, encryption, role-based access control, and compliance in regulated environments.
Experience turning database expertise into self-service tools, documentation, and engineering practices; familiarity with AI-assisted engineering tools is preferred.

Benefits

Comprehensive medical, dental, vision, health savings account, flexible spending accounts, commuter benefits, life and AD&D insurance, disability insurance, accident and critical illness insurance, and 401(k) with company match.
Parental leave, unlimited paid time off subject to policy, and eight company-wide holidays.
Referral bonus policy, employee assistance program, pet insurance, travel assistance, wellbeing and childcare discounts, benefit advocates, and learning and development benefits.
Full-time, in-office work five days per week in Mountain View, CA, or McLean, VA.

Salary: $174k - $253k/yr

ID.me

ID.me builds a secure digital identity network and wallet used for identity proofing, sign-in, and community verification across government, healthcare, and commerce. The company sells authentication and verification services to agencies and enterprises, including NIST 800-63-3 IAL2/AAL2–approved...

Similar positions

Staff Software Engineer, Inference

Together AI
Full time

Others
10/26/2026

Amsterdam, Netherlands

Sr. Software Engineer, Cloud Platform

Samsara
Full time

UK
10/26/2026

Remote

Software Engineer L3

Twilio
Full time

USA
10/26/2026
Salary: $139k-$204k

Remote

Fullstack Software Engineer, Notifications Lifecyc

Reddit
Full time

USA
10/26/2026
Salary: $164k-$229k

Remote

Software Engineer, Ads

Reddit
Full time

Canada
10/26/2026

Remote