Epic Cogito SQL DBA - Clarity/Caboodle Expert

Luxoft; Mexico; On-site; PHP 5,629,000 - 8,130,000; Full time

Job summary

Luxoft is seeking an experienced Epic Cogito Database Administrator to support Epic's analytics and database platforms. This hands-on role administers SQL Server databases, supports Clarity and Caboodle environments, manages ETL processes, and ensures availability, security, and integrity of healthcare data systems.

You will collaborate with analysts, infrastructure teams, and report developers, optimize performance, maintain runbooks, and participate in on-call rotations to keep production

Qualifications

• Epic Cogito / Clarity Certification.
• Microsoft SQL Server Administration.
• Epic Clarity & Caboodle Administration.
• ETL Process Management.
• SQL Performance Tuning & Query Optimization.

Responsibilities

• Administer and maintain Epic SQL Server databases, including Clarity and Caboodle environments.
• Monitor database health, performance, storage, and system capacity to ensure high availability.
• Execute, monitor, and troubleshoot ETL processes, ensuring successful data loads and SLA compliance.
• Perform backup, restore, disaster recovery, and failover activities.
• Optimize SQL Server performance through indexing, query tuning, and database maintenance.
• Design, maintain, and support SSIS packages for automated data integration workflows.
• Maintain database security, patching, authentication, and compliance with healthcare security standards.
• Collaborate with application analysts, infrastructure teams, and report developers to support production environments.
• Create and maintain operational documentation, runbooks, and recovery procedures.
• Participate in an on-call rotation supporting production environments.

Skills

Epic Cogito Certification

Microsoft SQL Server Administration

Epic Clarity & Caboodle Administration

ETL Process Management

SQL Performance Tuning

Tools

SSIS

SQL Server Management Studio

Job description

Luxoft is seeking an experienced Epic Cogito Database Administrator to support Epic's analytics and database platforms. This hands-on role administers SQL Server databases, supports Clarity and Caboodle environments, manages ETL processes, and ensures availability, security, and integrity of healthcare data systems.

You will collaborate with analysts, infrastructure teams, and report developers, optimize performance, maintain runbooks, and participate in on-call rotations to keep production