Systems Database Administrator
H
HJ StaffingHealthcare IT
100% remote, but candidates must reside in CaliforniaFull-TimeMiddle
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Experience
- Minimum of 3 years of experience in each of the listed areas: Systems DBA administration; database tuning, query optimization, code deployment, and complex T-SQL stored procedures; custom scripting and configuration; SQL Server BI tools or comparable platforms and data warehousing; and development platforms or languages.
- Required Skills
- Microsoft SQL ServerHIPAA
Requirements
- Hold a bachelor’s degree in Computer Science or a related technical field, or have an equivalent combination of education, coursework, and hands-on experience.
- Have at least 3 years of hands-on experience as a Systems DBA administering currently supported Microsoft SQL Server versions across production, development, and test environments.
- Have at least 3 years of experience in database tuning, query optimization, code deployment, and writing and debugging complex T-SQL stored procedures.
- Have at least 3 years of experience writing custom SQL, command shell, and PowerShell scripts.
- Be able to explain and justify virtual machine and SQL Server configuration decisions from scratch.
- Have at least 3 years of experience with Microsoft SQL Server BI tools (SSRS, SSIS, SSAS) or comparable platforms.
- Have experience maintaining data warehouse environments and enforcing data governance standards.
- Have at least 3 years of experience working alongside or developing with .NET, Java, C++, PERL, SAS, VB, or other modern programming technologies.
- Understand healthcare data confidentiality, security best practices, and HIPAA requirements.
- Be able to produce thorough technical specifications and communicate complex concepts clearly to developers, business stakeholders, and external partners.
- Preferred: Microsoft Certified Solutions Expert (MCSE) in Data Management and Analytics, or a comparable modern Microsoft Azure/SQL Server database certification.
Responsibilities
- 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.
View Full Description & ApplyYou'll be redirected to the employer's site