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. 2T Consulting
- ...Mainframe DB2 Database Administrator (DB2 DBA)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...Mainframe
$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- ...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,...MainframeFull time
- ...with 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 support in...MainframeFull timeLocal areaImmediate startRemote work
$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- ...Senior Mainframe DBAMainframe DB2 Database AdministratorWork Model: Onsite in Salt Lake City, UtahOn Call Support: This role may require participation... ...the primary onsite point of contact for DB2 database administration and related activities.Collaborate with application...Mainframe
- ...fostering teamdevelopment Required Skill and Experience • Database Administrator with hands-on experience in enterprise database... ...• Must have experience/exposure with any two technologies: DB2, or Sybase ASE, or MongoDB. • Provide L2/L3 database administration...Full timeTemporary workRelocation
- ...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
- ...multifactor authentication and other enterprise security enhancements on mainframe.• Monitor system logs and audit trails for suspicious activity... ...–SIEM (Q-Radar), z/OS-SA or CA-OPS/MVS Automation• Mainframe DB2, MQ, CICS, WAS, Control-M• Mainframe Security ACF2• Mainframe...Mainframe
- ...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
$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$135k - $205k
...Director, Mainframe Systems ProgrammingRemote - United StatesJR014354 At Ensono, our Purpose is to be a relentless ally, disrupting the... ...various technologies like Console/Batch Monitoring, Scheduling, DB2, IMS, CICS, Storage, etc. While direct mainframe experience...MainframeFull timeTemporary workWork experience placementWork at officeRemote workWork from homeFlexible hours- ...roadmaps with business goals, and foster executive relationships across major client accounts. You will drive architecture across mainframe, open systems, and cloud, guiding multi-year programs and revenue growth. You will collaborate with Sales, Consulting, and Product...Mainframe
- ...Mainframe DeveloperWe are seeking an experienced Mainframe Developer to join our team in Salt Lake City, UT. The ideal candidate will be responsible for developing, enhancing, maintaining, and supporting mission-critical mainframe applications. This role requires strong...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$80k - $100k
...A technology solutions provider in Salt Lake City seeks a Mainframe Developer with 5-7 years of experience. Responsibilities include supporting operations and analyzing issues for critical applications. Candidates should have expertise in JCL and COBOL, with a strong interest...MainframeShift work- ...Job DescriptionJob DescriptionSenior Database Administrator Come, Innovate, Build, Disrupt & Thrive! Position Overview KēSTA I.T. is seeking a senior-level Database Administrator with deep PostgreSQL expertise to support Postgres applications running in AWS for am organization...Permanent employmentFull timeTemporary workWork from home
$95k - $120k
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,000 MIPS and above. Manage BAU (Business As Usual) Service Delivery for Mainframe...MainframeWeekend work$120k - $145k
...Oracle EBS Database Administrator (Application Developer)Zions Bancorporation's Enterprise Technology and Operations (ETO) team is transforming what it means to work for a financial institution. With a commitment to technology and innovation, we have been providing our...Temporary workH1bWork at officeRemote workFlexible hours3 days per week- ...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
$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$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$154.58k - $194.65k
...Job Description Summary: We are looking for a highly skilled Mainframe Modernization Solutions Architect to analyze, design, architect,... ...legacy systems and with technologies such as COBOL, JCL, CICS, DB2 for z/OS, IMS DB/DC, Assembler, PL/I, REXX, flat/sequential files...MainframeFull timeRemote workWorldwide$50 - $55 per hour
...: Oracle DBA running Linux OS Install, Support and Maintain Oracle Database (DB), App Server, UNIX and shell scripting Expert in the administration of Oracle Database 11g and 12c Experience with Discoverer Desktop & Plus install...Immediate startRemote work$67k - $106k
If you take pride in doing Adaptability work well, the Database Administrator opening at Consulting Advantage Corp deserves a closer look. Come own your work at Consulting Advantage Corp: $67,000 - $106,000, a supportive team, and 5 years of Adaptability put to good use...Part timeWork at office- About the Role Our client is seeking a skilled and dedicated Database Administrator (DBA) to ensure the integrity, performance, and security of their critical database systems. This role, based in Upington , requires a meticulous individual with a deep understanding of...Work at officeRemote 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...Contract 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
- ...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
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Mainframe DB2 Database Administrator. Be the first to apply!




