Role: Java Developer (Reverse Engineering and Database Workload Specialist)
Location : San Jose, CA, USA or Scottsdale, AZ, USA (On-Site)
Duration: 12+ months
Experience Required:
- 10+ years of experience in Java application architecture
- Deep expertise in database transaction behavior, SQL extraction, and legacy system reverse engineering
- Experience working with global and cross-functional architecture, data, and QA teams
Core Technical Skills:
- Java architecture and large-scale codebase analysis
- JDBC and custom data access layer internals
- ORM frameworks including Hibernate, JPA, or equivalent ORM engines
- Transaction management and behavior decomposition
- SQL analysis including complex joins, subqueries, and transaction units
- Knowledge of distributed database incompatibility patterns for modern platforms (Preferred)
- Ability to analyze long-term legacy systems developed by multiple teams
Primary Responsibilities:
Codebase Analysis
- Analyze Java applications built using JDBC, ORM frameworks, or custom data access layers
- Extract embedded SQL statements and transaction scopes
- Identify implicit transactional assumptions including ordering, locking, isolation levels, retries, and error-handling behavior
SQL Signature Extraction
- Normalize and standardize extracted SQL into reusable and scalable SQL signatures
- Map SQL signatures to tables, columns, and transactional units
- Identify query patterns incompatible with modern distributed databases or Spanner-style schemas
Transaction Behavior Reconstruction
- Reconstruct logical transactions spanning multiple SQL queries
- Rebuild business workflows embedded in the codebase
- Translate system behavior into intent-based data contracts and engineering-ready specifications
Collaboration and Workload Engineering Support
- Work with Oracle architects to validate application runtime behavior
- Work with Spanner architects to assess migration feasibility and incompatibility risks
- Support QA teams in building realistic workload replay artifacts and data dependency maps
- Assist in creating workload signatures, dependency graphs, and replay input artifacts for migration validation
Key Deliverables
- Centralized SQL signature library for extracted queries
- Transaction behavior mapping across applications
- Application-to-data dependency graphs and contract artifacts
- Compatibility risk flags for distributed database migration
- Workload replay input artifacts for QA validation and performance reconstruction
Additional Expectations
- Ability to read and interpret code written by multiple engineering teams over many years
- Strong analytical and troubleshooting skills for transaction decomposition
- High ownership and independence in execution of architecture validation artifacts
- Excellent communication skills for stakeholder alignment and technical feasibility discussions
- Experience working in Agile delivery environments is a plus
Thanks & Regards
Bindiya Dhamija
Technical Recruiter
You received this message because you are subscribed to the Google Groups "NoviaJobs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to noviajobs+unsubscribe@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/noviajobs/CABaWORmyjjMF2%2BBfNYj9FWcsnRRbwi97XZM1TuU7FgwyA2PbJQ%40mail.gmail.com.
No comments:
Post a Comment