Db2 Database Administrator
TEKsystems, Latham, NY, United States
z/OS DB2 V11 and V12 Database Administrator (DBA).
Responsibilities include all aspects of DB2 DBA on the z/OS platform. Must have a working understanding of Structured Query Language (SQL), JCL, DB2 performance tuning, Database Definition Language (DDL) and all DB2 utilities. Ability to follow existing processes for Change, Incident, Problem, Availability, Service Level and Capacity Management. Must have working knowledge of DB2 database Backup/Recovery. Review Logical design and provide recommendations. Transform the Logical design model into a Physical design. Design and prepare application database changes (add new or change existing structure). Willingness to provide rotational 24 x 7 On Call support for production environment required.
Primary Duties Include
Incident and Problem resolution based on customer Service Level requirements.
Execute DB Utilities (Reorg, Runstats, Copy, Load, Unload, Modify, Check, Recover, Rebuild)
Proficiently write new and modify existing JCL
Execute DB2 Commands (Stop, Start, Display, Cancel, etc)
Resolve problems, document solutions, and implement changes.
DB2 Security (RACF, Grants, Revokes, Roles, Privileges)
Additional Qualifications
At least 7 years experience with DB2 z/OS, 4 years with v11/v12
At least 7 years experience with z/OS, JCL, TSO/ISPF, and DB2 Utilities
At least 7 years experience with executing DDL
At least 7 years experience in Capacity / Performance management
At least 7 years experience with DB2 Backup / Recovery
At least 7 years experience in Apply Problem Solving Techniques
At least 7 years experience in database monitoring
Bachelor’s Degree
Job Type & Location
This is a Contract position based out of Latham, NY.
Pay and Benefits
The pay range for this position is $65.00 - $80.00/hr.
Requirements
Medical, dental & vision
Critical Illness, Accident, and Hospital
401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available
Life Insurance (Voluntary Life & AD&D for the employee and dependents)
Short and long-term disability
Health Spending Account (HSA)
Transportation benefitsEmployee Assistance Program
Time Off/Leave (PTO, Vacation or Sick Leave)
Workplace Type
This is a fully remote position.
Application Deadline
This position is anticipated to close on Apr 25, 2026.
Equal Employment Opportunity
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
#J-18808-Ljbffr
Responsibilities include all aspects of DB2 DBA on the z/OS platform. Must have a working understanding of Structured Query Language (SQL), JCL, DB2 performance tuning, Database Definition Language (DDL) and all DB2 utilities. Ability to follow existing processes for Change, Incident, Problem, Availability, Service Level and Capacity Management. Must have working knowledge of DB2 database Backup/Recovery. Review Logical design and provide recommendations. Transform the Logical design model into a Physical design. Design and prepare application database changes (add new or change existing structure). Willingness to provide rotational 24 x 7 On Call support for production environment required.
Primary Duties Include
Incident and Problem resolution based on customer Service Level requirements.
Execute DB Utilities (Reorg, Runstats, Copy, Load, Unload, Modify, Check, Recover, Rebuild)
Proficiently write new and modify existing JCL
Execute DB2 Commands (Stop, Start, Display, Cancel, etc)
Resolve problems, document solutions, and implement changes.
DB2 Security (RACF, Grants, Revokes, Roles, Privileges)
Additional Qualifications
At least 7 years experience with DB2 z/OS, 4 years with v11/v12
At least 7 years experience with z/OS, JCL, TSO/ISPF, and DB2 Utilities
At least 7 years experience with executing DDL
At least 7 years experience in Capacity / Performance management
At least 7 years experience with DB2 Backup / Recovery
At least 7 years experience in Apply Problem Solving Techniques
At least 7 years experience in database monitoring
Bachelor’s Degree
Job Type & Location
This is a Contract position based out of Latham, NY.
Pay and Benefits
The pay range for this position is $65.00 - $80.00/hr.
Requirements
Medical, dental & vision
Critical Illness, Accident, and Hospital
401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available
Life Insurance (Voluntary Life & AD&D for the employee and dependents)
Short and long-term disability
Health Spending Account (HSA)
Transportation benefitsEmployee Assistance Program
Time Off/Leave (PTO, Vacation or Sick Leave)
Workplace Type
This is a fully remote position.
Application Deadline
This position is anticipated to close on Apr 25, 2026.
Equal Employment Opportunity
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
#J-18808-Ljbffr