高级数据库管理员
Senior Database Administrator
这是一个远程职位。
Embrace Healthcare Group 在北美推动一些最创新的医疗技术解决方案，专注于提升急诊环境中的临床效率和合规性。
EPOWERdoc 是 Embrace Healthcare Group 产品组合中的领先 SaaS 平台，专注于为各种规模的医院定制急诊科信息系统（EDIS）。由临床医生为临床医生设计，EPOWERdoc 通过直观的工作流程、可自定义的模板、同行评审的临床内容和实时编码支持，简化急诊室文档工作——帮助医护人员减少文档时间，更多地关注患者护理。
随着我们在医疗领域影响力的持续扩大，我们正在寻找充满热情的专业人士加入我们的团队。Senior SQL Server Production DBA 将负责管理 EPOWERdoc 产品在生产、测试和开发环境中所依赖的所有数据库的健康状况、性能和生命周期。
这是一个需要亲力亲为的职位，管理数十个客户托管的混合和云实例。您将标准化基本的数据库维护工作，包括备份、索引维护、性能调优、可扩展性和安全性。您将与架构师、开发人员、支持和 IT 团队紧密合作，诊断问题、配置新环境，并支持我们从本地安装向未来的多租户 SaaS 模式转型。如果您是一位积极主动的数据库专业人员，热衷于干净、高效运行的系统，我们期待您的加入！
职责
· 备份与恢复：设计并实施可靠的备份策略，确保全量和事务日志备份按计划执行。定期进行恢复测试，以验证恢复点目标（RPO）和恢复时间目标（RTO）是否始终满足要求。
- 高优先级故障处理：作为 Sev-1 和 Sev-2 数据库相关事件的主要响应者。推动及时的根本原因分析，并实施永久性解决方案，以保持系统稳定性并最小化未来风险。
- 性能与索引调优：持续监控等待统计信息、索引碎片和资源密集型查询。提供清晰且可操作的调优建议，以提高查询性能并降低高影响客户的延迟。
- 容量与存储规划：跟踪数据库文件的增长趋势，并提前至少 90 天预测存储需求。积极与内部团队沟通，确保资源合理分配。
查看英文原文
This is a remote position.
Embrace Healthcare Group powers some of the most innovative healthcare technology solutions in North America, with a focus on enhancing clinical efficiency and compliance across emergency care settings.
EPOWERdoc, a leading SaaS platform within the Embrace Healthcare Group portfolio, specializes in Emergency Department Information Systems (EDIS) tailored for hospitals of all sizes. Designed by clinicians for clinicians, EPOWERdoc streamlines emergency room documentation with intuitive workflows, customizable templates, peer-reviewed clinical content, and real-time coding assistance—helping providers reduce documentation time and focus more on patient care.
As we continue to scale our impact in the healthcare space, we are seeking passionate professionals to join our team. TheSenior SQL Server Production DBAwill 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. If you’re a proactive database professional with a passion for clean, well-tuned systems, we’d love to hear from you!
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.
Requirements
- 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.
Originally posted on Himalayas