Senior Database Administrator: Mainframe DB2, Migrations & DR

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 conduct database administration, design reviews, backup/recovery, and SQL tuning. The role includes documenting standards and driving data governance in line with customer requirements.

As experience grows, there are opportunities in database consultancy areas such as performance tuning, data governance, and data policies within a dynamic team.

Qualifications

• Minimum 4 years of Mainframe DB2 on z/OS database administration experience.
• Knowledge of database design, implementation and operation support.
• Experience migrating data from Mainframe DB2 on z/OS to flatfiles using scripts/tools.
• Experience with MS SQL Server or DB2 UDB and cloud platforms is a plus.

Responsibilities

• Migrate data from Mainframe DB2 on z/OS to flatfiles.
• Plan and perform database migration.
• Monitor performance and availability; implement corrective actions.
• Document configurations and provide regular reporting.
• Ensure service levels are met; lead databases per SOPs.
• Implement backup/restore and disaster recovery procedures.
• Define data governance policies and manage permissions.
• Keep abreast of database technologies and share knowledge.
• Collaborate with application teams on data model changes.

Skills

Mainframe DB2 on z/OS

Database design

Application SQL tuning

Tools

MS SQL Server

DB2 UDB

AWS

Azure

Job description

ITCAN PTE. LIMITED in Singapore is seeking an Application DBA to conduct database administration, design reviews, backup/recovery, and SQL tuning. The role includes documenting standards and driving data governance in line with customer requirements.

As experience grows, there are opportunities in database consultancy areas such as performance tuning, data governance, and data policies within a dynamic team.