Job Summary
One of the TOP banks in S.A. is seeking an experienced DB2 / IDMS Data Administrator to join their JHB team on a 1-year contract.
Qualifications and experience:
- IT degree or equivalent
- Minimum of 4 years' work experience on IDMS / DB2 database
- No less than 8 years' within IT, of which 5 years' is in operational DBA within a large complex corporate environment
- Understanding of mainframe operating system concepts and experience in another mainframe discipline
- Experience in DR exercise
- Willing to travel when required
- Position requires standby duties and after hours support
- Provide customer support during weekends
Key skills:
- Planning
- Results driven
- Accountability
- Customer orientated
- Adaptable
- Programming
- Troubleshooting
- Database analysis and design
- Analytical
- Problem solving
- DB2 SQL writing
- Database performance tuning
- Database security
- Backup and recovery strategy
- Usage of database utilities
- Database internals
- Disaster recovery
- Mainframe operations systems
- JCL and mainframe schedulers
- IBM utilities and editor
- Usage of supplied database toolsets (DB2admin and Spufi)
- IDMS supplied and DMLO navigation
Key performance areas:
- Incident handling
- Supplier liaison
- Draft managerial reports: database utility, capacity and utilisation
- Maintain database integrity
- Form part of the disaster recovery team
- Provide design solutions to business development, service management to support the initiatives for projects
- Conduct database monitoring to ensure optimal data access
- Support business database applications
- Troubleshoot database an DBMS errors
- Create and maintain business database objects within IDMS / DB2 sub-system
- Perform database tuning