NEWPosted 3 hours ago
Job ID: JOB_ID_5080
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, including primary key strategy, row key distribution (hotspot avoidance), interleaving decisions, and secondary index strategy.
- Decide where denormalization, projections, or materialized views are required.
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:
- Work 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.
- 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 (TrueTime, distributed transactions, 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 distributed DB migration experience strongly preferred.
- Experience in architecting High availability, High performance, Low latency workloads (Spanner, AlloyDB).
Key Deliverables:
- Canonical logical data model.
- Spanner physical schemas & index strategies.
- Transaction design guidelines.
- Performance readiness assessments.
- Migration readiness sign-off per domain.
Special Requirements
Remote, C2C
Compensation & Location
Salary: $150,000 – $200,000 per year (Estimated)
Location: San Jose, CA
Recruiter / Company – Contact Information
Recruiter / Employer: Google
Email: rajkamal@sysmind.com
Recruiter Notice:
To remove this job posting, please send an email from
rajkamal@sysmind.com with the subject:
DELETE_JOB_ID_5080