Description
Who We Are - Motivated by Purpose. Powered by Clinical Expertise.
Founded in 1983, we’re a clinically-driven, tech-enabled utilization management company offering expert clinical reviews, regulatory guidance, and actionable insights to healthcare organizations.
Excellence starts with our people.
WE OFFER
- A competitive compensation package
- Benefits include healthcare, vision, and dental insurance
- A generous 401(k) match
- Paid vacation, PTO, and holidays
- Growth and training opportunities
- An award-winning remote work environment
POSITION OVERVIEW
The Database Administrator is responsible for the health, performance, security, and architecture of the organization's relational and NoSQL/document database platforms across on-premises and cloud environments. During a period of significant modernization, this role keeps on-premises SQL Server stable while leading the design and migration of transactional workloads to Azure and supporting the move to Microsoft Fabric. The position partners with Software Development, QA, Infrastructure, Enterprise Architecture, Information Security, Business Intelligence, and vendors, taking a prevention-first approach to protecting PHI and the organization's data.
Roles:
- Primary technical owner and escalation point for all production and non-production databases and data stores, on-premises and in the cloud.
- Lead database architecture, design standards, and Azure migration strategy in alignment with enterprise architecture.
- Primary database partner to application development, QA, and Business Intelligence teams.
- Proactively identify and resolve performance, capacity, security, and stability risks before they become incidents.
Major Responsibilities or Assigned Duties:
On-prem SQL Server Operations & Decommissioning
- Administer, patch, secure, and support on-premises SQL Server (SQL Agent, SSIS, linked servers), keeping it stable through the transition.
- Inventory databases, dependencies, and data flows to sequence migration; decommission servers once workloads move.
Azure Cloud Database Architecture & Migration
- Lead design of the Azure transactional environment (Azure SQL Database, Managed Instance, SQL on Azure VMs), including tiers, sizing, HA, networking, and security, through the architecture review process.
- Oversee the on-prem to Azure migration from assessment through cutover, validation, and rollback; manage consumption and cost.
Multi-Platform Data Environment
- Support database workloads hosted on various cloud platforms (e.g., Cloud SQL, BigQuery, PostgreSQL) with consistent standards.
- Advise on the move to Microsoft Fabric, including source design, data movement, and integration with the Lakehouse and warehouse.
NoSQL and Document Platforms
- Administer and support NoSQL and document databases (e.g., Azure Cosmos DB, MongoDB), including partition/shard key design, indexing policies, consistency levels, throughput and cost management, and backup/restore.
- Partner with Development and Infrastructure on data integrity and consistency across relational and NoSQL/document databases, including idempotency and retry patterns.
- Extend monitoring, alerting, PHI protection, auditing, and backup/DR standards to NoSQL and document databases.
Proactive Monitoring, Security & Continuity
- Maintain monitoring, alerting, health checks, and performance baselines; tune queries and indexes and drive root cause analysis.
- Configure auditing to Information Security's SIEM; design and test backup, HA, and DR to RPO/RTO targets; support audits (e.g., HIPAA, SOC 2, HITRUST, URAC).
Application Development, BI & QA Partnership
- Partner with developers and BI on data modeling, schema design, and query patterns; review database code and changes before release.
- Guide QA on database testing standards (integrity, regression, load, performance), with QA retaining ownership of test strategy.
- Partner with QA on database acceptance criteria, masked test data, unit testing, and defect triage.
- Manage database change control and deployments across environments under the IT change management process.
Standards & Continuous Improvement
- Establish database standards, runbooks, and documentation; automate routine tasks; advise on licensing and emerging tools.
Other duties as assigned
Requirements
Skills:
- Expert SQL Server administration and T-SQL, including performance tuning, indexing, andquery plan analysis.
- Strong OLTP and analytical data modeling and database design.
- Deep knowledge of Azure database services (security, networking, HA, cost); familiarity with Google Cloud data services.
- Database security, encryption, and auditing, including PHI/HIPAA protection, Entra ID, Key Vault, and Defender for SQL.
- Working knowledge of NoSQL/document databases (e.g., Cosmos DB, MongoDB), including data modeling, partitioning, and consistency.
- Scripting (PowerShell, Python) and source control/CI/CD for database changes (Git, Azure DevOps, SSDT, Flyway).
- Prevention-first mindset, strong documentation habits, and clear communication with technical and non-technical audiences.
Experience:
- 5+ years as a SQL Server DBA supporting business-critical production systems.
- 2+ years administering and designing databases in Microsoft Azure.
- Led or played a key role in at least one database migration.
- Production experience with at least one NoSQL/document database platform preferred.
- Supporting development, QA, and BI teams within an Agile SDLC and formal change management.
- Healthcare or regulated-environment experience strongly preferred; Microsoft Fabric experience strongly preferred.
Certifications (Preferred):
- DP-300, AZ-305, Google Professional Cloud Database Engineer, DP-700/DP-600 (or
- Snowflake/Databricks equivalent), Security+, or ITIL Foundation.
Education:
- Bachelor's degree in computer science, information systems, or a related field, or equivalent education and experience.
----------------------------------------
Work Environment:
Remote (work-from-home) position requiring standard computer and telephone use. On-call rotation and occasional after-hours or weekend work for maintenance, migrations, and incidents are required
Diversity Statement:
Diversity creates a healthier atmosphere: All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.
Drug-Free Workplace:
This company is a drug-free workplace. All candidates are required to pass a Background Screen before beginning employment. All newly hired employees will take a Drug Screen, as well as agreeing to all necessary Compliance Regulations on their first day of employment. Employees are required to adhere to all applicable HIPAA regulations and company policies and procedures regarding the confidentiality, privacy, and security of sensitive health information.
California Consumer Privacy Act (CCPA) Information (California Residents Only):
- Sensitive Personal Info: MRIoA may collect sensitive personal info such as real name, nickname or alias, postal address, telephone number, email address, Social Security number, signature, online identifier, Internet Protocol address, driver’s license number, or state identification card number, and passport number.
- Data Access and Correction: Applicants can access their data and request corrections. For questions and/or requests to edit, delete, or correct data, please email the Medical Review Institute at HR@mrioa.com.
