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

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