Application Database Administrator

Central Bank; Missouri; On-site; USD 85,000 - 110,000; Full time

Job summary

Central Bank in the United States is seeking a database specialist to design, implement, and maintain cross-platform database solutions. You will perform problem analysis, review SQL standards, and document data structures while supporting DB2 Z/OS mainframes.

The role requires ETL development with SSIS and reporting with SSRS, plus strong communication with technical and business stakeholders.

Qualifications

• Experience with DB2 Z/OS environments.
• ETL implementations using SSIS or similar tools.
• Ability to analyze data and document findings clearly.
• Strong communication with technical and business stakeholders.

Responsibilities

• Design, implement, and maintain database solutions across multiple platforms.
• Perform problem analysis and resolution related to data and databases across various platforms.
• Review SQL for standards, best practices and evaluate statement performance costs.
• Research database structures including in-house and 3rd party solutions, data analysis, and documentation.
• Understand DB2 Z/OS mainframe environments.
• Implement ETL using MS SQL Server SSIS and create MS SQL Server SSRS reporting.
• Effectively communicate with technical and business stakeholders.

Skills

SQL

ETL

SSIS

SSRS

DB2 Z/OS

Data analysis

Documentation

Stakeholder communication

Tools

MS SQL Server

DB2

Job description

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