Senior DB2 DBA: Performance Tuning & Lifecycle Migrations

Encora; Singapore; Sur place; SGD 80 000 - 110 000; Plein temps

Résumé du poste

Encora Singapore is seeking a skilled Database Engineer to optimise SQL queries, assist with database design, and troubleshoot issues across DEV, TEST, UAT, and PROD environments.

You will guide developers on DB2 best practices, monitor performance, coordinate object migrations, and ensure data integrity while supporting testing activities and data refresh tasks in a global software engineering setting.

Qualifications

• Minimum 5 years of relevant working experience in the above technology is preferred.
• Experience with mainframe concepts and related storage is advantageous.
• Strong background in IT or related discipline is required.

Responsabilités

• 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

Connaissances

SQL tuning

Database design

Troubleshooting

Migration coordination

Performance monitoring

DB2 knowledge

Data integrity

Formation

Bachelor’s in IT/CS

Outils

JCL

VSAM

Database utilities

Backup & recovery

Description du poste

Encora Singapore is seeking a skilled Database Engineer to optimise SQL queries, assist with database design, and troubleshoot issues across DEV, TEST, UAT, and PROD environments.

You will guide developers on DB2 best practices, monitor performance, coordinate object migrations, and ensure data integrity while supporting testing activities and data refresh tasks in a global software engineering setting.