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 DescriptionRole: 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 InformationAll your information will be kept confidential according to EEO guidelines.
Skills Required
- Bachelor’s degree in Information Systems or a related field
- Minimum two years of professional experience in a DB2 z/OS and/or Microsoft SQL Server environment
- Strong knowledge of relational database and data warehouse design principles
- Database performance tuning, indexing strategy, and query optimization experience
- Strong SQL skills, including code review and tuning feedback
- Knowledge of Microsoft SQL Server Integration Services and Reporting Services
- Strong database administration, SDLC, and systems analysis knowledge
- Strong analytical, problem-solving, troubleshooting, and communication skills
- Ability to document technical architectures and solutions
- Ability to manage multiple simultaneous projects with attention to detail
- Ability to work effectively independently and as part of a team
What We Do
DEREX Technologies, Inc. established in 1996 is engaged nationally in providing professional computer services, including management consulting firm. We provide expert services nationwide to Fortune 500 companies and other private and public organizations in the United States. Derex provides a multi-faceted portfolio of products and services to its clients, including complete IT solutions.
