DB2 DBA Supporting Application

Encora Inc.; Singapore; On-site; SGD 60,000 - 100,000; Full time

Job summary

Encora is hiring a DB2 DBA in Singapore to support application databases and mainframe environments. You will review and optimise SQL queries, assist in designing table structures and indexes, and troubleshoot issues across DEV/TEST/UAT/PROD lifecycles.

You will guide developers on DB2 best practices and assist with data refreshes and test data preparation. The role emphasizes performance tuning, database migrations, and ensuring data integrity while applying standardised procedures across

Qualifications

• Bachelor’s degree or equivalent in IT/CS or related discipline.
• Minimum 5 years of relevant working experience in DB2 and mainframe environments is preferred.
• Experience with JCL, VSAM and DB2 backup/recovery procedures is advantageous.
• Familiarity with database utilities and tools is desirable.

Responsibilities

• Reviewing and optimising SQL queries to ensure performance and standards.
• Assist in database design including tables, indexes, and relationships for new features.
• Troubleshooting database issues including SQL errors, performance, and data integrity.
• Support database changes through development lifecycle and coordinate migrations.
• Monitor database performance and apply tuning measures such as stats updates and buffer pool adjustments.
• Provide guidance on DB2 best practices and coding standards to developers.
• Support testing activities with data refresh, test data preparation, and test case validation.

Skills

DB2

SQL

JCL

VSAM

Backup & Recovery

DB2 Performance Tuning

Mainframe Concepts

Education

IT / CS or related discipline

Tools

DB2 Utilities

JCL

Mainframe Tools

Job description

• 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 DB2 best 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

DB2 DBA Supporting Applictaion

Important Information

Location: Singapore

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 DB2 best 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 5 years of relevant working experience in the above technology is preferred.
• 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

About Encora

Encora is a global company that offers Software and Digital Engineering solutions. Our practices include Cloud Services, Product Engineering & Application Modernization, Data & Analytics, Digital Experience & Design Services, DevSecOps, Cybersecurity, Quality Engineering, AI & LLM Engineering, among others.

At Encora, we hire professionals based solely on their skills and do not discriminate based on age, disability, religion, gender, sexual orientation, socioeconomic status, or nationality