Before implementing any changes to the topology or database structure, review and evaluate the impact.
Make sure the databases are highly available, backed up, secure, and maintained
Examine the outcomes of the stress tests and offer suggestions to the development teams
Streamline procedures, automate managerial operations, and carry out routine administrative duties
Job Requirements:
Bachelor s/Master s degree in Engineering, Computer Science (or equivalent experience)
At least 6+ years of relevant experience as a Database Engineer
5-7+ years of experience developing T-SQL databases with MSSQL 2014-2016
Extensive background in developing and debugging sophisticated T-SQL queries
Ability to comprehend intricate business needs and know how to use different datasets in a healthcare database to meet those needs
Extensive experience working with ASP.NET/C# and T-SQL
A knack for retrieving massive datasets in a comprehensive and efficient manner
Ability to deconstruct data access, processing, and display logic for ETL and reporting procedures
Extensive knowledge in using native MSSQL tools to troubleshoot issues and analyze performance bottlenecks
Proven ability to use SSIS package deployment methodology and import data from a variety of data sources, including as text files, Excel spreadsheets, and XML
Familiarity with PHP/MySQL and SSIS is desirable
Prior knowledge of script component tasks and SSIS script tasks
An aptitude for comprehending front-end user requirements and a fix-it mentality
Nice to have some expertise in the healthcare industry, especially with a focus on standards for quality measurement like GPRO, HEDIS, and MIPS and interoperability like FHIR resources, QRDAs, and CCDs
Fluent in spoken and written English communication