email your resume to mike@kbtstech.com
Location: Carson City, NV
Duration: 12 Months Contract (Remote work)
W2 role. No C2C
DB2 DBA---ZOS
Project Overview
. 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:
ZOS DB2 DBA consultant must:
• Administer DB2 database and subsystems.
o Monitor storage, support capacity planning, support securing ZOS resources, perform routine maintenance tasks, assist with data migration tasks, troubleshoot and resolve issues.
• Log activity and time using time tracking software (Jira) daily.
• Clone databases and establish additional application environments.
• 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.
• Coordinate upgrades to ZOS, CICS, DB2, Administration tools, and application development tools.
• Coordinate DR testing and support data conversion and migration.
• Discuss business requirements and help with application and database design.
• Support CICS environments.
• 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 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.