Mainframe DB2 Z/OS & SQL ETL Administrator

Central Bank; Moberly (MO); On-site; USD 70,000 - 110,000; Full time

Job summary

Central Bank is seeking a database professional to design, implement, and maintain robust database solutions across multiple platforms. You will analyze data-related problems, review SQL for standards and costs, and research structures including in-house and third-party solutions.

Experience with DB2 on Z/OS, mainframe environments, and ETL with SSIS and SSRS reporting is preferred. Strong communication with technical and business stakeholders is essential for success.

Responsibilities

• Design, implement, and maintain database solutions across multiple platforms.
• Performs problem analysis and resolution related to data and databases across various platforms.
• SQL code reviews for standards, best practices and evaluate statement explain costs.
• Research database structures including in-house and 3rd party solutions, data analysis, and documentation.
• Previous knowledge and experience in a DB2 Z/OS environment.
• Understand technical environments for DB2 on Z/OS mainframe.
• Implement ETL using MS SQL Server SSIS and create MS SQL Server SSRS reporting.
• Effectively communicate with technical and business stakeholders.
• Other duties as assigned.

Job description

Central Bank is seeking a database professional to design, implement, and maintain robust database solutions across multiple platforms. You will analyze data-related problems, review SQL for standards and costs, and research structures including in-house and third-party solutions.

Experience with DB2 on Z/OS, mainframe environments, and ETL with SSIS and SSRS reporting is preferred. Strong communication with technical and business stakeholders is essential for success.