Job Description

Closing Date: 2025-11-02
Job Type: Contract
Job Level: Management
Experience: Between 7 - 10 Years
EE/AA: No
Summary

• Only South African citizens or Permanent Residents with SA ID numbers can apply.
• 1 year contract (no extension/no renewal).
• Type: Full-time work from Mondays - Fridays (8 - 9 working hours per day).
• After-hours/weekends: Possible standby/support hours required.
• Must have 7 years minimum work experience as an IBM DB2 DBA/Engineer.
• Must have 3 years minimum work experience as a Team Lead (IBM DB2).
• MUST HAVE a valid driver's license and own car.
• MUST HAVE: IBM Certified Administrator on IBM Db2 12 for z/OS.
• Travelling involved: Project will cover the entire Gauteng region (JHB North, East, South & West). Must be prepared to travel with own car (petrol costs included in salary/rate).
• Rate per hour neg.
• No criminal record.

Description

• Maintain and optimize DB2 databases to ensure high performance, availability, and security.
• Work closely with application and infrastructure teams to support critical business operations.
• Database Administration: Install, configure and upgrade DB2 database servers and related tools.
• Perform daily administration, maintenance, and monitoring of DB2 databases to ensure optimal performance. Ensure database performance, integrity, and availability are always maintained.
• Performance Tuning and Optimization: Analyse and optimize SQL queries, indexes, and database configurations for maximum efficiency.
• Continuously monitor database performance and resource utilization, ensuring optimal operation.
• Identify performance bottlenecks and implement improvements for enhanced database efficiency.
• Backup and Recovery: Develop and manage comprehensive backup, recovery, and disaster recovery plans to safeguard critical data.
• Perform database restoration and recovery testing to ensure compliance with Recovery Time Objectives (RTOs) and Recovery Point Objectives (RPOs).
• Security and Compliance: Implement and maintain database security best practices, including access control measures and data encryption.
• Database Design and Development: Design and optimize logical and physical database structures, including tablespaces, schemas, and indexes.
• Collaborate in database modelling, partitioning, and developing strategies to enhance database performance and scalability.
• Automation and Scripting: Develop and implement scripts for automating database monitoring, maintenance tasks, and alerts.
• Utilize scripting languages such as Shell, Perl, or Python to streamline database management and improve efficiency.
• Collaboration and Support: Work closely with application developers and system administrators to optimize database integration. o Provide expert-level database support for application deployments, system upgrades, and troubleshooting.
• Documentation: Maintain comprehensive and up-to-date documentation of database environments, configurations, processes, and standards.

Minimum Requirements
Qualifications & experience required:

• Matric plus IT degree/diploma OR relevant IBM certification and good work experience.
• MUST HAVE: IBM Certified Administrator on IBM Db2 12 for z/OS.
• Must have 7 years minimum work experience as an IBM DB2 DBA/Engineer.
• Must have 3 years minimum work experience as a Team Lead (IBM DB2) with ability to manage and supervise a team of DB2 DBA/Engineers.

Technical skills required:

• IBM DB2 Database Administration (5 years' experience required).
• Strong SQL query optimization and performance tuning skills.
• Experience with HADR (High Availability Disaster Recovery) setup and troubleshooting.
• Familiarity with database backup and recovery techniques.
• Proficiency in Linux/UNIX systems.
• Experience required with IBM Z (mainframe), IBM AS/400, Linux, UNIX and/or Windows.
• Scripting languages like Shell, Python, or Perl.
• Understanding of database security principles and auditing.
• Monitoring tools (IBM Data Management Console - DMC) or Nagios or Zabbix.

Skills Required