ZOS DB2 DBA Mainframe Systems

Job Title:ZOS DB2 DBA - 158982

Duration:6 Months (Potential to extend into 2027 calendar year but wont know until we get closer to the end of 2026.)

ZOS DB2 DBA consultant must:

• Have the capability to perform the functions described in Scope of Work section.
• Have a bachelors 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.
• Be able to work with the DMV IT teams to understand the requirements and design databases.
• Be able 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.
• 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 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.

ExperienceLevel4GreaterthanNine(9)Years

ProjectOverview

TheDepartmentofMotorVehicles(DMV)application(CARRS)isanintegratedsystemthatissupported bybothclientserverandwebapplicationswritteninPowerBuilderCOBOLDB2CICS and SQL DMV application has over 900 internal users 800000 portal accounts many

external customers and interfaces with local State and Federal agencies. The core application runs on SystemZwithmultipleCICSandDB2environmentssecuredisCOBOL/DB2 programs that run both in batch and CICS environments.

Theconsultantwillbeworkingonthefollowingbutnotlimitedto:

AdministerDB2databaseandsubsystems.

o MonitorstoragesupportcapacityplanningsupportsecuringZOSresourcesperform routinemaintenancetasksassistwithdatamigrationtaskstroubleshootandresolveissues.

ProvidestatusreportsasrequiredbyDMVpersonnel.

LogactivityandtimeusingDMVtimetrackingsoftware(Jira)daily.

FollowguidelinesestablishedbyNevadaDMV.

SupportDMVITteamsasneeded.

DocumentchangesandfollowprotocolsestablishedbyNevadaDMV.

TheconsultantwillworkwithDMVITteamsandcompletetheassignedtasksinthescopeofworkin accordance with the DMV IT standards and procedures.

ScopeofWork

Consultantmustprovidethefollowingbasedontheagreeduponprojectplan/schedule:

ManagemonitorandtuneDB2subsystemsandapplicationenvironments.

Clonedatabasesandestablishadditional

Required Skills:

Mainframe