7 hours ago
Base Salary
$174k - $253k/yr
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.
Tech Stack
AirbyteApache KafkaAWSFlywayGoGoogle Cloud PlatformHelmJavaKubernetesPostgreSQLPythonRubySQLTerraform
Categories
BackendData Engineering
About 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 credentials, plus group eligibility checks for discounts. Founded in 2010 and headquartered in McLean, VA, ID.me supports access at 20 U.S. federal and 45 state agencies and 70+ healthcare organizations.