DB2 DBA-ZOS

KBTS Technologies, Inc.
Carson City, United States of America
yesterday

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Remote
Carson City, United States of America

Tech stack

Java
Admin Tools
Application Lifecycle Management
JIRA
Customer Information Control System (CICS)
CLIST
COBOL
Databases
Data Conversion
Data Migration
Data Security
IBM DB2
Database Design
Software Debugging
Programming Tools
Job Control Language (JCL)
Rexx (Programming Language)
IBM System Z
Interactive System Productivity Facility (ISPF)
IBM Resource Access Control Facility
SQL Databases
Subsystems
Time Tracking Software
Z/OS
Omegamon

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.

Apply for this position