Lead Mainframe z/OS Db2 SRE - Performance & Automation

Veriipro

Cary (NC)

On-site

USD 120,000 - 170,000

Full time

12 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Veriipro is seeking an experienced Mainframe z/OS Db2 Site Reliability Engineer (SRE) to lead the administration, architecture, performance optimization, automation, and reliability of IBM Db2 for z/OS environments. You will drive DB2 subsystem administration, architecture design, and proactive performance improvements while modernizing mainframe capabilities with automation and CI/CD practices.

This role requires deep Db2 expertise, strong problem-solving, and leadership to coordinate

Qualifications

6–10 years of experience in mainframe database administration, Db2 engineering, database architecture, SRE, or related technical roles.
Strong hands-on experience with IBM Db2 for z/OS subsystem administration and database administration.
Expertise in Db2 systems DBA and application DBA responsibilities.
Strong knowledge of SQL performance tuning, query optimization, access paths, and physical database design.
Experience analyzing SMF/RMF data, performance reports, and application traces.
Knowledge of database backup, recovery, high availability, disaster recovery, and business continuity processes.
Experience with Db2 Safeguarded Copies and associated recovery procedures.
Experience automating database operations, including DDL/DML request processing and database change management.
Understanding of CI/CD pipelines, database deployment controls, version management, and release automation.
Familiarity with mainframe modernization and integration technologies, including zLinux, OpenShift, Ansible, and Python.
Strong troubleshooting, analytical problem-solving, and root-cause analysis skills.
Experience with technical architecture, solution documentation, governance, and stakeholder communication.
Ability to lead cross-functional teams and manage multiple complex technical initiatives.

Responsibilities

Db2 Administration: Perform IBM Db2 for z/OS subsystem administration, systems DBA activities, and application DBA functions.
Solution Architecture: Lead the architecture, design, and implementation of reliable, scalable, secure, and high-performing Db2 for z/OS solutions.
Performance Optimization: Analyze SQL queries, execution plans, application traces, and database access patterns to improve performance and resource utilization.
Physical Database Design: Design and optimize database objects, indexing strategies, table spaces, and other physical database structures.
Performance Monitoring: Analyze SMF (System Management Facilities) and RMF (Resource Measurement Facility) telemetry to identify bottlenecks and recommend improvements.
Database Automation: Develop self-service and on-demand automation for DDL and DML requests to streamline database provisioning and operational workflows.
CI/CD Enablement: Design and implement CI/CD pipelines for controlled, repeatable, and auditable database schema and code changes.
Resilience and Recovery: Support business continuity planning (BCP), disaster recovery exercises, database recovery procedures, and restoration from Db2 Safeguarded Copies.
Incident Management: Troubleshoot complex Db2 for z/OS issues and participate in incident, problem, release, and change management processes.
Mainframe Modernization: Evaluate and support mainframe integration, migration, and modernization initiatives involving zLinux, OpenShift, Ansible, and Python.
Governance and Standards: Maintain architecture standards, technical roadmaps, solution blueprints, operational procedures, and database governance practices.
Technical Leadership: Guide database administrators, application teams, operations engineers, and modernization teams through complex technical initiatives.
Stakeholder Management: Collaborate with business stakeholders, application owners, infrastructure teams, and enterprise architects to align technical solutions with business objectives.
Continuous Improvement: Identify opportunities to improve database availability, operational resilience, automation, security, and service reliability.