Mainframe DB2 DBA

Infosys•Charlotte, NC

About The Position

In the assigned Job Role of Infrastructure Consultant 2, your Area Of Responsibility will be as below: ⦁ Collaborate with internal and client teams to resolve complex incidents, conduct root cause analyses, and document findings with preventive recommendations ⦁ Participate in evaluation of client IT infrastructure, prepare actionable assessment reports, and support due diligence to document infrastructure maturity and improvement opportunities ⦁ Contribute to the design of scalable, cost-effective IT infrastructure solutions, review reusable components, and develop technical documentation for deployed systems ⦁ Align release schedules and environment readiness, execute deployments as per protocols, perform post-deployment testing, and manage version control to track changes ⦁ Co-ordinate maintenance schedules, emergency fixes, and technology upgrades while ensuring uninterrupted integration into existing systems and processes ⦁ Facilitate performance data analysis across systems, coordinate insights on system behavior, and support capacity planning to optimize performance ⦁ Conduct security checks, recovery drills, and compliance audits, implement security measures, and coordinate continuity plans to maintain adherence to standards ⦁ Gather feedback to identify automation opportunities, analyze existing infrastructure processes, and propose enhancements for efficiency gains ⦁ Act as liaison with onsite, offshore, and vendor teams to document project requirements, ensuring effective collaboration ⦁ Develop a centralized repository of technical and procedural knowledge, leveraging insights from other projects to drive efficiency and retain organizational expertise Your contribution to the team: ⦁ A collaborative spirit and excellent communication skills. ⦁ Ability to handle complex incidents and implement resolutions ⦁ A knack for conducting IT infrastructure assessment and identifying key optimization opportunities ⦁ Focused approach towards deployment management, system optimization, and process automation initiatives including sector specific focus ⦁ The ability to work with cross-functional teams

Requirements

Hands-on administration experience with IBM Db2 for z/OS (v12 or v13) in production environments.
Deep proficiency with Db2 utilities (REORG, RUNSTATS, COPY/RECOVER, LOAD/UNLOAD, CHECK), DDL, and package/plan bind/rebind.
Expert level experience with IBM OMEGAMON for Db2 Performance Expert and related monitoring/reporting.
Proficient with IBM Db2 Utilities Suite automation and/or IBM Db2 Utilities Management tools.
Expert performance tuning skills: buffer pool sizing/thresholds, statistics strategy, access path analysis (EXPLAIN), and concurrency/locking diagnostics.
Strong experience working knowledge of z/OS operations (TSO/ISPF, SDSF, JCL, JES2/3) and dataset management.
In depth understanding of data sharing/Parallel Sysplex fundamentals and group buffer pool concepts.
Solid experience with mainframe security (RACF) and least-privilege access models.
In depth understanding of Db2 data sharing tuning (GBP sizing, castout, locking) and disaster recovery strategies.
Strong communication and documentation skills; ability to partner with developers and operations teams.

Nice To Haves

Advanced scripting/automation skills (REXX, Python on z/OS USS where applicable); experience with z/OSMF and Ansible for z/OS is a plus.
Experience in regulated industries (banking/finance/healthcare) and with ITSM platforms (ServiceNow) is good to have.
AI-assisted development experience with Copilot or similar tools.

Responsibilities

Collaborate with internal and client teams to resolve complex incidents, conduct root cause analyses, and document findings with preventive recommendations
Participate in evaluation of client IT infrastructure, prepare actionable assessment reports, and support due diligence to document infrastructure maturity and improvement opportunities
Contribute to the design of scalable, cost-effective IT infrastructure solutions, review reusable components, and develop technical documentation for deployed systems
Align release schedules and environment readiness, execute deployments as per protocols, perform post-deployment testing, and manage version control to track changes
Co-ordinate maintenance schedules, emergency fixes, and technology upgrades while ensuring uninterrupted integration into existing systems and processes
Facilitate performance data analysis across systems, coordinate insights on system behavior, and support capacity planning to optimize performance
Conduct security checks, recovery drills, and compliance audits, implement security measures, and coordinate continuity plans to maintain adherence to standards
Gather feedback to identify automation opportunities, analyze existing infrastructure processes, and propose enhancements for efficiency gains
Act as liaison with onsite, offshore, and vendor teams to document project requirements, ensuring effective collaboration
Develop a centralized repository of technical and procedural knowledge, leveraging insights from other projects to drive efficiency and retain organizational expertise