Database Administrator (DB2)

ITCAN PTE. LIMITED; Singapore; On-site; SGD 90,000 - 150,000; Full time

Job summary

ITCAN PTE. LIMITED is seeking an Application DBA in Singapore to perform mainframe DB2 on z/OS administration, design and review database objects, and support backup/recovery. You will work with the application team to optimize data models and ensure robust data governance.

The role offers growth into performance tuning and data policy areas within a customer-focused environment. The candidate should have 4+ years of mainframe DB2 on z/OS experience, familiarity with MS SQL Server/DB2 UDB, and

Qualifications

• Requires at least 4 years of mainframe DB2 on z/OS administration experience.
• Experience migrating data from Mainframe DB2 on z/OS to flatfiles using scripts/tools.
• Knowledge of MS SQL Server, DB2 UDB, and cloud platforms is a plus.

Responsibilities

• Migrate data from Mainframe DB2 on z/OS to flatfiles using scripts or tools.
• Plan and perform database migration.
• Monitor & measure the performance & availability of databases; implement corrective actions.
• Monitor service levels, document & maintain database configurations; provide regular reports.
• Ensure service levels meet requirements; lead databases per SOPs.
• Implement backup/restore procedures and disaster recovery plans.
• Define data governance policies related to database operations; manage permissions and naming standards.
• Keep abreast of database technologies; be a strong team player.
• Review database design with application teams and suggest data model improvements.

Skills

Teamwork

Communication

Problem solving

Education

Bachelor's degree in Computer Science or related field

Tools

Mainframe DB2 on z/OS

MS SQL Server

DB2 UDB

AWS or Azure

SQL tuning tools

Job description

Job Description

Primary Purpose

The Application DBA is responsible to perform database Administration activities such as database setup, defining/maintaining database objects, backup and recovery. He/She is also involved in database design and review, application SQL tuning and maintaining documentation meeting customer’s expectation. As the experience in this position grows, there will be opportunities to expand to database consultancies areas such as performance tuning, data governance and data policies.

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.
• Keep abreast of database technologies.
• A good team player.
• 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

Qualifications

• This position requires mandatory Mainframe DB2 on z/OS database administration experience of at least 4 years. He/She possesses good knowledge of database design, implementation and operation support. He/She has 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 (eg. AWS or AZURE) is an added advantage.