Sr SQL Administrator

The Senior SQL Administrator is responsible for the administration, performance, availability, security, recoverability, and integrity of enterprise database platforms across on-premises and cloud-based environments. This position designs, implements, monitors, optimizes, and supports highly available database platforms used by businesses, manufacturing, quality, reporting, integration, and infrastructure systems. Serving as a database subject matter expert, the Sr. SQL Database Administrator partners with Infrastructure, Applications, Security, Quality, and business teams to maintain stable, secure, scalable, and compliant database services across on-premises and cloud environments.

Responsibilities

Manage day-to-day operations of enterprise database platforms, including configuration, maintenance, patching, backups, restores, performance, security, and capacity; Administer, maintain, and optimize Microsoft SQL Server environments across on-premises, virtualized, and cloud-hosted platforms; Monitor database health, performance, job execution, storage utilization, blocking, deadlocks, replication, availability groups, and backup success; Perform database performance tuning, including query analysis, indexing strategy, execution plan review, statistics maintenance, wait analysis, and resource optimization; Implement and support high availability and disaster recovery solutions, including SQL Server Always On Availability Groups, clustering, log shipping, replication, backups, and restore testing; Maintain database security controls, including authentication, authorization, least-privilege access, role-based permissions, encryption, auditing, and privileged access review; Develop and maintain automation for database maintenance, monitoring, alerting, reporting, backup validation, user access review, and operational support activities; Lead troubleshooting and root-cause analysis for complex database incidents, performance degradation, failed jobs, restore issues, connectivity problems, and application-impacting database events; Follow established change management, release management, incident management, security, and governance practices

Requirements

Bachelor's degree in Computer Science, Information Technology, Engineering, Data Management, or a related field with 8+ years of enterprise-level database administration and/or database engineering experience; or an equivalent combination of education and experience; 5+ years of experience supporting high availability, disaster recovery, backup, restore, and database recovery strategies for business-critical systems; Strong experience with SQL Server performance tuning, indexing, query optimization, execution plans, wait statistics, SQL Agent jobs, and database maintenance plans; Experience administering SQL Server Always On Availability Groups, failover clustering, log shipping, replication, or equivalent high availability technologies; Experience with database security practices, including least privilege access, role-based permissions, encryption, auditing, service accounts, and privileged access controls; Experience with PowerShell, T-SQL scripting, automation, monitoring, alerting, and operational reporting; Experience with enterprise backup platforms, restore validation, database integrity checks, and disaster recovery testing; Working knowledge of Windows Server, Active Directory, DNS, networking fundamentals, storage, virtualization, and cloud infrastructure as they relate to database services; Ability to plan, organize, and document complex database administration activities and configure systems in alignment with institutional policies and procedures; Ability to manage multiple priorities, handle concurrent projects, respond effectively to urgent or complex operational issues, and communicate clearly with technical and non-technical stakeholders; High degree of accuracy, attention to detail, data stewardship, documentation discipline, and organizational skills

Nice to have

Experience supporting Azure SQL Database, Azure SQL Managed Instance, or SQL Server hosted in Microsoft Azure; Experience supporting integrations with ERP, MES, LIMS, QMS, reporting, data warehouse, or enterprise application platforms; Experience with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI gateways, or related reporting and integration technologies; Microsoft SQL Server, Azure Database Administrator Associate, or equivalent database certification

Benefits

A collaborative teamwork environment where learning is constant, and performance is rewarded; The opportunity to be part of the team that is revolutionizing the treatment of some of the world's most devastating diseases; A generous benefits package for eligible employees that includes medical, dental, vision, life, AD&D, short and long-term disability insurance, 401(k) with employer match, paid parental leave, eleven paid company holidays per year, a minimum of fifteen days of accrued vacation per year, which increases with tenure, and paid sick time in compliance with applicable law(s); Competitive compensation package plus a benefits and equity program, when applicable