IMS DB2 Database Administrator

Description

Required / Desired Skills Skill Required / Desired Amount of ExperienceIBM DB2 Admin Tools Required 5 YearsIBM DB2 Automation Tools Required 5 YearsApplication Debugging (COBOL/IMS TM & IMS DB) Required 5 YearsDB2 for z/OS Required 5 YearsIMS Hierarchical Database Experience Required 5 YearsDB2 Relational Database Architecture Experience Required 5 YearsTCP/IP, Customer Information Control System (CICS) Required 5 YearsLINUX for IBM/z Series Required 5 YearsQuery Management Facility (QMF) Required 5 YearsOmegamon for DB2 Required 5 YearsDescription The Product Specialist support for IMS Hierarchical Database and DB2 Relational Database Architecture. Primary responsibility is to ensure availability and facilitate productive use of a product for Application Teams or end users.Work Guidelines Contractor personnel have learned the executive software environment, both functionally and technically, through systems documentation, related documentation, and discussions with PennDOT employees. Normal hours of work are eight (8) hours per day within the range of 7 30AM and 5PM, plus offhour availability (after hour calls outside this timeframe). Person proposed is positive, selfmotivated team players with good oral and written communication skills. The contractor is responsible for completing all work assigned and follows the methodology described below. Analysis Research and analysis of software problems and new releases. Research and analyze impact of problem resolution and new release implementation on systems applications. Testing Conduct sandbox, development, system, integration and user acceptance testing of the system changes. Implementation Migration to the production environments and integration of all system interfaces, usually Sunday mornings. Skill Requirements Positions have the following technical and analytical skills to perform administrative and maintenance functions on the following executive software. IMS/DB, IMS/TM, DB2 for z/OS, DB2 UDB for Linux, Unix and Windows, ORACLE DB IBM DB2 Admin Tools, IBM DB2 Automation Tools Information Management System (IMS), Application Debugging (COBOL/IMS TM & IMS DB), COBOL/MVS & LE/370 Additional technical and analytical skills in the following areas are helpful. Data Facility Systems Managed Storage / Multiple Virtual Storage (DFSMS/MVS), Data Facility Hierarchical Storage Manager (DFHSM) Device Support Facilities (DSF), TCP/IP, Customer Information Control System (CICS) LINUX for IBM/z Series Query Management Facility (QMF) Omegamon for DB2 FILEAID for DB2 Job Specifications Product Specialist support for IMS Hierarchical Database and DB2 Relational Database Architecture Position performs highly advanced technical work in mainframe operating systems and database management. Install and maintain mainframe database architecture of IMS and DB2. Perform advanced technical work to establish and maintain databases supported by BIO, which includes IMS, DB2, and DB2 Universal Database (UDB) for z/OS and NT. Support physical database design and development and implementation of database recovery, reorganization and backup procedures as well as the monitoring of database performance. Provide technical assistance to application developers for problems and procedures related to the use of all listed executive software. Insure systems have adequate resources to support the current operating environment and plans for new development and anticipated expansion of databases. Assist in managing the Department's DASD inventory to ensure that all production databases and systems have adequate resources. Provide technical assistance and problem analysis and resolution for the mainframe operating system and the listed executive software. Serve as the lead technical support for performance, design, and change implementation in the following architecture.