DB2 Database Administrator

TECHEMERGE SOLUTIONS PTE. LTD.; Singapore; On-site; SGD 140,000 - 190,000; Full time

Job summary

TECHEMERGE SOLUTIONS PTE. LTD. is seeking a seasoned DB2 Database Administrator in Singapore.

The role focuses on reviewing SQL, optimizing performance, and guiding developers on DB2 best practices. You will participate in database design, manage migrations across environments, and troubleshoot complex issues to ensure data integrity and system reliability. The ideal candidate brings 10+ years of DB2 experience, familiarity with JCL/VSAM, and a strong grounding in mainframe storage concepts.

Qualifications

• 10+ years of DB2 administration experience preferred.
• Strong background in IT, CS/CE or related discipline.
• Familiar with mainframe storage concepts and DB2 utilities.

Responsibilities

• Reviewing and optimising SQL queries written by developers for performance and standards.
• Assisting in database design: tables, indexes, relationships to support features.
• Troubleshooting DB2 issues including error codes, performance and data integrity.
• Supporting changes through DEV/TEST/UAT/PROD and coordinating migrations.
• Monitoring DB performance and applying tuning like table reorganisations and stats.
• Guiding developers on DB2 best practices and efficient query writing.
• Supporting testing with data refreshes, test data prep, and validation.

Skills

DB2 database administration

SQL performance tuning

Mainframe concepts

Education

Bachelor's degree in IT / Computer Science

Tools

JCL

VSAM

Database utilities

Backup and recovery procedures

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