Med-Metrix is looking to solve database development and maintenance issues, including ETL, transmission, encryption, and archiving of files, as well as improving database performance and providing operational support.
Requirements
- Minimum of three years SSIS experience
- Minimum of two years’ experience with C-Sharp andor VB.NET
- Thorough understanding of database structures, theories, principles, & practices
- Ability to write & troubleshoot SQL code & design stored procedures, functions, tables, views, triggers, indexes, & constraints
- Extensive knowledge of MS SQL Server 2012 or later
- Extensive knowledge with SSRSSSIST-SQL
- Technical knowledge of MS SQL Server internals with emphasis on query performance
Responsibilities
- Develop SSIS projects to handle ETL, transmission, encryption, and archiving of files received and generated SQL Database Tuning and Performance
- Design, develop, and maintain database tables, stored procedures, and supporting objects
- Build and support operational reports for company and clients
- Work with data team to provide operational support, resolve recurring problems
- Document database topology, architecture, processes and procedures
- Develop SQL queries and support ad hoc requests for data
- Assist with capacity planning and resource expansion through data aggregation and analysis
Other
- Four-year degree in Computer Science/Information Technology required
- Minimum five years working as a Database engineer or a related role
- Require ability to work independently with minimal supervision
- Ability to multi-task with several complex and demanding projects
- Strong interpersonal skills, ability to communicate well at all levels of the organization
