Website: Visit Website
LinkedIn: Visit LinkedIn
Business Type: Small/Medium Business
Company Type: Service
Business Model: B2B
Industry: Information Technology
Mactores is a trusted leader among businesses in providing contemporary data platform solutions. Since 2008, Mactores have been enabling businesses to accelerate their value through automation by providing End-to-End Data Solutions that are automated, agile, and secure. We collaborate with customers to strategize, navigate, and accelerate an ideal path forward with a digital transformation via assessments, migration, or modernization.
Mactores is looking for a Software Engineer with proficiency in Java, Spring, and Hibernate to participate in the migration project from Oracle to PostgreSQL. The ideal candidate should possess a robust understanding of Java, Spring, and Hibernate, with hands-on experience in developing large-scale Java web applications.
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.
SQL remediation guides, code-migration runbooks, troubleshooting guides, and knowledge-transfer material for customer teams.
Bachelor's degree in Computer Science, Engineering, or related field.

- 5+ 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.
- Experience with PostgreSQL, Aurora PostgreSQL, or modernization from legacy databases such as Oracle, SQL Server, or DB2.

Familiarity with CI/CD environments, performance testing tools, and observability stacks.
Consulting or professional services experience delivering fixed-timeline modernization projects.
We would like you to read more details about the work culture on
Managerial Interview: The hiring manager will engage with you in multiple discussions, lasting anywhere from 30 minutes to an hour, to assess your technical skills, hands-on experience, leadership potential, and communication abilities.

📌 Senior Database Software Engineer (Database Services) (Mumbai)
🏢 Mactores
📍 Mumbai