Application Database Administrator

Central Bank; Columbia Township (MO); 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 scalable database solutions across platforms with a focus on performance and reliability.

You will perform ETL using MS SQL Server SSIS/SSRS, apply SQL best practices, and collaborate with stakeholders to deliver data-driven insights while documenting structures and processes.

Qualifications

• Proficient data analysis and problem solving across platforms.
• Ability to communicate with technical and business stakeholders.
• Experience performing SQL code reviews and applying best practices.

Responsibilities

• Design, implement, and maintain database solutions across multiple platforms.
• Perform problem analysis and resolution related to data and databases across platforms.
• Research database structures including in-house and 3rd party solutions, data analysis, and documentation.
• Implement ETL using MS SQL Server SSIS and create MS SQL Server SSRS reporting.
• Ensure DB2 Z/OS environment readiness and documentation.

Skills

Data analysis

Stakeholder comms

Tools

DB2 Z/OS

MS SQL Server SSIS

MS SQL Server SSRS

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.