DB2 Administrator (zOS, Mainframe, must have 10+ years of exp)
Full Time • PA
Commonwealth of PA - PennDOT - DB2 Administrator (zOS, Mainframe) - 777291
Must have 10+ years of experience
2nd round in-person interview at Harrisburg, PA
Local candidates are preferred.
2nd round in-person interview at Harrisburg, PA
Local candidates are preferred.
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.
Closing Date: 09/22/2025
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.)
Compensation: $55.00 - $65.00 per hour
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
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.
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.
(if you already have a resume on Indeed)