DB2 Database Administrator

QUANTUM INFOTECH SOLUTIONS PTE. LTD.; Singapore; On-site; SGD 110,000 - 160,000; Full time

Job summary

QUANTUM INFOTECH SOLUTIONS PTE. LTD. is seeking an experienced DB2 Database Administrator to optimise SQL queries, assist in design, and troubleshoot issues across DEV, TEST, UAT and PROD environments.

The role emphasizes performance tuning, data integrity, and best practices for database development. The candidate will collaborate with application teams to implement changes, monitor performance, and ensure smooth migrations through the development lifecycle while leveraging mainframe concepts

Qualifications

• Bachelor's degree in IT/CS/CE or related field required.
• Minimum 10 years of DB2 database administration experience preferred.
• Experience with mainframe concepts is advantageous.

Responsibilities

• Reviewing and optimising DB2 SQL queries for performance.
• Assisting in database design, including tables, indexes, and relationships.
• Troubleshooting database issues including SQL errors and data integrity concerns.
• Supporting database changes through DEV/TEST/UAT/PROD, coordinating migrations.
• Monitoring database performance and performing tuning like reorganising tablespaces and updating statistics.
• Providing guidance on DB2 best practices and coding standards.
• Supporting data refresh, test data preparation, and database-related test validation.

Skills

DB2 administration

SQL performance tuning

Database design

JCL

VSAM

Troubleshooting

Mainframe experience

Education

Bachelor's degree in IT/CS/Computer Engineering

Tools

DB2 Utilities

Backup/Recovery tools

Mainframe tooling

Job description

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 DB2best 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

Requirements:

• Strong background in IT, Computer Science /Computer Engineering, or related discipline
• Minimum 10 years of relevant working experience in DB2 database administration is preferred.
• Relevant experience in the following would be advantageous:

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