Lead Data Architect (Google Spanner)

vision square inc • United State
Remote
Apply
AI Summary

Lead the target-state data architecture on Google Spanner for 1000+ applications, ensuring functional correctness and performance SLOs. Design Spanner-native schemas including primary keys, row key distribution, interleaving, and secondary indexes. Define transaction boundaries, consistency models, and idempotency patterns while mentoring domain architects.

Key Highlights
Own target-state data architecture on Google Spanner for 1000+ applications
Design Spanner-native physical schemas with primary key strategy and hotspot avoidance
Define transaction boundaries and consistency models under Spanner constraints
Key Responsibilities
Define the Logical Canonical Data Model (LCDM) independent of physical storage
Design Spanner-native physical schemas including primary key strategy, row key distribution, interleaving decisions, and secondary index strategy
Decide where denormalization, projections, or materialized views are required
Define transaction boundaries under Spanner constraints including single-partition vs multi-partition transactions
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, and transaction invariants
Review and sign off on schema compatibility scorecards
Participate in workload replay analysis
Diagnose and resolve hot key risks, transaction conflicts, and index amplification
Size Spanner instances and estimate cost envelopes
Act as final authority for Spanner data design decisions
Mentor domain architects and engineers
Provide executive-level architectural rationale
Technical Skills Required
Google Spanner internals TrueTime Distributed transactions Synchronous replication Petabyte-scale multi-region OLTP systems Distributed consistency models Failure modes in globally distributed databases Oracle to distributed DB migration

Job Description


Lead Data Architect (Google spanner) - San Jose, CA / Scottsdale, AZ/ Remote


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.

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 where 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


Similar Jobs

Explore other opportunities that match your interests

Remote IT Support Engineer

Networking
•
20m ago
Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Not Applicable

Jobs via Dice

United State

System Administrator

Networking
•
48m ago
Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Not Applicable

jahnel group

United State
Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Not Applicable

point

United State

Subscribe our newsletter

New Things Will Always Update Regularly