Job Portal

Job Title
Database Administrator DB2/IDMS (12 month contract) - Banking
Employment Type
Contract
Experience
8 to 10 years
Salary
Negotiable
Job Published
22 November 2024
Job Reference No.
2869800449

Job Description

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.

 

Skills

Industries