Computer Software Engineer (DB2 DBA, JCL, VSAM, Database Utilities)

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 reorganizing tablespaces, updating statistics, and adjusting buffer pools
• Providing guidance to application developers on DB2 best practices, coding standards, and efficient query writing techniques
• Supporting applicati...