DB2 DATABASE ADMINISTRATOR

Hi5 Consulting Solutions Pte Ltd; Singapore; On-site; SGD 70,000 - 110,000; Full time

Job summary

Hi5 Consulting Solutions Pte Ltd is seeking an experienced IT professional to support DB2 databases and mainframe environments in Singapore. You will review and optimize queries, help design tables, indexes, and relationships, and troubleshoot data integrity and performance issues.

The role covers supporting changes across DEV/TEST/UAT/PROD, monitoring performance, and providing guidance on best practices. Strong English communication and flexibility to work outside standard hours are required.

Qualifications

• A strong IT background in computing is required.
• 5+ years of relevant experience preferred.
• Experience with JCL, VSAM, and mainframe DB2 is advantageous.
• Good communication and English skills are essential.
• Ability to work after hours including weekends when needed.

Responsibilities

• Review and optimize SQL queries written by developers for performance and standards.
• Assist in database design: tables, indexes, relationships for new features.
• Troubleshoot DB issues: SQL errors, performance, data integrity.
• Support lifecycle changes and migrations across DEV/TEST/UAT/PROD.
• Monitor database performance and apply tuning: reorganize spaces, stats.
• Provide DB2 best practices and coding guidance to developers.
• Support testing with data refreshes, test data prep, validation.

Skills

JCL

VSAM

DB2

SQL performance

Database utilities

Backup and recovery

English communication

Tools

Mainframe concepts

Job description

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

Requirements

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 includingweekendwhen necessary