About this role

Mainframe DBA

Location: St. Louis, MO — Fully Onsite

MANDATORY SKILLS REQUIRED :

Qualifications

BS or BA in Information Systems or related field preferred.
Strong knowledge of database design principles in relational and data warehousing environments.
Highly competent in database performance tuning, creation of appropriate indexing strategies to meet data growth needs, and query optimization.
Strong SQL skills to provide code review and tuning feedback to development and reporting teams.
Strong communication skills with the ability to communicate effectively with business and technical teams.
Ability to effectively communicate and document technical architecture and solutions to internal peer groups as well as other groups.
Strong knowledge of database administration, 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 Services (SSIS) and SQL Server Reporting Services (SSRS).
Self-motivated and flexible in a dynamic work environment.
Team player with solid communication skills, excellent problem-solving and troubleshooting abilities, and willingness to embrace 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.

Design, implement, and maintain database solutions across multiple platforms.
Perform problem analysis and resolution related to data and databases across various platforms.
Conduct SQL code reviews for standards and best practices and evaluate SQL statement EXPLAIN costs.
Research database structures, including in-house and third-party solutions, perform data analysis, and maintain 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.
Perform other duties as assigned.