Senior Database Administrator

Luxoft; Mexico; On-site; MXN 900,000 - 1,200,000; Full time

Job summary

Luxoft in Mexico is seeking an experienced Epic Cogito Database Administrator to support Epic's analytics and healthcare data platforms, including Clarity and Caboodle. This hands-on role focuses on SQL Server administration, ETL processes, and ensuring data security and availability.

You will optimize performance, manage SSIS packages, participate in on-call rotations, and collaborate with analysts and developers to keep production environments running smoothly.

Qualifications

• Epic Cogito / Clarity Certification
• Microsoft SQL Server Administration
• Epic Clarity & Caboodle Administration
• ETL Process Management
• SQL Performance Tuning & Query Optimization
• Backup, Recovery & Disaster Recovery
• SSIS Package Development
• Database Security & Compliance

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

Backup & Recovery

Clarity

ETL

Microsoft SQL Server

SSIS

Job description

• We are seeking an experienced Epic Cogito Database Administrator to support Epic's analytics and database platforms. This hands-on role is responsible for administering SQL Server databases, supporting Clarity and Caboodle environments, managing ETL processes, optimizing database performance, and ensuring the availability, security, and integrity of healthcare data systems.

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.

Mandatory Skills:

• Backup & Recovery
• Clarity
• Extract, Transform, Load (ETL)
• Microsoft SQL Server
• Microsoft SQL Server Integration Services (SSIS)

Mandatory Skills Description:

• Epic Cogito / Clarity Certification
• Microsoft SQL Server Administration
• Epic Clarity & Caboodle Administration
• ETL Process Management
• SQL Performance Tuning & Query Optimization
• Backup, Recovery & Disaster Recovery
• SSIS Package Development
• Database Security & Compliance

Nice-to-Have Skills Description:

• Experience supporting large-scale healthcare organizations or multi-site environments.
• Familiarity with cloud platforms such as Microsoft Azure or AWS.
• Experience with data visualization and reporting tools (Power BI, Tableau, Qlik).
• Experience automating administrative tasks using PowerShell, Python, or Shell scripting.
• Exposure to Linux administration and VMware infrastructure.
• Experience working within ITIL or structured change management processes.