Mainframe Consultant

Avance Consulting; Cary (NC); On-site; USD 110,000 - 170,000; Full time

Job summary

Avance Consulting is seeking a senior Db2 for z/OS architect and DBA to lead architecture, design, and implementation of reliable, scalable Db2 solutions. You will provide technical leadership to cross-functional teams across database, application, and operations, focusing on modernization and governance.

Additionally, you will establish intake and change processes for new workloads, drive CI/CD automation for database changes, and review telemetry to optimize performance and design.

Qualifications

• Expertise in Db2 for z/OS subsystem administration and database administration.
• Strong SQL tuning and physical database design capabilities.
• Experience with mainframe modernization and zLinux environments.

Responsibilities

• Lead the architecture, design and implementation of 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 design changes.
• Troubleshoot Db2 for z/OS incidents and participate in release, change, incident and problem-management processes.

Skills

Db2 for z/OS

SQL tuning

OpenShift

Python

Ansible

Education

IBM System Architect certification

TOGAF certification

Tools

OpenShift

Ansible

Python

Job description

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.