Source description
About the role
Analyze and remediate large enterprise Java codebases to replace legacy or database-specific SQL constructs with modern, standards-compliant SQL.
Convert embedded SQL within Java services and MyBatis XML mappers, including rewriting constructs such as vendor-specific functions, sequences, pagination logic, dynamic SQL, and error-handling patterns.
Collaborate closely with schema and database migration engineers to ensure application-layer SQL aligns with the modernized target schema.
Refactor Java transaction logic, error-handling, drivers, and ORM/DAO layers to support the behavior of modern databases.
Participate in unit, integration, and performance testing to confirm functional parity and ensure applications meet performance SLAs post-modernization.
Support application cutover activities for production environments, including validation, monitoring setup, rollback planning, and stabilization.
Produce engineering documentation: SQL remediation guides, code-migration runbooks, troubleshooting guides, and knowledge-transfer material for customer teams.
Work across distributed teams (US & India) and collaborate with customer SMEs to ensure business logic alignment and successful modernization outcomes.
More at Mactores
Related open roles
Lead Database Migration Engineer
Remote · IN
Senior Product Engineer, Agent Systems
Remote · Mumbai
SAP Basis Administrator (Freelancer)
Remote · Mumbai
Full Stack Product Engineer, Agent Native
Remote · Mumbai
Senior Database Administrator (Freelancer)
Remote · IN
AWS Data Engineer (Senior) (Freelancer)
Remote · IN
