InterScripts, Inc.

Database Administrator

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