Responsibilities:
- a) Reviewing and optimising SQL queries written by application developers to ensure optimal performance and adherence to database standards
- b) Assisting in database design activities, including table structures, indexes, and relationships to support new application features or enhancements
- c) Troubleshooting database-related issues reported by application teams, including SQL error codes, performance problems, and data integrity concerns
- d) Supporting database changes through the development lifecycle (DEV, TEST, UAT, PROD), including coordinating database object migrations between environments
- e) Monitoring application database performance and implementing necessary tuning measures like reorganising tablespaces, updating statistics, and adjusting buffer pools
- f) Providing guidance to application developers on DB2 best practices, coding standards, and efficient query writing techniques
- g) Supporting application testing activities by helping with data refresh requests, test data preparation, and database-related test case validation
Requirements
- a) Strong background in IT, Computer Science / Computer Engineering, or related discipline
- b) Minimum 5 years of relevant working experience in the above technology is preferred.
- c) 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
