Lead Data Architect (Google spanner) jobs in United States
cer-icon
Apply on Employer Site
company-logo

Tata Consultancy Services · 3 hours ago

Lead Data Architect (Google spanner)

Tata Consultancy Services is seeking a Lead Data Architect to own the target-state data architecture on Google Spanner. The role involves defining the logical canonical data model and designing Spanner-native physical schemas while ensuring performance and transactional semantics for over 1000 applications.

Business Information SystemsConsultingInformation TechnologyIT Management
check
H1B Sponsor Likelynote

Responsibilities

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

Qualification

Google Spanner internalsLarge-scale data architectureDistributed transactionsPetabyte-scale OLTP systemsCanonical logical data modelTransaction design guidelinesPerformance readiness assessmentsMigration readiness sign-offDistributed consistency modelsFailure modes in databasesSchema compatibility validation

Required

10+ years in large-scale data architecture
Deep expertise in Google Spanner internals
TrueTime
Distributed transactions
Synchronous replication
Experience designing petabyte-scale, multi-region OLTP systems
Distributed consistency models
Failure modes in globally distributed databases
Canonical logical data model
Spanner physical schemas & index strategies
Transaction design guidelines
Performance readiness assessments
Migration readiness sign-off per domain
BACHELOR OF COMPUTER SCIENCE

Preferred

Prior Oracle → distributed DB migration experience strongly preferred

Company

Tata Consultancy Services

company-logo
Tata Consultancy Services is a business solutions company that specializes on information technology services and consulting.

H1B Sponsorship

Tata Consultancy Services has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (7880)
2024 (9690)
2023 (8537)
2022 (11159)
2021 (9813)
2020 (11984)

Funding

Current Stage
Public Company
Total Funding
unknown
2004-08-25IPO

Leadership Team

leader-logo
K. Krithivasan
Chief Executive Officer & Managing Director
linkedin
leader-logo
Aarthi Subramanian
President and Chief Operating Officer
Company data provided by crunchbase