Java Architect / Reverse Engineering Expert

San Jose, CA or Scottsdale, AZ

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.

Codebase Analysis

• Analyze Java applications using:

o JDBC

o ORM frameworks

o Custom data access layers

• Extract embedded SQL and transaction scopes.

• Identify implicit assumptions:

o Ordering

o Locking

o Isolation

o Retry behavior

SQL Signature Extraction

• Normalize SQL into reusable signatures.

• Map signatures to:

o Tables

o Columns

o Transaction units

• Identify query patterns incompatible with Spanner.

Behavior Reconstruction

• Reconstruct:

o Logical transactions spanning multiple queries

o 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:

o JDBC

o Transaction management

o 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