Database Administrator (IBM DB2 for z/OS) || Onsite role in Omaha, NE (Relocation will work)
DMS Vision Inc.
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- Azure
- SQL
- IBM DB2
- JCL
- DBA
- Mainframe
- z/OS
- RACF
- TSO/ISPF
Summary
Hi,
Hope you are doing well !!
I have an urgent position. 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 & Regards,
Abhishek Yadav
DMS Vision Inc. |
4645 Avon Lane, Suite 210, Frisco, TX 75033
Email: | Phone : | EXT - 103
- Dice Id: 91133942
- Position Id: 3235-35330-1794343727
- Posted 16 hours ago
Company Info
About DMS Vision Inc.
At DMS Vision, our main goal is to be an integral part of our customer’s success. With ambition to be a Global Premier Provider of innovative, value-based technology solutions, our team has the drive and determination to do whatever it takes to meet the needs of our clients. Through our services, we strive to save our client’s money, time and hassle in every way possible.
At DMS Vision, we provide IT Staffing, Software Development, Cybersecurity and IoT Development and Services.
Whenever we take on a new project, we take extensive measures to learn all that we can take care about our client’s business. This allows us to better understand their goals and become familiar with the company’s philosophy.
We combine the insights obtained from this unique perspective with our professional strategic processes to develop a detailed plan for achieving the client’s ultimate vision of accomplishment. Our collaborative approach to problem solving and our technological expertise enables us to tackle even the most complex of our customer’s problems.