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 OperationsDatabase 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 DB2 12 for zOS or higher in a production environment with high transaction rates
- High availability 24x7 designs and techniques
- Managing large data stores
- DB2 V10 utilities setup and execution
- DB2 performance and tuning
- Data Modeling expertise - logical and physical design
- Complex SQL coding / tuning
- Data Warehouse design with an understanding of OLAP design and query solutions
DB2 attachments/interfaces include DRDA DB2Connect
DB2 tools skill set will include but is notlimited to the following:
IBM Data Studio
IBM DB2 Administration Tool
IBM DB2 Automation Tool
IBM DB2 Explain
IBM DB2 Query Monitor
IBM OPTIM Workload Query Tuner
IBM File Manager
IBM Tivoli OMEGAMON
QMF
z/OS Mainframe skills but notlimited to the following:
- TSO and ISPF
- JCL
- DFSORT and /or ICETOOL
- REXX
- z/OS Utilities
Additional Desired Skills:
- Problem solving and analytical skills
- Ability to organize and prioritize workflow and projects
- Excellent written and oral communication skills
- DB2 V9 or V10 Certification preferred
- IMS Database experience
- IMS Database Utilities (IBM BMC NEON etc.)
- ETL tools experience (InfoShere Informatica etc.)
| Skill | Required / Desired |
| 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 |
Recommended Jobs
FOOD SERVICE UTILITY (FULL TIME)
Unidine Unidine is hiring immediately for full time **FOOD SERVICE UTILITY** positions. + **Location** : Creekside Retirement Community - 1433 VetsMem Parkway, Huntsville, TX 77340. + **Schedule** : F…
Electric Sign Installer
We are seeking a skilled Sign Installer to join a local team! The Sign Installer’s responsibilities include reading and interpreting design layouts, safely operating machinery, and installing vario…
Robotics Computer Engineer
**Description** The Guidance, Navigation, Control, and Autonomy Branch of the Leidos Innovations Center provides cutting-edge navigation for customers who can't rely on GPS alone, and we need your hel…
Fire Sprinkler Helper
Established in 2009, Impact Fire Services was the vision of a group of experienced industry professionals that wanted to build a best-in-class fire protection and life safety company. Through superior…
CDL Class A Driver
Disclaimer : This position is with FreightFishers, LLC. JOB SUMMARY : The CDL-A Truck Driver will play a key role in delivering FreightFishers frozen seafood products safely, efficiently, and…
Licensed Practical Nurse ( LPN ) PRN
Are you a compassionate Licensed Practical Nurse ( LPN ) looking for a fulfilling role in a supportive environment? Do you want to work where your contributions are valued, with opportunities for gro…
Auto Glass Technician (Dothan, AL)
B? Unmatched Support: Benefit from our 15 specialized departments, including several that operate 24/7, ensuring you have the support you need whenever you need it. Streamlined Operations: Our i…
Oncology Data Specialist (ODS) Subject Matter Expert
Oncology Data Specialist (ODS) Subject Matter Expert Fully Remote-United States Job Type Full-time Description **Overview** Tanaq Management Services (TMS) delivers professional, scientific, and techn…
Principal Applied Scientist (GenAI)
**Job Description** We are seeking a visionary leader to spearhead post training model research and development efforts. As the post training science lead, you will be responsible for driving the deve…
In-Home Design Consultant
In-Home Design Consultant (Sales Representative) Creating a fresh solution to bath remodeling, Bath Planet of Montgomery offers a stylish, cost-effective, low-maintenance bath improvement to home…