> Markdown version of [/jobs/ext/4549286-senior-mainframe-db2-database-administrator](https://www.wearedevelopers.com/jobs/ext/4549286-senior-mainframe-db2-database-administrator). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Mainframe DB2 Database Administrator - **Company:** Job Cloud Inc. - **Location:** Plano, TX, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** COBOL (Programming Language), Databases, Data Security, IBM DB2, Database Queries, Database Security, Endevor, Job Control Language (JCL), Python (Programming Language), Mainframes, Performance Tuning, IBM Resource Access Control Facility, SQL Databases, Backup and Restore, Z/OS, Physical Data Models, Splunk, Sql Tuning - **Published:** November 3, 2026 - **Apply:** https://www.thejobnetwork.com/job/39911843-84b0-44a6-a78d-52faf587be75/senior-mainframe-db-database-administrator ## About the Role Minimum 7-9 years DB2 DBA experience at a large financial institution preferred. - Demonstrated job stability and reliability. - Proficient with DB2 utilities (IBM and BMC), and BMC tools (Change Manager, Catalog Manager, Mainview, SQL Performance). - Strong understanding of DB2 recovery, ACF2/RACF managed security, Endevor, ITSM processes (BMC Remedy), SMF data, and reporting. - Working knowledge of JCL, COBOL, SQL, IBM/BMC utilities, Splunk, and Python. ## Description Develop efficient log scraping strategies to optimize CPU, memory, and storage usage. - Build and maintain Splunk dashboards to monitor Db2 environments. - Collaborate with DB2 teams to establish and manage log retention policies for outage coverage. - Translate business requirements into physical data models, emphasizing performance, availability, and recoverability. - Advise application teams on ACF2 and RACF database security to ensure proper data access provisioning. - Define and implement backup and recovery strategies tailored for production environments. - Support DB2 replication product upgrades, act as communication focal point, handle DBA remediation, and assess new features. - Provide performance tuning and optimization recommendations for database queries in collaboration with development teams. - Monitor and resolve issues identified in exception reports to maintain production stability. - Participate in DBA production on-call rotation, including 24x7 SEV1 support. - Conduct knowledge sharing sessions with application teams as needed. - Support various audits and compliance reviews, ensuring all deliverables and deadlines are met. - Requires deep Mainframe DB2 DBA experience (DB2 on z/OS), with focus on performance tuning.