Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

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

Vacancy posted 1 day ago
Similar jobs that could be interesting for youBased on the Mainframe DB2 Database Administrator in Midvale, UT vacancy
  •  ...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

    VeriiPro

    Midvale, UT
    4 days ago
  • $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... 
    Mainframe
    Local area

    CGI

    Salt Lake City, UT
    2 days ago
  •  ...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,... 
    Mainframe
    Full time

    CGI

    Salt Lake City, UT
    5 days ago
  •  ...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... 
    Mainframe
    Full time
    Local area
    Immediate start
    Remote work

    System One

    Salt Lake City, UT
    3 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... 
    Mainframe
    Hourly pay
    Contract work

    Judge Group, Inc.

    Salt Lake City, UT
    4 days ago
  •  ...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

    System One Holdings, LLC

    Salt Lake City, UT
    4 days ago
  •  ...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 time
    Temporary work
    Relocation

    Infosys Technologies

    Salt Lake City, UT
    4 days ago
  •  ...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 hours
    Weekend work

    Compunnel

    Salt Lake City, UT
    23 hours ago
  •  ...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

    Purple Drive

    Salt Lake City, UT
    4 days ago
  •  ...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

    United IT

    Salt Lake City, UT
    4 days ago
  • $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... 
    Mainframe
    Hourly pay
    Full time
    Local area

    City of Murray

    Murray, UT
    23 hours ago
  • $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... 
    Mainframe
    Full time
    Temporary work
    Work experience placement
    Work at office
    Remote work
    Work from home
    Flexible hours

    Ensono

    Salt Lake City, UT
    3 days ago
  •  ...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

    Ensono

    Salt Lake City, UT
    3 days ago
  •  ...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

    United IT

    Salt Lake City, UT
    5 days ago
  • $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... 
    Mainframe
    For contractors
    Work at office
    Local area

    Highmark Health

    Salt Lake City, UT
    3 days ago
  • $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... 
    Mainframe
    Shift work

    Staffworthy

    Salt Lake City, UT
    23 hours ago
  •  ...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 employment
    Full time
    Temporary work
    Work from home

    KēSTA I.T.

    Salt Lake City, UT
    1 day ago
  • $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... 
    Mainframe
    Weekend work

    Tata Consultancy Services

    Salt Lake City, UT
    3 days ago
  • $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 work
    H1b
    Work at office
    Remote work
    Flexible hours
    3 days per week

    National Bank of Arizona

    Midvale, UT
    4 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

    TechDigital Group

    Salt Lake City, UT
    23 hours ago
  • $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.... 
    Mainframe
    Hourly pay
    Local area
    Immediate start
    Flexible hours
    Shift work
    Rotating shift
    Day shift
    Afternoon shift

    NCR Voyix

    South Jordan, UT
    8 days ago
  • $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... 
    Mainframe
    Temporary work
    Local area

    Slalom

    Salt Lake City, UT
    4 days ago
  • $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... 
    Mainframe
    Full time
    Remote work
    Worldwide

    Rocket Software

    Salt Lake City, UT
    5 days ago
  • $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 start
    Remote work

    Navtech

    Salt Lake City, UT
    4 days ago
  • $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 time
    Work at office

    Consulting Advantage Corp

    Salt Lake City, UT
    23 hours ago
  • 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 office
    Remote work

    Placements24

    Riverton, UT
    1 day ago
  •  ...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

    AYR Global IT Solutions

    West Valley, UT
    1 day ago
  • $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 area
    Visa sponsorship

    Deloitte

    Salt Lake City, UT
    12 hours ago
  •  ...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 time
    H1b

    Sonsoft

    Salt Lake City, UT
    23 hours ago
  •  ...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

    AiQualTest LLC

    Salt Lake City, UT
    3 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Mainframe DB2 Database Administrator. Be the first to apply!