DB2 DBA Supporting Application

encora10

Singapore

On-site

SGD 90,000 - 120,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Encora is seeking a DB2 DBA to support application environments in Singapore. You will review SQL, optimise queries, assist with database design, and ensure data integrity across DEV, TEST, UAT, and PROD.

You will troubleshoot issues, monitor performance, and guide developers on DB2 best practices while coordinating object migrations and database changes throughout the software lifecycle.

Qualifications

  • Minimum 5 years of relevant IT/DB2 experience.
  • Strong knowledge of DB2, SQL, and mainframe concepts.
  • Experience with backup and recovery procedures and environment migrations.

Responsibilities

  • Review and optimise SQL queries for performance and standards.
  • Assist in database design including tables, indexes and relationships.
  • Troubleshoot database issues, SQL errors, performance problems, data integrity.
  • Support database changes across DEV/TEST/UAT/PROD and migrations.
  • Monitor performance; tune by reorganising tablespaces, updating stats, adjusting buffers.
  • Guide developers on DB2 best practices and efficient SQL writing.
  • Support testing with data refreshes and test data preparation.

Skills

DB2
SQL
Performance tuning
Troubleshooting
Monitoring

Education

IT/CS/CE degree

Tools

JCL
VSAM
Database utilities

Job description

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

DB2 DBA Supporting Application
DB2 DBA Supporting Application

Encora Inc. • Singapore

On-site
SGD 60,000 - 100,000
DB2 DBA Supporting Application
DB2 DBA Supporting Application

Encora • Singapore

On-site
SGD 80,000 - 110,000
DB2 DBA for Applications: Performance & Design
DB2 DBA for Applications: Performance & Design

Encora Inc. • Singapore

On-site
SGD 60,000 - 100,000
DB2 DBA: Optimize, Tune & Support Applications
DB2 DBA: Optimize, Tune & Support Applications

encora10 • Singapore

On-site
SGD 90,000 - 120,000
Application Maintenance Engineer
Application Maintenance Engineer

Encora Inc. • Singapore

On-site
SGD 90,000 - 150,000
Application Maintenance Engineer
Application Maintenance Engineer

encora10 • Singapore

On-site
SGD 120,000 - 180,000
Senior DB2 DBA: Performance Tuning & Lifecycle Migrations
Senior DB2 DBA: Performance Tuning & Lifecycle Migrations

Encora • Singapore

On-site
SGD 80,000 - 110,000
Linux with Lotus notes
Linux with Lotus notes

encora10 • Singapore

On-site
SGD 60,000 - 90,000
Project Manager
Project Manager

encora10 • Singapore

On-site
SGD 150,000 - 210,000
Business Analyst
Business Analyst

Encora • Singapore

On-site
SGD 90,000 - 150,000