Find work in the United States.

A simpler way to find your next job.

Jobs in the United States

25+ jobs

Save this search

Added 3 days ago
Mainframe Db2 Database Administrator
System One
Salt Lake City, UT
z/OS Mainframe Db2 Database Administrator / Mainframe DBA / Db2 DBA
Added 3 days ago
Db2 DBA ( mainframe z/OS platform )
System One
Salt Lake City, UT
z/OS Mainframe Db2 Database Administrator / Mainframe DBA / Db2 DBA
Added 4 days ago
Control-M Technical Administrator
Arete Technologies, Inc.
Austin, TX
8+ years’ experience with Unix/Linux Server Operation System
Added 5 days ago
Mainframe Db2 Database Administrator
System One
Salt Lake City, UT
z/OS Mainframe Db2 Database Administrator / Mainframe DBA / Db2 DBA
Added 5 days ago
Db2 DBA ( mainframe z/OS platform )
System One
Salt Lake City, UT
z/OS Mainframe Db2 Database Administrator / Mainframe DBA / Db2 DBA
Added 6 days ago
Senior Mainframe DB2 Database Administrator
CGI Technologies and Solutions, Inc.
Salt Lake City, UT
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…
Added 6 days ago
Integration Engineer 4 - Mainframe DB2 DBA
Capital One
Riverwoods, IL
Work within and across Agile teams (using Jira and Confluence) to design, test, implement, and support technical solutions, while developing comprehensive documentation for system…
Added 11 days ago
Senior Microfocus Enterprise SME
Capgemini
Irving, TX, TX
We are looking for a Microfocus Enterprise Administrator or expert to manage and support enterprise-scale environments across cloud (Azure/GCP) and on-premise infrastructure. This role will…
Added 11 days ago
Mainframe Security Administrator
Peraton
Remote, United States
Strong written and verbal communication; able to coordinate with and support technicians, system admins, developers, business analysts, and on-call staff.
Added 13 days ago
M
System / Software Engineer (DB2 Replication / CDC)
ManpowerGroup
Plano, TX
- $53.41 USD / hour
Title: System / Software Engineer (DB2 Replication / CDC) – Database Administrator II
Added 14 days ago
EU
System / Software Engineer (DB2 Replication / CDC)
Experis USA
Plano, TX
- $53.41 USD / hour
Title: System / Software Engineer (DB2 Replication / CDC) – Database Administrator II
Added 17 days ago
16310 - Senior Mainframe DBA
Smith Johnson Tech
Salt Lake City, UT
…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…
Added 17 days ago
Senior Mainframe DBA
System One
Salt Lake City, UT
On Call Support: This role may require participation in an on-call support rotation.
Added 17 days ago
ISPF RACF CICS IOF BJS Mssql Administrator
COOLSOFT
Tallahassee, FL
Job Description Administrator: ISPF, RACF, CICS, IOF BJS Mssql
Added 18 days ago
Database Administrator C. Advanced
Advanced Systems Design
Tallahassee, FL
Advanced Systems Design is seeking a Database Administrator C. Advanced for our client located in Tallahassee, FL.
Added 19 days ago
DB2 Database Administrator (DBA)
Apex Systems, Inc.
NEW YORK, NY
Added 23 days ago
DB2 Database Administrator (DBA)
Apex Systems, Inc.
NEW YORK, NY
Added 24 days ago
C
IBM Mainframe DB2 Specialist
Cognizant
Hartford, CT
- $100,000 to $115,000 USD / year
As an IBM Mainframe DB2 Specialist, you will be responsible for the administration, optimization, and support of DB2 for z/OS environments that power critical enterprise applications. You…
Added 24 days ago
IBM MQ Series FTE z/OS Admin System Programmer
ESRhealthcare and EXEC STAFF RECRUITERS
Frisco, TX
Support integration of MQ with CICS, DB2, IMS, and other z/OS subsystems
Added 25 days ago
Mainframe Administrator
IPolarity LLC
Whippany, NJ
We are seeking a highly skilled Mainframe DB2 Systems Administrator to manage and support DB2 for z/OS subsystems in a mission-critical enterprise environment. This role is responsible for…
Added 25 days ago
Senior IBM z/OS & z/OS Connect Administrator
ITTConnect
Columbus, OH
Support z/OS upgrades, IPL planning and execution, system initialization and post-IPL validation.
Added 27 days ago
Systems Administrator - Virtual
Alight Solutions LLC
United States
The IT Systems Administrator plays a vital role in supporting the stability and performance of our zCloud (Mainframe) environment. The primary focus of this position is to assist with z/OS…
Added 28 days ago
DB2 System Administrator (38823)
IDEALFORCE LLC
Columbus, OH
At least 8 years of experience as a DB2 Systems Administrator and as a CICS support lead.
Added 28 days ago
System Administrator 4/SA4 (41060)
IDEALFORCE LLC
Columbus, OH
This Under immediate supervision, learns technical nuances of a complex computer environment, performs file system maintenance & tuning, assists with system tuning, performs software…
Added 28 days ago
Mainframe Database Administrator
TecTammina
Trumbull, CT
Create policies, standards and procedures for the database system support and usage

Smith Johnson Tech

16310 - Senior Mainframe DBA

Salt Lake City, UT, United States

Apply About employer

Applications open in a new tab.

Job details

Posting language: English

Original job description

Work Model Onsite

SUMMARY

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 role, you will serve as the primary onsite DBA point of contact for database administration, production support, performance optimization, security, and disaster recovery activities. You will collaborate with application developers, architects, QA teams, DevOps, integration teams, offshore delivery teams, and third party partners to design, maintain, and support reliable DB2 environments for enterprise clients.

This is an excellent opportunity to work on challenging client engagements, contribute to modernization and cloud related initiatives, and grow your career within a collaborative consulting environment that values technical excellence, initiative, and continuous learning.

RESPONSIBILITIES

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

QUALIFICATIONS

Required:

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:

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

BENEFITS

This is a contract opportunity with a great organization. As a contractor for Smith Johnson, you are eligible for medical, dental, life, disability. Smith Johnson pays for 70% of your medical and dental and 100% of life and disability. The contract is also eligible for PTO/holiday accrued monthly. You are also eligible for a 3% retirement matching plan. Smith Johnson believes in taking care of our contractors.

Apply About employer

More about this job

Skills

IBM DB2
CGI
Database administration
Implement ICT recovery system
DevOps
Data models
DDL
SQL
Troubleshoot
Statistics
Process improvement
JCL
Manage database
Root cause analysis
Regulatory compliance
Data protection
Liaise with architects
Troubleshooting
Computer science
Computer engineering
COBOL
CICS
Problem solving
Communication skills
Debugging

Report this job