Mainframe SRE Professional

Role Purpose

- Performs DB design, optimization, break-fix, administer DB security, implement automation, new DB features implementation, support assist with database software installations/upgrades, develop, and administer IMS v15 and DB2 z/OS v12 mission critical business operational application databases in development, test, pre-production production data sharing complexes

Recommended Experience

- 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

Scope

- 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

Functional Capability

- 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

NA

Mai Role Purpose

- Performs DB design, optimization, break-fix, administer DB security, implement automation, new DB features implementation, support assist with database software installations/upgrades, develop, and administer IMS v15 and DB2 z/OS v12 mission critical business operational application databases in development, test, pre-production production data sharing complexes

Recommended Experience

- 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

Scope

- 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

Functional Capability

- 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 , UDB And Postgres