Mainframe DBA (DB2)

  • Lincoln, NE
  • Posted 1 day ago | Updated 1 day ago

Overview

Remote
Hybrid
Depends on Experience
Contract - W2
Contract - 6 Month(s)
No Travel Required

Skills

DB2
z/OS
COBOL
CICS
VSAM
IMS

Job Details

While this is a remote role, priority will be given to those who are in the local area.

 

Role Overview

We are seeking an experienced Mainframe DBA (DB2) to support a critical modernization initiative. The project involves expanding Unemployment Insurance (UI) Employer Account Numbers from 6 digits to 9 digits, requiring coordinated updates across DB2 databases, mainframe applications, and integrated systems.

The DBA will play a key role in impact analysis, schema changes, performance tuning, data integrity, and production readiness, working closely with mainframe developers, state IT staff, and cross-platform teams.

Key Responsibilities

  • Analyze existing DB2 schemas to assess impacts of expanding account number fields
  • Modify table definitions, keys, indexes, and constraints to support 9-digit account numbers
  • Support data conversion or dual-format handling strategies as required
  • Review and optimize SQL performance impacted by structural changes
  • Ensure data integrity, referential consistency, and compliance with UI system requirements
  • Support batch and online application changes related to DB2 access
  • Assist with test environment preparation and data validation
  • Participate in deployment planning, production cutover, and post-implementation support
  • Document database changes and support long-term maintainability

Required Qualifications

  • 5+ years of DB2 for z/OS DBA experience
  • Strong expertise in DB2 database design, schema changes, and performance tuning
  • Experience supporting high-volume batch and online transaction systems
  • Familiarity with COBOL and CICS DB2 access patterns
  • Experience working in z/OS environments
  • Strong analytical, troubleshooting, and documentation skills

Preferred Qualifications

  • Experience with Unemployment Insurance, tax, or benefits systems
  • Experience performing data model changes impacting primary keys or identifiers
  • Knowledge of VSAM, IMS, or data integration with distributed systems
  • Experience in government or highly regulated environments
  • Familiarity with mainframe change-management and release processes

ECCO Select is committed to hiring and retaining a diverse workforce. Our policy is to provide equal opportunity to all people without regard to race, color, religion, national origin, ancestry, marital status, veteran status, age, disability, pregnancy, genetic information, citizenship status, sex, sexual orientation, gender identity or any other legally protected category. Veterans of our United States Uniformed Services are specifically encouraged to apply for ECCO Select opportunities.

Equal Employment Opportunity is The Law

This Organization Participates in E-Verify

 

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.