Job Description :
Position:Mainframe Database Administrator
Location:Chicago, IL.
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 database security 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