The ideal candidate will have:
Mainframe, DBA, DB2 and Z/os, Performance tuning.
Job
Description:
•
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, Main
view, 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
Information
Locations Position Open to Locals or from neighbouring statesIndustry Information TechnologyStatus OpenJob Age 27 Day'sCreated Date 09/08/2025No.of Positions 2Duration 12 monthsZip Code
