Senior Mainframe Idms Database Administrator

Overview:
Expleo is a trusted partner for end-to-end, integrated engineering, quality services and management consulting for digital transformation. We are a talent incubator. The time you spend at Expleo will turbo-charge your career, allowing you to work on complex technical challenges, enjoy opportunities to expand your skills and take part in inspiring, multi-disciplinary collaborations with your colleagues. Whether working on autonomous vehicles, green planes, the factories of tomorrow or cutting-edge banking technology, you will have the opportunity to become a bolder version of yourself. Let’s change the game together.

We are seeking a highly experienced **Senior Mainframe IDMS Database Administrator** to join our team and provide critical database support for our client in **Johannesburg (Remote).**

**Role Overview**:
**Responsibilities**:

- 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 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.

Qualifications:

- IT degree or equivalent Industry accreditation preferred

Essential skills:
**Technical Skillset**:

- 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.

**Experience**:

- Approximately 20 years of experience in hands-on IDMS database support within a large, complex corporate environment.
- Extensive expertise in Z/OS, DB2 Mainframe, and IDMS Database administration.
- Strong knowledge of mainframe systems architecture, operating system concepts, and related database management tools.
- Proven experience in problem-solving, troubleshooting, and optimising database performance.
- Ability to work independently in a remote environment, effectively managing workloads and meeting deadlines.
- Demonstrated experience in participating in disaster recovery (DR) exercises.

**Benefits**:
We are guided by shared values in all things we do**: Courage, Excellence, Collaboration, Respect and Accountability.**
- Courage - We are bold thinkers and doers, always ready to take on new challenges. We think of ourselves as entrepreneurs, matching creativity with vigilance.
- Excellence - We are united by a shared ambition: change the game, together. Continuous performance is both an objective and a mindset.
- Collaboration -Teamwork and emotional intelligence are what makes us stand out in a crowd. We stand shoulder to shoulder, with our clients and our peers, through good times and setbacks.
- Respect - We are a hive of different profiles, and we place a high value on openness and transparency. We show respect, always.
- Accountability - We are reliable. We celebrate our successes, we take responsibility and learn from our failures. This is why we protect our “right to fail” as an opportunity to bounce back and progress.