Team Lead: IBM DB2 DBA / DB2 Engineer (contract)

About the position

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

Desired Skills:

• Team Lead (DB2 DBA)
• Team Lead (DB2 Engineer)
• Team Lead (DB2 Database Admin)