Java/SQL Developer

AVENSYS CONSULTING PTE. LTD.; Singapore; On-site; SGD 90,000 - 130,000; Full time

Benefits offered by this job

Competitive base salary

Attractive company benefits

Fun and collaborative work environment

Job summary

Avensys Consulting PTE. LTD. is seeking an experienced Java/SQL Developer to design, develop, and maintain full stack applications for corporate banking clients.

You will support a data migration project, migrate data to MariaDB, optimize procedures, and develop Spring Boot services and REST APIs, with a focus on data validation and documentation.

Qualifications

• 6+ years of hands-on Java development experience.
• Strong experience with Spring Boot, Spring Batch, and REST API.
• Strong MariaDB/SQL skills, including stored procedures and SQL tuning.
• Experience in data migration or database migration projects.
• Good analytical and problem-solving skills.

Responsibilities

• Migrate data and database objects to MariaDB.
• Develop, convert, and optimize stored procedures.
• Perform SQL tuning to improve query and batch performance.
• Develop and enhance Spring Boot services and REST APIs.
• Build and maintain Spring Batch jobs for data processing.
• Support data validation and reconciliation (corporate data volume ~250k–300k records).
• Participate in testing, defect fixing, and cutover activities.
• Prepare technical documentation.

Skills

Java development

Spring Boot

Spring Batch

REST API

MariaDB/SQL

Stored procedures

SQL tuning

Data migration

Analytical skills

Job description

Avensys is a reputed global IT professional services company headquartered in Singapore. Our service spectrum includes enterprise solution consulting, business intelligence, business process automation and managed services. Given our decade of success we have evolved to become one of the top trusted providers in Singapore and service a client base across banking and financial services, insurance, information technology, healthcare, retail, and supply chain.

We're seeking an experienced Java/SQL Developer to join our team. This role requires a versatile technologist who can design, develop, and maintain full stack applications that deliver real business impact for our clients.

Role Overview

Support a data migration project for a corporate banking client, covering database migration to MariaDB, stored procedure conversion, SQL performance tuning, and supporting Java application development.

Key Responsibilities

• 1. Migrate data and database objects to MariaDB
• 2. Develop, convert, and optimize stored procedures
• 3. Perform SQL tuning to improve query and batch performance
• 4. Develop and enhance Spring Boot services and REST APIs
• 5. Build and maintain Spring Batch jobs for data processing
• 6. Support data validation and reconciliation (corporate data volume approx. 250k–300k records)
• 7. Participate in testing, defect fixing, and cutover activities
• 8. Prepare technical documentation

Required Skills

• 1. 6+ years of hands‑on Java development experience
• 2. Strong experience with Spring Boot, Spring Batch, and REST API
• 3. Strong MariaDB/SQL skills, including stored procedures and SQL tuning
• 4. Experience in data migration or database migration projects
• 5. Good analytical and problem‑solving skills

Preferred

• 1. Banking or financial services domain exposure (corporate banking is a plus)
• 2. Experience with legacy-to-new platform migrations

WHAT’S ON OFFER

You will be remunerated with an excellent base salary and entitled to attractive company benefits. Additionally, you will get the opportunity to enjoy a fun and collaborative work environment, alongside a strong career progression.

Privacy Statement: Data collected will be used for recruitment purposes only. Personal data provided will be used strictly in accordance with the relevant data protection law and Avensys' privacy policy.