Database Administrator (DBA)

Medalogix is a one-of-a-kind data analytics company in the post-acute care space. We are transforming home health and hospice by leveraging cutting edge data science, machine learning, and innovative cloud technology to equip clinicians and agencies to provide the right care at the right time.

Medalogix is dedicated to empowering individualized patient care with innovative, data science-driven solutions that transform healthcare. The Company's machine learning products have demonstrated improved patient outcomes and reduced cost to the healthcare system, including reduced hospitalization, appropriate and timely transitions to end-of-life care, and optimized visit utilization for patients. Medalogix is poised for tremendous growth, as skilled home health and hospice care are positioned as the highest quality, lowest cost providers in an industry shifting to value-based care.

Medalogix is currently seeking hungry, humble, and smart Database Administrator to join our technology innovators that are bringing home health and hospice to the next level.

Why Medalogix?

Passionate Culture – Our success originates from our dedicated and incredibly talented team that operates with shared set of core values: Be Badass, Dream Big/Act Small, Do No Harm, and Row Together. In 2022, we earned the Great Place to Work Certification.

High Growth – Medalogix has grown 100%+ for three straight years, with continued material growth planned over the next three years.

Meaningful Work – Our products are used by healthcare providers in their day-to-day care programs. Our company’s work directly impacts patient care in the home.

Leading Technologies – At the core Medalogix is a technology company. We build modern, cloud-based SaaS software underpinned by data science and data engineering. Our technology team is passionate about using leading tools and practices in our daily work. Our market leading products are designed to equip home health and hospice agencies with technology to provide the right care at the right time. Medalogix products have received recognition from The Boston Globe, Fierce Healthcare, Becker's Hospital Review, HIMSS, and Harvard Business Review

Competitive Compensation & Benefits – Medalogix provides big company benefits in a smaller company environment. We provide competitive compensation along with awesome benefits including 401(k) matching.

Role Overview:

The Database Administrator is responsible for setup, support & management of our AWS and Azure cloud based SQL Server Databases across the production, test & development environments. The candidate will be responsible for creation and administration of SQL Server 2017, and 2019 databases in standalone, mirrored, and clustered environments. The candidate must have substantial hands-on technical experience in addition to strong conceptual knowledge about SQL Server database and underlying architecture and fundamentals. Duties and responsibilities are focused on database management and administration, including infrastructure strategy, design, deployment, monitoring and maintenance of database systems.

Duties & Responsibilities:

• Install SQL Server 2019 databases
• Support SQL Server 2017, and 2019 databases

• Write and optimize SQL
• Setup and support AWS RDS/Azure SQL instances
• Build and support database replication using mirroring and clustering
• Establish and maintain sound backup and recovery policies and procedures using SQL Server maintenance plans
• Adhere and improve “best practices” documentation

• Perform health checks and proactive monitoring
• Establishes and enforces all database standards and integrity
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Effectively execute on performance analysis, tuning & improvements of SQL Server database based application systems
• Install and support SQL Services Integration Services

• Database security and hardening (TDE, encryption in transit, etc), knowledge of TLS a big plus
• Willingness to learn and become the administrator of our Snowflake data lake/warehouse

Experience & Qualifications:

• Bachelor’s degree in Engineering or Computer Science or equivalent experience. AWS or Azure Cloud Practitioner certification.

• 5+ years SQL Server administration supporting a production environment;

• SQL Server Integration Services;
• Troubleshooting and resolving SQL Server database issues;
• Experience in code migration, database change management and data management through the various stages of the development life cycle;

• Ability to write complex SQL scripts;

• Database Encryption implementation;
• Database Disaster Recovery Implementation;
• AWS RDS / Azure SQL;
• Azure SQL Geo-Replication,
• Azure SQL Vulnerability Assessment Management;

• Experience with CI/CD for databases;
• Working knowledge of Security Group Implementations into Azure SQL;
• Knowledge of PowerBI
• Demonstrated experience in development of long-term database strategies for the enterprise environment to stay current with technology and provide the required functionality to the organization and as well as adherence to Change Control procedures and policies;

• Technically enthusiastic and willing to learn attitude is required;
• Familiarity designing disaster recovery procedures;
• Bonus skills: Working knowledge of Azure Data Factory/Warehouse;
• Bonus skills: Database IAC;
• Bonus skills: Snowflake Data Lake/Warehouse experience

Benefits

• Highly sponsored healthcare plans to choose from (PPO, HSA, and FSA)
• Optional Dental and Vision insurance
• 401(k) with company match; immediately vested
• Education Assistance Program/Employee Assistance Program
• Generous maternity / paternity leave
• We celebrate our wins with team events/outings
• Generous Paid Time Off + 8 Paid Holidays + Floating Holiday + Company Sponsored Volunteering Holiday
• Free downtown parking