Apply on Employer Site

ECCO Select · 1 day ago

Mainframe DBA (DB2) #10925

United States

Contract

Remote

Senior Level

5+ years exp

ECCO Select is seeking an experienced Mainframe DBA (DB2) to support a critical modernization initiative. The role involves expanding Unemployment Insurance Employer Account Numbers and requires coordination across DB2 databases and mainframe applications, focusing on impact analysis, schema changes, and performance tuning.

Information ServicesInformation Technology

Hiring Manager

Jeremy Skinner

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

Qualification

DB2 for z/OS DBADB2 database designPerformance tuningHigh-volume transaction systemsCOBOLCICSZ/OS environmentsAnalytical skillsTroubleshooting skillsData model changesVSAM knowledgeIMS knowledgeData integrationGovernment environmentsChange-management processesDocumentation skills