Description
We are seeking an experienced Database Administrator V with a focus on DB2 DBA to join our team. In this role, you will play a key part in managing and optimizing our DB2 environment, ensuring its performance, stability, and security.
Key Responsibilities
- Develop and implement strategies for log scraping to optimize CPU, memory usage, and staging space.
- Create and manage Splunk dashboards to monitor the DB2 environment effectively.
- Collaborate with DB2 teams to establish log retention policies for extended outage scenarios.
- Translate business requirements into physical models, considering processing needs, performance, availability, and data access methods.
- Consult with application teams on database security, including ACF2 and RACF, to ensure appropriate data access.
- Define and implement backup and recovery strategies specific to applications in the production environment.
- Support product upgrades related to DB2 replication, including communication with development teams and executing DBA remediation activities.
- Provide performance tuning support and recommendations for database calls in collaboration with the application development team.
- Monitor and address items on exception reports to maintain a stable production environment.
- Participate in DBA production on-call rotation, including 24⁄7 SEV1 test support.
- Conduct information sharing meetings with application teams as needed.
- Support audits, control assessments, database audits, and SOX reviews, ensuring deliverables are complete and on schedule.
Qualifications
- Extensive experience as a Mainframe DB2 DBA (DB2 on z/OS) with a strong focus on performance tuning.
- At least 7-9 years of DB2 DBA experience within a large financial institution.
- Proven job stability and a solid understanding of DB2 utilities, including IBM and BMC.
- Experience with BMC tools such as Change Manager, Catalog Manager, Mainview, and SQL Performance.
- Strong knowledge of DB2 recovery options.
- Familiarity with ACF2 and RACF managed security for DB2 access.
- Working knowledge of Endevor and ITSM processes and tools, including BMC Remedy.
How To Apply
If you're a qualified candidate and excited about this opportunity, please click “Apply” to submit your application. We look forward to hearing from you soon!
Employment Type: Full-Time