PennDOT - Exception (DB2 Database Administrator)

Please see the complete description.

• The position is hybrid. Telework Monday, Tuesday and Friday. Onsite (5th floor of The Keystone Building (400 N St., Harrisburg, PA 17120)) Wednesday and Thursday. Local candidates are preferred.
• For first day processing, possible badging and to pick up commonwealth-issued equipment candidate must physically report to The Keystone Building. There is metered, on-street / parallel parking in front of and around the building. PennDOT is not responsible for parking costs.
• Initial interview will be virtual via Microsoft Teams followed by in-person onsite.
• This requisition's current PO is funded through 6 / 30 / 26, so use that date in the RTR. Contract end date is dependent on the final schedule and projected needs. Historically additional funding should then last a year and occur from 7 / 1 / 26-6 / 30 / 27.

Required Experience : 10+ years DB2 experience

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 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.)

Required / Desired Skills

Skill

Required / Desired

Amount

of Experience

10+ years DB2 experience

Required

10

Years

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

Required

10

Years

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

Required

10

Years

High availability 24x7 designs and techniques

Required

10

Years

Managing large data stores

Required

10

Years

DB2 V10 utilities setup and execution

Required

10

Years

DB2 performance and tuning

Required

10

Years

Data Modeling expertise logical and physical design

Required

10

Years

Complex SQL coding / tuning

Required

10

Years

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

Required

10

Years

DB2 attachments / interfaces include DRDA, DB2 Connect

Required

10

Years

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

Years

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

Required

10

Years

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

Required

10

Years

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

Questions

No.

Question

Question1

The vendor rate is $84.03. Is this understood?

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?