Mainframe DBA for IDMS System

Maybank; Kuala Lumpur; On-site; MYR 120,000 - 180,000; Full time

Job summary

Maybank is seeking an experienced IDMS database administrator to manage and optimize IDMS databases on the mainframe. You will monitor, maintain, and implement changes to database structure and data to ensure security and availability.

The role requires strong IDMS programming knowledge, JCL expertise, and experience migrating ADS and DC-COBOL programs to QA and production, with the ability to troubleshoot using online monitors and perform recoveries when needed.

Qualifications

• Experience administering IDMS databases on mainframe environments.
• Strong knowledge of IDMS and IDMA database structures.
• Ability to research and resolve issues independently.
• Proficient in JCL and batch processing.
• Experience migrating ADS and DC-COBOL programs to QA/production.
• Capable of installing/upgrading IDMS and third-party software.
• Familiar with other DB platforms (DB2, SQL Server, Teradata).
• Maintain backups and data recovery procedures.
• Use online monitors for runtime problem resolution.

Responsibilities

• Manage, monitor and maintain IDMS databases.
• Make requested changes to database structure and data.
• Ensure database security, integrity, stability and availability.
• Monitor/tune CV and batch performance (SYGEN, DMCL buffers).
• Perform database changes (restructure, unload/reload, rollback and roll forward).
• Migrate ADS and DC-COBOL programs to QA and production.
• Install and upgrade IDMS and third-party software.
• Ensure backup procedures are in place.
• Perform data recovery, including rollback and roll forward.
• Use online monitors to resolve run-time problems (pre-alert).

Skills

IDMS system programming

IDMS structures knowledge

Independent problem solving

JCL experience

IDMS DBA utilities

CV/batch monitoring

Rollback and roll forward

ADS/DC-COBOL migration

Software installation/upgrades

Other DB platforms familiarity

Backup procedures

Data recovery

Runtime monitoring troubleshooting

Tools

SYGEN

DMCL buffers

IDMS utilities

DB2

SQL Server

Teradata

Job description

Responsible for Managing, monitoring and maintaining IDMS databases.

Making requested changes, updates and modifications to database structure and data.

Ensuring database security, integrity, stability and system availability.

• IDMS system programming experience
• Knowledge of IDMA database structures
• Ability to independently research and resolve problems
• Extensive JCL experience
• Experience using IDMS DBA utilities
• Monitor/tune CV and batch performance (SYGEN, DMCL buffers, etc.)
• Preform database changes (restructure, unload/reload, rollback and roll forward, etc)
• Experience and ability to migrate ADS and DC-COBOL programs to QA and production
• Experience installing and upgrading software for IDMS and third party products
• Skills with other database platforms a plus (DB2, SQL Server, Teradata)
• Ensure that appropriate backup procedures are in place.
• Perform data recovery, including rollback and roll forward.
• Use online monitors to resolve run-time problems (pre-alert)