Employment Opportunity - Database Administrator (DB2)

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

Job Summary

The Application DBA manages database administration tasks including setup, object maintenance, backup, recovery, and performance monitoring. This role involves database design review, SQL tuning, and documentation, with opportunities to expand into consultancy areas like performance tuning and data governance.

Responsibilities

• Migrate data from Mainframe DB2 on z/OS to flat files using scripts or tools in the mainframe environment to ensure accurate data transfer
• Plan and execute database migration projects to meet business requirements and minimize downtime
• Monitor database performance and availability proactively; implement corrective actions to optimize system reliability
• Track service levels, document database configurations, and provide regular performance and availability reports to stakeholders
• Ensure databases meet agreed service levels; develop and implement action plans to address any gaps
• Lead database operations following standard operating procedures to maintain consistency and quality
• Implement service continuity measures including backup, restore procedures, and disaster recovery plans to support uninterrupted business operations
• Define and enforce data governance policies related to database management, including permission controls, hardening standards, and naming conventions
• Stay updated on emerging database technologies to recommend improvements and innovations
• Collaborate with application teams to review and enhance database design, aligning data models with business and application needs
• Develop and enforce standards and procedures for database environments to ensure compliance and best practices
• Communicate technical database design rationales and issues effectively to customers and stakeholders
• Educate application teams on best practices for coding and database design to improve application performance and maintainability
• Share knowledge and lessons learned through Communities of Practice (CoPs) or internal forums to foster organizational learning
• Contribute to the knowledge repository by documenting experiences and insights gained from project implementations

Required competencies and certifications

• 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

Preferred competencies and qualifications

• Knowledge and experience with other database systems such as MS SQL Server or DB2 uDB
• Familiarity with cloud platforms such as AWS or Azure