Application Database Administrator

Central-Bank-c44c5195; Jefferson City (MO); Hybrid; USD 85,000 - 120,000; Full time

Job summary

Central Technology Services seeks a data/DB professional to design and maintain database solutions across platforms, including DB2 Z/OS and MS SQL Server. You will optimize queries, perform ETL with SSIS, and develop SSRS reports while coordinating with technical and business teams.

Ideal candidates have a strong grounding in database design, data warehousing, and SDLC processes, plus solid problem solving and teamwork abilities for a hybrid work environment.

Qualifications

• BS or BA in Information Systems or related field preferred.
• Strong knowledge of database design principles in relational and data warehousing.
• Experience with DB2 on Z/OS and MS SQL Server environments.
• Proficient in SQL performance tuning and indexing strategies.
• Experience with SSIS and SSRS for ETL and reporting.
• Strong communication and documentation skills.

Responsibilities

• Design, implement, and maintain database solutions across platforms.
• Analyze problems and provide resolution for data and databases.
• Perform SQL code reviews for standards and costs.
• Research database structures and document findings.
• Communicate effectively with technical and business stakeholders.
• Handle other duties as assigned.

Skills

Database design

SQL performance tuning

DB2 Z/OS

ETL with SSIS

SSRS reporting

Communication skills

Team collaboration

Education

B.S./B.A. in Information Systems

Tools

MS SQL Server

Job description

Full Time - Regular Central Technology Services

Job 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 3 rd 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.

Requirements

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

Position Type

Full Time - Regular

Department

Systems & Operations-006854

Work Hours

Monday - Friday 8:00am - 4:30pm

Standard Hours

40

Area of Interest

IT Services

Work Location Options

Hybrid

undefined

We strive to make this site accessible to all users. If you would like to contact us regarding the accessibility or need assistance, please email [e-mail] .