EVYONIC SOLUTIONS PTE. LTD. is hiring for a DB2 DBA(JCL, VSAM, Database Utilities) internship — a 12-month, on-site Software Engineering role based in Singapore. It is an unpaid internship. It is open to university students, typically in Year 2–4. Applicants with experience in recovery procedures, Computer Engineering, scientific discipline, JCL, and Information Technology are a strong fit.
About this role
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 application testing activities by helping with data refresh requests, test data preparation, and database-related test case validation Requirements • Strong background in IT, Computer Science / Computer Engineering, or related discipline • Minimum 5 years of relevant working experience in the above technology is preferred. • Relevant experience in the following would be advantageous: • Working with JCL (Jon Control Language) • Experience in VSAM and other mainframe storage concepts • Familiar with database utilities and tools • Experience with database backup and recovery procedures
Also in Software Engineering