DB2 Database Administrator

TechEmerge Solutions; Singapore; On-site; SGD 120,000 - 170,000; Full time

Job summary

TechEmerge Solutions in Singapore is seeking an experienced DB2 Database Administrator to optimise queries and support feature development.

You will lead SQL tuning, assist in database design, and troubleshoot issues across DEV/TEST/UAT/PROD environments, ensuring data integrity and performance. The ideal candidate has 10+ years of DB2 experience and familiarity with JCL and VSAM.

Qualifications

• Strong background in IT, Computer Science or related discipline.
• Minimum 10 years of DB2 database administration experience.
• Familiarity with JCL, VSAM and mainframe storage concepts is advantageous.

Responsibilities

• Reviewing and optimising SQL queries written by developers to ensure performance and standards.
• Assisting in database design activities, including table structures, indexes, and relationships.
• Troubleshooting database-related issues reported by application teams, including SQL errors and data integrity.
• Supporting database changes through DEV, TEST, UAT and PROD, coordinating migrations between environments.
• Monitoring database performance and implementing tuning measures like reorganising spaces and updating statistics.
• Providing guidance to developers on DB2 best practices and efficient query writing techniques.
• Supporting application testing activities with data refresh requests and test data preparation.

Skills

DB2 database administration

SQL performance tuning

Mainframe concepts familiarity

Tools

DB2 Utilities

JCL

VSAM

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