Derex Technologies Inc

Mainframe Database Administrator

Derex Technologies Inc St. Louis, Missouri, United States

IT Services and IT Consulting · 51-200 employees

10 h ago
dba Mid (2-5 yrs) Full-time United States
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

The Mainframe Database Administrator will design, implement, and maintain database solutions across multiple platforms, including DB2 Z/OS and MS SQL Server. They are responsible for performing problem analysis, conducting SQL code reviews, and implementing ETL processes using SSIS and SSRS reporting.

What they look for

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

Requirements

Candidates should have a bachelor's degree in Information Systems or a related field and at least two years of professional experience in DB2 Z/OS or MS SQL Server environments. Strong skills in database design, performance tuning, and effective communication with technical and business stakeholders are required.

Full description

Company Description

Derex Technologies Inc specializes in providing IT consulting, staffing solutions and software services. Globally headquartered in Harrison New Jersey since 1996 Derex delivers the highest quality technology professionals and an array of customized IT talent solutions designed to improve productivity and drive results to global clients throughout North America.

With over two decades of unparalleled experience, Derex provides supports to its clientele, across such industries as Systems Integration, Banking and Finance, Telecommunications, Pharmaceutical and Life Sciences, Energy, Healthcare, Technology, Transportation, and local and federal Government agencies.

Job Description

Role: Mainframe Database Administrator

Location: (St louis, MO) – Onsite Fully

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

Regards,

 

Manoj Goud

Derex Technologies INC

Contact : 973-834-5005 Ext 206

Additional Information

All your information will be kept confidential according to EEO guidelines.

Similar roles