Description

Lead the data architecture strategy for petabyte-scale, multi-region OLTP systems, with a primary focus on Google Spanner.

Responsibilities

• Define the Logical Canonical Data Model (LCDM) independent of physical storage constraints.
• Design Spanner-native physical schemas, including primary key strategies, row key distribution for hotspot avoidance, interleaving decisions, and secondary index strategies.
• Determine requirements for denormalization, projections, and materialized views to optimize read performance.
• Define transaction boundaries under Spanner constraints, specifying single-partition versus multi-partition transactions and atomicity consistency trade-offs.
• Act as the final authority for Spanner data design decisions, mentoring domain architects and providing executive-level architectural rationale.

Required Skills

• 10+ years of experience in large-scale data architecture.
• Deep expertise in Google Spanner internals, including TrueTime, distributed transactions, and synchronous replication.
• Proven experience designing petabyte-scale, multi-region OLTP systems.
• Strong understanding of distributed consistency models and failure modes in globally distributed databases.
• Ability to classify workloads by strong consistency versus bounded staleness tolerance.
• Experience defining idempotency and retry-safe patterns for distributed systems.
• Proficiency in workload replay analysis to diagnose hot key risks, transaction conflicts, and index amplification.

Preferred Skills

• Prior experience migrating systems from Oracle to distributed databases.

Key Skills

Education

Any Gradute