Epic Senior Enterprise Database Architect

Epic Senior Enterprise Database Architect

InterScripts is a Information Technology business based in Chantilly, VA and established in 2017 providing technology and platform enabled services and solutions. Historically, we have enabled our customers to realize the most value from their technology and resources through our Managed Services, Archival Solution, EHR, ERP, Advisory, Virtual Care, Technology, Application Development, and Cybersecurity services.

In addition, InterScripts has substantial experience in providing Technology and Platform Enabled solutions to commercial, public sector, and government entities. We are an ISO 27001, 9001 CMMI 3 and SOC 2 certified organization, signifying our ability to lower the risks for our clients’ application modernization efforts, custom development, support, operations, and MSP projects.

This is a remote position.

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.

• 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

• 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
• 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

• 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, column store, In-Memory OLTP)
• Strong understanding of healthcare data flows, HL7/FHIR integrations, and…