Lead Data Architect – Google Spanner

Dice is the leading career destination for tech experts at every stage of their careers. Our client, RealTek Consulting, is seeking the following. Apply via Dice today!Lead Data Architect – Google SpannerLocation: San Jose, California / Scottsdale, Arizona / RemoteDuration: 12+ MonthsJob SummaryWe are seeking a highly experienced Lead Data Architect – Google Spanner to own the target-state enterprise data architecture for a large-scale transformation to Google Cloud Spanner. This is a distributed systems architecture role, not a schema conversion role.The ideal candidate will bring deep expertise in Google Spanner internals, distributed database architecture, globally distributed OLTP systems, consistency models, transactional architecture, and enterprise-scale data modernization, with the ability to define scalable data architectures supporting 1000+ applications.This role requires architectural leadership, performance engineering expertise, and strong experience designing highly available, globally distributed transactional platforms.Job ResponsibilitiesEnterprise Data ArchitectureOwn the target-state Google Spanner data architecture for enterprise modernization initiatives.Define scalable architectures ensuring:Functional correctnessTransactional integrityPerformance SLO complianceScalabilityHigh availabilityLogical Data ModelingDefine and govern the Logical Canonical Data Model (LCDM):Business-domain aligned canonical data modelsLogical entity relationshipsDomain abstraction independent of physical implementationEnterprise data modeling governanceGoogle Spanner Physical Data DesignDesign Spanner-native physical schemas including:Primary key strategyRow key distributionHotspot avoidanceInterleaving strategiesSecondary index architecturePartition-aware data designArchitect decisions around:DenormalizationRead projectionsMaterialized viewsQuery optimization strategiesTransaction & Consistency ArchitectureDefine transaction design patterns under Spanner constraints including:Single-partition transactionsMulti-partition distributed transactionsAtomicity boundariesConsistency trade-offsRetry-safe design patternsIdempotent transactional workflowsWorkload classification for:Strong consistencyBounded stalenessEventual-read optimization use casesGoogle Spanner Internals ExpertiseDeep hands-on expertise required in:TrueTimeDistributed transactionsSynchronous replicationMulti-region consistencyConsensus-driven replication behaviorFailure handling in globally distributed systemsPerformance & Scalability EngineeringParticipate in workload replay and performance analysis.Diagnose and mitigate:Hot key risksTransaction conflictsLock contentionIndex amplificationQuery inefficienciesReplication overheadResponsibilities:Spanner sizing strategyCapacity planningPerformance readiness validationCost envelope estimationMigration Architecture & Compatibility ValidationSupport enterprise modernization / migration programs including:Oracle to distributed database migrationSchema compatibility analysisData contract validationQuery semantic compatibilityTransaction invariant validationCollaborate with:QA teamsPlatform engineeringApplication architectsMigration engineering teamsDeliver:CRUD contract validationCompatibility scorecardsMigration readiness sign-offsArchitectural LeadershipAct as the final authority for enterprise Spanner data design decisions.Provide executive-level architectural guidance and decision rationale.Mentor architects, engineers, and modernization teams.Drive architectural governance and design standards.Required SkillsGoogle Cloud SpannerDistributed Database ArchitectureLarge-Scale Data ArchitectureOLTP Systems DesignData ModelingLogical Canonical Data ModelingDistributed TransactionsStrong Consistency ModelsMulti-Region Database DesignPerformance EngineeringTransaction ArchitectureScalability EngineeringDeep Technical Expertise RequiredStrong hands-on expertise in:TrueTimeDistributed transactionsSynchronous replicationConsensus-based distributed databasesTransaction isolation modelsFailure modes in distributed systemsQuery optimization at scalePreferred SkillsOracle migrationGlobal distributed data platformsCloud-native transactional architectureCost optimization for distributed databasesEnterprise modernization programsExperience10+ years of relevant experience, including:Enterprise data architecture leadershipDistributed systems engineeringLarge-scale OLTP platform designGoogle Spanner or equivalent distributed database expertiseKey DeliverablesLogical Canonical Data Model (LCDM)Google Spanner physical schema designIndex architecture strategyTransaction design guidelinesPerformance readiness assessmentsMigration readiness sign-offsEnterprise architecture governance artifacts