DB2 Tools Specialist

Tanisha Systems Inc.; United States; Remote; USD 83,000 - 152,000; Full time

Job summary

Tanisha Systems is seeking expertise in DB2 tooling for a long-term contract. You will migrate DB2 utilities, convert associated JCL and control cards, and deliver documented IBM DB2 utilities configurations. Training on IBM DB2 tools and Infosphere Optim data management will be provided.

You will work with DBAs to minimize impact on applications while enhancing performance, monitoring, and data management capabilities across z/OS environments.

Qualifications

• Experience with migrating and tuning DB2 environments.
• Familiarity with IBM DB2 utilities and replacement tools.
• Comfort with training users on new DB2 tooling.

Responsibilities

• Migrate DB2 Utilities and convert Broadcom-CA JCL and control cards to IBM DB2 utilities parameters.
• Work with IBM DB2 tools and CA replacements; participate in training sessions.
• Assist DBAs with optimization, monitoring and log analysis tasks.

Skills

DB2

Tools

DB2 Tools

CA Tools

InfoSphere Optim

Job description

Workstream: DB2 Tools

Duration: Long-Term Contract

Job Description:

• Migration DB2 Utilities: Conversion of Broadcom-CA DB2 Utility JCL and Control Cards to standard, documented IBM DB2 Utilities parameters and function. Converted DB2 JOBs, PROCs, and Control Cards will be delivered.
• IBM DB2 SQL Performance Analyzer, IBM DB2 Query Monitoring , IBM DB2 Log Analysis Tool, IBM DB2 Administration Tool, IBM DB2 Object Comparison Tool, IBM DB2 Table Editor - training will be provided.
• IBM Infosphere Optim Test Data Management - training will be provided.
• Low to no impact to application development. Impact to DBAs.

Broadcom/CA Tools / IBM Replacement(s):

• CA Log Analyzer - DB2 Log Analysis Tool
• CA Plan Analyzer - DB2 SQL Performance Analyzer or DB2 Performance Solution Pack
• CA Subsystem Analyzer - DB2 Query Monitor for z/OS
• CA Detector - DB2 Query Monitor or DB2 Performance Solution Pack
• CA Index Expert - Query Workload Tuner
• CA Thread Terminator - DB2 Utilities Enhancement Tool for z/OS
• CA-RC/Compare - DB2 Change Management Solution Pack
• CA RC/Migrator
• CA RC/Query
• CA Fast Load - DB2 Extended Utilities Suite
• CA Fast Unload
• CA Fast Recover
• CA-RC/Update - IBM InfoSphere Optim Test Data Management Solution for z/OS
• CA RC/Extract.