Db2 z/OS DBA - Onsite 3x/Week, Performance Focus

Matlen Silver

Plano (TX)

On-site

USD 69,000 - 73,000

Full time

5 days ago

Be an early applicant

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

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.