Mainframe Database Administrator


Chicago, IL

Industry: e-Commerce


8 - 10 years

Posted 280 days ago

  by    Gaurav Kumar

This job is no longer available.

Role                     : Mainframe Database Administrator

Location              : Chicago,IL

Emp Type           : Permanent Job

Interview           : Phone/Skype


Job Description

Title of Position : Mainframe Database Administrator (on z/OS)

Summary of key responsibilities

?                   Knowledge acquisition from incumbent on Mainframe service delivery

?                   Identify risk during transition, provide mitigation and track till completion

?                   Manage escalations and track Service Delivery and ensure SLA compliance including with vendors

?                   Review and update the SOP documents on regular basis

?                   Support on all in-flight and upcoming project activities

?                   Recommend and perform customer-approved database streaming and replication procedures

?                   Ensure completion of authorized Service Requests, Changes, Problem tickets

?                   Experience with database physical and logical design, query analysis and optimization

?                   Define and provide guidance for database creation, configuration, upgrade, patches and refresh requirements

?                   Recommend operating system and database performance monitoring, tuning and configuration changes

?                   Provide technical assistance and subject matter expertise to applications groups

?                   Provide database storage management and capacity management recommendations

?                   Define and manage databasesecurity and access permissions in consultation with customer

Years of Experience

?                   7+ Years of experience in IDMS v17 & v18.5, DB2 v10, VSAM Database Administration on z/OS

?                   Technical requirements

?                   Experience in IDMS v17 & v18.5 (Primary), DB2 v10, VSAM Database Administration on z/OS

?                   IDMS, VSAM, DB2 internals, installation, upgrade, patching, configuration and operations

?                   Logical and physical database design skills

?                   Experience in SMPE and ISV tools installation and migration

?                   Create and maintain database entities, including instances, databases, table spaces and tables

?                   Experience in Data Sharing setup in Parallel Sysplex environment

?                   Database DR, Cloning, Backup/Recovery, HA and Point In Time Recovery (PITR) expertise

?                   Experience with Database ISV Tools and Products like OmegaMon and AdminTool

?                   Proficiency in IDMS, DB2, VSAM Systems Performance Tuning and Capacity Planning

?                   Application related performance tuning; Write, modify, and debug database specific SQL queries

?                   DBA related utilities like Unload, Load, DSNJU003, DSNJU004,Reorg, Runstats, image copy

?                   REXX, CLIST, JCL, JES and Assembler knowledge


IDMS v17 & v18.5, DB2 v10, VSAM Data Sharing, Buffer Pool tuning, PITR