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
Skills Required
- Strong background in IT, Computer Science / Computer Engineering, or related discipline
- Minimum 5 years of relevant working experience
- Working with JCL (Job Control Language)
- Understanding of VSAM and other mainframe storage concepts
- Familiar with database utilities and tools
- Experience with database backup and recovery procedures
Encora Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Encora and has not been reviewed or approved by Encora.
-
Healthcare Strength — Health coverage is described as employer-provided in multiple locations, with private plans and family coverage highlighted in Spain and Mexico. Medical insurance quality is presented as a recurring bright spot alongside standard coverage.
-
Leave & Time Off Breadth — Time off includes paid holidays and PTO, with regional materials indicating additional leave provisions in certain countries. Leave is generally portrayed as conventional to generous depending on location.
-
Flexible Benefits — Work-from-home flexibility is frequently highlighted as a plus, though it varies by role and client needs. Remote and hybrid options are positioned as part of the overall package.
Encora Insights
What We Do
Headquartered in Santa Clara, California, and backed by renowned private equity firms Advent International and Warburg Pincus, Encora is the preferred technology modernization and innovation partner to some of the world’s leading enterprise companies. It provides award-winning digital engineering services including Product Engineering & Development, Cloud Services, Quality Engineering, DevSecOps, Data & Analytics, Digital Experience, Cybersecurity, and AI & LLM Engineering. Encora's deep cluster vertical capabilities extend across diverse industries, including HiTech, Healthcare & Life Sciences, Retail & CPG, Energy & Utilities, Banking Financial Services & Insurance, Travel, Hospitality & Logistics, Telecom & Media, Automotive, and other specialized industries. With over 9,000 associates in 47+ offices and delivery centers across the U.S., Canada, Latin America, Europe, India, and Southeast Asia, Encora delivers nearshore agility to clients anywhere in the world, coupled with expertise at scale in India. Encora’s Cloud-first, Data-first, AI-first approach enables clients to create differentiated enterprise value through technology
