GENERAL DESCRIPTION

The role of the Database Administrator is critical in managing, maintaining, and optimizing the data infrastructure that supports our applications and business intelligence needs. This position requires a deep understanding of database technologies, security protocols, and performance tuning to ensure the reliability and integrity of our healthcare data. Going beyond standard administration, this role is key to empowering our development and analytics teams to deliver solutions with real-world impact.

AREAS OF RESPONSIBILITY
A successful Database Administrator will be able to perform these essential duties and responsibilities. Reasonable accommodations may be made, in accordance with applicable law, to enable individuals with disabilities to perform the essential functions.

The following is a list of essential functions, which may be subject to change at any time and without notice. Management may assign new duties, reassign existing duties, and/or eliminate function(s).

Database Management:
•Administer and maintain our databases across different environments (Production, QA, and Development) on Azure SQL and Snowflake.

ETL & Stored Procedures
•Manage and optimize ETL processes using Azure Data Factory and oversee the maintenance of numerous stored procedures used for local data processing.

Data Security:
•Implement and manage robust security protocols, including user access control and data encryption, to ensure compliance with healthcare regulations.

Backup and Recovery:
•Develop, maintain, and regularly test comprehensive backup and recovery strategies to protect against data loss.
Performance Tuning:
•Analyze and optimize database queries, schemas, indexing to improve application performance for our MAUI, Blazor and Web API applications.

Data Services
•Fulfill ad-hoc data requests, such as data refreshes and database copies between environments, and provide support to cross-functional teams.
Collaboration
•Work closely with dotnet developers, Power BI analysts, and other IT professionals to support data needs, deployments, and new projects.
Monitoring and Reporting:
•Proactively monitor database health, performance metrics, and resource utilization, and generate status reports.

Administrative Functions:
•Perform general administrative tasks and support other staff as needed.
•Utilize the company’s software systems to enhance patient care and staff efficiency.
•Must be available during normal work hours (unless previously approved by direct supervisor). Additional hours may be required to complete normal business functions and/or projects.
•Utilize the company’s software systems and update information as required.
•Participate in coaching calls.
•Perform other duties as requested or required, in the sole discretion of the Company.

MISSION EXPECTATIONS
Take responsibility for your own work in completing tasks. Assist others so that the resources, assistance, or support is provided to achieve success in their daily work.
•Communicate, endorse, and demonstrate the Company’s mission, vision, and values.
•Prompt and regular attendance.
•Adhere to standards of behavior, dress code, including name tag and approved uniform, personnel department, and company policies.
•Attend in-services and meetings on a regular basis.
•Promote a culture of outstanding customer service and strive to enhance patient experience at all times.
•Must be available during normal work hours (unless previously approved by direct supervisor). Additional hours may be required to complete normal business functions and/or projects.
•Must possess the ability to deal tactfully with patients, employees, management, visitors, government agencies, and the general public and maintain an open-door policy for all employees.
•Must possess the ability to make independent decisions when circumstances warrant.