SQL Server Database Administrator - Fort Belvoir, United States - Cassidy Consulting Group

Description

• 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 ITIL (Information Technology Infrastructure Library) practices for Change Management
• Work trouble tickets
• Participate in security audits

• Three to five years of experience with Microsoft SQL Server Enterprise Edition and all facets of database administration
• Three or more years of experience with Microsoft SQL Server High Availability features: Failover Clustering, Log Shipping, Database Mirroring, AlwaysOn Availability Groups
• Years of experience with Windows Server (2016 and higher) and Microsoft Failover Clusters
• Installation and configuration experience with SQL Server 2019 (and higher) and SQL Server Cumulative Updates (CUs)
• Strong documentation skills
• Strong database performance tuning skills
• Strong interpersonal skills, including the demonstrated ability to be a team player
• Participate in 24x7 oncall support rotation

• Experience with DoD (Department of Defense) Security Technical Implementation Guides (STIGs), Security Readiness Review (SRR) scripts, and Information Assurance Vulnerability Management (IAVM)
• Experience with PowerShell (5.1 or higher)
• Experience with Microsoft Azure
• Experience with scriptbased automation

• 401(k)
• 401(k)

• Dental insurance
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Referral program
• Tuition reimbursement
• Vision insurance

• 8 hour shift
• Monday to Friday

• Microsoft SQL Server: 3 years (required)
• Database administration: 3 years (required)
• High availability: 3 years (required)

• DoD 8570 certification (required)

• Secret (required)

• Fort Belvoir, VA required)

• Fort Belvoir, VA 22060: Relocate before starting work (required)