Mainframe Systems Programmer

Job Description Experience and Skills Required

ZOS DB2 DBA consultant must:

• Havethe capability to perform the functions described in Scope of Work section.
• Havea bachelor's degree in computer science, or any other equivalent degree or equivalent years of relevant experience, with a minimum of seven (7) years of DB2 DBA experience in ZOS platform.
• Have experience administering complex DB2 environments with multiple subsystems.
• Be experienced working on ZOS tools and utilities - TSO, ISPF, SDSF, JCL, DFSORT, ICETOOL, DFDSS, DFSMS, DFHSM, OMVS, RACF, REXX/CLIST.
• Be experienced with using DB2 tools - SPUFI, QMF, DB2 Admin Tool or equivalent, DB2 Object Compare or equivalent, IBM Data Studio, OMEGAMON or equivalent, Query Monitor or equivalent.
• Be proficient with DB2 utilities and DB2 backup and recovery.
• Beable to work with the DMV IT teams to understand the requirements and design databases.
• Beable to implement and migrate database changes.
• Have experience securing database objects.
• Have expertise in evaluating and tuning SQL and experience tuning DB2 subsystem.
• Have knowledge of DB2 Attachment facilities.
• Havegood knowledge of COBOL/CICS/DB2 application programming environment.
• Havegood communication, documentation and user requirement gathering skills.
• Be proficient in analyzing, debugging, and troubleshooting issues and ABENDs.
• Bea team player who can work with other contractors/consultants and permanent employees under a complex team structure.

• Experience installing and configuring DB2 Connect.
• Experience working with Application Lifecycle Management tools like LCM, CHANGEMAN, ENDEVOR, SCLM, RTC, or similar.
• Experience working with data modeler tools like ERWIN or similar.

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, , ASP.NET, COBOL, DB2, 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.

The consultant will be working on the following but not limited to:

• Administer DB2 database and subsystems.
• Monitor storage, support capacity planning, support securing ZOS resources, perform routine maintenance tasks, assist with data migration tasks, troubleshoot and resolve issues.
• 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.

• Consultant must provide the following based on the agreement upon project plan/schedule.
• Manage, monitor, and tune DB2 subsystems and application environments.
• Clone databases and establish additional