DB2 DBA-ZOS
Role details
Job location
Tech stack
Job description
email your resume to 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
Requirements
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.