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; manage capacity planning.
-

📌 Remote Consultant m|w|d (Ciudad de México)
🏢 Pyramid Consulting
📍 Ciudad de México