Job ID: JOB_ID_6078
Job Overview:
We are seeking a highly experienced Lead Data Architect with deep expertise in Google Spanner and distributed systems architecture. This role will own the target-state data architecture, ensuring scalability, consistency, and high performance for enterprise-grade applications. The ideal candidate will design data models and transaction strategies that support high availability, low latency, and large-scale OLTP workloads across multi-region environments.
Key Responsibilities:
Data Architecture & Modeling:
- Define and maintain the Logical Canonical Data Model (LCDM) independent of physical storage
- Design Spanner-native physical data models, including:
- Primary key strategies
- Row key distribution (hotspot avoidance)
- Table interleaving strategies
- Secondary indexing approaches
- Determine use of denormalization, projections, and materialized views
Transaction & Consistency Design:
- Define transaction boundaries (single-partition vs multi-partition)
- Evaluate and implement atomicity and consistency trade-offs
- Classify workloads based on:
- Strong consistency
- Bounded staleness tolerance
- Design idempotent and retry-safe transaction patterns
Performance & Scalability:
- Analyze workload patterns and participate in workload replay testing
- Identify and mitigate:
- Hot key issues
- Transaction conflicts
- Index amplification
- Optimize for high availability, high performance, and low latency workloads
- Size Spanner clusters and estimate cost models
Compatibility & Validation:
- Partner with QA and platform teams to validate:
- CRUD contracts
- Query semantics
- Transaction invariants
- Review and approve schema compatibility scorecards
Leadership & Governance:
- Act as the final authority on all Spanner data architecture decisions
- Mentor architects and engineering teams on best practices
- Provide executive-level architectural guidance and documentation
- Drive migration readiness and sign-offs for domain-level implementations
Required Skills & Experience:
- 8+ years of experience in Data Architecture & Modeling
- Strong hands-on expertise with Google Spanner:
- TrueTime
- Distributed transactions
- Synchronous replication
- Experience designing high availability, high performance, low latency systems
- Proven experience with petabyte-scale, multi-region OLTP systems
- Deep understanding of:
- Distributed consistency models
- Failure scenarios in distributed databases
- Experience with AlloyDB or similar distributed database platforms
- Strong experience in data modeling, schema design, and indexing strategies
Preferred Qualifications:
- Experience with Oracle to distributed database migrations
- Strong background in cloud-native architectures (GCP preferred)
- Familiarity with data governance, data lifecycle management, and large-scale migrations
- Excellent communication and leadership skills
Compensation & Location
Salary: $80 – $100 per year (Estimated)
Location: San Jose, CA
Recruiter / Company – Contact Information
Email: it.c@noviainfotech.com
Recruiter Notice:
To remove this job posting, please send an email from
it.c@noviainfotech.com with the subject:
DELETE_JOB_ID_6078