Role: Mainframe Analyst with DB2 Location: Des Moines, IA Duration: 12+ Months
Qualifications: Ability to understand mainframe DB2 in a data sharing environment Ability to use, install, maintain, and troubleshoot issues with IBM and BMC tools including logmaster, Apptune, reorg, load, unload, Catalog and Change manager, MainView, etc. Ability conduct performance monitoring and tuning activities on DB2 databases Create and maintain the performance of stored procedures Experience with IBM Utilities and JCL Working with operations and production support Team to fix the DB2 related Job failures
Additional desired skills: Ability to use mainframe SMPE Ability to use ITSM tools like Cherwell Ability to use Jira and Confluence .
More notes on role: This team is responsible for mainframe databases, infrastructure, and report for the DBAs within the business unit. Working on installing and upgrading DB2, apply maintenance, troubleshoot issues, and will be a part of the on-call team. Two teams merged earlier this year, so they are responsible for the install of all DB2 tools and utilities. Will help with performance tuning of queries, help with JCL and SQL, receive tickets coming through Sharewell, and providing overall maintenance. Help to support IMS (this would be a nice to have if someone's done this before) Mainframe SMPE is preferred, but can train on it if the candidate doesn't have the skills. Will most likely help complete an upcoming upgrade. IDAA-would be a nice to have
Associated topics: automotive, breakdown, customer service, field service, field service technician, machine repair, maintenance, repair, troubleshoot, upgrade