Mainframe DB2 Specialist

Mainframe DB2 Specialist
Remote
70/hr on w2
90/hr on T4


Key Skills:
• Db2 for z/OS system programming
• Db2 utilities administration (IBM + Broadcom/CA)
• JCL, PROC & control card conversion to IBM utilities
• Db2 job delivery, testing & documentation

ROLE PROFILE
Job Description/ Responsibilities Core Technical Skills:

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

Eligible to workional Skills:

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

Database Skills:

• Database Administration
• Db2 for z/OS subsystem administration and maintenance.
• Database, Tablespace, Index, and Catalog management.
• Db2 Utility execution, monitoring, and Eligible to workimization.
• Backup, Recovery, and Disaster Recovery procedures.
• Database change management and migration processes.
• 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 Skills

• Conversion of Broadcom/CA Db2 Utility JCL and Control Cards to IBM Db2 Utilities standards.
• Delivery and validation of converted Db2 Jobs, Procedures (PROCs), and Control Cards.
• Analysis of existing utility execution processes and implementation of IBM best practices.
• Development of migration standards, testing strategies, and cutover procedures.
• Install, configure, and manage IBM Db2 for z/OS environments in a Parallel Sysplex architecture.
• Install, configure, and administer IBM Db2 Tools and Utility Suites. Strong knowledge of Db2 systems programming, utilities, and database administration.
• Review new IBM Db2 Tool releases and functionality, providing recommendations on adEligible to workion and business value.
• Lead and execute migrations from Broadcom/CA Db2 Tools to IBM Db2 Tools.
• Convert Broadcom/CA Db2 Utility JCL, Procedures, and Control Cards to IBM Db2 Utilities standards.