DescriptionPOSITION OVERVIEWThe 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
RequirementsSkills:- 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
