JobCubby JobCubby
Sign up
CENTRAL BANCOMPANY, INC.

Application Database Administrator

CENTRAL BANCOMPANY, INC. Jefferson City, Missouri, United States

Banking · 1,001-5,000 employees

23 h ago
dba Mid (2-5 yrs) Full-time United States
Log in to apply, save this posting, or score it against your profile with AI.

About the role

The Application Database Administrator will design, implement, and maintain database solutions across multiple platforms including DB2 Z/OS and MS SQL Server. Responsibilities also include performing SQL code reviews, managing ETL processes, and providing technical documentation for business and technical stakeholders.

What they look for

DB2 Z/OS MS SQL Server SSIS SSRS Database Administration SQL Performance Tuning Query Optimization Data Warehousing ETL SDLC Systems Analysis Technical Documentation Problem Solving Database Design

Requirements

Candidates should possess a bachelor's degree in Information Systems or a related field and have at least two years of professional experience with DB2 Z/OS or MS SQL Server. Strong analytical skills, proficiency in database performance tuning, and the ability to communicate effectively with diverse teams are required.

Full description

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.

Qualifications

QUALIFICATIONS:

  • BS or BA in Information Systems or related field preferred
  • Strong knowledge of database design principles in relational and data warehousing environment
  • Highly competent in database performance tuning, creation of right indexing strategy to meet data growth needs and query optimization
  • Strong SQL skills to provide code review and tuning feedback to the development and reporting team
  • Strong communication skills with the ability to communicate with business and technical teams.
  • Effectively communicates and documents technical architecture and solutions to internal peer groups as well as other groups
  • Strong knowledge of database administration, Software Development Life Cycle (SDLC), and systems analysis procedures
  • Strong analytical and problem-solving skills
  • Minimum of two years of professional experience in a DB2 Z/OS environment and/or MS SQL Server environment
  • Knowledge of Microsoft SQL Server integration and reporting services
  • Self-motivation and remains flexible in a dynamic work environment
  • A team player with solid communication skills, excellent at problem solving, troubleshooting, and embracing new challenges
  • Ability to manage time across multiple, simultaneous projects, with attention to detail.
  • Must demonstrate the ability to work effectively as a member of a team, as well as the maturity to work independently

Similar roles