Senior Sql Dba

Locations: Radford, VA or Ft. Belvoir VA

This position is for a Microsoft SQL Server database administrator. The successful candidate will maintain SQL Server databases in enterprise environments consisting of approximately 2000 Windows servers. This position is responsible for development and sustainment of SQL Server 2019 Microsoft Failover Clusters. The successful candidate will standardize, consolidate, and optimize the existing SQL Server environments and monitor and maintain database performance. The successful candidate will also collaborate with internal and external customers to gather requirements for special processing, and work and track issues to resolution using an in-house ticket system.

Responsibilities include:Design, install, configure, audit, and maintain highly available enterprise database systems
Monitor backups on all SQL Server databases
Perform routine disaster recovery testing scenarios
Troubleshoot and maintain database performance, including the proposal of short term fixes, long term solutions, and the regular scheduling of index maintenance and database integrity checks
Establish and maintain database policies and standards
Generate database schema definitions and modifications as required
Refresh data from one processing environment to another as required
Develop, follow, and maintain team documentation for repeatable processes, including database feature installation, disaster recovery, and common problem resolution
Adhere to ITILv4 (Information Technology Infrastructure Library) practices for Change Management
Work trouble tickets
Participate in security audits