DB2 DBA – Application Support (Singapore)

About the role

The role involves supporting application teams by managing and optimizing DB2 databases. You will work closely with developers to ensure high-performance, reliable data access for new and existing features.

Key responsibilities

• Review and optimise SQL queries written by application developers to ensure optimal performance and adherence to database standards.
• Assist in database design activities, including table structures, indexes, and relationships to support new application features or enhancements.
• Troubleshoot database-related issues reported by application teams, including SQL error codes, performance problems, and data integrity concerns.
• Support database changes through the development lifecycle (DEV, TEST, UAT, PROD) and coordinate object migrations between environments.
• Monitor application database performance and implement tuning measures such as reorganising tablespaces, updating statistics, and adjusting buffer pools.
• Provide guidance to developers on DB2 best practices, coding standards, and efficient query writing techniques.
• Assist application testing activities by handling data refresh requests, preparing test data, and validating database-related test cases.

Required profile

• Strong background in IT, Computer Science, Computer Engineering or a related discipline.
• Minimum of 5 years of relevant experience working with DB2 and related technologies.
• Experience with JCL, VSAM, mainframe storage concepts, database utilities, and backup/recovery procedures is advantageous.

Required skills

• DB2 database administration.
• SQL query optimisation.
• JCL (Job Control Language).
• VSAM and mainframe storage concepts.
• Database utilities and tools.
• Backup and recovery procedures.
• Database design, indexing, tablespace management, statistics, and buffer pool tuning.