DB2 DBA Supporting Application

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