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 initiatives, including DB2 Database Universal Tablespace conversions, Image Copy Backup Remediation, Data replication, Db2 RACF support, Db2 Version 13 migration.
Day to day activities would include:
Develop REXX programs to support Database and JIRA activities
Develop and implement Recovery strategy to support Cyber MRA activities
Support Db2 DBA team with database maintenance
Conduct information sharing meetings with the application teams when requested
Monitoring and addressing items on exception reports to ensure a stable production environment
Performance tuning support and recommendations for database calls, in cooperation with the application development team
Support of product upgrades related to DB2 upgrade and 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
Support RACF initiatives and support application team addressing Db2 access issues
Position requires in-depth Mainframe DB2 DBA (DB2 on Z/oS) knowledge
Individual should have minimum of 7-9 years of DB2 DBA experience on z/Os at a single large financial institution
In depth working knowledge of JCL and ISPF
Working knowledge QREP and CDC a plus
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 JIRA
Working Knowledge of Slunk a plus
REXX programming
Python programming a plus
Strong Verbal and Written Communication skills