Database Administrator Ibm Db For Z

Kindly go through the Job description and let me know if this would be of interest to you.

Job Title: Database Administrator (IBM DB2 for z/OS)

Location: Onsite role in Omaha, NE (Relocation will work)

Duration: 6+ Months Contract

****While sharing resume mention consultant location and visa status***

Job Description:

The Database Administrator will administer, secure, and tune IBM Db2 for z/OS databases while providing secondary support for Microsoft SQL Server and Azure SQL Managed Instance. This role supports mainframe-to-warehouse data pipelines and treats documentation, cross-training, and knowledge transfer as core deliverables.

What You'll Do

Database Administration & Design: Review and approve physical database designs (tablespaces, partitioning, indexing). Manage ZPARM, buffer pools, storage allocation, and version-controlled DDL changes via ITIL processes.

Performance & Maintenance: Monitor subsystem and thread health. Analyze access paths using EXPLAIN, optimize inefficient SQL, and schedule maintenance utilities (REORG, RUNSTATS, COPY, RECOVER).

Backup, Recovery & Security: Own backup strategies, log management, point-in-time recovery, and disaster recovery runbooks. Manage Db2 authorization, roles, and RACF integration under least-privilege principles to satisfy audit requirements.

Integration & Operations: Support nightly extract pipelines (unload utilities, SFTP, enterprise scheduling) and DDF/DRDA distributed access. Participate in on-call rotations, maintenance windows, and Db2 version/PTF upgrades.

Knowledge Transfer: Maintain runbooks, cross-train backup administrators on critical procedures, and mentor engineering teams on SQL efficiency.

What Skills You Need

Bachelor's degree in CS, MIS, or related field (or equivalent experience).

10+ years administering IBM Db2 for z/OS in production environments.

Strong working knowledge of z/OS, JCL, TSO/ISPF, RACF, and Db2 utilities.

Deep expertise in EXPLAIN/access path analysis, SQL tuning, buffer pools, and disaster recovery.

Experience with formal ITIL change, incident, and problem management.

Preferred Skills

IBM Certified Database Administrator Db2 for z/OS.

Experience with Microsoft SQL Server, Azure SQL Managed Instance, or Db2 data sharing/Parallel Sysplex.

Scripting proficiency in COBOL, REXX, or Python.

Exposure to enterprise schedulers (e.g., Stonebranch) and Db2 performance monitoring tools.

Property and casualty insurance data domain knowledge.

Thanks &