Technical Consultant

Job Description:

Responsibilities include full life cycle management of DB2 mainframe databases from analysis through decommission. Additionally the Individual will be involved in DB2 related z/Os Database software upgrades, including DB2 Database, DB2 Connect, BMC and Shadow products.
Day to day activities would include:
• 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.