IBM DB2 Database Administrator

State of Nebraska•Lincoln, NE

2d•Onsite

About The Position

Nebraska DHHS is seeking an experienced Database Administrator to support and maintain critical IBM z/OS and LUW DB2 environments that power essential Health and Human Services systems. The role focuses on data reliability, system performance, and long-term stability for mission-critical applications. It is a full-time, permanent, on-site position at the Nebraska State Office Building in Lincoln, Nebraska; remote and hybrid work are not available, and candidates outside Nebraska must be open to relocation. The position is not eligible to be contracted. Hours are Monday through Friday during business hours, with occasional off-hours support. The State of Nebraska describes its values as treating others with dignity and respect, acting ethically, and prioritizing the customer. The agency does not sponsor or transfer non-immigrant work visas for this position and does not accept STEM OPT (Form I-983).

Requirements

Associate degree in Computer Science or a related field and three years of related experience; or a bachelor's degree or equivalent in computer science, information systems, mathematics, engineering, or another related field and two years of experience. Equivalent combinations of education and experience will be considered.
Related experience may include application programming, software installation and maintenance, systems programming, online programming, database design, analysis and programming using IFS and/or SQL/DS, and database administration.
Knowledge and experience supporting IBM z/OS and LUW DB2.
SQL query development and troubleshooting skills.
Knowledge of IBM z/OS tools, including Data Studio, SPUFI, QMF, and DB2I.
Knowledge and experience with Java and REXX development to author and maintain DB2 administration scripts.
Must be open to relocation if located outside Nebraska.
Must be able to provide occasional off-hours support.

Nice To Haves

At least five years of recent IBM z/OS and LUW DB2 administration and support experience.
Experience with IBM InfoSphere Data Replication.
REXX, Python, or VBScript development experience.
CA CoolGen experience.
COBOL experience.
Strong Java, REXX, and Python development skills.

Responsibilities

Design, implement, and test IBM z/OS and LUW DB2 database changes in accordance with NFOCUS and MMIS releases.
Manage IBM z/OS and LUW DB2 environments, including reorganization, statistics, data unloads and loads, backups, and recoveries.
Assist technical teams with SQL query development and troubleshooting.
Administer and maintain Windows MS SQL Servers.
Author and maintain scripts used for DB2 administration.