Must Haves:

• 7+ years of experience with mainframe Cobol coding specifically with DB2
• Needs someone with strong knowledge/experience - won’t just be doing day to day tasks; will be providing recommendations to other DBAs
• application DBA experience in mainframe DB2 with strength in query tuning
• DB2 DBA Mainframe experience on z/Os - with a focus on performance and DB2 internals
• Performance tuning and troubleshooting – knows what to look for, where to go – not timid
• Identifying Performance reports
• In depth working knowledge of DB2 Utilities
• SMF Accounting data experience
• Qrep and CDC replication skills
• Large Financial Enterprise experience

Day to Day:

• Provision of technical consultation to application teams during the design of database solutions in regard to approach, resources, availability and recoverability.

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

• Implement, change, remove database owned components ensuring adherence to Enterprise and database standards

• Support of product upgrades related to DB2 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

• Supplying database technical expertise to application developers by assisting in development debugging efforts related to database and providing information on the various database utilities and facilities

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