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
View details
Apply Now