Senior Mainframe DBA

Shree Narayani Networking Solutions•Salt Lake, UT

3d•Onsite

About The Position

CGI is seeking an experienced Mainframe DB2 Database Administrator to support a banking-industry client in Salt Lake City, Utah. The role is the primary onsite point of contact for DB2 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 enterprise DB2 environments. The work also includes supporting modernization and cloud-related initiatives in a collaborative consulting environment. This is a 1-year contract-to-hire position, with conversion expected after one year. The role is 100% onsite in Salt Lake City. Participation in an on-call support rotation may be required.

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 mainframe technologies including COBOL, JCL, CICS, and VSAM, and 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.
Demonstrated 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 translate logical data models into efficient physical DB2 database designs.
Execute DDL to create and modify tables, views, storage groups, and other database objects, and 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 to improve application performance and minimize CPU consumption.
Monitor and troubleshoot DB2 performance issues involving access paths, locking, buffer pools, and SQL execution; analyze EXPLAIN output and diagnostic information 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 for potential 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 administration and monitoring tools, including DB2 Admin Tool and Query Monitor.
Provide production support, investigate incidents, perform root-cause analysis, and coordinate timely issue 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, SMEs, development and QA teams, 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.
Clearly communicate technical issues, risks, recommendations, and status updates to technical and nontechnical stakeholders.