Database Analyst

Role: Database Analyst Location: Tallahassee FL(REMOTE) Long term Contract CONTRACTOR QUALIFICATIONS AND EXPERIENCE - Five years of experience in data modelling, data mining, database standardization, deduplication and performance tuning. - Five years of experience developing Online Analytical Processing (OLAP) cubes using SQl Server Analysis Services. - Five years of experience developing SQL Server Integration Services packages performing Extraction, Transformation and Loading activities. - Five years of experience with dashboard and scorecard development. - Five years of experience with the development of reports using MS SQL Server Reporting Services (MS SSRS) and maintenance of enterprise reports using MS SSRS. - Five years of experience with business intelligence tools and systems, such as SSRS. - Five years of experience with MS SQL product inclusive of MS SQL 2016,2019, 2022. - Five years of experience with SQL programming inclusive of stored procedures, functions, triggers, scheduled jobs, and linked servers - Five years of experience with SQL relational databases, Online Transaction Processing (OLTP) and Decision Support System (DSS) serving in high performance, service-oriented, multi-tiered environments. - Three years of experience with software build and release management methodologies. - Two years of experience in a healthcare IT domain. - One year of experience with Prenatal Risk Screening datasets CONTRACTOR RESPONSIBILITIES SERVICE TASKS: Contractor will perform the following tasks in the time and manner specified: - Monitor and optimize the performance of existing Data Exchange Interfaces, including SQL Server Integration Services (SSIS) or any other HIV/AIDS data systems daily as directed by the Department. - Develop and submit new Data Exchange Interfaces utilizing SSIS, File Mover, or other available tools daily as directed by the Department. - Document and submit modifications and additions to integration processes, system technical objects and system processes and store in a documentation repository daily as directed by the Department. - Develop and submit database objects in Transact-SQL (T-SQL) in support of programming changes daily as directed by the Department. - Develop and submit Ad-hoc reports and queries on MSSQL databases daily as directed by the Department. - Process release tickets to manage user requirements and defect tickets to correct system errors within the timeframe directed by the specific ticket request. - Facilitate collecting system requirements with the Department's Division of Disease Control and Health Protection (DCHP) staff daily as directed by the Department. - Deliver code to perform system functions as defined in use requirements daily as assigned by the Department. - Perform testing on system changes to meet user-defined requirements daily as assigned by the Department. - Facilitate user acceptance testing (UAT) with the DCHP staff daily as assigned by the Department. - Produce and submit work estimates to implement user-defined requirements and system changes daily as directed by the Department. - Produce and submit status reports on the implementation of user-defined requirements daily as directed by the Department. - Coordinate with the Department's Information Technology staff to ensure processes are followed and in compliance with Department standards daily as directed by the Department. - Correspond (verbally and in written formats) with project teams, internal stakeholders regarding project activities deliverables, and status daily as directed by the Department. - Work with Division resources to standardize collection and storage of CHP shared data daily as requested by the Department.