DB2 Specialist
Location: Gauteng
Positions Available: 5
Salary: Market-related
Employment type: 3 Year contract, hybrid
Job Overview
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.
Key Responsibilities
IBM Db2 Database Administration
- Install, configure, administer and maintain IBM Db2 database environments.
- Support enterprise Db2 database instances and associated services.
- Configure databases, tablespaces, 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.
Database Performance Monitoring and Optimisation
- 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.
Backup, Recovery and Disaster Recovery
- 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 rollforward 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.
High Availability and Database Replication
- Support high-availability Db2 database architectures.
- Configure and maintain High Availability Disaster Recovery (HADR) environments where applicable.
- Monitor database replication and synchronisation.
- Support database failover and recovery procedures.
- Troubleshoot replication delays and availability incidents.
- Maintain resilient database configurations.
- Participate in failover and disaster recovery exercises.
- Identify potential single points of failure.
- Collaborate with infrastructure teams on high-availability requirements.
- Recommend improvements to database resilience.
Database Security and Access Management
- Implement database security and access control requirements.
- Manage database users, roles and privileges.
- Configure authentication and authorisation controls.
- Support integration with enterprise identity management systems.
- Apply least-privilege access principles.
- Monitor database security events and audit records.
- Support database encryption and secure connectivity.
- Investigate unauthorised access or suspicious database activity.
- Assist with vulnerability assessments and security remediation.
- Ensure compliance with organisational security policies and applicable regulations.
SQL and Database Development Support
- Develop and optimise complex SQL queries.
- Support stored procedures, functions and database objects.
- Review database schema changes and application requirements.
- Troubleshoot SQL errors and transaction processing issues.
- Assist development teams with database connectivity and integration.
- Evaluate query performance and execution plans.
- Support database object deployment and configuration.
- Ensure database changes follow approved standards.
- Assist with application release testing.
- Provide specialist Db2 technical guidance.
Database Storage and Capacity Management
- Monitor database storage utilisation and growth.
- Manage tablespaces, containers and database storage allocations.
- Support database capacity forecasting and planning.
- Identify storage-related performance and availability risks.
- Coordinate storage expansion with infrastructure teams.
- Monitor transaction log utilisation.
- Optimise database storage structures.
- Support data archival and retention requirements.
- Maintain storage configuration documentation.
- Recommend improvements to database resource efficiency.
Operating System and Infrastructure Integration
- Support Db2 databases running on