Specialist Engineer Mainframe Storage Level 2 at Absa Group Limited (Absa)

Job Summary

Build high-performing, scalable, enterprise-grade Platform services & build capability in others to do the same. This includes but is not limited to applying critical thinking, design thinking and problem solving skills in an agile team environment to solve complex technical problems with high quality solutions & leading all phases of the development lifecycle to deliver against business requirements at an optimal cost to serve.
Job Description

Key Responsibilities
Support for end user programmers and application teams.

•  Natural and Cobol / Rexx and Assembler.
• Writing of and analyzing SQL statements.   

Extensive performance tuning and enhancements.

• Creating DB2 databases, table spaces, tables, indexes, fields, for Test / Dev / QA and Production environments.

Partitioning. 

• Automation of processes.

Responsible for data and object housekeeping and maintenance.

• Reorg/Run stats/Backups.
• Automation of processes.

Database availability: Uptime and stability.

• High availability and SYSPLEX knowledge.

Database backups and environmental restores.

• High availability
• Recover procedures
• Automation of processes.

Database structure support.

• Altering table spaces, table, indexes, and fields.

Manage, monitor and configure database security.

• DCL (Data Control Language)
• RACF
• TWS

Maintain processes and schedules.

• DB2 Installation and upgrades.

Version upgrades.

• Patching.
• ZParm parameters.

All the mentioned duties included the daily operational functions to keep the systems running, as well as project involvement.

The projects would eventually slot into the ‘daily operations’ and it was essential to get the design standards and procedures in place upfront. In doing this, operationally the projects would need very little ‘down time’ to correct. Especially the high focused ones.

A good understanding and work relationship with the various stakeholders within the environment i.e. OS , Storage , Networks etc also assisted in delivering first class support to the stakeholders and business.

SOFTWARE PRODUCTS AND VERSIONS WORKING ON:

• DB2 VERSION 10
• DB2 VERSION 11 (zOS, 2.4)
• DB2 VERSION 12

Not mentioned in detail is the zOS operating system knowledge. This knowledge is essential to maintain PDS, copy/create/edit files on zOS

Education

• Bachelor's Degree: Information Technology

Closing Date: 18th, March 2022