- Install, configure, patch, upgrade, secure, and maintain Microsoft SQL Server instances, virtual machines, database objects, and supporting software across production, development, and testing environments.
- Write, troubleshoot, and optimize complex stored procedures, queries, and database code.
- Partner with application development teams to validate and deploy code safely to production.
- Write custom PowerShell and command shell scripts to manage, monitor, and maintain database servers and automated workflows.
- Design, implement, maintain, and test backup, recovery, and disaster recovery plans.
- Manage authentication, authorization, user access, and activity auditing; conduct security and access audits for HIPAA and internal data governance compliance.
- Monitor server health and system resources and perform short- and long-term storage and capacity planning.
- Create and maintain technical documentation, including installation runbooks, configuration justifications, change control procedures, data governance standards, and SQL coding guidelines.
Microsoft SQL ServerHIPAA