Mainframe Developer Administrator (IMS & DB2 z/OS DBA)

IMS, DB2 z/OS

IMS FF, FP DBs

Drive application migration from z/OS to Postgres

Recommend performance improvements which optimize and fine-tune AXPs database and operating system data sharing complexes / environments

Support mainframe mission critical applications covering WCC SERVICES ACQUISITIONS, REMITTANCES, ACCOUNTS RECEIVABLE, MERCHANT, LOYALTY, CORP. etc. Totaling tens of thousands of database instances

Maintain standard procedural documentation related to all aspects of operating the mainframe IMS/zDb2 database business computing ecosystem

Participate in enablement of high availability / automated database reorganization procedures that minimize business client impacts, improve overall availability and allow for huge data volume scaling

Create, synch-up and refresh required mainframe IMS & Db2 data Warehouse databases for development, test and production (as directed) environments

Spearhead team efforts to upgrade to NEW and IMPROVED structure capabilities – e.g., converting OLD zDb2 VSAM tablespaces to massively improved Universal Table Space type structures – to enable PETABYTE data volume growth capabilities and in preparation for zDb2 VERSION 13

Create, synch-up and refresh required mainframe IMS & Db2 data Warehouse databases for development, test and production (as directed) environments

Spearhead team efforts to upgrade to NEW and IMPROVED structure capabilities – e.g., converting OLD zDb2 VSAM tablespaces to massively improved Universal Table Space type structures – to enable PETABYTE data volume growth capabilities and in preparation for zDb2 VERSION 13

Drive application migration from z/OS to Postgres

Legacy platform modernization

Support IMS FF, FP, DB2 z/OS maintenance, development, and migration activities

Mentor new junior team members to effectively develop and monitor database systems – pass on and nurture junior DBAs in the ways of properly administering critical mission operational DBMS systems, on the mainframe

Prefer Bachelor’s degree or higher in Information Management, Computer Science Engineering, or related subject

Design review meetings, involved in logical design and in converting logical model(s) into a physical database model(s)

Re-engineer and optimize mainframe access paths and assist in redesign of very large databases, via new function deployments, for performance reasons and for the inclusion / deployment of new tech-business features

Maintain and administer application database security in accordance with zDBMS and organizational approved standards and procedures

Provide maintenance like backups, reorganization, and database analysis & diagnoses / database error resolution

Utilize BMC Admin toolset Change Manager, IBM data studio, IBM visual studio to exploit automation functionality to complete LIFT & SHIFT tasks, across disparate platforms, not just mainframe DBMSs

Experience in using IBM, BMC utilities for IMS, DB2 z/OS DBs

Experience in IMS FF, FP DBs