Database Administrator DB2/IDMS (12 month contract) - Banking

Johannesburg, Gauteng
Contract
Full-time

16 days ago

Key Duties and Responsibilities:To manage, monitor and support mainframe IDMS and DB2 database objects and ensure their availability, performance, security and consistency in order to support mission critical business applications.

Create and maintain business database objects within an IDMS and DB2 subsystem.
Perform database tuning to ensure the DBMS functions at optimal levels.
Schedule database maintenance tasks.
Troubleshoot database and DBMS errors and provide solutions to support business when required.
Provide input and implement operational and business strategies, industry best practices and ensure necessary ITO governance is in place.
Perform database monitoring and notification to ensure optimal data access, to support business database applications in line with contractual agreements.
Perform a database consultation role and provide design solutions to Business Development and Service Management to support initiatives when required for current and future projects.
Be an integral part of the disaster recovery (DR) team which designs, performs and documents disaster recovery procedures.
Service all incidents, changes and requests and ensure that SLAs are met.
Enforce security standards to prevent data being compromised and to maintain database integrity.
Provide managerial reports of database utility, capacity and utilisation in order for them to make informed decisions.
Maintain relationships with suppliers for incident handling.

Educational Requirements:

IT degree or equivalent Industry accreditation preferred
8 years within the IT industry with at least 5 of those years being an operational DBA within a large complex corporate environment
Understanding of mainframe operating system concepts and experience in another mainframe discipline.
Experience in participating in a DR exercise.
Minimum of 4 years working experience on IDMS/DB2 databases.

Skills:

Programming background.
Trouble shooting
Database analysis and design
Analytical thinking and problem solving
DB2 SQL writing
Database Performance tuning
Database security knowledge
Backup and recovery strategy knowledge
Usage of Database Utilities
Database Internals
Disaster recovery knowledge
Mainframe Operation systems knowledge
JCL and Mainframe schedulers
IBM Utilities and editor
Usage of supplied database toolsets DB2 Tools (Db2 Admin and Spufi) and IDMS supplied and DMLO navigation.

Culture:

Must have a strong sense of ownership and responsibility.
Delivering results and meeting customer expectations.
Planning and Organising.
Adhering to Principles and Values.
Adapting and Responding to Change.
Following Instructions and Procedures.

Additional information:The position require standby duties and after hours support.Able to provide customer support during weekend slots.Able to travel when required.

Isilumko Staffing

Apply Now