Lead Data Architect; Google spanner

Job Description Own the target‑state data architecture on Google Spanner, ensuring the new data model satisfies functional correctness, performance SLOs, and transactional semantics required by 1000+ applications—before large‑scale app rewrites occur.

• Define the Logical Canonical Data Model (LCDM) independent of physical storage.
• Design Spanner‑native physical schemas:
  • Row key distribution (hotspot avoidance)
  • Interleaving decisions
  • Secondary index strategy
  • Decide where denormalization, projections, or materialized views are required.

• Define transaction boundaries under Spanner constraints:
  • Single‑partition vs multi‑partition transactions
  • Atomicity and consistency trade‑offs
  • Classify workloads by strong consistency vs bounded staleness tolerance.
  • Define idempotency and retry‑safe patterns.

• Work with QA and platform teams to validate:
  • CRUD contracts
  • Query semantics
  • Transaction in variants
  • Review and sign off on schema compatibility scorecards.

• Participate in workload replay analysis.
• Diagnose and resolve:
  • Hot key risks
  • Transaction conflicts
  • Index amplification
  • Size Spanner instances and estimate cost envelopes.

• 10+ years in large‑scale data architecture
• Deep expertise in Google Spanner internals:
  • True Time
  • Distributed transactions
  • Synchronous replication
  • Experience designing petabyte‑scale, multi‑region OLTP systems
  • Distributed consistency models
  • Failure modes in globally distributed databases
• Prior Oracle → distributed DB migration experience strongly preferred
• Canonical logical data model
• Spanner physical schemas & index strategies
• Transaction design guidelines
• Performance readiness assessments
• Migration readiness sign‑off per domain

Salary Range – $120,000–$130,000 a year

Qualifications:

BACHELOR OF COMPUTER SCIENCE