Job Description
Job Description:
Insight Global is seeking a Mainframe DB2 DBA (z/OS) for a leading financial services client. This role will focus heavily on performance tuning, database security, and maintaining stability across large-scale enterprise DB2 environments. The ideal candidate will work closely with application and infrastructure teams to design, optimize, and secure database systems, while also supporting critical production operations and upgrades. This person will play a key role in ensuring high availability, recoverability, and compliance in a complex, mission-critical environment.
Day-to-Day:
• Develop log scraping strategies to optimize CPU, memory, and storage usage
• Build and maintain Splunk dashboards to monitor DB2 environments
• Define and implement log retention policies
• Translate business requirements into DB2 physical data models
• Partner with application teams on database security (ACF2/RACF)
• Design and implement backup and recovery strategies for production
• Support DB2 replication upgrades, remediation, and feature evaluations
• Perform performance tuning and optimize database queries
• Monitor and resolve issues identified in exception reports
• Participate in 24x7 on-call rotation and SEV1 incident support
• Conduct knowledge-sharing sessions with application teams
• Support audits, SOX compliance, and control assessments
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
Must-Haves:
• 7–9+ years of Mainframe DB2 DBA (DB2 on z/OS) experience within a large financial institution
• Strong expertise in DB2 performance tuning and optimization
• Hands-on experience with DB2 Utilities (IBM & BMC)
• Working knowledge of BMC tools (Change Manager, Catalog Manager, MainView, SQL Performance tools)
• Deep understanding of DB2 recovery strategies and options
• Strong knowledge of ACF2 & RACF security models for DB2 access
• Experience working with Endevor
• Familiarity with ITSM tools/processes (BMC Remedy)
• In-depth technical knowledge of DB2 z/OS, JCL, COBOL, SQL
• Proven experience supporting production environments and on-call rotations
Nice to Have Skills & Experience
Plusses:
• Experience with SMF data analysis and reporting
• Knowledge of Splunk dashboards and monitoring
• Familiarity with Python scripting
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.