Mactores - Java Engineer - Application/Database Modernization

Key Responsibilities :

- Participate in application modernization and database migration initiatives involving Oracle to PostgreSQL transformations.

- Analyze existing applications, database schemas, stored procedures, and business workflows to design modernization strategies.

- Develop, enhance, and maintain enterprise applications using Java, Spring Framework, Spring Boot, and Hibernate.

- Refactor legacy codebases to improve maintainability, performance, and scalability.

- Design and implement database migration processes, ensuring data integrity, consistency, and minimal downtime during transition activities.

- Convert Oracle-specific database objects, queries, procedures, triggers, and packages into PostgreSQL-compatible implementations.

- Optimize SQL queries and database structures to achieve high performance and efficient resource utilization.

- Collaborate with architects, data engineers, and cross-functional teams to define migration roadmaps and technical solutions.

- Participate in system design discussions, code reviews, and architecture evaluations.

- Troubleshoot application issues, performance bottlenecks, and database-related challenges during modernization projects.

- Develop integration components, APIs, and services required for seamless communication between modernized applications and enterprise systems.

- Create technical documentation, migration plans, implementation guides, and operational procedures.

- Support testing activities including unit testing, integration testing, performance testing, and user acceptance testing.

Required Skills and Qualifications :

- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline.

- Strong proficiency in Java programming with experience in developing large-scale web applications.

- Hands-on experience with Spring Framework, Spring Boot, Spring MVC, and Hibernate/JPA.

- Solid understanding of object-oriented programming principles, design patterns, and software engineering best practices.

- Experience working with Oracle databases and PostgreSQL, including schema design, query optimization, indexing, and performance tuning.

- Knowledge of database migration methodologies, tools, and best practices.

- Familiarity with SQL, PL/SQL, and PostgreSQL procedural language concepts.

- Experience with RESTful APIs, microservices architecture, and distributed systems.

- Knowledge of version control systems such as Git and experience with CI/CD pipelines.

- Understanding of cloud platforms, containerization technologies, and DevOps practices will be an advantage.

- Strong analytical, problem-solving, and communication skills with the ability to work effectively in distributed and remote teams.

Preferred Qualifications :

- Experience in application modernization, legacy system transformation, or database migration projects.

- Exposure to cloud-native architectures and modern data platforms.

- Familiarity with migration assessment tools and automated code conversion techniques.

- Prior experience in Agile development methodologies and collaborative engineering environments is highly desirable.