Application Systems Analyst / Programming Manager 4

DMV Consultant

This is a short-term assignment. There is a potential of a short extension if needed. 20-30/hrs a week expected. Must reside in the U.S. Prepare for BAFO

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.

Responsibilities

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:
• 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.

Required /Desired Skills

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

Vendor Provided Items

• Personal computer equipment for any potential remote work that meets State security standards.