Design and maintain DB2 Database applications which have the following characteristics:
Design for maximum performance.
Provide production and test database support ina complex environment.
Enforce appropriate DB2 security standards.
Create, manage and support DB2 StoredProcedures, DB2 Triggers, and DB2 Referential Integrity.
Provide DB2 Connect configuration access supportfor individual users and distributed systems.
Work with Management to develop projectschedules.
Responsible for the evaluation and creation ofappropriate backup and recovery strategies for new database requirements.
Qualifications
z/OS DB2 12 for zOS or higher in a production environment with high transaction rates
IBM Data Studio
IBM DB2 Automation Tool
IBM DB2 Query Monitor
IBM File Manager
QMF
TSO and ISPF
Problem solving and analytical skills
| Skill Required /Desired Amount of exp. required in years Candidate Experience | ||
| 10+ years DB2 experience | Required | 10 |
| Excellent knowledge of DB2 z/OS Database Support, including but not limited to the following- | Required | 10 |
| z/OS DB2 12 for zOS or higher in a production environment with high transaction rates | Required | 10 |
| High availability 24x7 designs and techniques | Required | 10 |
| Managing large data stores | Required | 10 |
| DB2 V10 utilities setup and execution | Required | 10 |
| DB2 performance and tuning | Required | 10 |
| Data Modeling expertise logical and physical design | Required | 10 |
| Complex SQL coding / tuning | Required | 10 |
| Data Warehouse design with an understanding of OLAP design and query solutions | Required | 10 |
| DB2 attachments/interfaces include DRDA, DB2 Connect | Required | 10 |
| 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 | 10 |
| DB2 tools skill set will include, but not limited to the following: IBM DB2 (Administration Tool, Automation Tool, Explain, Query Monitor) | Required | 10 |
| z/OS Mainframe skills, but not limited to the following: TSO & ISPF, JCL, DFSORT &/or ICETOOL, REXX, z/OS Utilities | Required | 10 |
| Problem solving and analytical skills | Desired | 0 |
| Ability to organize and prioritize workflow and projects | Desired | 0 |
| Excellent written and oral communication skills | Desired | 0 |
| DB2 V9 or V10 Certification preferred | Desired | 0 |
| IMS Database experience | Desired | 0 |
| IMS Database Utilities (IBM, BMC, NEON, etc.) | Desired | 0 |
| ETL tools experience (InfoShere, Informatica, etc.) | Desired | 0 |
| No. Question Answer | |
| Question2 | Resume wise, please do not include filler material (e.g. describing a company's core capabilities/description). Please only include relevant info (e.g. what was done at the job/project). Is this reflected in the resume? |
| Question3 | Where does your candidate currently reside (e.g. city, state)? |
| Question4 | If you elect to, please provide your candidate's e-mail address and phone number under Summary of Qualifications (seen in the Details tab). This should never be in the resume. Did you do that? |
| Question5 | Inaccurate responses to the skills above will result in your company being omitted from future PennDOT requisitions. The skills (and applicable experience) must also be explicitly referenced in the candidate resume. Have you confirmed that the responses to the skills above are accurate and reflect the actual experience the candidate possesses? |
| Question6 | Do you understand, and will abide by, the provision in your subcontract with OST that it is PROHIBITED for government equipment to be taken or used outside of the United States by your contractors? The consequences of this occurring can and will result in repercussions to you, the prime vendor, regardless if the candidate works for a sub-vendor of yours. It will also result in immediate termination of the contractor, and make them ineligible for rehire in the program. |
| Question7 | As mentioned, this requisition will feature first round interviews via Teams (followed by in-person onsite). In order to deter a fake candidate scam at the virtual interview, the candidate must present a valid photo ID to the camera at the beginning of the interview. They also must pan the camera 360 degrees in the fixed room for the panel to see to make sure they are the only person in the room during the interview. Do you accept these conditions? |
...cover letter may not be reviewed.** Job Purpose: The Senior Accountant at Greater Spokane Inc. (GSI) plays a critical role in... ...Significant experience in financial management, preferably in a nonprofit environment. Nonprofit accounting experience is highly valued...
...restaurant with a focus on pastry, with at least 2 years of having managerial responsibilities A genuine passion and knowledge for food and pastries Culinary school attendance Prior experience with laminated dough, cakes, ice cream, chocolate, and sugar work...
...Join in the FUN and be part of a GREAT TEAM! Busy Corporate-focused hotel and the Best in West side of Allentown Marriott brand - Four Points Allentown Lehigh Valley - is seeking Full-time and part-time for IMMEDIATE hire! Schedule: This is an OVERNIGHT position...
...mission is to connect loved ones by creating the worlds simplest products and services that improve family life. We make consumer... ...throughout the world. Were seeking a Senior Growth Product Manager: Ecommerce to take our DTC business to the next level. Reporting...
...procedures Must be able to suggestively sell food and beverage items Las Casuelas Nuevas is a local culinary institution and a staple of Restaurant Row that has stood the test of time serving great Mexican food in the Coachella Valley for over 40 years. The Delgado...