DB2 DBA-ZOS

email your resume to View email address on click.appcast.io 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.