DB2 DBA Supporting Applictaion
Important Information
Location: Singapore
Responsibilities:
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
Requirements
a) Strong background in IT, Computer Science / Computer Engineering, or related discipline
b) Minimum 5 years of relevant working experience in the above technology is preferred.
c) Relevant experience in the following would be advantageous:
• Working with JCL (Jon Control Language)
• Understanding of VSAM and other mainframe storage concepts
• Familiar with database utilities and tools
• Experience with database backup and recovery procedures
About Encora
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.
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
Encora is a global digital engineering company built for a new era of AI-powered businesses. Forged in Silicon Valley, we grew up serving digital natives who demanded speed, scale, and flawless experiences. Today, we bring that same DNA to enterprises worldwide, enabling speed and hyper-adaptability, moving them further along their quest to become more composable and agile.
With two decades at the convergence of Cloud, Data, and AI, we help organizations move beyond rigid, legacy models to become composable enterprises, through adaptive systems designed to sense change and reconfigure in real time.
More than 9,500 engineers, designers, and domain experts across the Americas, Europe, India, and Southeast Asia give Encora the ability to combine nearshore agility with global scale. Backed by Advent International and Warburg Pincus, we deliver innovation acceleration and modernization across industries, powered by Encora AIVA™, our orchestration platform for AI-native engineering.
We believe the future won’t be built by humans or machines alone, but by human creativity amplified by limitless machine intelligence. At Encora, that’s how we help our clients build fast and adapt faster.
