WeAreDevelopers Logo WeAreDevelopers
Sign in
For You LIVE
Back

Database Administrator (IBM DB2 for z/OS) || Onsite role in Omaha, NE (Relocation will work)

DMS Vision, Inc.
Omaha, NE, United States
3 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
10 years minimum
Working hours
Regular working hours
Job source
www.dice.com

Tech stack

COBOL (Programming Language) Databases Data Sharing IBM DB2 Disaster Recovery IBM Parallel Sysplex Job Control Language (JCL) Rexx (Programming Language) Python (Programming Language) Microsoft SQL Server SQL Azure IBM Resource Access Control Facility
+10 more
Runbook SQL Databases Z/OS Tso/ispf Scripting File Transfer Protocol (FTP) Indexer Performance Monitor Data Pipelines Sql Tuning

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.

Requirements

  • 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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…