DB2 Database Performance & Optimization Specialist

Exasoft Pte. Ltd.; Singapore; On-site; SGD 90,000 - 150,000; Full time

Job summary

Exasoft Pte. Ltd. in Singapore is seeking a DB2 specialist to review and optimise SQL queries, assist in database design, and troubleshoot data integrity and performance issues across applications.

You will support changes through DEV, TEST, UAT, PROD, monitor performance, and advise developers on best practices. Strong communication and English skills are essential, with willingness to work beyond hours when needed.

Qualifications

• Strong background in IT, Computer Science / Computer Engineering, or related discipline.
• Minimum 5 years of relevant working experience in the above technology is preferred.
• Working with JCL (Job Control Language).
• Understanding of VSAM and other mainframe storage concepts.
• Familiar with database utilities and tools.
• Experience with database backup and recovery procedures.
• Possesses good communication and interpersonal skills.
• Have good command of written and oral English.
• Must be able to work beyond business hours including weekend when necessary.

Responsibilities

• Reviewing and optimising SQL queries written by application developers to ensure optimal performance and adherence to database standards.
• Assisting in database design activities, including table structures, indexes, and relationships to support new application features or enhancements.
• Troubleshooting database-related issues reported by application teams, including SQL error codes, performance problems, and data integrity concerns.
• Supporting database changes through the development lifecycle (DEV, TEST, UAT, PROD), including coordinating database object migrations between environments.
• Monitoring application database performance and implementing necessary tuning measures like reorganising tablespaces, updating statistics, and adjusting buffer pools.
• Providing guidance to application developers on DB2 best practices, coding standards, and efficient query writing techniques.
• Supporting application testing activities by helping with data refresh requests, test data preparation, and database-related test case validation.

Skills

SQL optimization

Database design

Troubleshooting

DB2 best practices

Communication skills

English fluency

Education

Bachelor's degree in IT/CS/CE

Tools

JCL

VSAM

Job description

Exasoft Pte. Ltd. in Singapore is seeking a DB2 specialist to review and optimise SQL queries, assist in database design, and troubleshoot data integrity and performance issues across applications.

You will support changes through DEV, TEST, UAT, PROD, monitor performance, and advise developers on best practices. Strong communication and English skills are essential, with willingness to work beyond hours when needed.