Mainframe SRE

Job 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
Responsibilities
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
Qualifications
NA
About Us
At Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus.
Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.
We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.

Work arrangement
No