DB2 Z/OS Mainframe & SQL Server ETL Specialist

Central Bank; Missouri; On-site; USD 90,000 - 120,000; Full time

Job summary

Central Bank in Missouri is seeking a database professional to design, implement, and maintain database solutions across platforms. You will analyze problems, optimize data workflows, and ensure data integrity in both mainframe and distributed environments.

Responsibilities include SQL standards reviews, researching data structures (in-house and third-party), ETL development with SSIS, and creating SSRS reports.

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 in Missouri is seeking a database professional to design, implement, and maintain database solutions across platforms. You will analyze problems, optimize data workflows, and ensure data integrity in both mainframe and distributed environments.

Responsibilities include SQL standards reviews, researching data structures (in-house and third-party), ETL development with SSIS, and creating SSRS reports.