Application Database Administrator

Central Bank; Sedalia (MO); On-site; USD 70,000 - 90,000; Full time

Job summary

Central Bank in Sedalia, MO is seeking a database engineer to design, implement, and maintain cross-platform database solutions. The role involves analyzing data issues, reviewing SQL for standards, and researching diverse database structures. Candidates should have experience with DB2 Z/OS and MS SQL Server ETL/Reporting tools.

Strong stakeholder communication is essential. The position focuses on delivering robust data architectures and efficient reporting workflows, aligning with business

Qualifications

• Experience designing and modeling relational databases.
• Ability to analyze data requirements and propose data-driven solutions.
• Strong ability to document database architectures and processes.
• Effective communication with business stakeholders and technical teams.

Responsibilities

• Design, implement, and maintain database solutions across multiple platforms.
• Perform problem analysis and resolution related to data and databases across platforms.
• Review SQL code for standards and best practices; evaluate cost and performance.
• Research database structures including in-house and third-party solutions; document findings.

Skills

Database design

Data analysis

Documentation

Stakeholder communication

Tools

DB2 Z/OS

MS SQL Server SSIS

MS SQL Server SSRS

SQL

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.