The role involves migrating Oracle databases to PostgreSQL by analyzing, refactoring code, and ensuring functional parity through testing. Collaboration across teams to align business logic and create documentation is also required.
Mactores is the agent-native AWS modernization firm. Most modernization work doesn't ship, it stalls in pilots, slips a year, or lands at three times the budget. We exist to ship it: production systems running, legacy retired, outcomes measured. Our delivery is built on Aedeon, the agent platform built by Mactores' founders' sister company, which absorbs the repetitive 60–70% of engagement work, discovery, dependency mapping, validation, test generation, that traditional consulting bills human hours against. Forward-deployed engineers own the rest: architecture, judgment, and cutover, on dates we commit to in the contract.
Enterprises stuck on Oracle carry license renewals, vendor-specific SQL nobody wants to touch, and application layers welded to the database underneath them. This role sits in our Application & Database Modernization pillar: you'll work an Oracle-to-PostgreSQL migration where Aedeon handles the mechanical conversion at scale and you own what the tools can't the refactoring judgment inside large enterprise Java codebases. You'll rewrite the SQL the application actually depends on, align it with the modernized schema, prove functional parity, and see the application through production cutover. Not a proof of concept. A system that ships.
What you will do?
- Analyze and remediate large enterprise Java codebases — replace legacy and database-specific SQL constructs with modern, standards-compliant SQL.
- Convert embedded SQL in Java services and MyBatis XML mappers: rewrite vendor-specific functions, sequences, pagination logic, dynamic SQL, and error-handling patterns.
- Work closely with schema and database migration engineers so application-layer SQL lands aligned with the modernized target schema.
- Refactor Java transaction logic, error handling, drivers, and ORM/DAO layers to match the behavior of modern databases.
- Run unit, integration, and performance testing to confirm functional parity and hit performance SLAs post-modernization.
- Support production cutover — validation, monitoring setup, rollback planning, and stabilization until the system holds.
- Produce engineering documentation that outlives the engagement: SQL remediation guides, code-migration runbooks, troubleshooting guides, and knowledge-transfer material for customer teams.
- Work across distributed teams (US and India) and with customer SMEs to keep business logic aligned and the modernization on track.
What are we looking for?
- Bachelor's degree in Computer Science, Engineering, or a 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 you can analyze, interpret, optimize, and rewrite complex SQL embedded in Java applications.
- Deep understanding of JDBC, ORMs, Java transaction patterns, and database-driven application flows.
- Experience on enterprise-grade, high-performance applications with complex data interactions.
- Strong communication skills and the ability to work with global distributed teams in US time zones.
You will be preferred if
- Experience with PostgreSQL, Aurora PostgreSQL, or modernization from legacy databases such as Oracle, SQL Server, or DB2.
- Exposure to automated code-refactoring tools or GenAI-assisted remediation workflows.
- Familiarity with CI/CD environments, performance testing tools, and observability stacks.
- Consulting or professional services experience delivering fixed-timeline modernization projects.
How we work?
Agents do the repetitive 60–70% of the work a traditional consulting engagement of equivalent scope staffs humans for. Engineers do the rest, and the rest is the interesting part. You won't spend months grinding through mechanical SQL conversion; Aedeon and its regression harness cover that. Your hours go to refactoring judgment, risk tradeoffs, production cutover, and post-cutover optimization. We commit to delivery dates and absorb the overage cost for delays inside our control, which means the engineering has to be right the first time. That's the job.
Life at Mactores
We care about creating a culture that makes a real difference in the lives of every Mactorian. Our 10 Core Leadership Principles that honor Decision-making, Leadership, Collaboration, and Curiosity drive how we work.
1. Be one step ahead
2. Deliver the best
3. Be bold
4. Pay attention to the detail
5. Enjoy the challenge
6. Be curious and take action
7. Take leadership
8. Own it
9. Deliver value
10. Be collaborative
We would like you to read more details about the work culture on https://mactores.com/careers
The Path to Joining the Mactores Team
At Mactores, our recruitment process is structured around three distinct stages:
Pre-Employment Assessment:
A series of evaluations of your technical proficiency and suitability for the role.
Managerial Interview: The hiring manager engages with you in multiple discussions, 30 minutes to an hour each, covering technical skills, hands-on experience, leadership potential, and communication.
HR Discussion: During this 30-minute session, you'll have the opportunity to discuss the offer and next steps with a member of the HR team.
Mactores provides equal opportunities in all employment practices. We don't discriminate based on race, religion, gender, national origin, age, disability, marital status, military status, genetic information, or any other category protected by federal, state, and local laws. This applies to every part of the employment relationship, recruitment, compensation, promotions, transfers, disciplinary action, layoff, training, and social and recreational programs.
Note: Please answer as many questions as possible with this application to accelerate the hiring process.
Mactores Mumbai, Maharashtra, IND Office
316, Neelkanth Corporate Park, Vidyavihar West, Mumbai, India, 400086
Similar Jobs
Fintech • Legal Tech • Software • Financial Services • Cybersecurity • Data Privacy
Lead and develop an offshore sales development team to drive high-volume inbound and outbound lead generation for US and EMEA. Own team performance, prospecting, CRM reporting, rapid lead follow-up (15-minute target), and cross-functional alignment with sales and marketing to meet/exceed lead targets.
Top Skills:
CRMLinkedInSalesforce
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
The role involves managing financial reporting requirements including data assessment and transformation, stakeholder engagement, and ensuring regulatory compliance for reporting processes.
Top Skills:
ExcelFinrepIfrsMs Powerpoint
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
The role involves managing program conflicts, facilitating communication across programs, process mapping, conducting quality assurance deep dives, and optimizing resource management, ensuring alignment and efficiency in financial transformation projects.
Top Skills:
Azure DevopsClarityMS OfficeTableau
What you need to know about the Mumbai Tech Scene
From haggling for the best price at Chor Bazaar to the bustle of Crawford Market, the energy of Mumbai's traditional markets is a key part of the city's charm. And while these markets will always have their place, the city also boasts a thriving e-commerce scene, ranking among the largest in the region. Driven by online sales in everything from snacks to licensed sports merchandise to children's apparel, the local industry is worth billions, with companies actively recruiting to meet the demands of continued growth.
