Zensar Technologies—Mainframe Database Administrator (IMS & DB2 z/OS DBA)

Job description

Description: - 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 Requirements: - 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 Responsibilities: - 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