Application Systems Analyst / Programming Manager

Role Description

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 daily using DMV time tracking software (Jira).
• Follow guidelines established by the Nevada DMV.
• Support DMV IT teams as needed.
• Document changes and follow protocols established by the 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 data privacy and security.
• Support Application Lifecycle and application development tools, as needed.
• Migrate database changes.
• Document and update procedures and checklists.
• Coordinate DR testing and support data conversion and migration.
• Help DMV IT teams with SQL review and tuning.
• Discuss business requirements and assist with application and database design.

Qualifications

• 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 z/OS 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 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.