Db2 Database Administrator

Aurionpro; Bengaluru; On-site; INR 1,400,000 - 2,300,000; Full time

Job summary

Aurionpro in Bengaluru seeks a seasoned Mainframe DB2 z/OS DBA with 8 to 15 years of experience to join our team. You will install, configure, and maintain DB2 subsystems, perform upgrades, migrations, and manage databases, tablespaces, and indexes.

Responsibilities include monitoring performance, SQL tuning, running DB2 utilities, implementing backup/recovery strategies, handling incidents, and collaborating with z/OS, application, and infrastructure teams to ensure data availability and

Qualifications

• Extensive DB2 for z/OS system administration experience.
• Migration experience from CA tools to IBM DB2 Utilities Suite for z/OS is required.
• Strong knowledge of performance tuning and security/compliance for mainframe DB2.

Responsibilities

• Install, configure, and maintain DB2 subsystems on z/OS.
• Perform upgrades, migrations, and subsystem configurations.
• Manage DB2 objects such as databases, tablespaces, tables, and indexes.
• Monitor DB2 performance and optimise SQL queries and access paths.
• Execute DB2 utilities (REORG, RUNSTATS, LOAD, COPY, RECOVER) and design backup/recovery strategies.
• Provide L2/L3 support for DB2-related incidents and root-cause analysis.
• Support CAB/change/release processes and collaborate with z/OS/infrastructure teams.

Skills

DB2 on z/OS

SQL tuning

z/OS/JCL/SDSF

Tools

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

SPUFI

QMF

Job description

• Total Experience: 8 to 15 Years
• Technical Area: Mainframe

DB2:

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

General Requirements:

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

Technical Skills

• 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)