Contract Based SQL Developer OpportunityRole: SQL DeveloperLocation: Nashville, TennesseeHire Type: Contract (7 Months)Client: State of TNSkills Needed: XML, SQL, Json, API development, design, Stored Procedures, SQL Queries, MS SQL Server Databases, Views, Healthcare Informatics, and Implementation, SQL Server Reporting Services (SSRS), database design and optimization, Entity Management concepts and functions, development of API processes, C#, Structured Query Language (SQL) Server 2012 or later, SQL Server Integration Services (SSIS) development, complex query development, SQL Server Analysis Services (SSAS), SQL Management Studio (SSMS), Database design and implementation, Business Intelligence Development.Job DescriptionPosition Description: The Tennessee Department of Health (TDH) is currently recruiting a qualified candidate to support the maintenance of TDH’s Integrated Data System and associated business intelligence as a part of the Office of Informatics and Analytics (OIA).A qualified candidate must have experience working with MS SQL Server databases developing high-quality database solutions and possess in-depth knowledge of database design and optimization. The candidate must have experience in Entity Management concepts, design, and implementation as well as experience in the ascertainment and integration of new data sources. This position will be responsible for the critical development of intermediate to advanced SQL queries, stored procedures, views, and functions that ensure the overall infrastructure of the IDS is flexible and scalable to accommodate future needs.Additionally, the position will be responsible for developing and supporting enterprise integration technologies including the development of IDS interfaces/interoperability. This position requires a solid understanding of computer science fundamentals and experience with the utilization and development of API processes working with programs such as JSON, XML, SQL, and C#. This position will also be responsible for documenting all maintenance and update procedures to ensure that all future API’s and data sets are incorporated seamlessly within the IDS.This position will also directly support OIA’s data architect in the enhancement and maintenance of the Integrated Data System, the Integrated Data Warehouse and development of associated documentations.Key ResponsibilitiesSupport development and maintenance of the Integrated Data SystemSupport development and administration of Entity Management processes in the IDSSupport development and administration of the TDH’s Data LakeSupport development and administration of TDH’s Cloud platformSupport development and maintenance of internal Surveillance programAssist with development and execution of Quality Assurance protocolsSupport business intelligence design and implementationMinimum QualificationsEducation and Experience: Preferred Bachelor’s Degree in Computer Science or related field. Consideration for related technical certifications and/or work experience.
Experience in Structured Query Language (SQL) Server 2012 or later (5+ years).Skills: Stored procedure development and optimization, SQL Server Integration Services (SSIS) development, and complex query development utilizing multiple large data sources using SQL 2012 or later. Strong written and verbal communication skills required. Business Intelligence Development, Application Program Interface (API) developmentPreferred QualificationsExperience in SQL Management Studio (SSMS), SQL Server Integration Services (SSIS), Application Program Interface (API) development, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), working knowledge of Database design and implementation, and Healthcare Informatics preferred.