Database Administrator (DB2)

U3 INFOTECH PTE. LTD.; Singapore; On-site; SGD 120,000 - 180,000; Full time

Job summary

U3 INFOTECH PTE. LTD. is seeking an experienced Mainframe DB2 Database Administrator with deep expertise in DB2 on z/OS and data migration.

You will join enterprise-scale environments supporting mission-critical applications and collaborate with application teams to optimize data design and operations. The role emphasizes migrating data from Mainframe DB2 on z/OS to flatfiles, monitoring performance and availability, applying robust backup/DR strategies, and upholding data governance while

Qualifications

• Mandatory 4+ years of Mainframe DB2 on z/OS Database Administration experience.
• Experience in migrating data from Mainframe DB2 on z/OS to flatfiles.
• Knowledge of database design, implementation and operation support.

Responsibilities

• Migrate data from Mainframe DB2 on z/OS to flatfiles.
• Plan and perform database migration.
• Monitor and improve performance and availability of databases.
• Maintain configuration and provide regular reporting to stakeholders.
• Define data governance policies and manage permissions.
• Implement backup/restore and disaster recovery procedures.

Skills

Mainframe DB2

z/OS DB2

Data migration

Performance monitor

AWS

Azure

Tools

DB2 tools

Job description

We are looking for Database admin who has strong expertise for Mainframe DB2 (or DB2 onz/OS) skillset who has strong expertise with mainframe DB2 Database Administrator (z/OS)

If you are experienced Mainframe DB2 Database Administrator with expertise in DB2 on z/OS and database migration? Join our team and work on enterprise-scale database environments supporting mission-critical applications.

Key Responsibilities

• Migrating data from Mainframe DB2 on z/OS to flatfiles using scripts or tools in the mainframe environment.
• Plan and perform database migration.
• Monitor & measure the performance & availability of databases proactively; implement corrective actions identified to improve performance & availability.
• Monitor the agreed service level, document & maintain the configuration of the databases; provide regular reporting to relevant parties.
• Ensure service level meet requirement. Propose and implement action plan when required. Lead and monitor databases according to standard operations procedures.
• Implementation of service continuity measures, i.e., backup/restore procedures & disaster recovery plan, to ensure continuous operation of the business.
• Define data governance policy related to database operations management. Manage database permission, hardening standards, database naming standards.
• Work with application team to review the database design and recommend suitable changes to the data model with understanding of the business and application environment.
• Develop standards and procedures related to database environment and ensure that it is followed through for all implementations.
• Engage customers to explain the rationale of the database design, or other technical issues.
• Educate application team on best practices in coding and design.
• Share knowledge with the rest of organization through CoPs or other in-house forums.
• Contribute to knowledge repository on experience learnt through project implementation.
• Mandatory 4+ years of Mainframe DB2 on z/OS Database Administration experience.
• Good knowledge of database design, implementation and operation support.
• Experience in migrating data from Mainframe DB2 on z/OS to flatfiles using scripts or tools in the mainframe environment.
• Knowledge and experience in other databases such as MS SQL Server or DB2 uDB, as well as cloud platforms (AWS or Azure), is an added advantage.

Please refer to U3’s Privacy Notice for Job Applicants/Seekers at https://u3infotech.com/privacy-notice-job-applicants/. When you apply, you voluntarily consent to the collection, use and disclosure of your personal data for recruitment/employment and related purposes.