This is a remote position.
THE OPPORTUNITY
One of our Wisconsin’s premier academic health systems, is seeking a Senior Enterprise Database Architect to lead a comprehensive performance optimization and architecture assessment initiative across their database ecosystem. This is a high-impact, hands-on engagement where you’ll work directly with clinical and IT leadership to ensure the data infrastructure powering Epic’s Cogito and Caboodle platforms — as well as the broader Oracle and Microsoft SQL Server estate — is tuned, resilient, and architected for long-term scalability.
If you’re the kind of architect who thrives on untangling complex database environments, diagnosing deep performance bottlenecks, and leaving systems measurably better than you found them — this role was built for you.
WHAT YOU’LL DO
Epic Cogito & Caboodle Architecture
• Conduct a full architecture review of Epic’s Cogito (operational reporting data warehouse) and Caboodle (enterprise analytics data warehouse) implementations
• Assess ETL pipelines, Clarity-to-Caboodle data flows, index strategies, and query execution plans for performance bottlenecks
• Validate Cogito/Caboodle configuration against Epic best practices and recommend tuning adjustments
• Partner with Epic analysts and report writers to optimize Chronicles, Clarity, and Caboodle query performance
Oracle & SQL Server Performance Engineering
• Perform deep-dive performance tuning across Oracle Database and Microsoft SQL Server instances supporting clinical, financial, and ancillary systems
• Analyze AWR/ASH reports (Oracle) and DMV/Query Store diagnostics (SQL Server) to identify resource contention, wait states, and optimization opportunities
• Review database configurations, memory allocation, I/O subsystems, and storage architecture for both platforms
• Develop and implement indexing strategies, query rewrites, partitioning schemes, and maintenance plans
Enterprise Architecture & Governance
• Map the complete database landscape: inventory all Oracle and SQL Server instances, versions, patch levels, and dependencies
• Assess high availability and disaster recovery configurations (Always On AG, Data Guard, RAC) and recommend improvements
• Evaluate security posture including encryption, access controls, auditing, and compliance with HIPAA/HITECH requirements
• Deliver a comprehensive architecture assessment report with prioritized remediation roadmap and executive-level recommendations
• Provide knowledge transfer sessions and runbook documentation for the internal DBA team
Requirements
WHAT YOU BRING
• 12+ years of enterprise database architecture and administration experience across Oracle and Microsoft SQL Server in large healthcare environments
• Deep hands-on expertise with Epic Cogito, Caboodle, Clarity, and Chronicles database layers, not just awareness, but real tuning and architecture experience. Should be Epic Certified
• Proven track record of leading full-stack database performance engagements: assessment, diagnosis, tuning, and documentation
• Expert-level knowledge of Oracle performance internals (AWR, ASH, SQL Profiles, RAC, Data Guard, partitioning)
• Expert-level knowledge of SQL Server performance internals (Query Store, DMVs, execution plans, Always On AG, columnstore, In-Memory OLTP)
• Strong understanding of healthcare data flows, HL7/FHIR integrations, and HIPAA-compliant database security practices
• Ability to communicate architecture findings and recommendations to both technical teams and executive leadership
Preferred Qualifications
• Epic certification in Cogito, Caboodle, or Clarity administration – Mandatory
• Oracle OCP or OCM certification; Microsoft Data Platform certifications (DP-300 or equivalent)
• Experience with database migration, consolidation, or cloud-readiness assessments (Azure SQL, OCI)
• Familiarity with monitoring tools such as SolarWinds DPA, Idera, Foglight, or Oracle Enterprise Manager
• Prior consulting or contract engagement experience with health systems of similar scale
Benefits
WHY INTERSCRIPTS
• Work with a trusted healthcare IT partner, HITRUST, SOC 2, ISO 27001:2022 certified with deep Epic ecosystem expertise
• Competitive contract rates commensurate with senior architect-level experience
• Direct engagement with a marquee health system — real problems, real impact
• Potential for extension or transition into ongoing managed services engagements
• Backed by InterScripts’ onshore and nearshore delivery teams for collaborative support
Skills Required
- 12+ years of enterprise database architecture and administration experience across Oracle and Microsoft SQL Server
- Deep hands-on expertise with Epic Cogito, Caboodle, Clarity, and Chronicles database layers
- Proven track record of leading full-stack database performance engagements
- Expert-level knowledge of Oracle performance internals
- Expert-level knowledge of SQL Server performance internals
- Strong understanding of healthcare data flows and HIPAA-compliant database security practices
- Ability to communicate architecture findings to technical teams and executive leadership
What We Do
InterScripts delivers comprehensive IT services and solutions, including management and technology consulting, to commercial, government, and healthcare organizations. They specialize in modernizing technology, data management, and secure data archival, notably with their AI-powered platform, BytePad.
