Sr Database Manager

Job Title: Sr Database Manager

Job Location: Tallahassee, FL 32399 (Onsite)

Duration: 12+ Months Contract with possibility to extension

Job Description:

Scope / Background: The scope is for Database Manager services on an hourly assignment basis to support the centralization and cloud-modernization of the Department's Health Management System (HMS). Services will be provided to the Florida Department of Health.

Project Overview: The contractor will provide technical support for HMS-related applications, including system design, application/database code creation or modification, troubleshooting, release/sprint planning support, documentation, required training, and compliance with data security and confidentiality requirements.

Type of Project: IT Staff Augmentation / Hourly Assignment – Database Manager Services

QUALIFICATIONS AND EXPERIENCE

Contractor staff assigned to this agreement must possess the following minimum qualifications and experience:

• A minimum of 7 years of documented experience working as InterSystems IRIS/Caché Object Script Developer and a thorough understanding of the Cache database system.
• A minimum of 7 years of documented experience in designing and implementing IRIS/Cache databases, including data modeling and Structured Query Language (SQL).
• A minimum of 7 years of documented experience using Hypertext Markup Language (HTML), Cascading Style Sheets (CSS), and Javascript.
• A minimum of 5 years of documented experience using SQL queries, Javascript Object Notation (JSON), jQuery, Ajax, Bootstrap, and eXtensible Markup Language (XML).
• Expert in object-oriented programming.
• Experience in building Web services and consuming web services in cache.
• Working knowledge of Simple Object Access Protocol (SOAP), Secure Sockets Layer (SSL) certificates, Java key stores, and encryption.
• Working knowledge of message/file transfer protocols: Transmission Control Protocol/Internet Protocol (TCP/IP), File Transfer Protocol (FTP), Secure File Transfer Protocol (SFTP), Pretty Good Privacy (PGP), (Public key/Private key).
• Working knowledge of data governance frameworks and compliance regulations, like the Health Insurance Portability Accountability Act (HIPAA), relevant to data management and privacy.

DELIVERABLES

Contractor will complete and submit the following deliverables to the Department in the time and manner specified:

Monthly: Provision of Database Manager services in the time and manner specified in Tasks 6.1.1-6.1.2.

6.1. SERVICE TASKS: Contractor will perform the following tasks in the time and manner specified:

6.1.1. Perform the following for applications based on Intersystems Cache, Cache Server Pages (CSP), HTML, Javascript, Jquery, Json, Ajax, and ASP.Net. 6.1.1.1. Create system designs and provide documentation for system feature enhancements and additions and bug fixes, daily, as specified in the work tickets assigned by the Department.

6.1.1.2. Modify and create application code and database code, ready for User Acceptance Testing, daily, as specified in the work tickets assigned by the Department.

6.1.1.3. Troubleshoot, determine, and document resolutions to system issues identified by the HMS Support group and the Applications Management team, daily, as specified in the work tickets assigned by the Department.

6.1.1.4. Provide work estimates, communication and updates for Release Planning, Sprint Planning and Daily Scrum, daily, as specified in the work tickets assigned by the Department.

6.1.1.5. Document application modifications and additions in a documentation repository, daily, as specified in the work tickets assigned by the Department.

6.1.2. Complete job required training as assigned by the Department. As directed by the Department, submit verification after each training (i.e. certification of completion, completed sign-in sheet, etc.).