Application Database Administrator

Centralbancompany; Jefferson City (MO); On-site; USD 85,000 - 120,000; Full time

Job summary

Centralbancompany seeks a database engineer to design, implement, and maintain database solutions across platforms, with DB2 Z/OS and MS SQL Server experience. You will review SQL, optimize queries, and support ETL/SSIS and SSRS reporting.

Ideal candidates have a BS in Information Systems, at least two years in DB2 Z/OS or MS SQL Server, strong communication, and the ability to work in a dynamic team environment.

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

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.

Skills

Database design

SQL performance tuning

Communication skills

SDLC knowledge

Problem solving

Team collaboration

Time management

DB2 Z/OS

Education

BS in Information Systems

BA in related field

Tools

MS SQL Server

SSIS

SSRS

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 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:

• 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