z/OS/DB2 Database Administrator - $102 on 1099 / $89 W2 - HYBRID

Job Description:

****No Corp to Corp, Only W2/ 1099 Resumes will be considered

Scope of Work

Consultant must provide the following based on the agreed upon project plan/schedule:

• Manage, monitor, and tune DB2 subsystems and application environments.
• Clone databases and establish additional application environments.
• DB2 database and dataset backup and recovery.
• Refresh data, as needed.
• Clone and establish additional application environments, as needed.
• Aid in data conversion projects and extract data to staging environments, as needed.
• Maintain privacy and security of data.
• Support Application Lifecycle, application development tools, as needed.
• Migrate database changes.
• Document and update procedures and check list.
• Coordinate upgrades to ZOS, CICS, DB2, Administration tools, and application development tools.
• Coordinate DR testing and support data conversion and migration.
• Help DMV IT teams with SQL review and tuning.
• Discuss business requirements and help with application and database design.
• Support CICS environments.

Deliverables

Consultant must:

• Complete work and project tasks assigned.
• Consultant must provide daily / weekly status reports of the project with details on tasks and hours spent on each task, as well as:
• Overall completion status of the project in terms of the approved project plan and schedule.
• Document problems that were encountered and proposed/actual resolution.
• Document issues that need to be addressed.
• Document accomplishments during the period.
• Document activities to be accomplished during the next reporting period.

Experience and Skills Required

ZOS DB2 DBA consultant must:

• Have the capability to perform the functions described in Scope of Work section.
• Have a bachelor's degree in computer science, or any other equivalent degree or equivalent years of relevant experience, with a minimum of seven (7) years of DB2 DBA experience in ZOS platform.
• Have experience administering complex DB2 environments with multiple subsystems.
• Be experienced working on ZOS tools and utilities - TSO, ISPF, SDSF, JCL, DFSORT, ICETOOL, DFDSS, DFSMS, DFHSM, OMVS, RACF, REXX/CLIST.
• Be experienced with using DB2 tools - SPUFI, QMF, DB2 Admin Tool or equivalent, DB2 Object Compare or equivalent, IBM Data Studio, OMEGAMON or equivalent, Query Monitor or equivalent.
• Be proficient with DB2 utilities and DB2 backup and recovery.
• Be able to work with the DMV IT teams to understand the requirements and design databases.
• Be able to implement and migrate database changes.
• Have experience securing database objects.
• Have expertise in evaluating and tuning SQL and experience tuning DB2 subsystem.
• Have knowledge of DB2 Attachment facilities.
• Have good knowledge of COBOL/CICS/DB2 application programming environment.
• Have good communication, documentation and user requirement gathering skills.
• Be proficient in analyzing, debugging, and troubleshooting issues and ABENDs.
• Be a team player who can work with other contractors/consultants and permanent employees under a complex team structure.

Experience and Skills Preferred

• Experience installing and configuring DB2 Connect.
• Experience working with Application Lifecycle Management tools like LCM, CHANGEMAN, ENDEVOR, SCLM, RTC, or similar.
• Experience working with data modeler tools like ERWIN or similar.