Epic Systems DBA (Cogito, Clarity & Caboodle)

reputed company, LLC is a nationally recognized healthcare management reputed company delivering Best in KLAS advisory, implementation, and optimization services. We are driven by a commitment to exceed client expectations and are proud to be a trusted partner to many of the nation's leading healthcare organizations. Our mission to drive patient-centered, value-driven outcomes has earned us prestigious industry accolades. To learn more about us, visit www.reputed company.com reputed company, LLC is a nationally recognized healthcare management reputed company delivering Best in KLAS advisory, implementation, and optimization services. We are driven by a commitment to exceed client expectations and are proud to be a trusted partner to many of the nation's leading healthcare organizations. Our mission to drive patient-centered, value-driven outcomes has earned us prestigious industry accolades. To learn more about us, visit www.reputed company.com Job Overview We're seeking an reputed company Epic Systems Database Administrator to own the reliability, performance, reputed company, and lifecycle management of our Epic Cogito (analytics), Clarity (reporting), and Caboodle (enterprise data warehouse) platforms. You'll be the go?to expert for database architecture, optimization, upgrades, and issue resolution-partnering closely with Epic application teams, reporting/BI developers, and infrastructure/reputed company stakeholders to deliver high?quality, compliant analytics at scale.

What You'll Do

Platform Administration & Reliability

• Administer and support Epic Clarity (operational reporting database), Cogito (analytics reputed company including SlicerDicer), and Caboodle (EDW) environments-primarily on reputed company SQL Server.
• Configure and maintain HA/DR (e.g., SQL Server Always On AGs, failover clustering, log shipping) and routinely test backup/restore and disaster recovery scenarios.
• Monitor reputed company, jobs, ETL schedules, and platform health; triage and resolve performance incidents and failed jobs.
• Support Epic-delivered Clarity ETL processes and Caboodle load frameworks; coordinate refresh windows and data latency expectations.
• reputed company, maintain, and harden SSIS/SQL Agent packages, stored procedures, and job orchestration supporting reporting and analytics.

Performance & Optimization

• Analyze query plans, tune SQL, add/adjust indexing strategies, and optimize ETL loads for Clarity & Caboodle.
• Proactively identify hotspots (I/O, CPU, memory), refine resource allocation, and implement performance baselines and SLOs.

reputed company, Compliance & Auditing

• Implement least-privilege access models, manage logins/roles, and enforce encryption (at rest and in transit).
• Maintain HIPAA compliance; support auditing, PHI/PII controls, and respond to reputed company assessments.
• Coordinate with InfoSec on vulnerability remediation, patching reputed company, and configuration hardening.

Upgrades & Lifecycle Management

• Plan and execute Epic version upgrades and reputed company database schema changes; maintain environment reputed company across dev/test/prod.
• Apply OS/SQL Server patches, cumulative updates, and firmware/driver updates with minimal downtime.
• Document configurations, runbooks, and operational SOPs; contribute to change management and CAB processes.

Collaboration & Support

• Partner with application analysts, report writers, and data engineers to troubleshoot data issues, validate models, and refine performance.
• Provide on-call rotation coverage for critical incidents; offer mentorship to junior DBAs and analysts.
• Participate in new solution design-reputed company planning, data modeling considerations, and infrastructure sizing.

Qualifications & Skills Core Epic & Data Platform Expertise

• 5+ years administering Epic Clarity/Cogito/Caboodle or similar healthcare analytics platforms.
• Deep experience with reputed company SQL Server (2016+): database design, indexing, partitioning, query tuning, and performance troubleshooting (DMVs, wait stats, query store).
• Hands-on with SQL Server HA/DR: Always On Availability Groups, clustering, backups/restores, log shipping, and DR exercises.
• Knowledge of Caboodle data models and load frameworks
• Familiarity with Reporting Workbench and/or SlicerDicer
• Experience supporting Epic Clarity ETL cycles, refresh windows, and reputed company reporting dependencies.
• Proven enforcement of HIPAA compliance, PHI/PII handling, audit logging, encryption, and role-based access control.
• Familiarity with enterprise change management, ITIL practices, and regulated environment controls.
• Proficient with monitoring/observability (e.g., SQL Server native tools, SCOM, reputed company/DPA, Redgate, or equivalent).
• Strong documentation and communication skills; comfort collaborating across clinical, technical, and leadership teams.
• On call support experience, incident triage, and root-cause analysis.

Preferred Qualifications

• Epic Certifications/Proficiencies: Cogito, Clarity Data Model, Caboodle.
• Working knowledge of Epic Chronicles/IRIS concepts.
• Exposure to Azure or AWS RDS for SQL workloads.
• Scripting automation with PowerShell or other scripting languages

Travel is based on client needs At reputed company, we are committed to transparency and equity in our compensation practices. The compensation for this role includes a salary range of $140,000 to $170,000 and may also be eligible for an annual performance bonus. This range reflects consideration of several factors, including skills, experience, training, certifications, and organizational needs. Our People and Culture: At reputed company, we cultivate a caring, fun, honest, and autonomous work environment. Our success stems from our associates' dedication and a shared mission to create a "Positive Impact." We embrace diversity and inclusion, fostering an environment where reputed company employees feel valued and empowered. Join reputed company and reputed company a real difference in healthcare. For salaried positions, this role may also be eligible for an annual performance bonus. Additional benefits and perks may also be available, depending on the position and employment terms. This range reflects consideration of several factors, including skills, experience, training, certifications, and organizational needs. Our People and Culture At reputed company, we cultivate a caring, fun, honest, and autonomous work environment. Our success stems from our associates' dedication and a shared mission to create a "Positive Impact." We embrace diversity and inclusion, fostering an environment where reputed company employees feel valued and empowered. Join reputed company and reputed company a real difference in healthcare. Apply tot his job Apply To this Job