[Hiring] Senior Database Administrator @Embrace Software Inc.

Role Description

This is a remote position. The Senior SQL Server Production DBA will be responsible for owning the health, performance, and lifecycle of every database that powers EPOWERdoc’s product across production, staging, and development environments. This is a hands-on role managing dozens of customer-hosted, hybrid, and cloud instances. You will standardize basic database hygiene, including backups, index maintenance, performance tuning, scalability, and security. You’ll work side-by-side with architects, developers, Support, and IT teams to diagnose issues, provision new environments, and support our shift from on-premise installations to a future multi-tenant SaaS offering.

Responsibilities

• Backup & Recovery: Design and implement robust backup strategies that ensure both full and transactional log backups run on schedule. Conduct regular restore tests to validate that Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO) are consistently met.
• High-Severity Triage: Act as the primary responder for Sev-1 and Sev-2 database-related incidents. Drive timely root cause analysis and implement permanent solutions to maintain system stability and minimize future risks.
• Performance & Index Tuning: Continuously monitor wait statistics, index fragmentation, and resource-intensive queries. Provide clear and actionable tuning recommendations that improve query performance and reduce latency for high-impact customers.
• Capacity & Storage Planning: Track database file growth trends and forecast storage requirements at least 90 days in advance. Proactively engage with internal teams and customers to address potential disk space or I/O limitations before they become critical.
• Schema & Data Change Management: Review and validate SQL scripts submitted by development teams. Safely apply changes across customer environments while maintaining detailed version control and change history.
• Environment Provisioning: Develop and maintain repeatable scripts and runbooks for provisioning new environments or cloning databases. Support the efficient onboarding of new sites and refresh test environments as needed.
• Security & Compliance: Implement and enforce best practices for database security, including encryption at rest and in transit, least-privilege access controls, and comprehensive auditing. Ensure compliance with regulatory standards such as HIPAA.
• Process Improvement: Document and maintain standard operating procedures (SOPs). Identify opportunities to automate routine database tasks—such as backups, integrity checks, and deployments—using scripting and lightweight DevOps pipelines.

Qualifications

• 5+ years of experience administering SQL Server (2016–2022) in 24×7 production environments, including on-premise and cloud-hosted setups.
• Strong knowledge of backup/restore strategies, index maintenance, performance tuning, and HA/DR solutions like Availability Groups, log shipping, or mirroring.
• Comfortable supporting customer-managed on-premise servers, VPN/ExpressRoute-integrated cloud VMs, and internal lab environments.
• Proficient in T-SQL and scripting (PowerShell or Bash) for automation and operational efficiency.
• Experience with large datasets, including table partitioning and archival strategies for 100M+ row tables.
• Skilled at troubleshooting blocking, deadlocks, timeouts, and other database performance issues in collaboration with dev and support teams.
• Strong written and verbal communication; able to overlap at least 4 hours with US Eastern Time.

Nice to Have

• Exposure to healthcare/EHR systems and data privacy regulations (HIPAA, HITECH).
• Microsoft SQL Server certification.

Benefits

• Competitive salary, structured based on the UK working hours.
• Comprehensive training and mentorship programs for skill and knowledge enhancement.
• Opportunities for career advancement and professional development.