Senior Database Administrator

This is a fully remote position, open to applicants in United States.

📋 Description

• Take responsibility for the health, performance, and lifecycle management of databases that support EPOWERdoc across production, staging, and development environments.

• Oversee customer-hosted, hybrid, and cloud SQL Server instances.

• Design and execute comprehensive backup strategies, including full and transactional log backups.

• Conduct restore tests to ensure RPO and RTO targets are met.

• Address Sev-1 and Sev-2 database incidents promptly.

• Lead root cause analysis and implement lasting stability enhancements.

• Monitor wait statistics, index fragmentation, and resource-heavy queries.

• Provide recommendations for database performance tuning.

• Track database growth and project storage requirements at least 90 days in advance.

• Review and validate SQL scripts developed for projects.

• Apply schema and data modifications across customer environments while maintaining version control and change history.

• Develop scripts and documentation for environment provisioning and database cloning processes.

• Assist in onboarding new sites and refreshing testing environments.

• Implement practices for database encryption, least-privilege access, auditing, and compliance with HIPAA regulations.

• Document standard operating procedures (SOPs) and automate routine database tasks through scripting and lightweight DevOps pipelines.

• Collaborate effectively with architects, developers, support, and IT teams.

• Aid in the transition from on-premise installations to a future multi-tenant SaaS model.

⛳️ Requirements

• A minimum of 5 years of experience in SQL Server administration (2016–2022) within 24×7 production environments, encompassing both on-premise and cloud-hosted configurations.

• Strong expertise in backup and restore strategies, index maintenance, performance tuning, and high availability/disaster recovery solutions like Availability Groups, log shipping, or mirroring.

• Comfortable supporting customer-managed on-premise servers, as well as VPN/ExpressRoute-integrated cloud virtual machines and internal lab environments.

• Proficient in T-SQL and scripting languages (PowerShell or Bash) for enhancing automation and operational efficiency.

• Experience in managing large datasets, including table partitioning and archival strategies for tables exceeding 100M rows.

• Adept at troubleshooting issues such as blocking, deadlocks, timeouts, and other performance problems in collaboration with development and support teams.

• Excellent written and verbal communication skills; must be able to overlap at least 4 hours with US Eastern Time.

• Familiarity with healthcare/EHR systems and data privacy regulations, including HIPAA and HITECH.

• Microsoft SQL Server certification is required.

🏝️ Benefits

• Competitive salary, structured according to UK working hours.

• Comprehensive training and mentorship programs aimed at enhancing skills and knowledge.

• Opportunities for career growth and professional development.