Mainframe DB2 DBA

Matlen Silver; Plano (TX); On-site; USD 120,000 - 160,000; Full time

Job summary

Matlen Silver seeks a seasoned DB2 DBA with strong z/OS expertise to optimize performance, reliability, and security across production environments. The role focuses on tuning, backup/recovery strategy, and collaboration with application teams for data access controls.

Responsibilities include log scraping strategy development, Splunk dashboarding for monitoring, and participating in on-call rotations to maintain a stable production Db2 environment.

Qualifications

• 7-9 years of DB2 DBA experience on z/OS in a large financial institution.
• Deep knowledge of DB2 utilities (IBM, BMC).
• Experience with ACF2 and RACF security for DB2 access.

Responsibilities

• Develop log scraping strategies to limit CPU, memory usage and staging space.
• Build Splunk dashboards to monitor the Db2 environment.
• Define and implement backup and recovery strategies for production DB2 on z/OS.
• Support 24x7 Sev1 on-call production DBA rotation and incident response.
• Collaborate with application teams on security and data access controls.
• Perform DB2 performance tuning and recommendations with development teams.
• Assist with SOX audits and ITSM processes; ensure milestones are met.

Skills

Mainframe DB2

Performance tuning

z/OS DB2

DB2 security

Tools

Endevor

Mainview

Catalog Manager

Change Manager

BMC Remedy

Job description

Alternate locations- CHARLOTTE North Carolina JERSEY CITY New Jersey

Responsibilities include

• develop log scrapring 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, # trans 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.

Position requires in-depth Mainframe DB2 DBA (DB2 on Z/oS) knowledge with a focus on performance tuning.

Individual should have minimum of 7-9 years of DB2 DBA experience on z/Os at a single large financial institution.

Job stability is a key requirement.

experience with DB2 Utilities including IBM and BMC

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.