Job Description

JOB SUMMARY:
The SQL Server Database Administrator is responsible for managing, securing, optimizing and modernizing a hybrid Microsoft data platform. This role supports SQL Server running on virtual machines, Azure SQL Managed Instance, and Azure SQL Database.
KEY RESPONSIBILITIES:
• Administer SQL Server environments hosted on virtual machines, Azure SQL Managed Instance and Azure SQL Database across production and nonproduction workloads.
• Install, configure, patch, upgrade and maintain SQL Server instances and related database services.
• Design, implement, test and document backup; restore, high-availability and disaster-recovery solutions aligned with business recovery objectives.
• Monitor database health, capacity, availability, and performance; troubleshoot blocking, deadlocks, query regressions, resource contention and connectivity issues.
• Optimize queries, indexes, statistics, execution plans, storage, compute and service tiers to improve performance and control cost.
• Implement database security controls, including least-privilege access, role-based permissions, encryption, auditing, vulnerability remediation and secrets management.
• Automate recurring administration, monitoring, deployment and maintenance tasks using T-SQL, PowerShell, Azure Automation or equivalent tools.
• Plan and execute database migrations and modernization initiatives among SQL Server on Azure virtual machines, Azure SQL Managed Instance and Azure SQL Database.
• Partner with application, cloud infrastructure, security, data governance, data engineering and business intelligence teams on solution design, release planning, incident response and capacity forecasting.
• Maintain operational documentation, runbooks, architecture diagrams, standards and change records; participate in an on-call support rotation as required.
• Perform other job-related duties as required or assigned.

QUALIFICATIONS:
• Working knowledge of SQL Server 2025 AI features including semantic search, RAG, NLP and SSMS CoPilot.
• Demonstrated knowledge with SQL Server on virtual machines, Azure SQL Managed Instance, and Azure SQL Database.
• Advanced proficiency in T-SQL, database performance tuning, indexing, backup and recovery, high availability, disaster recovery, security, monitoring, capacity management and maintenance of SQL Server and related services in virtual machine environments.
• Ability to support business-critical production databases and leading complex incident troubleshooting through resolution.
• Strong written and verbal communication skills, sound change-management practices, and the ability to collaborate across technical and business teams.
• Successful completion of Health Care Sanctions background check.

EDUCATION/EXPERIENCE:
• Bachelor’s degree in information technology, computer science, business information systems.
• A current Azure Database Administrator Associate certification.
• A minimum of seven years of professional database administration experience in enterprise environments.
• A minimum of three years of hands-on experience administering SQL Server data platforms in Microsoft Azure.
• Experience operating and supporting data integration solutions with Azure Data Factory preferred.
• Experience with Azure Synapse Analytics, including dedicated or serverless SQL workloads preferred.
• Experience with Microsoft Fabric, including OneLake, lakehouses and Fabric Data Warehouse preferred.
• Experience administering Power BI environments, including gateways, semantic models, refresh schedules, access controls, capacity, monitoring and governance preferred.
• Experience with infrastructure as code, source control, CI/CD pipelines and automated database deployment practices preferred.
• Experience supporting regulated, security-sensitive, or highly available enterprise environments and industries such as Healthcare, Financial Services or Oil and Gas preferred.
• Experience with other RDBMS platforms such as Oracle, PostgreSQL or MongoDB preferred.

CommunityCare is an equal opportunity at will employer and does not discriminate against any employee or applicant for employment because of age, race, religion, color, disability, sex, sexual orientation or national origin