Database Administrator Db2/idms

Johannesburg, Gauteng, South Africa

Job Description


Contact person for this position: Amori Prinsloo amori@joblinkplacement.co.za Website: www.joblinkplacement.co.za Our client is looking to employ a Database Administrator (DB2/IDMS) for a 1 year contract that might be extended for 2 years. 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
  • 10-12 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 6-8 years working experience on IDMS/DB2 databases.
Remote work permissible provided that the required network and security is as per customer standards requirements. Skills:
  • Programming background.
  • Trouble shooting xe2x80x93 Essential
  • Database analysis and design xe2x80x93 Essential
  • Analytical thinking and problem solving xe2x80x93 Essential
  • DB2 SQL writing xe2x80x93 Essential
  • Database Performance tuning xe2x80x93 Essential
  • Database security knowledge xe2x80x93 Essential
  • Backup and recovery strategy knowledge xe2x80x93 Essential
  • Usage of Database Utilities xe2x80x93 Essential
  • Database Internals
  • Disaster recovery knowledge xe2x80x93 Essential
  • Mainframe Operation systems knowledge xe2x80x93 Essential
  • JCL and Mainframe schedulers xe2x80x93 Essential
  • IBM Utilities and editor xe2x80x93 Essential
  • 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 requires standby duties and after hours support.
  • Able to provide customer support during weekend slots.
  • Able to travel when required.
Industry: IT and Banking Contract: R 650 xe2x80x93 R 700 per hour. Johannesburg

Beware of fraud agents! do not pay money to get a job

MNCJobs.co.za will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Job Detail

  • Job Id
    JD1278840
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Johannesburg, Gauteng, South Africa
  • Education
    Not mentioned