Zensar Technologies—Mainframe SRE

Job description

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