Locations: Jacksonville, FL/Richmond, VA / Charlotte, NC / Pennington, Jersey City, NJ / New York City, NY / Hybrid
Job Description & Responsibilities:
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.
Individual should have minimum of 7 plus years of DB2 DBA experience on z/Os at a single large financial institution.
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
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 .
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