Essential Duties & Responsibilities
Database Extraction
Extract data from source systems including Oracle, SQL Server, MySQL, PostgreSQL, Cache, and proprietary healthcare systems.
Execute extraction utilities and custom scripts.
Monitor extraction processes and troubleshoot failures.
Validate extracted data against source systems.
Generate extraction reports and row count validations.
Database Restoration
Restore extracted data into target environments such as Snowflake, SQL Server, Oracle, and cloud platforms.
Create and manage database schemas, tables, indexes, and constraints.
Perform backup, rename, truncate, and recovery operations.
Execute bulk data loads using approved utilities and scripts.
Monitor restoration performance and optimize loading processes.
Project & Client Support
Participate in project planning, extraction and restoration activities.
Communicate status updates to stakeholders.
Create technical documentation and workflow guide.
Support Project manager and client meetings and troubleshooting sessions.
Qualifications
Technical Skills
Databases: Oracle, Microsoft SQL Server, Snowflake, PostgreSQL & MySQL.
Query Languages: SQL, PL/SQL and & T-SQL
Operating Systems: Windows Server.
File Formats: CSV, TXT, XLSX, TSV, DAT and BACPAC
Soft Skills
Excellent communication and documentation skills.
Ability to manage, adapt and prioritize multiple tasks simultaneously.
Attention to detail and data accuracy.
Strong analytical and troubleshooting abilities
Education
Bachelor’s degree in computer science, Information Technology, Database Administration, or related field.
Experience
2+ years of experience in data extraction, restoration or migration roles.
Knowledge of data governance, security, and compliance within healthcare settings, ensuring adherence to HIPAA and other regulations
Additional Information
ELLKAY is committed to fostering a collaborative and high-performance work environment that supports innovation, teamwork, and professional growth. Most roles are designed to operate from our office locations to encourage effective collaboration and engagement across teams. Any alternative work arrangements may be considered at the company’s discretion based on role requirements and business needs. For more information about our company, please visit www.ELLKAY.com. ELLKAY is a Smoke-Free Workplace.
ELLKAY, LLC provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
