DB2 Database Administrator

Job Position - DB2 DBA Supporting Application

Experience - 8+ years

Location - Singapore

Job Description -

a) Strong background in IT, Computer Science / Computer Engineering, or related discipline

b) Minimum 5 years of relevant working experience in the above technology is preferred.

c) Relevant experience in the following would be advantageous

• Working with JCL (Jon Control Language)
• Understanding of VSAM and other mainframe storage concepts
• Familiar with database utilities and tools
• Experience with database backup and recovery procedures

d) Possesses good communication and interpersonal skills

e) Have good command of written and oral English

f) Must be able to work beyond business hours including weekend when necessary

Job Scope

You will be providing support for the following areas

a) Reviewing and optimising SQL queries written by application developers to ensure optimal performance and adherence to database standards

b) Assisting in database design activities, including table structures, indexes, and relationships to support new application features or enhancements

c) Troubleshooting database-related issues reported by application teams, including SQL error codes, performance problems, and data integrity concerns

d) Supporting database changes through the development lifecycle (DEV, TEST, UAT, PROD), including coordinating database object migrations between environments

e) Monitoring application database performance and implementing necessary tuning measures like reorganising tablespaces, updating statistics, and adjusting buffer pools

f) Providing guidance to application developers on DB2 best practices, coding standards, and efficient query writing techniques

g) Supporting application testing activities by helping with data refresh requests, test data preparation, and database-related test case validation

About CLPS RiDiK

RiDiK is a global technology solutions provider and a subsidiary of CLPS Incorporation (NASDAQ: CLPS), delivering cutting-edge end-to-end services across banking, wealth management, and e-commerce. With deep expertise in AI, cloud, big data, and blockchain, we support clients across Asia, North America, and the Middle East in driving digital transformation and achieving sustainable growth.

Operating from regional hubs in 10 countries and backed by a global delivery network, we combine local insight with technical excellence to deliver real, measurable impact. Join RiDiK and be part of an innovative, fast-growing team shaping the future of technology across industries.