Job ID: FL-PR169012-R20597 (98290203)12P
Onsite SQL Server Admin (DevOps certified) with SSIS, BI Development Studio, OLTP, DSS, data warehouse, build/release, and ETL experience
Location: Tallahassee FL (DOH)
Duration: 36 months
Positions: 2
CONTRACTOR QUALIFICATIONS AND EXPERIENCE:
The Contractor must possess the following minimum qualifications and experience:
5.1. Five years of MS SQL Server Administration experience.
5.2. Five years of MS SQL Server Integration Services experience.
5.3. Five years of MS SQL Stored procedures, triggers, scheduling and performance tuning.
5.4. Five years of experience with MS SQL Server 2008 or a later version.
5.5. Five years of experience with Business Intelligence Development Studio or Visual Studio for package(s) development.
5.6. Five years of experience with SQL programming inclusive of stored procedures, functions, triggers, Data Transformation Services (DTS) packages, scheduled jobs, and linked servers.
5.7. Five years of experience with SQL relational databases, Online Transactional Processing (OLTP) and Decision Support System (DSS).
5.8. Five years of experience importing data into a large-scale data warehouse environment utilizing SQL Server Integration Services or Data Import functionality.
5.9. Five years of experience with Source Control systems such as Visual Studio Team Services or Team Foundation Server.
5.10. Five years of experience with software build and release management methodologies.
5.11. DevOps certified with five years of experience in HIV Surveillance, Budget, and Case Management systems.
6. CONTRACTOR RESPONSIBILITIES:
6.1. SERVICE TASKS: Contractor will perform the following tasks in the time and manner specified:
6.1.1. Assist with data management tasks for HIV testing data on a weekly basis as directed by the Department.
6.1.2. Produce and submit data reports related to quality improvement or technical assistance visits on a weekly basis as directed by the Department.
6.1.3. Maintain current SQL Server integration packages deployed in production daily.
6.1.4. Maintain and support the Department’s HIV/AIDS Data warehouse and other SQL Server Databases daily as directed by the Department.
6.1.5. Develop new SQL server integration packages as needed for Extract, Transform an Load (ETL)
daily as directed by the Department.
6.1.6. Collaborate with the Department’s Division of Disease Control and Health Protection (DCHP) information technology teams; design, develop, and code based on business requirements for the DCHP Master Person Index (MPUI) project as part of the overall strategic effort for integration and interoperability of its systems and software daily as directed by the Department.
6.1.7. Work with DCHP resources to standardize collection and storage of DCHP shared data daily as directed by the Department.
6.1.8. Implement and submit DCHP SQL Server database standards on the Department’s HIV/AIDS
databases as directed by the Department.
6.1.9. Monitor and optimize the existing Data Exchange Interfaces, including SQL Server Integration
Services (SSIS), or any other Department HIV/AIDS systems daily as directed by the Department.
6.1.10. Perform database administration tasks for the Department’s HIV/AIDS databases as per
Department policies and procedures daily as directed by the Department.
Assist with COVID-19. Contractor will be available to provide support off hours, holidays, and weekends as needed by the Department.
F Resume Self-Certification Form.pdf