16310 - Senior Mainframe DBA

Smith Johnson Tech•Salt Lake, UT

5d•Onsite

About The Position

CGI is seeking a skilled Mainframe DB2 Database Administrator to work onsite in Salt Lake City, Utah. The role serves as the primary onsite DBA point of contact for database administration, production support, performance optimization, security, and disaster recovery. The DBA works with application developers, architects, QA, DevOps, integration teams, offshore delivery teams, and third-party partners to design, maintain, and support reliable DB2 environments for enterprise clients. The position may require participation in an on-call support rotation. This contract opportunity involves supporting enterprise database environments and contributing to client engagements, modernization and cloud-related initiatives, and continuous improvement efforts. The role requires at least six years of mainframe database administration experience and hands-on IBM DB2 for z/OS expertise. A bachelor's degree in a related technical discipline is requested, though equivalent technical experience may be considered.

Requirements

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.
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 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 in 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.
Initiative, sound judgment, and 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.

Nice To Haves

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.

Responsibilities

Serve as the primary onsite point of contact for DB2 database administration and related activities.
Collaborate with application developers and architects to turn logical data models into efficient physical DB2 database designs.
Execute DDL to create and modify tables, views, storage groups, and other database objects; manage schema evolution through DB2 ALTER activities.
Implement and maintain Universal Table Spaces, including PBG and PBR structures, and design and manage DB2 indexes.
Write, review, and tune complex SQL queries; monitor and troubleshoot performance issues involving access paths, locking, buffer pools, and SQL execution.
Analyze EXPLAIN output and diagnostic information to identify bottlenecks and recommend corrective actions.
Use Real Time Statistics to monitor database health and proactively schedule maintenance.
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; use DB2 Admin Tool and Query Monitor for administration and monitoring.
Provide production support, investigate incidents, perform root cause analysis, and coordinate timely resolution.
Administer DB2 security, including GRANT and REVOKE privileges, in accordance with enterprise access policies; support security, audit, compliance, and data-protection requirements.
Develop, test, and execute disaster recovery strategies; manage image copies, DB2 logs, backups, and recovery activities.
Participate in production readiness reviews, recovery exercises, and operational support activities.
Coordinate with architects, subject-matter experts, 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 to technical and non-technical stakeholders.