Database Administrator

This is a fully remote position, open to applicants in Utah.

📋 Description

• Take responsibility for the health, performance, security, and architecture of relational and NoSQL/document database platforms across both on-premises and cloud environments.

• Ensure the stability of on-premises SQL Server while spearheading the migration of transactional workloads to Azure and facilitating the transition to Microsoft Fabric.

• Act as the primary technical owner and escalation point for both production and non-production databases and data stores.

• Drive database architecture, design standards, and the strategy for migration to Azure.

• Collaborate with Software Development, QA, Infrastructure, Enterprise Architecture, Information Security, Business Intelligence, and vendors.

• Administer, patch, secure, and provide support for on-premises SQL Server, including SQL Agent, SSIS, and linked servers.

• Inventory databases, dependencies, and data flows; plan migrations and decommission servers post-workload migration.

• Design Azure transactional environments, encompassing tiers, sizing, high availability, networking, and security protocols.

• Oversee migrations from assessment through to cutover, validation, and rollback; manage consumption and associated costs.

• Support cloud database workloads, including Cloud SQL, BigQuery, and PostgreSQL.

• Provide guidance on Microsoft Fabric source design, data movement, and integration with Lakehouse and warehouse frameworks.

• Administer NoSQL and document databases, including Azure Cosmos DB and MongoDB.

• Maintain monitoring, alerting, health checks, performance baselines, auditing, backup, high availability, and disaster recovery standards.

• Optimize queries and indexes and lead root cause analysis efforts.

• Configure auditing to align with Information Security's SIEM and support HIPAA, SOC 2, HITRUST, and URAC audits.

• Collaborate with developers and BI on data modeling, schema design, query patterns, database code reviews, and implementation of release changes.

• Advise QA on database testing standards and work together on acceptance criteria, masked test data, unit testing, and defect triage.

• Manage database change control and deployments across various environments.

• Establish database standards, maintain runbooks and documentation; automate routine tasks and provide guidance on licensing and emerging tools.

• Participate in on-call rotation and occasionally perform after-hours or weekend maintenance, migration, and incident resolution work.

⛳️ Requirements

• Extensive experience in SQL Server administration and T-SQL, with a focus on performance tuning, indexing, and query plan evaluation.

• Strong understanding of OLTP and analytical data modeling and database design principles.

• In-depth knowledge of Azure database services, including security, networking, high availability, and cost management.

• Familiarity with Google Cloud data services.

• Proficiency in database security, encryption, and auditing, including protection of PHI/HIPAA, Entra ID, Key Vault, and Defender for SQL.

• Working knowledge of NoSQL/document databases such as Cosmos DB and MongoDB, including aspects of data modeling, partitioning, and consistency.

• Experience with scripting in PowerShell and Python.

• Proficient in source control and CI/CD for database changes using Git, Azure DevOps, SSDT, and Flyway.

• A prevention-first mindset, strong documentation practices, and effective communication skills with both technical and non-technical stakeholders.

• Over 5 years of experience as a SQL Server DBA supporting business-critical production systems.

• At least 2 years of experience in administering and designing databases in Microsoft Azure.

• Have led or played a significant role in at least one database migration.

• Preferred production experience with at least one NoSQL/document database platform.

• Experience supporting development, QA, and BI teams within an Agile SDLC and formal change management processes.

• Experience in healthcare or regulated environments is highly preferred.

• Strongly preferred experience with Microsoft Fabric.

• A Bachelor’s degree in computer science, information systems, or a related field, or equivalent education and experience.

• Background screening required prior to employment commencement.

• Drug screening required for newly hired employees.

• Must comply with relevant HIPAA regulations and company policies regarding the confidentiality, privacy, and security of sensitive health information.

🏝️ Benefits

• A competitive compensation package.

• Comprehensive healthcare, vision, and dental insurance.

• Generous 401(k) matching.

• Paid vacation, PTO, and holidays.

• Opportunities for growth and training.

• An award-winning remote work environment.