Description :
This position will provide Clinical data solutions for Healthcare informatics efforts. We are looking for a highly motivated professional with strong organizational, analytical, and problem-solving skills.
Responsibilities:
Design , develop and optimize large, complex DB schemas, SQL scripts and objects to meet application functionality and performance requirements.
Requirements:
Expertise in Database Architecture in an environment that handles large volumes of data, excess of 500 million of new data records every day.
Strong analytical and organizational skills.This job involves analyzing existing databases and the client's needs to develop effective data driven solutions.
Demonstrate expertise in performance tuning including both query and server optimization utilizing SQL tools and/ or 3rd party solutions.
Strong knowledge and experience in data modeling, database design, optimization for performance SQL, stored procedures
Expertise in understanding complex business needs, analyzing , designing and developing solutions.
Hands-on development experience in SQL Server 2016 or above using SSIS and SSRS
Experience in troubleshooting and resolving data related issues.
Excellent oral and written communication skills
Expertise in performance tuning especially tuning complex queries, procedures, and indexing strategies.
Nice to have
Monitor and perform tuning on complex ETL jobs using meta-data/variables/parameters.