DB2 Database Administrator

Role: DB2 Database Administrator

Locations: Plano, TX; Jacksonville, FL; Charlotte, NC; Hopewell, NJ (Onsite)

Duration: Long term Contract

• 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 Endeavor
• 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.