Mainframe Administrator

Hiring : W2 Candidates Only

🛂  Visa :  Open to any visa type  with valid work authorization in the USA

Description

• Design and maintain DB2 Database applications which have the following characteristics :
• Design for high availability.
• Design for maximum performance.
• Maintain and develop techniques and proceduresto provide 24x7 availability.
• Provide production and test database support ina complex environment.
• Perform all functions which are performed by a DB2 Database Administrator, such as :
• SQL code reviews.
• Performance Monitoring and Tuning DB2 at theapplication database level.
• Enforce appropriate DB2 security standards.
• Collaborate with the DB2 systems programmingstaff to appropriately manage DSNZPARM settings.
• Create, manage and support DB2 StoredProcedures, DB2 Triggers, and DB2 Referential Integrity.
• Create Change Requests, Resolve ServiceRequests, Provide 24x7 On call support.
• Provide DB2 Connect configuration access supportfor individual users and distributed systems.
• Coordinate with team members on technicaldecisions and directions.
• Work with Management to develop projectschedules.
• Provide Database performance and tuning whichtypically involves collaboration between Data Center, Technical Operations,Database Design and Administration, and the various software development areas.
• Responsible for the evaluation and creation ofappropriate backup and recovery strategies for new database requirements.
• Participate in Disaster Recovery planning.

Qualifications

Excellent knowledge of DB2 z / OSDatabase Support, including but not limited to the following :

z / OS Mainframe skills, but notlimited to the following :

Additional Desired Skills :

Skill

Required / Desired

Years Used

Last Used

10+ years DB2 experience

Required

Excellent knowledge of DB2 z / OS Database Support, including but not limited to the following-

Required

z / OS DB2 12 for zOS or higher in a production environment with high transaction rates

Required

High availability 24x7 designs and techniques

Required

Managing large data stores

Required

DB2 V10 utilities setup and execution

Required

DB2 performance and tuning

Required

Data Modeling expertise - logical and physical design

Required

Complex SQL coding / tuning

Required

Data Warehouse design with an understanding of OLAP design and query solutions

Required

DB2 attachments / interfaces include DRDA, DB2 Connect

Required

DB2 tools skill set will include, but not limited to the following : QMF & IBM (Data Studio, OPTIM Workload Query Tuner, File Manager, Tivoli OMEGAMON)

Required

DB2 tools skill set will include, but not limited to the following : IBM DB2 (Administration Tool, Automation Tool, Explain, Query Monitor)

Required

z / OS Mainframe skills, but not limited to the following : TSO & ISPF, JCL, DFSORT & / or ICETOOL, REXX, z / OS Utilities

Required

Problem solving and analytical skills

Desired

Ability to organize and prioritize workflow and projects

Desired

Excellent written and oral communication skills

Desired

DB2 V9 or V10 Certification preferred

Desired

IMS Database experience

Desired

IMS Database Utilities (IBM, BMC, NEON, etc.)

Desired

ETL tools experience (InfoShere, Informatica, etc.)

Desired