> Markdown version of [/jobs/ext/4674846-database-administrator-ibm-db2-for-z-os-onsite-role-in-omaha-ne-relocation-will-work](https://www.wearedevelopers.com/jobs/ext/4674846-database-administrator-ibm-db2-for-z-os-onsite-role-in-omaha-ne-relocation-will-work). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Database Administrator (IBM DB2 for z/OS) || Onsite role in Omaha, NE (Relocation will work) - **Company:** DMS Vision, Inc. - **Location:** Omaha, NE, United States - **Experience:** Expert - **Contract:** Contract - **Skills:** 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, Runbook, SQL Databases, Z/OS, Tso/ispf, Scripting, File Transfer Protocol (FTP), Indexer, Performance Monitor, Data Pipelines, Sql Tuning - **Published:** November 11, 2026 - **Apply:** https://www.dice.com/job-detail/9a13338f-2a35-4970-8776-2138a510afdb ## About the Role * 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. ## 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.