Contractor will perform the following tasks in the time and manner specified
Design cloud infrastructure to support a centralized HMS
Provide subject matter expertise in collaboration with the Centralization of HMS (CHMS) to Project Team to design and establish the cloud environment
Perform configuration and optimization of the centralized IRIS instance
Provide data migration support
Collaborate with the CHMS Team to develop the data migration strategy
Implement Extract, Transform, Load (ETL) processes to migrate data into the centralized environment
Perform tuning and optimization of infrastructure supporting the HMS in a centralized cloud environment
Perform routine monitoring of database performance ]
Gather baseline metrics of the HMS performance in a distributed environment
In collaboration with the CHMS Team, develop performance metrics for a centralized instance of the HMS
Perform tuning and optimization of the centralized HMS database to achieve performance goals
Define and implement caching strategies to support performance goals
Collaborate with the CHMS Team to maintain a database with the intent of ensuring data integrity
Monitor database performance and integrity using tools to detect and resolve database corruptions or inconsistencies
Update and patch the IRIS database to fix known bugs and vulnerabilities that could compromise data integrity Implement data redundancy techniques to prevent data loss in case of hardware failure
Tune database for optimal performance, contributing to integrity by reducing the likelihood of errors during high-load scenarios
Work closely with developers to ensure that database design and access patterns are optimized for data integrity
Collaborate with the CHMS Team to manage the creation of user accounts and maintain security levels at the direction of the Department.
Understand the roles and responsibilities of each user or user group to determine the level of access and permissions needed
Utilize the InterSystems IRIS management portal to create new accounts
Assign appropriate privileges and access levels to users based on their role and necessity ensuring the principle of least privilege is followed
Review user access levels and adjust as necessary
Monitor database access and activities to detect any unauthorized or suspicious behavior
Complete job required training as assigned by the Department.
Submit verification of completion of each training (i.e. submit a completed sign-in sheet, submit a certification of completion, etc.) to the Department Contract Manager
DATA SECURITY AND CONFIDENTIALITY TASK:
The Contractor, its employees, subcontractors, and agents must comply at all times with all Department data security procedures and policies in the performance of this scope of work as specified in the Data Security and Confidentiality document
Contractor will complete and submit the following deliverables to the Department in the time and manner specified
Monthly: Provision of IRIS Database Manager Services in the time and manner specified in Tasks