Overview
Skills
Job Details
Our direct client is looking for a DB2 Database Administrator for a Hybrid (2D/week onsite) Long term contract in Harrisburg, PA.
NOTE:
- The position is hybrid. Telework (Monday, Tuesday and Friday). Onsite (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.
JOB 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 procedures to provide 24x7 availability.
- Provide production and test database support in a complex environment.
- Perform all functions which are performed by a DB2 Database Administrator, such as:
- SQL code reviews.
- Performance Monitoring and Tuning DB2 at the application database level.
- Enforce appropriate DB2 security standards.
- Collaborate with the DB2 systems programming staff to appropriately manage DSNZPARM settings.
- Create, manage and support DB2 Stored Procedures, DB2 Triggers, and DB2 Referential Integrity.
- Create Change Requests, Resolve Service Requests, Provide 24x7 On call support.
- Provide DB2 Connect configuration access support for individual users and distributed systems.
- Coordinate with team members on technical decisions and directions.
- Work with Management to develop project schedules.
- Provide Database performance and tuning which typically involves collaboration between Data Center, Technical Operations,Database Design and Administration, and the various software development areas.
- Responsible for the evaluation and creation of appropriate backup and recovery strategies for new database requirements.
- Participate in Disaster Recovery planning.
Qualifications
- 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
SKILL MATRIX:
- 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 - Plus to have
- Ability to organize and prioritize workflow and projects - Plus to have
- Excellent written and oral communication skills - Plus to have
- DB2 V9 or V10 Certification preferred - Plus to have
- IMS Database experience - Plus to have
- IMS Database Utilities (IBM, BMC, NEON, etc.) - Plus to have
- ETL tools experience (InfoShere, Informatica, etc.) - Plus to have
Question 1: Where does your candidate currently reside (e.g. city, state)?
Question 2: 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.
Question 3: 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?
Question 4: This position is onsite 2days/week (Wednesday and Thursday). Are you fine with this?
Question 5: 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. Are you fine with this?
Location: Hybrid (2days/week Wed & Thur), 5th floor of The Keystone Building, 400 N St., Harrisburg, PA 17120
Type: Long term contract
Please send resume to "jobs at etechnovision dot com" with B4008B in Subject for immediate consideration