Jobloria
DB2 Database Administrator
Tra'bian Enterprises
Location : Harrisburg, PA, 17101
Job Type : Full Time / Part Time
Date Posted : 1 December 2025
September 18, 2025 / Comments Off on DB2 Database Administrator
| 10+ years DB2 experience | 10 |
| Excellent knowledge of DB2 z/OS Database Support, including but not limited to the following- | 10 |
| z/OS DB2 12 for zOS or higher in a production environment with high transaction rates | 10 |
| High availability 24×7 designs and techniques | 10 |
| Managing large data stores | 10 |
| DB2 V10 utilities setup and execution | 10 |
| DB2 performance and tuning | 10 |
| Data Modeling expertise – logical and physical design | 10 |
| Complex SQL coding / tuning | 10 |
| Data Warehouse design with an understanding of OLAP design and query solutions | 10 |
| DB2 attachments/interfaces include DRDA, DB2 Connect | 10 |
| 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 |
| DB2 tools skill set will include, but not limited to the following: IBM DB2 (Administration Tool, Automation Tool, Explain, Query Monitor) | 10 |
| z/OS Mainframe skills, but not limited to the following: TSO & ISPF, JCL, DFSORT &/or ICETOOL, REXX, z/OS Utilities | 10 |
| Problem solving and analytical skills Desired |
LOCATION:Harrisburg, PA
POSITION TYPE: ASAP – 06/30/2026
POSITION TERMS:Hybrid – Telework Monday, Tuesday and Friday. Onsite Harrisburg, PA – Wednesday and Thursday
- Design for high availability.
- Design for maximum performance.
- Maintain and develop techniques and procedures to provide 24×7 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 24×7 On call support.
- Provide DB2 Connect configuration access supportfor 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.
SKILLS:
10+ years DB2 experience10Excellent knowledge of DB2 z/OS Database Support, including but not limited to the following-10z/OS DB2 12 for zOS or higher in a production environment with high transaction rates10High availability 24×7 designs and techniques10Managing large data stores10DB2 V10 utilities setup and execution10DB2 performance and tuning10Data Modeling expertise – logical and physical design10Complex SQL coding / tuning10Data Warehouse design with an understanding of OLAP design and query solutions10DB2 attachments/interfaces include DRDA, DB2 Connect10DB2 tools skill set will include, but not limited to the following: QMF & IBM (Data Studio, OPTIM Workload Query Tuner, File Manager, Tivoli OMEGAMON)10DB2 tools skill set will include, but not limited to the following: IBM DB2 (Administration Tool, Automation Tool, Explain, Query Monitor)10z/OS Mainframe skills, but not limited to the following: TSO & ISPF, JCL, DFSORT &/or ICETOOL, REXX, z/OS Utilities10Problem solving and analytical skills Desired- This field is for validation purposes and should be left unchanged.
- Max. file size: 1 GB.
Freqently Asked Questions
Harrisburg's tech market has a moderate demand for seasoned DB2 Database Administrators, with a limited but steady number of openings. Candidates with over 10 years of DB2 z/OS expertise, like those sought by Tra'bian Enterprises, often find opportunities due to scarcity of specialists in this niche.
Harrisburg’s traffic congestion peaks midweek, especially around downtown hubs. Given Tra'bian Enterprises offers a hybrid schedule with onsite work Wednesday and Thursday, planning routes to avoid rush hours or utilizing telework days can optimize work-life balance for DB2 DBAs.
Mastery of z/OS DB2 12+, high availability 24×7 architecture, and complex SQL tuning set Db2 DBAs apart. Expertise in IBM tools like Data Studio, Optim, and Tivoli Omegamon further elevates their profile, enabling efficient management of large-scale data stores with high transaction volumes.
Professionals adept in both DB2 administration and advanced data modeling, including OLAP query optimization, have strong career trajectories. Their ability to bridge database stability with analytical performance is highly valued in sectors requiring robust data warehouse solutions.
Daily tasks blend hands-on database performance tuning, SQL code reviews, and troubleshooting with team collaboration on technical strategies. Hybrid schedules at Tra'bian enable focused onsite problem-solving midweek and remote monitoring on telework days, ensuring continuous 24×7 DB2 availability.
At Tra'bian Enterprises, DB2 DBAs actively contribute to project timelines and technical choices, working closely with systems programming teams and management. This involvement ensures database configurations align with broader organizational goals and maintain high system resilience.
Experienced Db2 DBAs in Harrisburg typically command salaries between $110,000 and $135,000 annually, reflecting the specialized skills in mainframe DB2 administration and 24×7 high availability systems. Tra'bian Enterprises offers competitive compensation aligned with these market standards.
The hybrid setup—onsite midweek with telework on other days—caters to DB2 experts who value both direct collaboration and flexible scheduling. This balance supports productivity in complex environments while accommodating personal and commuting preferences.
A Db2 DBA focuses heavily on IBM’s z/OS mainframe systems and specialized tools, managing high-transaction, large-scale data environments. SQL DBAs often support broader relational databases with varied platforms, while Db2 specialists handle intricate mainframe utilities and performance tuning unique to IBM ecosystems.
Many assume entry-level DBAs can easily transition into Db2 roles; however, this position demands deep expertise in mainframe environments, advanced SQL tuning, and 24×7 availability designs. Without substantial experience in z/OS and IBM DB2 tools, candidates may struggle with the complexity involved.
Find The Related Jobs
Affinity Search
Database Administrator
Richfield, OH
Affinity Search
Database Administrator
Twinsburg, OH
Affinity Search
Database Administrator
North Royalton, OH
Affinity Search
Database Administrator
Hinckley, OH
Affinity Search
Database Administrator
Broadview Heights, OH
Affinity Search
Database Administrator
Peninsula, OH
Popular Searches for DB2 Database Administrator