Mainframe Z/os Db2 Sre

Tata Consultancy Services; Cary (NC); On-site; USD 80,000 - 90,000; Full time

Job summary

Tata Consultancy Services Limited in Cary, NC seeks a Mainframe z/OS Db2 SRE to administer Db2 for z/OS, perform SQL tuning, manage SMF/RMF telemetry, and drive resilient, automated database solutions. You will lead architecture and coordinate across database, application, operations, and modernization teams.

Ideal candidates have Db2 for z/OS expertise, experience with BCP testing, and a track record of implementing CI/CD pipelines for database changes in a regulated environment.

Qualifications

• Experience administering Db2 for z/OS and database systems.
• SMF/RMF telemetry and application-trace analysis experience.
• BCP testing and recovery from safeguarded copies.
• Self-service automation for DDL/DML and CI/CD for database changes.

Responsibilities

• Lead the architecture, design and implementation of reliable, scalable 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 automation for DDL and DML requests and enable CI/CD pipelines for controlled database changes.
• Review telemetry and application traces; recommend SQL improvements and physical design changes.
• Support disaster recovery testing and data recovery from safeguarded copies.
• Troubleshoot and resolve incidents; participate in release, change, incident and problem-management processes.
• Maintain architecture standards, governance, roadmaps and blueprints while evaluating modernization opportunities.
• Lead cross-functional teams and multiple complex initiatives.

Skills

Mainframe

Db2 for z/OS

SQL tuning

CI/CD pipelines

Automation

OpenShift

Ansible

Python

Leadership

Education

TOGAF certification

IBM System Architect certification

Job description

Job Description

Mainframe z/OS Db2 SRE

• 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.
• Enable CI/CD pipelines for controlled database-change deployment.
• 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.
• 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.
• Salary Range- $80,000-$90,000 a year

• Location
• Cary, NC
• Function
• TECHNOLOGY
• Role
• Engineer
• ID
• 435924
• Skills
• Mainframe
• Salary Range
• $80,000 - $90,000