What are the responsibilities and job description for the Mainframe DBA (Chandler) position at Matlen Silver?
Local candidates required. No C2c or w2 referrals please.Responsibilities include:
Required Skills:
- 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.
Required Skills:
- 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, Mainview, 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
- In depth understanding of Db2 zOS, JCL, COBOL, SQL IBM Utilities and BMC Utilities.
Salary : $60