Overview
Skills
Job Details
DB2 Database Administrator / Full-Time / Hybrid / Harrisburg, PA
Become a member of a growing team of Information Technology professionals making an impact and providing solutions for Government and Commercial clients since 1996 Join the Domino Tech Team!
Accepting Candidates Until 09/22/2025 at 2:00 PM
The Position:
Client: Commonwealth of Pennsylvania Pennsylvania Department of Transportation (PennDOT)
Position Title: PennDOT DB2 Database Administrator Exception (777291)
Location: Hybrid; Remote Off-Site and On-Site in Harrisburg, PA
Duration: Initial term through 06/30/2026 (+ Annual Renewal in 1-Year Terms)
Note: The position is hybrid; with remote off-site Monday, Tuesday and Friday, and on-site Wednesday and Thursday. Candidates must currently reside within a reasonable commuting distance (2-hour/100-miles) of Harrisburg, PA.
- 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.
The Skills and Experience:
- 10+ Years: DB2 experience
- 10+ Years: Excellent knowledge of DB2 z/OS Database Support, including but not limited to the following;
- 10+ Years: z/OS DB2 12 for zOS or higher in a production environment with high transaction rates
- 10+ Years: High availability 24x7 designs and techniques
- 10+ Years: Managing large data stores
- 10+ Years: DB2 V10 utilities setup and execution
- 10+ Years: DB2 performance and tuning
- 10+ Years: Data Modeling expertise logical and physical design
- 10+ Years: Complex SQL coding / tuning
- 10+ Years: Data Warehouse design with an understanding of OLAP design and query solutions
- 10+ Years: DB2 attachments/interfaces include DRDA, DB2 Connect
- 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)
- 10+ Years: DB2 tools skill set will include, but not limited to the following: IBM DB2 (Administration Tool, Automation Tool, Explain, Query Monitor)
- 10+ Years: z/OS Mainframe skills, but not limited to the following: TSO & ISPF, JCL, DFSORT &/or ICETOOL, REXX, z/OS Utilities
- 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 (Infosphere, Informatica, etc.)
The Company:
The mission of Domino Technologies, Inc. is to provide clients with IT solutions for their individual business processes that lead to strategic market advantages. Since its founding in 1996, the Domino Tech Team has built a solid record of performance working with clients in the Government and Commercial sectors.
The Perks:
- Excellent Market Salary
- Competitive Benefits
- Paid Holidays and Vacation
- Positive Work-Life Balance
The Location:
Domino Technologies is based in the Harrisburg area the capital city of the Commonwealth of Pennsylvania and the county seat of Dauphin County. Located on the east bank of the Susquehanna River, Harrisburg is the anchor of the Susquehanna Valley metropolitan area.
Contact Us Today!