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.

• etl process management: schedule and troubleshoot clarity extracts and caboodle etl jobs.

• backup & recovery: perform regular backups, verify restores, and test disaster recovery plans.

• security & compliance: manage roles, permissions, and enforce hipaa/security standards.

• upgrades & patching: apply epic-released updates and rdbms upgrades in production and non-production environments.

• monitoring & troubleshooting: use epic and third-party tools to monitor database health and resolve issues.

• collaboration: work with application analysts, report writers, and infrastructure teams for system changes and enhancements.

• documentation: maintain operational runbooks, recovery procedures, and configuration guides.

• provide 24x7 on-call support, ensuring rapid resolution of critical system issues.

• document processes and technical specifications and deliver knowledge transfer to team members.

• track and resolve issues using a ticketing system.

• demonstrate strong understanding of both technical and business requirements in healthcare environments.

required qualifications:

• bachelor’s degree in computer science, information systems, or related field.

• 3–5 years of dba experience, with at least 2 years supporting epic systems as a database administrator.

• database administration experience is required.

• basic familiarity with ehr systems including workflows and business processes

• multiyear programming experience in classroom or business setting in programming languages such as tcl, javascript, java, or python.

• on-call support:



participate in after-hours support and change control processes and on-call support as part of an on-call rotation

• strong analytical and problem-solving skills.

• excellent communication abilities.

• willingness to work in us business hours

• willing and able to support multiple healthcare systems across three different time zones in the us.

• dedicated, self-motivated, adaptable, and self-directed with a strong work ethic.

must-have (non-negotiable) skills:

• epic cogito/clarity certification – required for administering epic’s analytics environment and etl processes.

• strong sql server expertise – proficiency in ms sql server, including performance tuning and query optimization.

• etl process management – hands-on experience with clarity console and caboodle etl workflows, troubleshooting failures, and ensuring data integrity.

• familiarity with programming languages api or scripting languages – java, c++, .net, python, javascript, etc.

important (strongly preferred) skills:

• epic caboodle & slicerdicer administration – ability to configure caboodle data models and manage slicerdicer security.

• system administration background – experience with linux servers, vmware environments, and storage systems supporting epic infrastructure.

• performance monitoring & capacity planning – skilled in using epic and third-party tools for proactive database health checks and resource planning.

• build ssis packages

good to have (optional) skills:

• data visualization tools – familiarity with qlik, power bi, or tableau for reporting and analytics.

• automation & scripting – ability to automate tasks using shell scripts or configuration management tools.

• cloud integration – experience integrating epic environments with cloud platforms (azure, aws) for backup or analytics workloads.

familiarity in developing and maintaining ssis packages.

📌 Medical records consultant (México)
🏢 Pyramid Consulting
📍 México