Senior SQL Server Database Administrator

Job Description

We are seeking a Senior SQL Server Database Administrator to administer, secure, optimize, monitor, and support Microsoft SQL Server database environments for a federal health research customer. The role supports development, test, and production databases across on-premises and cloud environments and requires strong expertise in standalone and clustered architectures, backup and recovery, failover clustering, T-SQL, performance tuning, troubleshooting, SQL Server Agent, SSRS, SSIS, SSAS, security, and data integration.

Key Responsibilities

· Administer Microsoft SQL Server databases in development, test, staging, disaster-recovery, and production environments.

· Support standalone and clustered SQL Server architectures on Windows in on-premises and cloud environments.

· Install, configure, patch, upgrade, secure, monitor, and troubleshoot SQL Server instances and supporting components.

· Design, configure, maintain, test, and document full, differential, and transaction-log backup and recovery processes.

· Configure, administer, monitor, and troubleshoot SQL Server failover clusters and high-availability capabilities.

· Create, schedule, monitor, and troubleshoot SQL Server Agent jobs, maintenance plans, alerts, and automated operational processes.

· Write, review, optimize, and troubleshoot T-SQL queries, scripts, stored procedures, functions, triggers, views, and deployment packages.

· Perform query tuning, indexing, statistics maintenance, execution-plan analysis, capacity planning, and performance optimization.

· Manage users, roles, permissions, service accounts, authentication, auditing, encryption, and database-security configuration.

· Administer and support SQL Server Reporting Services, SQL Server Integration Services, and SQL Server Analysis Services.

· Support schema changes, application releases, data migrations, data refreshes, synchronization, reporting, and data-integration workflows.

· Develop and ma...