DB2 DBA(Z/os)

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.

• 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.

• Possesses good communication and interpersonal skills.

• Have good command of written and oral English.

• Must be able to work beyond business hours including weekend when necessary.