Job ID: JOB_ID_5453
Job Title: Lead Data Architect – Google Spanner
Location Options:
- San Jose, CA (Onsite)
- Scottsdale, AZ (Onsite)
- Remote
Job Type:
Contract
Job Description:
We are seeking a highly skilled and experienced Lead Data Architect to own the target-state data architecture on Google Spanner. This role is crucial for ensuring the new data model meets functional correctness, performance Service Level Objectives (SLOs), and transactional semantics required by over 1000 applications before large-scale application rewrites occur. This is a distributed systems architect role, not merely a schema converter.
Key Responsibilities:
- Data Architecture & Modeling: Define the Logical Canonical Data Model (LCDM) independent of physical storage. Design Spanner-native physical schemas, including primary key strategy, row key distribution (hotspot avoidance), interleaving decisions, and secondary index strategy. Determine where denormalization, projections, or materialized views are necessary.
- Transaction & Consistency Design: Define transaction boundaries under Spanner constraints, including single-partition vs. multi-partition transactions, and atomicity and consistency trade-offs. Classify workloads by strong consistency vs. bounded staleness tolerance. Define idempotency and retry-safe patterns.
- Compatibility & Contract Validation: Collaborate with QA and platform teams to validate CRUD contracts, query semantics, and transaction invariants. Review and sign off on schema compatibility scorecards.
- Performance & Scalability: Participate in workload replay analysis. Diagnose and resolve hot key risks, transaction conflicts, and index amplification issues. Size Spanner instances and estimate cost envelopes.
- Leadership: Act as the 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, including True Time, distributed transactions, and synchronous replication.
- Experience designing petabyte-scale, multi-region OLTP systems.
- Strong understanding of distributed consistency models and failure modes in globally distributed databases.
- Prior Oracle or other distributed database migration experience is strongly preferred.
Key Deliverables:
- Canonical logical data model
- Spanner physical schemas & index strategies
- Transaction design guidelines
- Performance readiness assessments
- Migration readiness sign-off per domain
About Valzo Soft Solutions:
Valzo Soft Solutions is a dynamic IT solutions provider focused on delivering high-quality services to its clients. We specialize in connecting top talent with challenging opportunities in the technology sector.
Special Requirements
Remote, San Jose, CA, Scottsdale, AZ
Compensation & Location
Salary: $100 – $130 per year (Estimated)
Location: San Jose, CA
Recruiter / Company – Contact Information
Email: havi@valzosoft.com
Recruiter Notice:
To remove this job posting, please send an email from
havi@valzosoft.com with the subject:
DELETE_JOB_ID_5453