Mainframe DB2

About Infrastructure Technology Infrastructure Services is a team based in South Africa and Rest of African countries. We are accountable for delivering and supporting resilient, secure infrastructure technology and services to customers, clients and colleagues, both in South Africa and Rest of Africa.

Mainframe Capacity and Performance Team The mainframe Capacity and Performance team is responsible for ensuring that all z/Os and z/VM / z/Linux systems on the mainframe are managed in a way that is acceptable to both the organisation and their customers.

Overall Purpose of Role The role is as an Engineer Database Specialist working in the Mainframe Infrastructure team to provide technical maintenance and support for DB2 Databases.

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