Job Title: PennDOT - DB2 Database Administrator
Location: Hybrid – Harrisburg, Pennsylvania
Duration: 9 months (until 06/30/2026)
Job Description:
Commonwealth of PA – PennDOT is seeking an experienced DB2 Database Administrator to design, maintain, and optimize z/OS DB2 Database applications with high availability, performance tuning, and complex SQL coding. This is a hybrid role, requiring onsite presence Wednesday and Thursday at the Keystone Building (400 N St., Harrisburg, PA 17120), with telework Monday, Tuesday, and Friday. Local candidates are strongly preferred.
Key Responsibilities:
- Design and maintain DB2 applications for high availability and maximum performance.
- Support production and test databases in a complex environment.
- Perform SQL code reviews and DB2 performance tuning at the application level.
- Enforce DB2 security standards and manage DSNZPARM settings.
- Create/manage DB2 Stored Procedures, Triggers, and Referential Integrity.
- Resolve service requests and provide 24x7 on-call support.
- Provide DB2 Connect configuration support.
- Collaborate with team members and management to develop project schedules and technical solutions.
- Implement backup, recovery strategies, and participate in Disaster Recovery planning.
Required Qualifications:
10+ years of DB2 experience, especially in high transaction environments.
- Strong expertise with:
- z/OS DB2 12 for zOS or higher
- DB2 V10 utilities setup and performance tuning
- Complex SQL coding and query optimization
- Data Modeling (logical & physical)
- Data Warehouse & OLAP design understanding
- IBM Data Studio, DB2 Administration Tool, DB2 Automation Tool, DB2 Explain, DB2 Query Monitor, IBM OPTIM Workload Query Tuner, IBM File Manager, IBM Tivoli OMEGAMON, QMF
- z/OS mainframe skills: TSO, ISPF, JCL, DFSORT/ICETOOL, REXX, z/OS Utilities.
Desired Skills:
- DB2 V9 or V10 Certification (preferred)
- IMS Database & Utilities experience (IBM, BMC, NEON, etc.)
- ETL tools experience (InfoSphere, Informatica, etc.)
- Strong problem-solving, analytical, and communication skills.
Additional Information:
- First day requires physical presence at Keystone Building for processing, badging, and equipment pickup.
- Metered, on-street parking available (candidate responsible for costs).
- Initial interview will be virtual via Microsoft Teams, followed by in-person onsite interview.
Important: Candidate must present valid photo ID and pan room for security during virtual interview.
- Government equipment use is prohibited outside the U.S.
About SR International INC.
SR International has been a leading name among the IT consulting companies with offices in US and India. For past 16 years, our industry experience and domain knowledge have enabled us to provide innovative solutions to our customers.
Who We Are
We Are Leading IT Based Solution Providers
Today, the world of business information represents the realization of our collective efforts toward improving the future. Held only by the limits of our imagination, the business world is accelerating at an ever-increasing pace. Imagine a better way of doing business, of implementing the perfect software, of refining practice or business integration. All it takes are benchmark standards in service, support, and technical know-how, which have been our bread and butter.
Our Vision.
Established in 2002, SR International Inc is one of the fastest growing and reputed provider of Information Technology Services and Solutions in the USA. Since our inception, we have been a trusted IT partner for our clients. We take pride in our highly skilled IT Resources and unique engagement model. We have been consistently delivering on our promises as a high-performance team. Our expertise in Cloud Computing, Mobility, Web Technologies, ERP and CRM are second to none. Our industry-leading flagship product iMathSmart is re-defining math learning experience for school students.
Career At SR International
At SR International, we treat our consultants like family. Our business and our reputation have been built and maintained by quality resources working onboard, so it’s important for us to maintain the quality resource pool.
Activate JobCopilot
Your email job alert is now active!