Senior Mainframe DBA
Salt Lake City, Utah
Experience: 5
Category: Information Technology
Contractor Work Model: Onsite
Brand: System One
Job ID: 382425
Date Posted: 10/23/2026
Shortcut: http://jobs.systemone.com/rDinRF
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: This role may require participation in an on-call support rotation.
Your future duties and responsibilities
How You'll Make an Impact
As a Mainframe DB2 DBA, you will help ensure the performance, stability, security, and availability of enterprise database environments. Your responsibilities will include:
Database Design and Architecture
. Serve as the primary onsite point of contact for DB2 database administration and related activities.
. Collaborate with application developers and architects to translate logical data models into efficient physical DB2 database designs.
. Execute DDL for the creation and modification of tables, views, storage groups, and other database objects.
. Safely manage schema evolution through complex DB2 ALTER activities.
. Implement and maintain Universal Table Spaces, including PBG and PBR structures, to support effective storage and partitioning strategies.
. Design, create, and manage DB2 indexes to support data integrity and optimize application access paths.
Performance Tuning and Monitoring
. Write, review, and tune complex SQL queries to improve application performance and minimize CPU consumption.
. Monitor and troubleshoot DB2 performance issues, including access path concerns, locking, buffer pools, and SQL execution.
. Analyze EXPLAIN output and other diagnostic information to identify performance bottlenecks and recommend corrective actions.
. Use Real Time Statistics (RTS) to monitor database health and schedule maintenance activities proactively.
. Support performance optimization and continuous improvement initiatives across production environments.
Database Operations and Automation
. Execute and monitor DB2 utilities, including LOAD, UNLOAD, REORG, RUNSTATS, COPY, and RECOVER.
. Manage DB2 space allocation, including PRIQTY and SECQTY, and monitor VSAM datasets to help prevent storage shortages.
. Develop and maintain JCL and REXX scripts to automate batch processing and routine DBA activities.
. Use DB2 command level functions to manage database threads, statuses, and operational activities.
. Leverage DB2 administration and monitoring tools, such as DB2 Admin Tool and Query Monitor, to support efficient database management.
. Provide production support, investigate incidents, perform root cause analysis, and coordinate timely issue resolution.
Security and Business Continuity
. Administer DB2 security, including GRANT and REVOKE privileges, in alignment with enterprise access policies.
. Support database security, audit, compliance, and data protection requirements.
. Develop, test, and execute disaster recovery strategies to support business continuity.
. Manage image copies, DB2 logs, backup processes, and recovery activities to help ensure timely restoration following an outage.
. Participate in production readiness reviews, recovery exercises, and operational support activities.
Collaboration and Delivery
. Coordinate with architects, SMEs, development teams, QA, DevOps, integration teams, offshore resources, and third party vendors.
. Provide technical guidance and knowledge transfer to team members and offshore delivery teams.
. Support application releases, database changes, maintenance activities, and production deployments.
. Document database designs, operating procedures, troubleshooting steps, and recovery processes.
. Communicate technical issues, risks, recommendations, and status updates clearly to both technical and non-technical stakeholders.
Required qualifications to be successful in this role
What You'll Bring
. Bachelor's degree in Computer Science, Computer Engineering, Information Systems, or a related technical discipline. Equivalent technical experience may be considered.
. At least six years of experience in mainframe database administration, maintenance, and production support.
. Strong hands-on experience administering IBM DB2 for z/OS, including database design, performance monitoring and tuning, backup and recovery, security, and production support.
. Working knowledge of mainframe technologies, including COBOL, JCL, CICS, and VSAM, and an understanding of how applications interact with DB2 databases.
. Experience with DB2 utilities and administration activities, including RUNSTATS, REORG, COPY, RECOVER, LOAD, and UNLOAD.
. Experience analyzing and resolving DB2 performance issues, including SQL performance and access path concerns.
. Experience supporting multiple applications within a large enterprise or production environment.
. Experience coordinating with offshore teams and providing technical direction or guidance.
. Strong analytical, troubleshooting, and problem-solving skills.
. Excellent written, verbal, and interpersonal communication skills.
. Demonstrated initiative, sound judgment, and the ability to make informed technical decisions.
. Ability to evaluate and recommend solutions for moderate to complex database and production support issues.
. Ability to work onsite in Salt Lake City and collaborate directly with client and delivery teams.
. Availability to participate in on call support activities.
Preferred Qualifications
. Experience with Endevor.
. Experience using mainframe debugging and diagnostic tools.
. Experience supporting large scale enterprise modernization or database transformation initiatives.
. Familiarity with automation, scripting, monitoring, and continuous improvement practices.
. Consulting or client facing experience in a technology services environment.
Ref: #404-IT Pittsburgh
-
Senior Project Manager – Treasury & Payments
Salt Lake City, Louisiana
Job Title: Senior Project Manager – Treasury & Payments Location: Salt Lake City, Utah Type: Full-time Work Model: Hybrid – onsite and remote Responsibilities • Lead end to end project delivery across initiation, planning, execution, monitoring, implem...
Date Posted: 10/11/2026 Recommended
-
Network Engineer
Salt Lake City, Utah
Job Title: Network Engineer Location: Salt Lake City UT Type: Contract to Hire Work Model: Onsite – onsite Hours: 40.0 Security Clearance: Not specified Responsibilities • Design, implement, and maintain scalable, secure, resilient, and highly availabl...
Date Posted: 08/26/2026 Recommended
-
Senior Data Engineer (Databricks & Cloud Analytics)
Salt Lake City, Utah
Job Title: Senior Data Engineer (Databricks & Cloud Analytics) Location: Salt Lake City, Utah Work Model: Hybrid – onsite and remote Responsibilities • Design, develop, and support enterprise data platforms, cloud analytics solutions, or large-scale da...
Date Posted: 09/30/2026 Recommended
-
Senior Data Engineer (Databricks & Cloud Analytics)
Salt Lake City, Utah
Job Title: Senior Data Engineer (Databricks & Cloud Analytics) Location: Salt Lake City, Utah Work Model: Hybrid – onsite and remote Responsibilities • Design, develop, and support enterprise data platforms, cloud analytics solutions, or large-scale da...
Date Posted: 10/05/2026 Recommended
-
Business Systems Analyst – FX Trading Platform Modernization
Salt Lake City, Utah
Job Title: Business Systems Analyst – FX Trading Platform Modernization Location: Salt Lake City, Utah Work Mode : 5 Days Onsite Duration : Contract to Hire Responsibilities Lead business analysis, strategic planning, and migration initiatives supporti...
Date Posted: 08/06/2026 Recommended
-
Engineering Design Manager
Salt Lake City, UT
Job Title: Engineering Design Manager Location: Salt Lake City, UT Type: Direct Hire Compensation: $120,000.00 - $153,000.00 Work Model: Onsite Overview The IS Design Manager is responsible for the design production throughout the life cycle of a proje...
Date Posted: 09/29/2026 Recommended
-
Operations & Production Supervisor
Salt Lake City, UT
Job title: Operations & Production Supervisor Location: Salt Lake City, UT (Onsite) Schedule: Monday-Friday | 8:00 AM-5:00 PM Pay: $80,000 - $100,000 annually + Benefits Travel: Occasional travel to company headquarters and other facilities (approximat...
Date Posted: 09/29/2026 Recommended
-
Business Systems Analyst – FX Trading Platform Modernization
Salt Lake City, Utah
Job Title: Business Systems Analyst – FX Trading Platform Modernization Location: Salt Lake City, Utah Responsibilities Lead business analysis, strategic planning, and migration initiatives supporting the transition from legacy FX trading platforms, su...
Date Posted: 08/06/2026 Recommended
-
Commissioning Director
Salt Lake City, UT
Job Title: Commissioning Director Location: Salt Lake City, UT Type: Direct Hire Compensation: $135,000.00 - $200,000.00 Work Model: Onsite Overview The Director of Commissioning leads and supports teams responsible for ensuring that building systems a...
Date Posted: 09/30/2026 Recommended
-
Senior Test Automation Engineer – Payments
Salt Lake City, Utah
Job Title: Senior Test Automation Engineer – Payments Location: Salt Lake City, UT Type: Contract to hire Responsibilities • Design, develop, enhance, and maintain scalable and reusable test automation frameworks for complex enterprise applications. • ...
Date Posted: 10/05/2026 Recommended
-
Calypso Developer
Salt Lake City, Utah
Job Title: Calypso Developer Location: Salt Lake City, UT, United States Type: Permanent Full Time Work Model: Remote – offsite Responsibilities Design, develop, customize, and support Calypso applications, workflows, extensions, and integrations suppo...
Date Posted: 10/06/2026 Recommended
-
Platform Engineer (DevOps)
Salt Lake City, Utah
Job Title: Platform Engineer (DevOps) Location: Salt Lake City, UT Responsibilities • Design, build, and optimize enterprise CI/CD pipelines using GitHub Actions and other modern DevOps platforms • Administer enterprise Source Code Management (SCM) rep...
Date Posted: 08/06/2026 Recommended
-
Platform Engineer (DevOps)
Salt Lake City, Utah
Job Title: Platform Engineer (DevOps) Location: Salt Lake City, UT Work Mode : 5 Days Onsite Duration : Contract to Hire Responsibilities • Design, build, and optimize enterprise CI/CD pipelines using GitHub Actions and other modern DevOps platforms • ...
Date Posted: 08/06/2026 Recommended
-
Electrical Engineer
Salt Lake City , Utah
Job Title: Electrical Engineer Location: Salt Lake City, UT Type: Contract-to-hire Compensation: $45.00 - $55.00/hr. Salary will be commensurate with experience. Work Model: Onsite Hours: 40 hours per week Security Clearance: Not specified Overview Sys...
Date Posted: 10/22/2026 Recommended
-
Energy Storage Pre-Construction Manager
Lake Mary, FL
Job Title: Energy Storage Pre-Construction Manager Location: Lake Mary, FL Type: Direct Hire Work Model: Onsite – onsite Overview System One is seeking a storage pre-construction manager for a full-time position in Lake Mary, FL. The Manager of Constru...
Date Posted: 08/06/2026 Recommended
-
Facilities Technician
Salt Lake City, UT
Job Title: Facilities Technician Location: Salt Lake City, UT Type: Direct Hire Compensation: $38,000.00 - $52,000.00 Work Model: Onsite Overview The Facilities Technician is responsible for maintaining, repairing, and ensuring the safe operation of bu...
Date Posted: 09/21/2026 Recommended
-
Electrical Final Assembler
Salt Lake City, UT
Job Title: Electrical Final Assembler Location: Salt Lake City, Utah Type: Contract To Hire Compensation: $19.00 - $24.00 per hour Work Model: Onsite Responsibilities Working from instruction manuals, wiring diagrams, lists, and drawings Assembling ele...
Date Posted: 10/01/2026 Recommended
-
Site Reliability Engineer
Pittsburgh, Pennsylvania
Senior Site Reliability Engineer (SRE) Location: Pittsburgh, PA / Cleveland, OH / Dallas, TX FTE Position Overview We are seeking an experienced Senior Site Reliability Engineer (SRE) to support production operations, application reliability, performan...
Date Posted: 08/12/2026 Recommended
-
Aluminum Welder
Salt Lake City, UT
Job Title: Aluminum Welder Location: Salt Lake City, UT Type: Direct Hire Compensation: $66,000.00 - $80,000.00 Work Model: Onsite Overview Our Client offers a wide range of international career opportunities. Here you get the chance to expand your pot...
Date Posted: 10/01/2026 Recommended
-
Senior Solution Architect
Salt Lake City, Utah
Job Title: Senior Solution Architect Client Location: Salt Lake City, Utah Type: Contract To Hire Work Model: Onsite Experience * 8+ years of progressive experience in software engineering, solution architecture, or enterprise application development *...
Date Posted: 08/06/2026 Recommended
-
Senior Solution Architect
Salt Lake City, Utah
Job Title: Senior Solution Architect Client Location: Salt Lake City, Utah Type: Contract To Hire Work Model: Onsite Experience * 8+ years of progressive experience in software engineering, solution architecture, or enterprise application development *...
Date Posted: 08/06/2026 Recommended
-
Mainframe Modernization Engineer
Lafayette, Louisiana
Job Title: Mainframe Modernization Engineer Location: Lafayette, Louisiana Type: Permanent Full Time Work Model: Hybrid – onsite and remote Responsibilities Analyze existing COBOL programs and understand their business and technical logic. Review and v...
Date Posted: 10/22/2026 Recommended
-
Engineering Technician
Salt Lake City, Utah
Job Title: Engineering Technician Location: Salt Lake City, UT Type: Contract Compensation: $26-28/hr Work Schedule: Monday to Friday Overview Engineering Technician (Contract) opportunity in Salt Lake City, UT supporting medical device engineering tea...
Date Posted: 10/22/2026 Recommended
-
Engineering Director
Salt Lake City, Utah
Job Title: Engineering Director Location: Salt Lake City, Utah Type: Direct Hire Compensation: $150,000 - $200,000 Contractor Work Model: Hybrid – onsite and remote Overview The Director of Engineering is responsible for directing, overseeing, and util...
Date Posted: 09/29/2026 Recommended
-
Electrical Engineer PE I
Salt Lake City, Utah
Job Title: Electrical Engineer PE Location: Salt Lake City, Utah Type: Direct Hire Compensation: $100,000.00 - $150,000.00 Contractor Work Model: Hybrid – onsite and remote Overview The Electrical Engineer, PE I is responsible for overseeing the creati...
Date Posted: 09/29/2026 Recommended
-
Senior PostgreSQL Database Administrator
washington, VA
Job Title: Senior PostgreSQL Database Administrator Location: Washington, DC Type: Direct Hire Compensation: $190,000.00 Work Model: Onsite Hours: 40.0 Security Clearance: Active Top Secret with current or previously held SCI access Contact: Crystal.di...
Date Posted: 09/24/2026 Recommended
-
Data Analyst – Data Integration & Enablement
Salt Lake City, Utah
Job Title: Data Analyst – Data Integration & Enablement Location: Salt Lake City, UT Type: Permanent Full Time Compensation: 0 Work Model: Hybrid – onsite and remote Hours: 40.0 Security Clearance: None Responsibilities • Partner with business and tech...
Date Posted: 10/05/2026 Recommended
-
Mechanical Assembler
Salt Lake City, UT
Job Title: Mechanical Assembler Location: Salt Lake City, UT Type: Contract To Hire Compensation: $19.00 - $24.00 Work Model: Onsite Responsibilities Assemble equipment, sub-assemblies, and vehicle structures according to engineering drawings and speci...
Date Posted: 10/02/2026 Recommended
-
Associate Engineering Technician
Salt Lake City, Utah
Job Title: Associate Engineering Technician Location: Salt Lake City, UT Type: Contract Compensation: $23/hr Work Schedule: Monday to Friday Overview This is a contract Associate Engineering Technician role in Salt Lake City, UT, supporting medical dev...
Date Posted: 10/22/2026 Recommended
-
Interior Assembly Technician
Salt Lake City, UT
Job Title: Interior Assembly Technician Location: Salt Lake City, UT Type: Contract to hire Compensation: $19.00 - $24.00 Work Model: Onsite Responsibilities Install floors and floor substructures inside passenger railcars Lay linoleum with precision a...
Date Posted: 10/02/2026 Recommended
⚠️ Protecting Job Seekers from Identity Scams
At System One, your privacy and security are important to us. As job-related scams continue to target job seekers, we want to help you recognize and avoid common recruitment fraud. Identity theft scams often involve individuals, also known as "scammers," posing as recruiters or employers to obtain sensitive personal information, such as Social Security numbers, bank account details, or copies of driver’s licenses, with the goal of stealing identities, accessing financial accounts, or creating fraudulent accounts in a victim’s name.