HBO Consulting is currently one of the fastest growing IT consulting companies in South Africa, offering clients' an array of IT and business related services.
We believe that potential exists everywhere... tapping into it effectively is the key to our and our clients success. Being a proudly South African (BEE) company we want to play an intrinsic role in advancing business solutions across our country and beyond its borders.
Title:
DB2 DBA
Posted On:
11/13/2019 12:08:00 AM
Designation:
DB2 DBA
No. of vacancies:
2
Qualifications:
Bachelor Degree
Minimum Total Experience:
2
Job Tenure:
No Preference/Any
Salary Offered:
DOE
Job Location:
Gauteng
GAUTENG
South Africa
The DBA is responsible for:
- Supporting the Customer Accounts utilising DBA skills for DB2 v8 and DB2 9
- BAU problem and change (UK Core Hours - 0800 - 1800) 24/7
- Support with OOH Rota participation (UK 1800 - 0800)
- Supporting the business in the install, maintenance and upgrade of applications
- Supporting the business during the install of IBM products to ensure application compatibility
- Maintaining application housekeeping
- Application performance monitoring and tuning
- Assisting the business in application recovery
Skills required:
- DB2 Universal Database for Z/os V8
- In depth Knowledge of DB2 V8 utilities
- Working knowledge of DB2ADM/DB2PE/QMF/DB2AUT for object administration
- Administration of applications within a Distributed Data Architecture (DDF)
- JCL Composition
- JES2
- JES3
- Ability to use CA7/Jobtrac/OPC for schedule creation and error handling
- TSO - ISPF
- In-depth knowledge of SQL coding and optimization; including DDL/DML
- Understanding of SAP Database Administration
- Working knowledge of application housekeeping utilities - COPY/QUIESCE/REORG/RUNSTATS/MODIFY
- Working knowledge of creating JCL job schedules for running housekeeping utilities
- DB2PE or OMEGAMON XE for application monitoring
- Working knowledge of application recovery using RECOVERY utilities
- Working knowledge of standalone DB2 utilities - DSN1COPY/DSN1CHKR
- Working knowledge of object administration within a Data sharing environment
- Knowledge of application disaster recovery
- Relational database administration skills
- Problem determination skills
- Good verbal and written communication skills