JOBSEARCHER

Senior Java Architect - Transaction & SQL Reverse Engineer

ARCHIVED

We can't find an active application page for this role right now. It may reopen or be listed elsewhere. Use Next Steps to search for an active apply link and similar live jobs.

Purple DriveWe are seeking a highly experienced Senior Java Application Architect to reverse engineer data access and transactional behavior across a large portfolio of enterprise Java applications. The role focuses on extracting embedded SQL, reconstructing transactional workflows, and translating runtime behavior into testable data contracts and workload signatures to support large-scale database modernization initiatives. This position plays a critical role in pre-model validation and database compatibility assessment, particularly for migrations from traditional RDBMS platforms (e.g., Oracle) to distributed databases such as Google Spanner.
Key Responsibilities: Analyze large and complex Java application codebases utilizing JDBC, ORM frameworks (Hibernate / JPA), and custom data access layers. Extract embedded SQL statements and transaction boundaries from application code. Identify implicit runtime assumptions, including query ordering dependencies, locking behavior, transaction isolation levels, and retry and failure handling mechanisms.
SQL Signature & Workload Extraction: Normalize extracted SQL into reusable and standardized SQL signatures. Map SQL signatures to database tables and columns, transaction scopes, and logical units of work. Identify SQL and transaction patterns that are incompatible with distributed databases such as Spanner.
Transaction & Behavior Reconstruction: Reconstruct logical transactions spanning multiple queries and service layers. Identify business workflows embedded within application code. Translate low-level implementation details into intent-based transactional contracts. Create behavioral models that reflect real-world production workloads.
Collaboration & Validation:
  • Partner with Oracle database architects to validate actual runtime behavior and constraints.
  • Collaborate with Google Spanner architects to assess feasibility, risks, and required design changes.
  • Support QA and performance teams in developing realistic workload replay and test scenarios.
  • Key DeliverablesSQL Signature Library
  • Transaction behavior and dependency maps
  • Application-to-data dependency graphs
  • Compatibility risk assessments and flags
  • Input artifacts for workload modeling and replay
Required Skills & Experience: 10+ years of experience in Java application architecture. Deep expertise in JDBC, transaction management (local and distributed), and ORM internals (Hibernate, JPA).Strong SQL skills, including complex joins, subqueries, and transactional SQL patterns. Proven experience reverse engineering large, legacy enterprise systems. Ability to analyze and understand code written by multiple teams over many years. Soft SkillsStrong analytical and problem-solving abilities. Excellent written and verbal communication skills. Ability to work across architecture, database, and QA teams. Comfortable operating in ambiguous, highly technical environments.
Preferred Qualifications: Experience with database modernization or cloud migrations. Familiarity with distributed databases (e.g., Google Spanner).Experience in financial services or other transaction-intensive domains.