Database Administrator V

**Glider: BOA-DBA-IV-V-1**

This position is onsite

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.

Primary Skill
Others - Please specify
Secondary Skill

Tertiary Skill

Required Skills
Position requires in-depth Mainframe DB2 DBA DB2 on Z/oS knowledge with a focus on performance and DB2 internals.
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.
- In depth working knowledge of 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
- In-depth understanding of DB2 Explain and ability to identify less than optimal access paths
- 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
- Understanding of Data Dictionaries including Brownstone.
- Background in database design for 24x7 availability.

Desired Skills
Excellent verbal and written communication skills

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.