Database Administrator - DB2

Total Experience : 8 to 15 Years

Technical Area : Mainframe

Specific Requirements :

Product Migration Experience from CA tools/SW to IBM SW/Tools.

Few Examples :

- CA Fast Check for DB2 for z/OS to IBM DB2 Utilities Suite for z/OS

- CA Fast Index for DB2 for z/OS to IBM DB2 Utilities Suite for z/OS

- CA Fast Load for DB2 for z/OS to IBM DB2 Utilities Suite for z/OS

- CA Fast Recover for DB2 for z/OS to IBM DB2 Utilities Suite for z/OS

DB2 System Administration :

- Install, configure, and maintain DB2 subsystems on z/OS

- Perform DB2 upgrades, migrations, and subsystem configurations

- Manage DB2 objects such as databases, tablespaces, tables, and indexes

Database Performance & Tuning :

- Monitor DB2 performance and optimise SQL queries and access paths

- Perform performance tuning using DB2 tools and utilities

- Troubleshoot performance bottlenecks and implement improvements

Backup, Recovery & Utilities :

- Execute DB2 utilities (REORG, RUNSTATS, LOAD, COPY, RECOVER)

- Design and manage backup and recovery strategies

- Ensure database integrity and data availability

Incident & Problem Management :

- Provide L2/L3 support for DB2 - related incidents

- Perform root cause analysis and implement long - term fixes

- Ensure adherence to SLA and timely incident resolution

Change & Release Management :

- Implement DB2 changes via CAB process

- Support deployments, releases, and database migrations

- Maintain version control and change documentation

Security & Compliance :

- Manage DB2 security and access controls

- Ensure compliance with audit and regulatory requirements

- Support audit activities and provide necessary documentation

Capacity Planning & Monitoring :

- Monitor DB2 storage, buffer pools, and resource utilisation

- Perform capacity planning and recommend scaling strategies

Collaboration & Integration :

- Work with application teams, z/OS engineers, and infrastructure teams

- Support application releases, data migrations, and integrations

Required Skills & Qualifications :

- Strong experience in DB2 on z/OS (System & DBA level)

- Knowledge of DB2 utilities (REORG, RUNSTATS, LOAD, COPY, RECOVER)

- Expertise in SQL tuning and performance optimisation

- Familiarity with z/OS, JCL, SDSF

- Experience with DB2 tools (SPUFI, QMF, DB2 Admin Tool)

Skills

DB2, Mainframe, System Administration, DBA, Database Design, Database Maintenance, SQL, z/OS