Job Description
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 re...
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 re...