Installation / configuration MSY related DB2 DB Instances:
- Installation and configuration of DB instance
- Setting up of backups for system files of the database instance (without application components)
- Integration of the database instance into the system monitoring
- Integration of the database instance into the z/OS system automation
- Integration of the database instance into the standard reporting (DB Instance Availability)
- Setting up the database basic system security (DB-internal/-external (e.g.: RACF, TSS))
Maintain, develop Methods and Tools for Operations
Support to maintain the Administration of DB Basis Security
DB2 System Programming, administration DB2 parameters
DB2 System Administration Operations (Creation, Update, deletion System Objects in DB instances)
Support for related SW Procurement
Path Management, development migration Concepts, Version and Release Upgrades.
Prevention and Tuning (maintenance, system tuning, manage 3rd Level Support)
Support development of System Automation and Monitoring procedures
Support administration and execution of the Standard Reporting
System Generations
Ensuring Data Consistency of All System Files
Execution of backup of all System Data
Archiving LOGs, etc, Admin System Log Files
Troubleshooting
Incident, Problem, Change Management
Audit issues remediation
Documentation (system and operating documentation) for DB Systems
Implementation High Availability DB2-SYSPLEX solution like DB2 Data Sharing

DBA tasks:

Set Up Backup of application databases & database Recovery
Reorganization/Loads/Unload
Monitoring DB size of the application databases
Administration runs for maintenance of the system tables (Catalogs, Libraries, etc.; ONLY DB2)
Review of the physical DB consistency (DB Checker)
DBA- Administration (e.g.: define, delete, generate, reorganize) of application databases

Mainframe Administrator (System & DBA) (REF4677F)

Job Description