Job
Description
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 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 Drive application migration from z/OS to modern technologies/Cloud 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) environment 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 Benefits include: Competitive base salaries Bonus incentives Support for financial-well-being and retirement Comprehensive medical, dental, vision, life insurance, and disability benefits (depending on location) Flexible working model with hybrid, onsite or virtual arrangements depending on role and business need Generous paid parental leave policies (depending on your location) Free access to global on-site wellness centers staffed with nurses and doctors (depending on location) Free and confidential counseling support through our Healthy Minds program Career development and training opportunities
