About the Job
This role involves configuring, maintaining and optimizing Cogito reporting databases to align with the environment strategy.
* Capacity planning to ensure sufficient system resources
* Monitoring database size and health
* Creating and managing plans for statistics and index maintenance
Key Responsibilities
1. Configuring and maintaining the Cogito databases according to the environment strategy
2. Engaging in capacity planning exercises to ensure adequate system resources
3. Understanding performance metrics, monitoring system performance, and troubleshooting issues
4. Managing logins for different types of access, including login behavior and working environment configuration
5. Applying RDMS upgrades and updates to production and non-production environments
6. Performing database backups and verifying restores
7. Participating in Change Control processes for all planned applications and technical activities
8. Ensuring Epic database changes are communicated to the necessary teams across the enterprise
Requirements
* Degree qualified in a relevant field (Data Science or STEM subject) or equivalent experience
* Working knowledge of the database operating systems
* Technically experienced in MS SQL Server analytical database platforms
Benefits
The company offers flexible work arrangements and individuals who live and work in Ireland will have the opportunity to split their monthly work hours between Letterkenny and telecommuting from a home-based office in a hybrid work model.
Career Development
You will be rewarded and recognised for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role, as well as providing development for other roles you may be interested in.