Java Architect

Role Summary:
Reverse engineer embedded SQL and transactional behavior from 1000+ Java applications and convert them into testable data contracts and workload signatures.
This role is critical for pre-model validation.
Key Responsibilities
Codebase Analysis
• Analyze Java applications using:
JDBC
ORM frameworks
Custom data access layers
• Extract embedded SQL and transaction scopes.
• Identify implicit assumptions:
Ordering
Locking
Isolation
Retry behavior
SQL Signature Extraction
• Normalize SQL into reusable signatures.
• Map signatures to:
Tables
Columns
Transaction units
• Identify query patterns incompatible with Spanner.
Behavior Reconstruction
• Reconstruct:
Logical transactions spanning multiple queries
Business workflows embedded in code
• Translate behavior into intent-based contracts.
Collaboration
• Work with Oracle architects to validate runtime behavior.
• Work with Spanner architects to assess feasibility.
• Support QA in creating realistic replay workloads.
Required Skills & Experience
• 10+ years of Java application architecture
• Expert in:
JDBC
Transaction management
ORM internals (Hibernate/JPA)
• Strong SQL knowledge (complex joins, subqueries)
• Experience reverse engineering large legacy systems
• Ability to read code written by many teams over years
Key Deliverables
• SQL signature library
• Transaction behavior maps
• App-to-data dependency graphs
• Compatibility risk flags
• Input artifacts for workload replay"