Hospital is seeking an experienced Epic Clarity/Cogito Specialist.
The Clarity/Cogito Database and ETL Administrator creates and maintains the databases for Clarity and Caboodle, Epic's Data warehouse product. They also install and maintain the Clarity Console used to transfer data nightly from Epic's operational database into the Clarity database and ensures that the extract, transfer, and load (ETL) process is completed daily.
Epic Clarity and Cogito certifications are required.
At least 3 years of experience as a DBA is required. Experience with SQL Server is required. Hospital Experience is preferred.
- Configure and maintain the Cogito databases
- Ensure optimal performance and integrity of ETL process by maintaining Epic best practices.
- Schedule and monitor a recurring Clarity extract process.
- Add new tables and columns to extracts as needed.
- Troubleshoot and resolve Clarity Console and ETL process errors.
- Work with the report writers to provide data needed for reports.
- Engage in capacity planning exercises to ensure adequate system resources.
- Apply RDMS upgrades and updates to production and non-production environments.
- Perform database backups and verify restores.