Mainframe DB2 Database Administrator
Full-time
2T Consulting
We are seeking an experienced Mainframe DB2 Database Administrator (DB2 DBA) with strong expertise in IBM DB2 on z/OS architecture. The ideal candidate will have hands-on experience in DB2 database administration, performance tuning, utilities, data integrity, and mainframe technologies. The candidate will be responsible for maintaining database stability, optimizing performance, supporting application development, and ensuring the integrity, availability, and security of organizational data.
Key Responsibilities
- Administer and maintain IBM DB2 databases in a mainframe z/OS environment.
- Ensure database integrity, availability, reliability, and optimal performance.
- Perform DB2 performance tuning, query optimization, Explain analysis, and plan/package management.
- Manage DB2 database objects, including tables, indexes, tablespaces, partitions, and related structures.
- Implement DB2 Universal Table Space (UTS) conversion strategies and manage associated requirements, limitations, and enhancements.
- Execute DB2 utilities, including LOAD, UNLOAD, IMAGE COPY, RUNSTATS, REORG, RECOVER, CHECK DATA, CHECK INDEX, REPAIR, STOSPACE, and DSNCOPY.
- Perform DB2 commands and operational tasks, including thread monitoring and cancellation, utility termination, and database start/stop operations.
- Manage DB2 logs and support database recovery, backup, and restore activities.
- Support application development and deployment through database changes, user provisioning, and appropriate DB2 access controls.
- Work with application teams to support COBOL programs, VSAM datasets, and DB2 integration.
- Analyze complex database issues, identify root causes, and implement efficient and reliable solutions.
- Maintain database documentation, follow operational standards, and support production incidents and troubleshooting.
- Collaborate with development, infrastructure, and operations teams to facilitate business enhancements and continuous improvement.
Required Technical Skills
- Strong hands-on experience with IBM DB2 DBA on mainframe z/OS architecture.
- Expert knowledge of TSO, MVS, JCL, SDSF, and ISPF.
- Working knowledge of REXX coding, scripting, and maintenance.
- Knowledge of COBOL and VSAM capabilities and their integration with DB2 applications.
- Strong understanding of DASD requirements, capacity calculations, and storage utilization.
- Experience with DB2 Master Console and DB2 subsystem environments, including DB2PMSTR, DB2PDBM1, and DB2PDIST.
- Hands-on experience with DB2 Version 12 (DB2 v12).
- Strong understanding of DB2 catalog tables and database object management.
- Experience with DB2 performance tuning, Explain, plan tables, and access plan analysis.
- Understanding of DB2 plans versus packages and bind/rebind processes.
- Knowledge of DB2 partitioning and partition rotation architecture.
- Strong understanding of DDL, DML, and CML.
- Experience with the DB2 Primary Option Menu, SPUFI, DCLGEN, and DB2I defaults.
- Experience with DB2 program preparation, precompile, bind, rebind, free, and run processes.
- Proficiency in DB2 commands, utilities, and administration tools.
Vacancy posted 15 hours ago
Similar jobs that could be interesting for youBased on the Mainframe DB2 Database Administrator in Midvale, UT vacancy
- Mainframe DB2 System DBA Define and provide guidance for database creation, configuration, upgrade, patches and refresh requirements. Recommend operating system... ...experience in Mainframe z/OS Db2 v13 Database Administration Technical requirements Experience in Mainframe...Mainframe
$91.8k - $160.7k
Senior Mainframe DB2 Database Administrator Position Description Are you an experienced Mainframe DB2 Database Administrator who enjoys solving complex technical challenges and supporting mission critical applications? CGI is seeking a skilled and motivated Mainframe...MainframeLocal area- ...Mainframe Developer – COBOL, CICS, DB2 Seeking an experienced Mainframe Developer to develop, maintain, enhance, and support mission-critical enterprise... ...maintain DB2 programs, queries, stored procedures, and database-related components. Work with VSAM datasets and...MainframePermanent employment
System One Holdings, LLC
Midvale, UT3 days ago $50 - $58 per hour
...$58.00 USD Hourly Description: Mainframe DB2 DBA Location: Salt Lake City, UT... ...Mainframe DB2 DBA to join our enterprise database team. In this role, you will be... ...What You'll Do Database Design & Administration Design, create, and maintain...MainframeHourly payContract work- ...Job Description Job Description Job Title: Mainframe Developer (COBOL, CICS, DB2) Description: Mainframe Developer (COBOL, CICS, DB2) Position... ...by troubleshooting application, batch processing, database, and testing environment issues . Develop and maintain...Mainframe
System One
Salt Lake City, UT8 days ago - ...Job Description Job Description Job Title: Senior Mainframe DBA Location: Salt Lake City, Utah Type: Contract Senior Mainframe DBA Position Description Mainframe DB2 Database Administrator Work Model: Onsite in Salt Lake City, Utah On Call Support:...MainframeContract work
System One
Salt Lake City, UT7 days ago $42 per hour
Database Administrator Location: Salt Lake City, UT Onsite Flexibility: Onsite Contract Details Position Type: Contract Contract Duration: 6... ...support for Sybase Adaptive Server Enterprise, Sybase IQ, UDB DB2, Sybase Replication, Postgres, Hadoop, MSSQL, Mongo DB,...Contract workWork visa- ...Summary Provide production support for multiple database platforms (Sybase Adaptive Server Enterprise, Sybase IQ, UDB DB2, Sybase Replication, Postgres, Hadoop, MSSQL... ...3-5 years of experience in Database Administration. 3-5 years of hands‑on experience with Sybase...Flexible hoursWeekend work
$20.49 - $31.08 per hour
...Receives returned powerline material stock items; disassembles, inspects, determines suitability of material for restocking. Utilizes mainframe computer terminal to properly account for issues, returns, receipts of new materials and associated back orders; inputs essential...MainframeHourly payFull timeLocal area$68.4k
...and/or develop new methods of analysis, database design and performance measurement or, in... ..., R, SQL) and other database technology (DB2, Teradata, and Oracle). Other duties... ...SKILLS Strong technical skills in the mainframe, PC and Internet-based technologies to be...MainframeFor contractorsWork at officeLocal areaHighmark Health
Salt Lake City, UT3 days ago$100k - $160k
...the highest technical skill and experience in a broad range of mainframe infrastructure software. Displaying a broad range of disciplines... ...understanding of the major subsystems such as JES, CICS, MQ series, DB2, IMS, and VSAM. Possess in principle, an understanding of...MainframeFull timeLocal areaRemote workBroadcom Corporation
Draper, UT1 day ago- ...Mainframe z/OS System Programmer Salt Lake City, UT Job Description Mainframe z/OS System Programmer Minimum 10+ years of hands-on technical experience as a Mainframe z/OS Prior experience working in a large Mainframe setup of minimum 5...MainframeWeekend work
Q1 Technologies
Salt Lake City, UT4 days ago - ...Candidate will be responsible for providing database support. The roles require candidate to... ...issues for SAP Sybase ASE, IBM DB2 LUW, SAP Sybase IQ, SAP Sybase Replication... ...in SAP Sybase ASE / IBM DB2 LUW database administration, maintenance and implementation in a complex...Flexible hours
$78.4k - $119.18k
The Database Administrator, Mid oversees the stability, performance, and security of enterprise databases that support mission‑critical systems in a highly regulated government environment. The role designs and refines database structures, indexing strategies, and capacity...Contract workWork experience placementWork at office$19 - $20.83 per hour
...equipment such as access points or switches. Preferred Qualifications (not Required, But Nice To Have) Familiarity with large servers, mainframe computers, and imaging software. A+ Certification, CompTIA, N+ Certification. One or more years of related experience. Does...MainframeHourly payLocal areaImmediate startFlexible hoursShift workRotating shiftDay shiftAfternoon shift$30 - $40 per hour
...Job Description Job Description Database Administrator (DBA) Salt Lake City, UT (Onsite2-3 days per week/Hybrid) Contract Rate: $30.00 - $40.00per hr. Contract Duration: Up to 3 Years We are seeking an experienced Database Administrator to support the modernization...Contract work3 days per weekConsultNet
Salt Lake City, UT3 days ago- ...Summary: The Customer Solutions Engineer a highly skilled Mainframe Modernization Senior Consultant to provide technical... ...System level experience of IBM CICS; IMS and JCL Relational databases, such as IBM DB2/UDB, Oracle, Microsoft SQL Server; PostgreSQL Windows...MainframeLocal areaRemote workWorldwide
Rocket Software
Salt Lake City, UT2 days ago - ...Description Description: On-site Every Other Week onsite / 5 days in Salt Lake City, UT Join our client as a Junior Oracle Database Administrator supporting mission-critical environments across development, test, and production. This is a hands-on production support...Hourly payWork experience placementLocal area
Eliassen Group
Salt Lake City, UT15 days ago - ...and Wisconsin Our client seeks experienced .NET Developers to support a large-scale modernization initiative replacing legacy mainframe applications with modern .NET-based services and APIs. You will focus on backend development, enterprise integrations, and event-...MainframeHourly payContract workLocal areaRemote work
Eliassen Group
Salt Lake City, UT4 days ago - ...Texas and Wisconsin Our client seeks experienced .NET Developers to support a large-scale modernization initiative replacing legacy mainframe applications with modern .NET-based services and APIs. You will focus on backend development, enterprise integrations, and event-...MainframeContract workLocal areaRemote work
$80k - $100k
...About the job Mainframe Developer Location: Salt Lake City, Utah, United States Office space available at location listed Industry: Information Technology - Other Job Category : Information Technology - Other IT What you will do. Job type: On-site...MainframeFull timeWork at officeLocal areaRelocation packageShift workRZS Recruitment
Salt Lake City, UT2 days ago- ...maintain consumer information within internal databases Special assignments or tasks... ...Associate’s degree in marketing or business administration or equivalent relevant experience in... ...Office applications and enterprise or mainframe systems (e.g., SAP), with the capacity...MainframeWork at office
Petro Papa
Salt Lake City, UT1 day ago $18 - $22 per hour
...three rings. Receives, processes, and verifies the accuracy of orders from customers utilizing the company's internal CRM/Axapta mainframe system and customer purchase orders. Data entry Initiates required action for response to customer service requests for order changes...MainframeWeekly payTemporary workWork experience placementWork at officeImmediate startDay shift- ...1) year in project management, project implementation, or project planning IT Specialists may require 1 year computer, PC and/or Mainframe, or related in IT systems and software development Lab Specialists may require 1 year laboratory or related Preferred Experience...MainframeMonday to Friday
$97.5k - $131.63k
...software solutions to large, multi‑stakeholder organizations. Strong understanding of enterprise IT environments, including cloud, mainframe, and hybrid infrastructure solutions. Exceptional communication, negotiation, and presentation skills. Demonstrated ability...MainframeFull timeWork at officeRemote workWorldwideRocket Software
Salt Lake City, UT3 days ago- ...Workplace Type: Remote Standard Hours: Open Rate: $60.00 to $65.00/hr. w2 Description Remote Our client seeks a Senior DBA to support database operations and design improvements for a portfolio of online and batch applications serving a Federal Office of Child Support...Hourly payPermanent employmentContract workWork at officeLocal areaRemote work
$155k - $410k
Industry/SectorEUR X-SectorSpecialismOracleManagement LevelDirectorJob Description & SummaryAt PwC, our people in business application consulting specialise in consulting services for a variety of business applications, helping clients optimise operational efficiency. These...Full timeTemporary workH1bPwC
Salt Lake City, UT21 hours ago$60k
...Qualifications Bachelor's degree in Accounting, Finance, Business Administration or a related field with at least five years of relevant... ...specific systems, such as Workday, Banner, PeopleSoft, and DEFINE (Mainframe) system, is highly desirable. Additionally, experience in...MainframeFull timePart timeCasual workWork at officeImmediate startRemote workAfternoon shift$143k - $193.05k
...this role, this person will be a recognized thought leader, driving the evolution of our Automation product lines to meet enterprise mainframe and hybrid cloud environment. You will collaborate with customers, engineering teams, sales, and product management teams to...MainframeFull timeRemote workWorldwide$63.75k - $86.25k
...during periods of heavy workloads. Thorough knowledge of PC and mainframe software and systems as currently used by the Company.... ...departments throughout the organization. Prepares and analyzes administrative cost and budget reports, including the investigation of budget...MainframeFor contractorsWork at officeImmediate startWork from homeRelocationFlexible hours3 days per week
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Mainframe DB2 Database Administrator. Be the first to apply!
