Database Analyst

Job Summary
Position: Database Analyst

Duration: 30 Months

Location: Tallahassee, Florida

Responsibilities:

Service Tasks: Contractor will perform the following tasks in the time and manner specified:

1. At the direction of the Department, develop code and application from the requirements and data needed, as gathered during either Joint Application Requirements (JAR) sessions or Joint Applications Design (JAD) sessions, or both to JAD and JAR sessions to produce SharePoint or Web pages using the division standard and Department standards (Web Update Procedures, IOP 50-17-2).

2. At the direction of the Department, develop backend code from the requirements and data needs, as gathered during JAR and JAD sessions to produce data driven web pages.

3. At the direction of the Department, develop code and application from the requirements and data needed, as gathered during JAR and JAD sessions, to enable role- based security.

4. At the direction of the Department, develop backend code from the requirements and data needed, as gathered during JAR sessions and JAD sessions, to produce administration tools and screens.

5. At the direction of the Department, develop code and application from the requirements and data needed, as gathered during JAR and JAD sessions, to provide direct input to and output from the Health Information Exchange (HIE) database.

6. At the direction of the Department, provide change management in a code promotion role in partnership with development team as defined within the Change Management Standard Operating Procedures document (642630-5).

7. At the direction of the Department, document, using MS Word, MS Visio, or other software, system technical objects, business requirements, business processes, and system processes.

8. At the direction of the Department, develop code, as gathered during JAR and JAD sessions with Integration Broker team to secure data transfer to and from other agencies.

9. At the direction of the Department, perform User Acceptance Testing (UAT), following the Department Application Testing Standards Global Artifact document, on the system and identify all potential issues.

10. At the direction of the Department, develop database resources, as gathered during JAR and JAD sessions, for the creation of a seamless single sign-on interface between Merlin and PRISM.

11. At the direction of the Department, create required reporting documents, using MS Project, MS Word, SQL Server, Crystal Reporting, Qlik Reporting, or other software.

12. At the direction of the Department, attend status meetings, JAR, and JAD sessions.

13. Weekly at the direction of the Department, update project plans using MS Project, or other software, with current task status.

14. At the direction of the Department, assist with any COVID-19 related issues that arise in relation to database analysis and development of new and existing functionalities using the Microsoft .Net programming and the SQL Server.

Qualifications And Experience:

Contractor staff assigned to this agreement must possess, at minimum, the following qualifications:

1. 10 years of experience with facilitating and developing applications from use cases process documents, and workflow diagrams.

2. 10 years of experience working with end-users and subject matter experts to document existing processes and identify appropriate changes to existing processes.

3. 10 years of experience translating the above documented processes to program code.

4. 10 years of experience interacting with highly confidential data as it relates to infectious diseases, personally identifiable information, and the security implications of such interaction.

5. 10 years of experience developing web-based applications in a Microsoft .Net environment.

6. 10 years’ experience with object-oriented development techniques.

7. 10 years of experience with database reporting tools.

8. 10 years of experience with facilitating, developing, and maintaining MS SQL databases

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

10. 10 years of experience in database deployment.

11. 10 years of experience in analyzing and developing role-based security.

12. 10 years of experience in database analysis and design.

13. 10 years of experience with data conversions and migrations.

14. Microsoft Certified SQL server DBA.

15. 4 years of experience with Visual Studio Team System.

16. 4 years of experience with Team Foundation Server.

17. 4 years of experience with Azure DevOps.

Job Type: Full-time

Schedule:

• 8 hour shift

Work Location: In person