Job Description:
****No Corp to Corp, Only W2/ 1099 Resumes will be considered
Scope of Work
The consultant will be working on the following but not limited to:
- COBOL, CICS, DB2 queries, JCL, ZEKE.
- Produce extensive reports and data exports.
- Provide status reports as required by DMV personnel.
- Log activity and time using DMV time tracking software (Jira) daily.
- Follow guidelines established by Nevada DMV.
- Support DMV IT teams as needed.
- Document changes and follow protocols established by Nevada DMV.
- Promptly and accurately respond to Webex, MS Teams, emails, etc.
- Interact with DMV IT teams and complete the assigned tasks in the scope of work
- Strictly follow DMV IT standards and procedures
- 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 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.
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:
- o Overall completion status of the project in terms of the approved project plan and schedule.
- o Document problems that were encountered and proposed/actual resolution.
- o Document issues that need to be addressed.
- o Document accomplishments during the period.
- o Document activities to be accomplished during the next reporting period.
Required Skill:
- Have the capability to perform the functions described in Scope of Work section.
- Have relevant experience, with a minimum of nine (9) years in COBOL, CICS, DB2 queries, JCL.
- Have experience working in complex DB2 environments with multiple subsystems.
- Be experienced working on ZOS tools and utilities - TSO, ISPF, SDSF, JCL, RACF, REXX.
- Be experienced with using DB2 tools - SPUFI, QMF or equivalent.
- Be proficient with making entries in DB2 utilities.
- Be able to work with the DMV IT teams to understand the requirements and design databases.
- Have expertise in evaluating and tuning SQL queries.
- 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.
Preferred Skills:
- Experience configuring DB2 Connect.
- Experience working with Application Lifecycle Management tools like LCM, SCLM, RTC, or similar.