DB2 Specialist

• Maintain automated maintenance schedules.

Location: Gauteng

Positions Available: 5

Salary: Market-related

Employment type: 3 Year contract, hybrid

We are seeking experienced and technically proficient DB2 Specialists to administer, maintain, optimise, secure and support enterprise IBM Db2 database environments within complex, high-availability IT infrastructures.

The successful candidates will be responsible for ensuring the performance, availability, integrity, security and operational reliability of business-critical Db2 databases supporting enterprise applications and services.

This role requires substantial hands-on expertise in IBM Db2 database administration, SQL performance tuning, database configuration, backup and recovery, high availability, database security and production troubleshooting
.

The ideal candidates will have proven experience supporting large-scale IBM Db2 environments, managing complex database workloads, diagnosing performance problems and implementing resilient database solutions.

Candidates should understand enterprise database architecture, operating system integration, data replication, disaster recovery and structured IT service management processes.

The role requires collaboration with database architects, application developers, infrastructure engineers, systems administrators, cybersecurity specialists and enterprise operations teams.

This is a specialist IBM Db2 role requiring substantial hands-on Db2 administration and technical support experience. General SQL development, Microsoft SQL Server administration, Oracle administration or reporting experience without practical Db2 expertise will not be sufficient.

• Install, configure, administer and maintain IBM Db2 database environments.
• Support enterprise Db2 database instances and associated services.
• Configure databases, table spaces, buffer pools and storage structures.
• Manage database parameters and configuration settings.
• Monitor database availability, health and operational performance.
• Perform database maintenance and housekeeping activities.
• Support database upgrades, fix packs and patching.
• Maintain database environments across development, testing and production.
• Troubleshoot database configuration and operational issues.
• Ensure compliance with database administration standards.

• Monitor database performance, throughput and resource utilisation.
• Analyse SQL execution plans and identify performance bottlenecks.
• Optimise SQL queries, indexing strategies and database structures.
• Investigate locking, deadlocks and transaction performance issues.
• Tune buffer pools, memory allocation and database configuration.
• Evaluate database workload patterns and capacity requirements.
• Support performance testing and benchmarking.
• Identify inefficient database access patterns.
• Recommend improvements to database performance and scalability.
• Collaborate with application developers on query optimisation.

• Configure and maintain Db2 backup and recovery procedures.
• Perform full, incremental and online database backups where supported.
• Manage transaction logs and recovery configurations.
• Execute database restore and roll forward recovery procedures.
• Validate backup integrity and recovery readiness.
• Support disaster recovery planning and testing.
• Define and support recovery time and recovery point objectives.
• Maintain recovery documentation and operational procedures.
• Investigate backup and recovery failures.
• Ensure business-critical databases can be restored reliably.

• Support high-availability Db2 database architectures.
• Configure and maintain High Availability Disaster…