Database Administrator DB2/IDMS
To oversee, monitor, and maintain mainframe IDMS and DB2 database objects, ensuring their availability, performance, security, and consistency to support critical business applications.
Key Responsibilities and Duties:
- 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, 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
Minimum Requirements:
- 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.
- Programming background.
- Trouble shooting – Essential
- Database analysis and design – Essential
- Analytical thinking and problem solving – Essential
- DB2 SQL writing – Essential
- Database Performance tuning – Essential
- Database security knowledge – Essential
- Backup and recovery strategy knowledge – Essential
- Usage of Database Utilities – Essential
- Database Internals
- Disaster recovery knowledge – Essential
- Mainframe Operation systems knowledge – Essential
- JCL and Mainframe schedulers – Essential
- IBM Utilities and editor – Essential
- Usage of supplied database toolsets DB2 Tools (Db2 Admin and Spufi) and IDMS supplied and DMLO navigation.
Job Type:
- Contract
Workplace Type:
- Remote
Experience Level:
- Executive
Do you have what it takes? Contact Kivara Rajgopal on [Email Address Removed] or [Phone Number Removed];
Desired Skills:
- Configuration
- Migration
- Administration
- IDMS
- DB2
- Database Support
Desired Qualification Level:
- Degree