Mainframe DB2 Database Administrator
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.
- ...3 rd parties - W2 candidates only *** Must be able to work on site 5 days a week - no remote work z/OS Mainframe Db2 Database Administrator / Mainframe DBA / Db2 DBA - Experience in mainframe database administration, maintenance and production...MainframeFull timeImmediate startRemote work
$91.8k - $160.7k
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 DB2 DBA to join our team in Salt Lake City, Utah...MainframeLocal area- 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 DB2 DBA to join our team in Salt Lake City, Utah. In this...MainframeFull time
- ...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
- ...Job Title: Mainframe Developer Location: Salt Lake City, UT (Onsite) Job Description We are seeking an experienced Mainframe Developer... ...Perform coding and debugging using COBOL, JCL, and DB2 Analyze business requirements and translate them into technical...Mainframe
- ...Description The Database Administrator is a specialist individual-contributor role at the Upper Mid (L3+) level, above Data Engineer II and alongside... ...(every legacy database, integration and gateway, including DB2 and MIMIX, CData, SSIS, DBSSQL3 and the on-premises gateways...For contractorsWork at officeLocal area
$19 - $20.83 per hour
...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....MainframeHourly payLocal areaImmediate startFlexible hoursShift workRotating shiftDay shiftAfternoon shift- ...Mainframe Developer Location: Midvale/Salt Lake City, UT (Onsite) Are you an experienced Mainframe Developer (COBOL, CICS, DB2) looking to work on mission critical enterprise systems that support... ...application, batch processing, database, and testing environment issues....Mainframe
$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 area$40 - $80 per hour
...Senior Database Administrator (PostgreSQL / AWS) Location: Remote (Utah Residents Only) Contract Length: 12 Months Work Arrangement: 100% Remote with occasional onsite meetings as needed Elevate Enterprise Database Performance in a Modern Cloud Environment We're seeking...Contract workTemporary workRemote work- ...Senior Database AdministratorK?STA I.T. is seeking a senior-level Database Administrator with deep PostgreSQL expertise to support Postgres applications running in AWS for an organization.In this role, you will provide expert guidance on PostgreSQL databases and work side...Permanent employmentFull timeTemporary workWork from home
- ...sponsorship for this position.Job Description:The RoleFidelity Investments is seeking an experienced and highly motivated Senior Database Administrator to provide operational excellence across our Development, Test, and Production database environments. This role will be...Permanent employmentFull time
$186k - $257k
...technology transformation by turning decades-old mainframe code into agile, cloud-native systems.... ....* Knowledge of z/OS fundamentals: CICS, DB2, VSAM, batch scheduling, system... ...augmented generation (RAG) patterns, vector databases, and agentic orchestration for code analysis...MainframeTemporary workLocal area$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 work$110.7k - $218.3k
...industries/sectors you serve.Limited immigration sponsorship may be available.A Bachelor's degree in Accounting, Finance, Business Administration, Economics, Information Systems, or another related field Preferred: Ability to manage multiple work assignments and project...Local areaVisa sponsorship- ...development life cycle.• At least 2 years of experience in Capital Markets domain.• Fundamental understanding of a RDBMS is required( DB2/ Sybase)• Strong experience in Core Java, Unix• Experience with Hibernate, Spring IOC( v3) and Spring MVC • Ability to work in team...Full timeH1b
- ...others. If you're as passionate about your future as we are, join our team.KPMG is currently seeking a Senior Engineer, Senior Database Administrator to join our Digital Nexus technology organization.Responsibilities:Install, configure, upgrade, and maintain Oracle 19c...H1bLocal areaAfternoon 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 week- ...Human Services (DHHS) Job Description The Department of Health and Human Services (DHHS) is seeking a senior-level Database Administrator (DBA) with extensive mastery and understanding of PostgreSQL to support Postgres applications running in AWS. The DBA will...Remote work
- A national staffing firm is seeking a Database Consultant for a contract position in West Valley City, Utah. The ideal candidate will have over 7 years of experience in Oracle and strong SQL skills, along with knowledge of data architecture and Unix basics. Key tasks include...Contract work
- ...DescriptionJob DescriptionDescription:On-site Every Other Week onsite / 5 days in Salt Lake City, UTJoin 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
$77k - $202k
...management, and HR analytics workstreams- Configuring Oracle Human Capital modules such as Core HR, absence management, benefits administration, compensation, payroll, and time and labor- Analyzing client requirements and translating business processes into system design...Full timeH1b- ...least 4 years of accounting, planning, analytical, and/or reporting experience in positions with increasing responsibility. AS/400 mainframe computing experience. Foodservice industry experience. Fit the following? We want you here! Teamwork oriented Organized Problem...Mainframe
$71.2k - $158.2k
**Job Description** We're on a journey to advance how health happens with technologies that empower patients, support clinicians, inspire innovation, and save lives. Our mission? **To create a human-centric healthcare experience powered by unified global data.** It's a ...Temporary workWork experience placementLocal areaFlexible hours$63.75k - $86.25k
...during periods of heavy workloads.Thorough knowledge of PC and mainframe software and systems as currently used by the Company.Ability... ...throughout the organization.Prepares and analyzes administrative cost and budget reports, including the investigation of budget...MainframeFor contractorsWork at officeRelocationFlexible hours3 days per week- ...leading plan and build teams across multiple levels of the stack (database, network, storage, compute, digital workplace, etc.) Legacy... ...change program of $100+ million (e.g., cloud migration, mainframe rationalization, virtualization). Experience with modern infrastructure...MainframeFull timeContract workTemporary work
$105k - $166k
...Qualifications Required 6+ years relevant experienceSound knowledge HealthcareNew development, application maintenance and supportTech: Mainframe+ AI+ PEGA +Distributed systemBachelor's degree, preferably in Computer Science, Information Technology, Computer Engineering, or...MainframeLocal areaFlexible hours$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 work- ...and Wisconsin We're looking for a Lead .NET Developer to help drive a large-scale modernization initiative replacing legacy mainframe applications with modern .NET services and APIs. This is a hands-on technical leadership role for someone who can lead backend...MainframeHourly payContract workLocal areaRemote work
$84k - $148k
...Senior Mainframe Systems Programmer - ADABASRemote - United StatesJR014442 Position Summary The successful candidate will perform mainframe database Software upgrades coupled with administration and tuning to support our customers' Software AG ADABAS environments...MainframeFull timeTemporary workWork experience placementRemote workWork from homeFlexible hours
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Mainframe DB2 Database Administrator. Be the first to apply!




