Project Overview

The Department
of Motor Vehicles (DMV) application (CARRS) is an integrated system that is
supported by both client server and web applications written in Power Builder,
VB.NET, ASP.NET, COBOL, DB2, ZEKE, JCL, CICS, and SQL Server.  The DMV application has over 900 internal
users, 800,000 portal accounts, many external customers, and interfaces with
local, State and Federal agencies. The core application runs on System Z with
multiple CICS and DB2 environments secured by RACF. The core application is
COBOL/DB2 programs that run both in batch and CICS environments. 

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.

Experience and Skills Required

·         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.

Experience and Skills Preferred

·         Experience with PowerBuilder
programming

·         Experience configuring DB2
Connect.

·         Experience working with
Application Lifecycle Management tools like LCM, SCLM, RTC, or similar.