Senior SQL Server Production DBA
New
E
Embrace Healthcare GroupHealthcare software
Source API remote eligibility restrictions: United States, Overlap at least 4 hours with US Eastern TimeFull-TimeSenior
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Experience
- 5+ years of experience administering SQL Server (2016–2022) in 24×7 production environments
- Required Skills
- BashMicrosoft SQL ServerHIPAA
Requirements
- Have 5+ years of experience administering SQL Server (2016–2022) in 24×7 production environments.
- Have experience with on-premise and cloud-hosted setups.
- Know backup and restore strategies, index maintenance, performance tuning, and HA/DR solutions such as Availability Groups, log shipping, or mirroring.
- Be comfortable supporting customer-managed on-premise servers, VPN/ExpressRoute-integrated cloud VMs, and internal lab environments.
- Be proficient in T-SQL and PowerShell or Bash scripting for automation and operational efficiency.
- Have experience with large datasets, including table partitioning and archival strategies for tables with 100M+ rows.
- Be skilled at troubleshooting blocking, deadlocks, timeouts, and other database performance issues with development and support teams.
- Be able to overlap at least 4 hours with US Eastern Time.
- Nice to have: exposure to healthcare/EHR systems and HIPAA or HITECH data privacy regulations.
- Nice to have: Microsoft SQL Server certification.
Responsibilities
- Design and implement backup strategies for full and transactional log backups, and conduct restore tests against RPO and RTO targets.
- Respond to Sev-1 and Sev-2 database incidents, lead root cause analysis, and implement permanent solutions.
- Monitor wait statistics, index fragmentation, and resource-intensive queries, and recommend performance tuning.
- Track database file growth and forecast storage needs at least 90 days ahead.
- Review and validate SQL scripts, then apply changes across customer environments while maintaining version control and change history.
- Develop scripts and runbooks for provisioning environments and cloning databases.
- Implement database security practices, including encryption, least-privilege access, and auditing, and support HIPAA compliance.
- Maintain standard operating procedures and automate routine database tasks using scripting and lightweight DevOps pipelines.
View Full Description & ApplyYou'll be redirected to the employer's site
