Database Analyst

Role: Database Analyst

Location: Tallahassee FL(REMOTE)

Long term Contract

CONTRACTOR QUALIFICATIONS AND EXPERIENCE

1. Five years of experience in data modelling, data mining, database standardization, deduplication and performance tuning.

2. Five years of experience developing Online Analytical Processing (OLAP) cubes using SQl Server Analysis Services.

3. Five years of experience developing SQL Server Integration Services packages performing Extraction, Transformation and Loading activities.

4. Five years of experience with dashboard and scorecard development.

5. 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.

6. Five years of experience with business intelligence tools and systems, such as SSRS.

7. Five years of experience with MS SQL product inclusive of MS SQL 2016,2019, 2022.

8. Five years of experience with SQL programming inclusive of stored procedures, functions, triggers, scheduled jobs, and linked servers

9. 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.

10. Three years of experience with software build and release management methodologies.

11. Two years of experience in a healthcare IT domain.

12. 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.

---