What are the responsibilities and job description for the DB2 Database Administrator position at TRA'BIAN ENTERPRISES?
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 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
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 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