Mainframe DB2 Tools Specialist

Role: Mainframe DB2 Tools Specialist

Location: Remote

Duration: 1 year contract

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

Optional 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 optimization.

• 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 adoption 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.

Years of Experience:

16.00 Years of Experience

Authorization: Applicants must be legally authorized to work in the United States.

Regards,

_______________________

Parthasarathy K

Lead Recruiter

Work: 972-474-8787 Ext: 306,Direct: 972-737-8607

Partha.k@themesoft.com

Themesoft Inc |Themesoft Jobs