Loading...
Java Engineer – Application / Database Modernization (Freelancer) at mactores
mactoresMumbai, MH·1d ago
Mid LevelFreelanceJavaRustSpringAWSPostgreSQLAgileCI/CDGit
Salary Range
$102,000 - $138,000 /year
This salary is estimated based on similar roles. The actual salary may vary.
About the Role
Mactores is seeking a Software Engineer to participate in a migration project from Oracle to PostgreSQL. The ideal candidate will analyze and remediate large enterprise Java codebases to replace legacy SQL constructs with modern, standards-compliant SQL.
Key Responsibilities
- →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.
Requirements
- ✓Bachelor’s degree in Computer Science, Engineering, or related field.
- ✓3+ years of professional Java development experience (Spring, JDBC, MyBatis/Hibernate or equivalent).
- ✓Experience with application modernization, database migrations, or large-scale refactoring initiatives.
- ✓Strong SQL expertise and the ability to analyze, interpret, optimize, and rewrite complex SQL used within Java applications.
- ✓Deep understanding of JDBC, ORMs, Java transaction patterns, and database-driven application flows.
- ✓Experience working on enterprise-grade, high-performance applications with complex data interactions.
- ✓Strong communication skills and ability to work with global distributed teams in US time-zones.
