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

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 5 years minimum work experience as an IBM DB2 DBA/Engineer.

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.



Between 5 - 7 Years