DB2 DBA: Optimize, Tune & Support Applications

encora10

Singapore

On-site

SGD 90,000 - 120,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

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

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

DB2 DBA for Applications: Performance & Design
DB2 DBA for Applications: Performance & Design

Encora Inc. • Singapore

On-site
SGD 60,000 - 100,000
Senior DB2 DBA: Performance Tuning & Lifecycle Migrations
Senior DB2 DBA: Performance Tuning & Lifecycle Migrations

Encora • Singapore

On-site
SGD 80,000 - 110,000
DB2 DBA Supporting Application
DB2 DBA Supporting Application

encora10 • Singapore

On-site
SGD 90,000 - 120,000
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 & PostgreSQL Database Administrator (On-Prem/Cloud)
Db2 & PostgreSQL Database Administrator (On-Prem/Cloud)

OPUS IT Services Pte Ltd • Singapore

On-site
SGD 90,000 - 120,000
Database Administrator - Db2 & PostgreSQL Expert
Database Administrator - Db2 & PostgreSQL Expert

OPUS IT Services Pte Ltd • Singapore

On-site
SGD 90,000 - 150,000
Oracle DBA – Performance Tuning, Cloud & HA
Oracle DBA – Performance Tuning, Cloud & HA

HYPERSCAL SOLUTIONS PTE. LTD. • Singapore

On-site
SGD 90,000 - 150,000
Oracle DBA — 24/7 Production, Tuning & DR
Oracle DBA — 24/7 Production, Tuning & DR

Sciente International Pte Ltd • Singapore

On-site
SGD 70,000 - 110,000
Senior MSSQL/DB2 DBA — Always On, DR & Security
Senior MSSQL/DB2 DBA — Always On, DR & Security

LPS • Singapore

On-site
SGD 110,000 - 170,000