The Senior Database Administrator is a hands-on senior technical role responsible for the reliability, availability, security, performance, recoverability, and lifecycle management of enterprise Microsoft SQL Server environments. The position owns operational and strategic administration of SQL Server 2019 and later across development, QA, staging, reporting, and production workloads. The successful candidate brings a minimum of seven years of database administration experience, deep SQL Server troubleshooting expertise, strong automation practices, and the ability to lead complex production support, upgrade, security, and recovery initiatives.
Administer, monitor, tune, patch, upgrade, and troubleshoot SQL Server 2019 and newer environments.
Own database integrity, availability, backup, restore, and disaster recovery procedures, including recurring recovery testing.
Implement and support high-availability solutions such as Always On Availability Groups and appropriate failover architectures.
Analyze execution plans, indexes, statistics, waits, memory, tempdb, storage, blocking, deadlocks, and concurrency issues.
Create database maintenance standards for consistency checks, backups, index/statistics care, jobs, retention, and capacity.
Administer security using least privilege, role-based access, encryption, auditing, service-account governance, and access reviews.
Partner with developers and data engineers on schema design, stored procedures, query performance, releases, and rollback planning.
Automate operational tasks using T-SQL, PowerShell, SQLCMD, SQL Agent, source control, and approved monitoring platforms.
Lead database incident response, root-cause analysis, corrective actions, and stakeholder communication.
Provide technical leadership for SQL Server migrations, consolidations, upgrades, Azure SQL adoption, and hybrid modernization.
Support Microsoft BI and integration workloads where SQL Server is a source or platform, including SSIS, SSRS, SSAS, and Power BI connectivity.
Maintain architecture diagrams, configuration baselines, runbooks, escalation procedures, and support documentation.
