ALL CAPS, NO SPACES B/T UNDERSCORES PTN_US_GBAMSREQID_
Candidate BeelineID i.e. PTN_US_9999999_SKIPJOHNSON0413
MSP Owner: Brandon Wyatt
Targeted Bill Rate- market rate-market ratehr
REQUIREMENT_CITY - San Jose, CA | Scottsdale, AZ
REQUIREMENT_ID- 10476375
Role Name - Lead Data Architect - Google Spanner
EXPERIENCE_RANGE_IN_REQUIRED_SKILLS_ Google Spanner
ROLE_DESCRIPTION -
"Role Summary
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.
This role is not a schema converter. It is a distributed systems architect role.
Key Responsibilities
Data Architecture & Modeling
• Define the Logical Canonical Data Model (LCDM) independent of physical storage.
• Design Spanner-native physical schemas:
o Primary key strategy
o Row key distribution (hotspot avoidance)
o Interleaving decisions
o Secondary index strategy
• Decide wpersone denormalization, projections, or materialized views are required.
Transaction & Consistency Design
• Define transaction boundaries under Spanner constraints:
o Single-partition vs multi-partition transactions
o Atomicity and consistency trade-offs
• Classify workloads by strong consistency vs bounded staleness tolerance.
• Define idempotency and retry-safe patterns.
Compatibility & Contract Validation
• Work with QA and platform teams to validate:
o CRUD contracts
o Query semantics
o Transaction invariants
• Review and sign off on schema compatibility scorecards.
Performance & Scalability
• Participate in workload replay analysis.
• Diagnose and resolve:
o Hot key risks
o Transaction conflicts
o Index amplification
• Size Spanner instances and estimate cost envelopes.
Leadership
• Act as final authority for Spanner data design decisions.
• Mentor domain architects and engineers.
• Provide executive-level architectural rationale.
Required Skills & Experience
• 10+ years in large-scale data architecture
• Deep expertise in Google Spanner internals:
o TrueTime
o Distributed transactions
o Synchronous replication
• Experience designing petabyte-scale, multi-region OLTP systems
• Strong understanding of:
o Distributed consistency models
o Failure modes in globally distributed databases
• Prior Oracle → distributed DB migration experience strongly preferred
Key Deliverables
• Canonical logical data model
• Spanner physical schemas & index strategies
• Transaction design guidelines
• Performance readiness assessments
• Migration readiness sign-off per domain
"
