Ryvo — What's next?Book a Call
Engineering · IT

Mainframe Cobol/DB2 Programmer

Mainframe development on COBOL, CICS, DB2, JCL and ZEKE for the Nevada DMV. Reports, data exports, SQL tuning, DR support and database migrations.

Apply for this role →All openings
Team

Engineering

Level

Senior

Location

State of Nevada, United States

Job type

Contract Remote

Experience

Minimum 9 years

Work authorization

No H1B visa sponsorship; EAD, Green Card, Citizens only

Scope of Work

  • 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

  • Complete work and project tasks assigned.
  • Provide daily / weekly status reports of the project with details on tasks and hours spent on each task.
  • 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

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