Medical Records Consultant

Pyramid Consulting, Inc; México; A distancia; MXN 700.000 - 900.000; Jornada completa

Descripción de la vacante

Pyramid Consulting, Inc. is seeking an Epic Cogito Database Administrator to support remote operations from Mexico.

You will administer Epic Cogito/Clarity, Caboodle, Chronicles, and related SQL Server databases, focusing on reliability, security, and performance across US business hours. Responsibilities include ETL management with Clarity/Caboodle, backup and DR planning, health checks, and collaboration with analysts and developers to ensure data integrity and scalable solutions for

Formación

• 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.
• Experience administering Epic Cogito/Clarity and data warehouses.
• Ability to work across US business hours and multiple time zones.

Responsabilidades

• Design, develop, and maintain databases for reliability and scalability.
• Document specifications and follow industry best practices.
• Install and monitor software; manage CPU, memory, and disk usage.
• Perform ETL operations with Clarity and Caboodle; monitor jobs and troubleshoot failures.
• Implement backup, recovery, and DR cutovers; ensure data security and HIPAA compliance.
• Collaborate with analysts, report writers, and infrastructure teams for system changes.
• Maintain runbooks, disaster recovery procedures, and configuration guides.
• Provide 24x7 on-call support for critical systems.

Conocimientos

SQL Server performance tuning

Problem solving

Communication

US hours availability

On-call experience

Educación

Bachelor's degree in CS / IS

3-5 years DBA, Epic exposure

Herramientas

Epic Cogito/Clarity Administration

Clarity Console & Caboodle ETL workflows

SSIS Development

Linux servers

VMware

Descripción del empleo

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

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.

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.