Db2 for z/OS Database Administrator

Matlen Silver; Plano (TX); On-site; USD 69,000 - 73,000; Full time

Job summary

Matlen Silver is seeking a Db2 for z/OS Database Administrator in Plano, TX, with 7+ years of Db2 DBA experience on z/OS. The role focuses on DB2 performance tuning, security (ACF2/RACF2), and backup/recovery strategies as part of a 12‑month engagement with potential extension. Other approved locations include Jacksonville, FL and Jersey City, NJ.

The position is 3 days onsite. You will develop log scraping strategies, build Splunk dashboards, and collaborate across teams to ensure optimal DB2

Qualifications

• Minimum of 7 years of Db2 DBA experience on z/OS.
• In-depth Mainframe Db2 on z/OS knowledge with performance tuning.
• Experience at a large financial institution preferred.
• Working knowledge of BMC tools including Change Manager, Catalog Manager, Mainview, and SQL performance.
• Solid understanding of Db2 recovery options.
• Broad understanding of ACF2 and RACF2 security for Db2 Access.
• Working knowledge of Endevor.
• ITSM processes and tools including BMC Remedy.
• Deep understanding of Db2 zOS, JCL, COBOL, SQL IBM Utilities and BMC Utilities.
• Understanding of SMF data and reporting.
• Knowledge of Splunk.

Responsibilities

• Develop log scraping strategies to limit CPU, memory usage, and staging space while log scraping.
• Build Splunk dashboards to monitor the Db2 environment.
• Work with other Db2 teams in setting up log retention policies to cover extended outages.
• Translate business requirements into a physical model prioritizing processing requirements, performance, availability, recoverability, and data access.
• Consult with application teams on ACF2 and RACF managed Db2 security.
• Define and implement backup and recovery strategies for production.
• Support Db2 replication upgrades and remediation activities; coordinate with dev teams.
• Provide performance tuning recommendations for database calls with development.
• Monitor and address items on exception reports to maintain a stable production environment.
• Support DBA production on-call rotation including 24x7 Sev1 test support.
• Share information in meetings with application teams as requested.
• Support SOX audits, control assessments, and database audits; ensure milestone deliverables are met.

Skills

Db2 on z/OS performance tuning

Mainframe Db2 on z/OS

SQL performance

SMF data & reporting

Db2 recovery options

RACF/ACF2 security

JCL/COBOL/SQL

Endevor

ITSM / BMC Remedy

Splunk

Tools

BMC Change Manager

BMC Catalog Manager

Mainview

Endevor

BMC Remedy

Splunk

Job description

Job Title: Db2 for z/OS Database Administrator

Duration: 12 months with extension possible to 18 months

Location: Plano, TX (3 days per week onsite)

Other Approved Locations: Jacksonville, FL or Jersey City, NJ

Pay Scale: $50-53/hr W2 (Cannot subcontract or C2C)

Job Description

Matlen Silver has partnered with a leading global financial services firm to recruit a Db2 DBA with extensive experience installing and managing relational databases running on z/OS. Your primary responsibility will be to ensure optimal Db2 database efficiency and security by analyzing database issues and monitoring database performance.

Responsibilities

• Develop log scraping strategies to limit CPU, memory usage, and staging space while log scraping.
• Build Splunk dashboards to monitor the Db2 environment
• Work with other Db2 teams in setting up log retention policies to cover for extended period of outages
• Translation of business requirements into a physical model for implementation with a focus on a clear understanding of processing requirements (peak times, etc), performance, availability, recoverability, and data access methods
• Consulting with the application teams on both ACF2 and RACF managed database security to ensure appropriate access is provisioned for data access
• Defining and implementing application specific backup and recovery strategies for the production environment.
• Support of product upgrades related to Db2 replication providing a focal communication point for development teams as well as completing owned DBA remediation activities, executing internal verification processes, conducting assessments of new feature/function and providing recommendations for use.
• Performance tuning support and recommendations for database calls, in cooperation with the application development team.
• Monitoring and addressing items on exception reports to ensure a stable production environment
• Support DBA production on call rotation including 24X7 SEV1 test support.
• Conduct information sharing meetings with the application teams when requested.
• Support of Self Identified Audits, Control assessments, Database Audits and SOX reviews, ensuring deliverables are complete and correct, and all milestone deliverables dates are met.

Qualifications

• Position requires in-depth Mainframe Db2 on z/OS knowledge with a focus on performance tuning.
• Individual should have minimum of 7 years of Db2 DBA experience on z/OS.
• Experience working at a large financial institution is preferred.
• Working knowledge of BMC tools including change manager, catalog manager, Mainview, and SQL performance.
• Solid understanding of Db2 recovery options.
• Broad understanding of ACF2 and RACF2 managed security for Db2 Access.
• Working knowledge of Endevor.
• Working knowledge of ITSM Processes and tools including BMC Remedy.
• In depth understanding of Db2 zOS, JCL, COBOL, SQL IBM Utilities and BMC Utilities.
• Understanding of SMF data and reporting.
• Knowledge of Splunk

About Matlen Silver

Experience Matters. Let your experience be driven by our experience. For more than 40 years, Matlen Silver has delivered solutions for complex talent and technology needs to Fortune 500 companies and industry leaders. Led by hard work, honesty, and a trusted team of experts, we can say that Matlen Silver technology has created a solutions experience and legacy of success that is the difference in the way the world works.

Matlen Silver is an Equal Opportunity Employer and considers all applicants for all positions without regard to race, color, religion, gender, national origin, age, sexual orientation, veteran status, the presence of a non-job-related medical condition or disability, or any other legally protected status.

If you are a person with a disability needing assistance with the application or at any point in the hiring process, please contact us at email and/or phone at: [e-mail] // 908-393-8600.