TECKpert is hiring a
IRIS Database Manager

Summary

The job description is for a Senior Database Manager position to support a government agency in Tallahassee, Florida. The role involves centralization and cloud-modernization of the Department’s Health Management System (HMS). The employee will work remotely and the contract term is for two years with a potential salary up to $170,000 per year.

Requirements

• Bachelor's degree in Computer Science, Engineering, or related degree
• Ten (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
• Five (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. This includes 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

Responsibilities

• Provide subject matter expertise in collaboration with the Centralization of HMS (CHMS)Project Team to design and establish the cloud environment as directed by the Department
• Perform configuration and optimization of the centralized IRIS instance as directed by the Department
• Collaborate with the CHMS Team to develop the data migration strategy as directed by the Department
• Implement Extract, Transform, Load (ETL) processes to migrate data into the centralized environment as directed by the Department
• Perform routine monitoring of database performance as directed by the Department
• Gather baseline metrics of the HMS performance in a distributed environment as directed by the Department
• In collaboration with the CHMS Team, develop performance metrics for a centralized instance of the HMS as directed by the Department
• Perform tuning and optimization of the centralized HMS database to achieve performance goals as directed by the Department
• Define and implement caching strategies to support performance goals as directed by the Department
• Monitor database performance and integrity using tools to detect and resolve database corruptions or inconsistencies as directed by the Department
• Update and patch the IRIS database to fix known bugs and vulnerabilities that could compromise data integrity as directed by the Department
• Implement data redundancy techniques to prevent data loss in case of hardware failure as directed by the Department
• Tune database for optimal performance, contributing to integrity by reducing the likelihood of errors during high-load scenarios as directed by the Department
• Work closely with developers to ensure that database design and access patterns are optimized for data integrity as directed by the Department
• Understand the roles and responsibilities of each user or user group to determine the level of access and permissions needed as directed by the Department
• Utilize the InterSystems IRIS management portal to create new accounts as directed by the Department
• Assign appropriate privileges and access levels to users based on their role and necessity, ensuring the principle of least privilege is followed as directed by the Department
• Review user access levels and adjust as necessary as directed by the Department
• Monitor database access and activities to detect any unauthorized or suspicious behavior as directed by the Department
• 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 as directed by the Department

Preferred Qualifications

• Preference given to candidates with Intersystems IRIS Certification(s); particularly the Intersystems IRIS System Administration Specialist
• Knowledge of data governance frameworks and compliance regulations, like the Health Insurance Portability Accountability Act (HIPAA), relevant to data management and privacy

Benefits

• Compensation and Term: This opportunity is for a full-time position with a two (2) year contract term with pay commensurate with experience up to $170,000 per year
• Candidates can work remotely
• Medical, dental, vision and life insurance available after 30 days of hire