Mainframe Z/OS Db2 SRE

Techvilla Solutions · Cary, NC, Wake County, NC; North Carolina, United States

We are 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. The ideal candidate will possess strong expertise in Db2 subsystem and database administration, SQL performance tuning, database recovery, and mainframe modernization.

Key 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.

Required Skills and 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.