Job Title: Epic Cogito Database Administrator

Employment Type: Full-Time

Location: Remote in Mexico

Language: Advance (B2-C2)

Mandatory skills: Epic Cogito/Clarity Administration

MS SQL Server

ETL Process Management

Epic Caboodle & SlicerDicer Administration

SSIS Package Development

Key Responsibilities:

• Design, develop, and maintain databases to ensure reliability and scalability.

• Document technical specifications and follow industry best practices.

• Install and maintain software, monitoring system resources (CPU, memory, disk).

• Perform ETL (Extract, Transform, Load) operations in compliance with SLAs; monitor job execution, troubleshoot failures, and apply fixes as needed.

• Handle specialized data processes with accuracy and security.

• Implement and document backup and recovery procedures, including failover strategies.

• Maintain database security, ensuring systems are patched and compliant with security standards.

• Execute disaster recovery (DR) cutovers for critical systems to maintain business continuity.





• Manage authentication protocols to safeguard access.

• Plan system capacity, forecasting growth and ensuring redundancy for storage and CPU resources.

• Monitor performance, review logs and conduct health checks regularly.

• Optimize database performance, applying indexing and assisting developers in query tuning.

• Troubleshoot issues, including locked resources and user-related problems.

• Apply server patches and optimizations to maintain data integrity and security.

• Manage data warehouses, ensuring efficient storage and retrieval.

• Ensure compliance with data protection laws and organizational policies.

• Design and manage SSIS packages for automated data workflows.

• Collaborate with cross-functional teams to assess and fulfill SQL Server requirements.

• Database Management: Administer and maintain Epic databases (Clarity, Caboodle, Chronicles).

• Performance Optimization: Monitor and tune database performance;

📌 Medical Records Consultant (México)
🏢 Pyramid Consulting
📍 México