Db2 Specialist

Sasso Consulting (Pty) Ltd

Johannesburg

Hybrid

ZAR 650,000 - 900,000

Full time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Sasso Consulting (Pty) Ltd invites experienced DB2 Specialists to administer and optimise IBM Db2 environments across enterprise-scale systems. You will ensure high availability, security, and reliable operation of critical databases supporting key applications and services.

The role emphasizes hands-on Db2 administration, performance tuning, backup/recovery, and production support, with collaboration across architects, developers and operations teams in a hybrid setting.

Qualifications

  • Experience administering IBM Db2 in large enterprise environments.
  • Proficient in SQL tuning and query optimisation.
  • Familiar with high-availability configurations and disaster recovery planning.
  • Knowledge of database security, access controls and compliance requirements.

Responsibilities

  • Install, configure and maintain IBM Db2 database environments.
  • Monitor performance, capacity and reliability; optimise SQL and schema design.
  • Manage backups, recoveries, logs and DR testing to ensure RPO/RTO objectives.
  • Configure and enforce security, user roles and audit controls across databases.
  • Collaborate with developers, infrastructure and security teams to ensure resilient DB ecosystems.

Skills

IBM Db2 administration
SQL performance tuning
High availability architectures
Database security

Tools

IBM Db2
SQL

Job description

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
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Db2 Specialist
Db2 Specialist

Sasso Consulting • Johannesburg

Hybrid
ZAR 900,000 - 1,200,000
DB2 Specialist
DB2 Specialist

Sasso Consulting • Centurion

Hybrid
ZAR 600,000 - 1,200,000
DB2 Specialist — Hybrid Contract
DB2 Specialist — Hybrid Contract

Sasso Consulting (Pty) Ltd • Johannesburg

Hybrid
ZAR 650,000 - 900,000
Mainframe DB2
Mainframe DB2

Boardroom Appointments • Johannesburg

On-site
ZAR 900,000 - 1,200,000
Senior IBM DB2 DBA: Performance, Security & HA
Senior IBM DB2 DBA: Performance, Security & HA

Boardroom Appointments • Cape Town

On-site
ZAR 900,000 - 1,200,000
Senior IBM DB2
Senior IBM DB2

Boardroom Appointments • Cape Town

On-site
ZAR 900,000 - 1,200,000
Mainframe DB2 Engineer — Capacity & Performance
Mainframe DB2 Engineer — Capacity & Performance

Boardroom Appointments • Johannesburg

On-site
ZAR 900,000 - 1,200,000
Database Specialist (Contract)
Database Specialist (Contract)

The Focus Group • Sandton

On-site
ZAR 800,000 - 1,100,000
Senior Database Administrator (SQL Server, IBM DB2 & PostgreSQL)
Senior Database Administrator (SQL Server, IBM DB2 & PostgreSQL)

iDbase Software • Johannesburg

Hybrid
ZAR 900,000 - 1,300,000
Senior Database Administrator (SQL Server, IBM DB2 & PostgreSQL)
Senior Database Administrator (SQL Server, IBM DB2 & PostgreSQL)

Idbasesoftware • Johannesburg

Hybrid
ZAR 900,000 - 1,300,000