DB2 DBA: Mainframe Migration, Performance & Governance

ITCAN PTE. LIMITED; Singapore; On-site; SGD 120,000 - 180,000; Full time

Job summary

ITCAN PTE. LIMITED in Singapore is seeking an Application DBA to manage DB2 on z/OS, overseeing setup, maintenance, backup, recovery, and performance monitoring, with emphasis on data migration and governance.

You will collaborate with application teams to review designs, tune SQL, document configurations, and stay ahead with emerging database technologies to ensure service levels and reliability.

Qualifications

• Minimum 4 years of experience in Mainframe DB2 on z/OS database administration.
• Proven expertise in database design, implementation, and operational support for Mainframe DB2 on z/OS.
• Experience migrating data from Mainframe DB2 on z/OS to flat files using scripts or tools within the mainframe environment.

Responsibilities

• Migrate data from Mainframe DB2 on z/OS to flat files.
• Plan and execute database migration projects with minimal downtime.
• Monitor database performance and availability; implement corrective actions.
• Document configurations and provide performance/availability reports.
• Lead database operations following standard procedures for consistency and quality.
• Define and enforce data governance policies, including permissions and naming conventions.
• Collaborate with application teams to review and refine database designs.

Skills

Mainframe DB2 on z/OS

Database design

Operational support

Data migration

Tools

MS SQL Server

DB2 UDB

Job description

ITCAN PTE. LIMITED in Singapore is seeking an Application DBA to manage DB2 on z/OS, overseeing setup, maintenance, backup, recovery, and performance monitoring, with emphasis on data migration and governance.

You will collaborate with application teams to review designs, tune SQL, document configurations, and stay ahead with emerging database technologies to ensure service levels and reliability.