Lead Mainframe z/OS Db2 SRE

Prism IT Global; Cary (NC); Presencial; USD 120 000 - 180 000; Tempo integral

Resumo da oferta

Prism IT Global in Cary, NC is seeking an experienced Db2 DBA to lead the administration of Db2 for z/OS subsystems and databases. You will optimize SQL, design physical structures, and guide modernization efforts across mainframe and OpenShift environments.

You will establish change and intake processes, automate DDL/DML requests, review telemetry, and participate in incident, problem and release management while providing technical leadership to cross-functional teams.

Qualificações

• Experience with Db2 for z/OS subsystem and database administration.
• SQL tuning and physical database design expertise.
• SMF/RMF telemetry and application-trace analysis knowledge.
• BCP testing and Safeguarded Copies recovery experience.
• Automation for DDL/DML requests and CI/CD pipelines.
• Mainframe modernization, OpenShift, Ansible, Python.
• Lead architecture, design and implementation of Db2 solutions.
• Technical leadership across database, application and operations teams.

Responsabilidades

• Lead cross-functional teams and complex initiatives.
• Establish intake and change processes for workloads.
• Develop self-service automation for DDL and DML requests.
• Review telemetry and traces; recommend SQL improvements.
• Support incident, release and problem-management processes.
• Maintain architecture standards and governance; drive modernization opportunities.

Conhecimentos

Db2 for z/OS

SQL tuning

Database administration

Mainframe modernization

OpenShift

Ansible

Python

Technical leadership

Incident management

Architecture governance

Ferramentas

OpenShift

Ansible

Python

SMF/RMF telemetry

CI/CD tooling

Descrição da oferta de emprego

• IBM Db2 for z/OS subsystem administration and database administration
• Db2 application DBA and systems DBA capabilities, including SQL tuning and physical database design
• SMF/RMF telemetry and application-trace analysis
• Database resilience, BCP testing and recovery from Safeguarded Copies
• Self-service automation for DDL/DML requests and CI/CD pipelines for database changes
• Mainframe modernization, integration, migration, zLinux, OpenShift, Ansible and Python
• Lead the architecture, design and implementation of reliable, scalable and secure Db2 for z/OS solutions.
• Provide technical leadership to database, application, operations and modernization teams.
• Establish intake and change processes for new workloads and tune Db2 subsystems and databases.
• Develop self-service, on-demand automation for DDL and DML requests.
• Review SMF/RMF telemetry and application traces; recommend SQL improvements and physical database-design changes.
• Support BCP testing and recovery of data from Safeguarded Copies.
• Troubleshoot and resolve Db2 for z/OS incidents; participate in release, change, incident and problem-management processes.
• Maintain architecture standards, governance, roadmaps and blueprints while evaluating modernization opportunities.

Generic Managerial Skills, If any

• Lead cross-functional teams and multiple complex initiatives.
• Communicate effectively with business stakeholders, application teams, infrastructure teams and enterprise architects.
• Apply strategic thinking, analytical problem solving, stakeholder management and architectural governance.
• Financial services or insurance industry experience preferred.
• Relevant IBM System Architect or TOGAF certification preferred.