Database Architect

Database Architect

Req number:

R2294

Employment type:

Full time

Worksite flexibility:

Onsite

Job Summary

Database Architect provides services specific to the InterSystems IRIS data management software to support the centralization and cloud-modernization effort.

Job Description

We are searching for a Database Architect services specific to the InterSystems IRIS data management software to support the centralization and cloud-modernization of the client in Tallahassee, FL. A criminal history record check, including fingerprinting, on the consultant will be conducted. The duration is till end of June 2026. This position will be full-time and Onsite.

 

What You’ll Do

• 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

What You'll Need

Required:

• The Contractor must possess the following minimum qualifications and experience:

• 10 years of documented experience as a Database Manager managing and optimizing InterSystems IRIS and Cache databases, including experience with its advanced features for scalability, performance, and reliability

• 5 years of documented experience with cloud platforms such as Amazon Web Services (AWS), Azure, or Google Cloud. Experience must demonstrate knowledge of cloud database services, cloud storage solutions, and cloud migration strategies

• Documented extensive experience in multiple database migrations, preferably some experience moving databases to the cloud

• Documented experience in consolidating and centralizing databases, ideally in a large-scale environment, including planning, executing, and overseeing the centralization process

• Expertise in designing and implementing backup strategies and disaster recovery plans in a cloud environment

• Documented experience tuning database for performance by optimizing queries, indexing strategies, and server configurations

• Proficiency in automation tools and scripting languages for database tasks. Documented experience with tools like PowerShell, Bash, or Python

• Familiarity with DevOps practices and tools, and experience in implementing Continuous Integration/Continuous Deployment (CI/CD) Practices

• Preference given to candidates with Intersystems IRIS Certification(s); particularly the Intersystems IRIS System Administration Specialist

Physical Demands 

• Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state and local standards 

• Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc. 

• Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor

Reasonable Accommodation Statement

If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to or (888) 824 – 8111.

Equal Employment Opportunity Policy Statement

It is the policy of CAI not to discriminate against any employee or applicant due to race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran. It is also the policy of CAI to take affirmative action to employ and to advance in employment, all persons regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran, and to base all employment decisions only on valid job requirements. This policy shall apply to all employment actions, including but not limited to recruitment, hiring, upgrading, promotion, transfer, demotion, layoff, recall, termination, rates of pay or other forms of compensation and selection for training, including apprenticeship, at all levels of employment. Employees and applicants of CAI will not be subject to harassment due to race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran. Additionally, retaliation, including intimidation, threats, or coercion, because an employee or applicant has objected to discrimination, engaged or may engage in filing a complaint, assisted in a review, investigation, or hearing or have otherwise sought to obtain their legal rights under any Federal, State, or local EEO law is prohibited.