Mainframe DBA (IMS and DB2) Level 3

Baker & Taylors; United States; Remote; USD 100,000 - 140,000; Full time

Job summary

A leading company is seeking a Senior Mainframe DBA to manage and optimize their main ERP system databases. The ideal candidate should have extensive experience in IMS and DB2 database administration, data migration, and system integration, ensuring the databases meet high availability and performance standards.

Qualifications

• Minimum 8 years of experience with IBM mainframe systems.
• Extensive experience with IMS database management and DB2.
• Proficient in SQL and JCL programming.

Responsibilities

• Design, implement, and maintain IMS and DB2 databases.
• Plan and execute data migration from IBM Data Propagator to IBM InfoSphere.
• Ensure data security and compliance with company policies.

Skills

Database Management

SQL

Performance Tuning

Data Integration

Data Security

Education

Bachelor's degree in technology or related fields

Tools

IMS DB/DC

DB2

IBM InfoSphere

JCL

Microsoft Suite

Job description

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

• Design, implement, and maintain IMS and DB2 databases on IBM mainframe systems.
• Ensure high availability, performance, and scalability of databases.
• Develop and execute SQL scripts for database management and automation tasks.
• Perform database tuning, optimization, and capacity planning.
• Implement and manage database backup, recovery, and disaster recovery procedures.

•Data Migration

• Plan and execute data migration projects from IBM Data Propagator to IBM InfoSphere.
• Develop migration strategies, including data mapping, transformation, and validation.
• Ensure data integrity and minimal downtime during migration processes.
• Collaborate with cross-functional teams to ensure successful migration and integration with existing systems.

System Integration and Support

• Collaborate with development teams to design and optimize database structures to support ERP applications.
• Provide technical expertise and support for the ERP system, ensuring seamless integration with EDI, Order Processing, Warehousing, and Financials.
• Troubleshoot and resolve database-related issues promptly.

Data Security and Integrity

• Ensure data security and compliance with company policies and industry standards.
• Monitor and manage database access and permissions.
• Conduct regular audits and implement measures to protect data integrity.

Tool and Utility Management

• Proficiency in IMS DB/DC, DB2, and IMS/DB2 Tools and utilities.
• Strong knowledge of JCL (Job Control Language) and TSO/ISPF.
• Familiarity with IBM InfoSphere, including DataStage and Data Replication.
• Experience with database monitoring and performance tuning tools.
• Develop and maintain scripts for automation and monitoring purposes.

Business Process Integration

• Apply basic accounting concepts to support business operations.
• Utilize Microsoft Suite for documentation, reporting, and communication.

Support and Maintenance

• Manage maintenance contracts and provide technical support to ensure continuous operation and timely issue resolution.
• Collaborate with cross-functional teams to support business needs and project initiatives.

Skills and Qualifications:

• Bachelors 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.