Mainframe Database Administrator

Job Description

Job Description – Mainframe DBA (IMS and DB2) Level 3 Baker & Taylor (“B&T”) is a leading global provider of physical and digital English language books and media content. The key to our success is largely dependent on the stellar ability of our Product Development & IT Services Team for developing and maintaining some of the Advanced technology platforms supporting content procurement, delivery, and analytics. Job Summary We are seeking an experienced Senior Mainframe DBA to join our team and support our main ERP system. The ideal candidate will have extensive experience in IMS database administration as well as experience in DB2 database administration and expertise in migrating IBM Data Propagator to InfoSphere. The ideal candidate will have a deep understanding of mainframe environments, including IBM z/OS, and demonstrate proficiency in database management, performance optimization, and data integration solutions. Responsibilities • Database Management o Design, implement, and maintain IMS and DB2 databases on IBM mainframe systems. o Ensure high availability, performance, and scalability of databases. o Develop and execute SQL scripts for database management and automation tasks. o Perform database tuning, optimization, and capacity planning. o Implement and manage database backup, recovery, and disaster recovery procedures. • Data Migration o Plan and execute data migration projects from IBM Data Propagator to IBM InfoSphere. o Develop migration strategies, including data mapping, transformation, and validation. o Ensure data integrity and minimal downtime during migration processes. o Collaborate with cross-functional teams to ensure successful migration and integration with existing systems. • System Integration and Support o Collaborate with development teams to design and optimize database structures to support ERP applications. o Provide technical expertise and support for the ERP system, ensuring seamless integration with EDI, Order Processing, Warehousing, and Financials. o Troubleshoot and resolve database-related issues promptly. • Data Security and Integrity o Ensure data security and compliance with company policies and industry standards. o Monitor and manage database access and permissions. o Conduct regular audits and implement measures to protect data integrity. • Tool and Utility Management o Proficiency in IMS DB/DC, DB2, and IMS/DB2 Tools and utilities. o Strong knowledge of JCL (Job Control Language) and TSO/ISPF. o Familiarity with IBM InfoSphere, including DataStage and Data Replication. o Experience with database monitoring and performance tuning tools. o Develop and maintain scripts for automation and monitoring purposes. • Business Process Integration o Apply basic accounting concepts to support business operations. o Utilize Microsoft Suite for documentation, reporting, and communication. • Support and Maintenance o Manage maintenance contracts and provide technical support to ensure continuous operation and timely issue resolution. o Collaborate with cross-functional teams to support business needs and project initiatives. Skills and Qualifications: • Bachelor’s degree in technology or related fields. • Minimum 8 years of experience with IBM mainframe systems. • Extensive experience with IMS database management. • Experience with DB2 database management. • Proficient in SQL and JCL programming. • Strong understanding of database design, optimization, and performance tuning. • Proven experience with data migration from IBM Data Propagator to IBM InfoSphere. • Understanding of basic accounting concepts. • Proficiency with Microsoft Suite. • Experience managing maintenance contracts and providing technical support. Preferred Qualifications • Experience in a distribution company. • Familiarity with EDI, Order Processing, Warehousing, and financial systems. • Knowledge of modern development practices such as Agile and DevOps. Show more Show less