Database Administrator

Description:

The Database Administrator (DBA) ensures the stability, security, and performance of OCP’s enterprise data environment. This role is critical to maintaining trusted, compliant, and high-performing databases that power provider-facing reporting, enterprise analytics, and business operations. The DBA supports OCP’s migration to Azure, ensures databases scale with new practices and acquisitions, and partners with engineers and analysts to deliver accurate, reliable data across the organization.

Key Responsibilities

• Database Administration & Optimization
• Administer, configure, and maintain SQL Server and Azure SQL databases across multiple environments.
• Monitor performance, identify bottlenecks, and proactively tune queries, indexes, and storage for efficiency.
• Implement monitoring dashboards and alerts to anticipate and resolve issues before they impact users.
• Support schema design and changes to accommodate new applications, integrations, and acquisitions.

Backup, Recovery & Reliability

• Own database backup, restore, and disaster recovery processes across on-premise and cloud systems.
• Regularly test and validate recovery plans to ensure business continuity.
• Implement and support high-availability and failover solutions for mission-critical data systems.

Security, Compliance & Auditing

• Manage role-based access controls, encryption, and user provisioning across environments.
• Ensure compliance with HIPAA, HITECH, and internal data privacy/security standards.
• Conduct regular audits and collaborate with security teams to close vulnerabilities.
• Maintain audit trails and documentation for regulatory and internal review.

Cloud Migration & Hybrid Support

• Support OCP’s migration from legacy on-premise systems to Azure SQL and Synapse.
• Optimize hybrid environments during transition, balancing on-prem and cloud workloads.
• Collaborate with engineers to align pipelines with database best practices and performance requirements.
• Recommend cloud-native features (e.g., scaling, partitioning, replication) to improve resiliency and efficiency.

Collaboration, Documentation & Continuous Improvement

• Partner with data engineers and analysts to ensure data delivery meets reporting and analytics needs.
• Provide database expertise for cross-functional projects such as acquisitions, system integrations, and new data sources.
• Maintain detailed documentation of database architecture, configurations, and operational processes.
• Research and adopt new database features, tools, and automation practices to improve efficiency and reduce cost.

Requirements:

Required Qualifications

• Bachelor’s degree in Information Systems, Computer Science, or related field.
• 3–5 years of experience as a SQL Server DBA with exposure to Azure cloud.
• Strong knowledge of database tuning, indexing, partitioning, and performance monitoring.
• Experience implementing and maintaining backup, recovery, and high-availability solutions.
• Familiarity with HIPAA and healthcare data privacy/security requirements.

Preferred Qualifications

• Experience supporting healthcare applications (EHR, claims, financial, practice management).
• Hands-on experience with Azure Synapse, Data Lake, or other cloud-native data platforms.
• Familiarity with Power BI semantic models and enterprise reporting environments.
• Experience with automation tools for database monitoring, patching, or provisioning.

Physical Requirements:

• Ability to sit and work at a computer for extended periods.
• Occasional light lifting of office equipment (e.g., laptop, monitors) if needed.
• Occasional travel to market locations or corporate offices may be required.

Compliance:

• Adhere to all internal safety, security, and confidentiality standards.
• Maintain full compliance with HIPAA and other regulatory frameworks.