Mainframe DB2 System DBA

Looking 12+ years of experience

Job title: Mainframe DB2 System DBA

Location: Plano. Texas 75024(Local preferred )

Skills:

IT IS_AMS_Mainframe_DB2 Administration

Typical Requirements (Technical):

• DB2 subsystem installation, migration, and configuration
• DB2 catalog/directory management
• SMP/E installation & maintenance
• DB2 buffer pool tuning, EDM pool tuning
• Managing DB2 logs, BSDS, active/archive logs
• Performance monitoring using OMEGAMON, Mainview, or similar tools
• Applying DB2 PTFs, APAR fixes
• Managing DDF, TCP/IP connectivity for DB2

Gap in Profiles Received:

Most candidates are DB2 DBA or Application Support, lacking experience with DB2 subsystem-level tasks such as installation, SMP/E maintenance, PTF application, and system-level performance tuning.

Below is the original job description shared -

Must Have Technical/Functional Skills:

Install, upgrade, maintain and customize DB2 and its associated IBM and 3rd party software

Monitor DB2 on z/OS environment

Create, modify and maintain the DB2 databases on z/OS environment

Technical system support for DB2 sub systems, database tools and utilities

Support DB2 business, end user and application requirements

Roles & Responsibilities:

Install, upgrade, maintain and customize DB2 and its associated IBM and 3rd party software

Monitor DB2 on z/OS environment

Create, modify and maintain the DB2 databases on z/OS environment

Technical system support for DB2 sub systems, database tools and utilities

Support DB2 business, end user and application requirements