Mainframe DB2 System Programmer

Mainframe DB2 System Programmer

Job Title: Mainframe DB2 System Programmer
Contract Type: Contract
Location: Singapore
Reference: JOB_002672[397]
Contact Name: SJH (+6565603224)
Contact Email:
Job Published: July 29, 2021 15:33

Job Description

We are looking for a Mainframe DB2 System Programmer, who is/are able to fulfill the following requirements:

Duration: 6 Months

- 10+ years of experience as mainframe DB2 System Programmer

Roles and Responsibilities:
- Evaluate and implement new features/functions of DB2 and associated third party products.
- Extensive use of utilities and Performance Monitoring tools using BMC, CA and IBM products. 
- Consultant on DB2 database applications architecture
- Knowledge of SMP/E and can prepare for and apply maintenance to a DB2 subsystem
- Engineer and execute the processes to upgrade and/or apply maintenance to releases / versions of mainframe database system software, and associated third party products
- Maintain DSNZPARMs
- Implement automated disaster recovery mechanisms for Mainframe Database subsystems and associated third party products.  Participate in all recovery coordination activities
- Create & modify WLM address spaces for stored procedures as needed
- Database security management
- Backup/Recovery strategies
- Strategy Reviews
- Scalability Analysis
- Database Architecture design strategy
- Planning Database maintenance window
- Capacity planning 
- Monitor and troubleshoot DB2 address spaces for any potential issues
- DB2 Database configuration across difference Mainframe LPARs.
- Prepare and execute housekeeping strategies for the DB2 Catalog and Directory. 
- Implement security strategy for DB2 via RACF. 
- Troubleshoot Level 3 DB2 Database issues.
- Provide Level 3 support to troubleshoot/resolve system level and application problems with DB2 Database technologies and associated Third Party products – coordinate escalation/intervention with vendor as necessary

Please send your application to with (JOB_002672) in Subject line and highlighting:
- Your relevant experience
- Current/expected salary 
- Availability information 
- A latest MS-WORD Resume