Mainframe DB2 Tools Specialist

Mainframe DB2 Tools Specialist

Location: Remote
Experience: 16+ Years
Duration: Long-Term Contract

Job Summary

We are seeking an experienced Mainframe DB2 Tools Specialist with strong expertise in IBM Db2 for z/OS, Db2 Tools and Utilities, database administration, and migration activities. The ideal candidate will have hands-on experience migrating Broadcom/CA Db2 Tools to IBM Db2 Tools and converting associated JCL, procedures, and control cards.

Core Technical Skills

• Install, configure, and manage IBM Db2 for z/OS in a Parallel Sysplex environment.
• Install, configure, and administer IBM Db2 Tools and Utility Suites.
• Strong knowledge of Db2 systems programming, utilities, and database administration.
• Establish policies and procedures for database management, security, maintenance, disaster recovery, and utilization.
• Review new IBM Db2 Tool releases and recommend adoption based on business value.
• Evaluate change requests and determine their impact on client environments.
• Provide technical guidance and vendor consultation for Db2 Tools migration activities.
• Lead migrations from Broadcom/CA Db2 Tools to IBM Db2 Tools.
• Convert Broadcom/CA Db2 Utility JCL, PROCs, and Control Cards to IBM Db2 Utilities standards.
• Develop migration project plans covering assessment, conversion, implementation, testing, cutover, and post-migration support.
• Validate converted jobs, procedures, and utilities for operational readiness and IBM standards compliance.

Database Skills

• Db2 for z/OS subsystem administration and maintenance
• Database, Tablespace, Index, and Catalog management
• Db2 Utility execution, monitoring, and optimization
• Backup, Recovery, and Disaster Recovery
• Database change management and migration
• SQL performance analysis and tuning
• Utility scheduling and automation
• Database monitoring and reporting
• Space management and capacity planning
• Package, Plan, and Access Path management
• Performance diagnostics and workload analysis
• Production support and problem determination

IBM Db2 Tool Migration

• Migrate Broadcom/CA Db2 Tools to IBM Db2 Tools.
• Convert Broadcom/CA Db2 Utility JCL and Control Cards to IBM standards.
• Deliver and validate converted Db2 Jobs, PROCs, and Control Cards.
• Analyze existing utility execution processes and implement IBM best practices.
• Develop migration standards, testing strategies, and cutover procedures.
• Support installation and administration of IBM Db2 Tools and Utility Suites.

Preferred / Additional Skills

• Broadcom/CA Db2 Tools administration
• IBM Db2 Tools implementation and support
• z/OS scheduling and automation
• Mainframe systems programming
• Db2 DBA experience
• JCL, REXX, and ISPF
• Utility automation
• SMP/E installation and maintenance experience