Mainframe DBA

Location: St. Louis, MO — Fully Onsite

MANDATORY SKILLS REQUIRED :

DB2 z/OS Mainframe | MS SQL Server | SQL | Database Administration | Performance Tuning | Indexing | Query Optimization | EXPLAIN | SSIS | SSRS | ETL | Data Warehousing | Database Design | SDLC | Systems Analysis | Troubleshooting | Technical Documentation | Stakeholder Communication

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.

Responsibilities

• 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.