DB2 DBA Supporting Application

About this role

<p><strong>DB2 DBA Supporting Applictaion</strong></p> <p> </p> <p><strong>Important Information</strong></p> <p><strong>Location: Singapore</strong></p> <p> </p> <p><strong>Responsibilities:</strong></p> <p>a) Reviewing and optimising SQL queries written by application developers to ensure optimal performance and adherence to database standards</p> <p>b) Assisting in database design activities, including table structures, indexes, and relationships to support new application features or enhancements</p> <p>c) Troubleshooting database-related issues reported by application teams, including SQL error codes, performance problems, and data integrity concerns</p> <p>d) Supporting database changes through the development lifecycle (DEV, TEST, UAT, PROD), including coordinating database object migrations between environments</p> <p>e) Monitoring application database performance and implementing necessary tuning measures like reorganising tablespaces, updating statistics, and adjusting buffer pools</p> <p>f) Providing guidance to application developers on DB2 best practices, coding standards, and efficient query writing techniques </p> <p>g) Supporting application testing activities by helping with data refresh requests, test data preparation, and database-related test case validation</p> <p> </p> <p>Requirements</p> <p>a) Strong background in IT, Computer Science / Computer Engineering, or related discipline</p> <p>b) Minimum 5 years of relevant working experience in the above technology is preferred.</p> <p>c) Relevant experience in the following would be advantageous:<br>• Working with JCL (Jon Control Language)<br>• Understanding of VSAM and other mainframe storage concepts<br>• Familiar with database utilities and tools<br>• Experience with database backup and recovery procedures</p> <p> </p> <p><strong>About Encora</strong></p> <p>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.</p> <p>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</p>