Mainframe Developer

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.

• 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

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

Qualifications

• 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