Remote - Lead Data Architect (Google spanner)
ARCHIVED
We can't find an active application page for this role right now. It may reopen or be listed elsewhere. Use Next Steps to search for an active apply link and similar live jobs.
Position : Lead Data Architect (Google spanner)Location :RemoteDuration: Full TimeOwn 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 ResponsibilitiesData Architecture & Modeling• Define the Logical Canonical Data Model (LCDM) independent of physical storage.• Design Spanner-native physical schemas:o Primary key strategyo Row key distribution (hotspot avoidance)o Interleaving decisionso Secondary index strategy• Decide where denormalization, projections, or materialized views are required.Transaction & Consistency Design• Define transaction boundaries under Spanner constraints:o Single-partition vs multi-partition transactionso 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 contractso Query semanticso Transaction invariants• Review and sign off on schema compatibility scorecards.Performance & Scalability• Participate in workload replay analysis.• Diagnose and resolve:o Hot key riskso Transaction conflictso 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 TrueTimeo Distributed transactionso Synchronous replication• Experience designing petabyte-scale, multi-region OLTP systems• Strong understanding of:o Distributed consistency modelso Failure modes in globally distributed databases• Prior Oracle → distributed DB migration experience strongly preferred