Sr. SQL DBA

MINIMUM: 7 Years Experience SQL Server 2016 (or later versions) database administration: • Installing and upgrading SQL Servers, including applying service packs • Performing routine database maintenance • Creating and scheduling SQL Server jobs to perform database maintenance activity • Rebuilding indexes • Updating statistics • Consistency checks • Monitoring error logs and event logs for database errors • SQL Server native tools and services • SQL Server Profiler • Index Tuning Advisor • SQL Server Configuration Manager • Extended Events • Performance Monitor • Dynamic Management View • SQL Server Broker Service • Linked Servers • MSDTC • SQL Server System Databases • Database Mail • SQL Server Health Checks and Policies • Managing SQL Server security and auditing • User security • Database roles • Authentication methods • SQL Server and database auditing • Encryption at rest, transit, and backup • Capacity Planning for storage and database objects • Maintaining and managing SQL Server disk space to ensure storage is properly utilized • Index and statistics usage • Managing disk storage for Windows Failover Cluster Service (WFSC) • Database backup and recovery • Establishing standards and schedules for database backups • Developing recovery procedures to meet RPO and RTO • Restoring databases with point in time recovery • Creating and testing Disaster Recovery plans • Proficient in TSQL coding, tuning, and ETL methodologies • SQL Server High Availability Methods • Mirroring • Always On Required: • 5 Years Windows Server Administration experience: • Building and maintaining Windows Host and Guest Servers • Installing and managing end point protection • Nessus configuration and vulnerability scans • Application Server, Web Server, File Server, and FTP Server configuration and maintenance • Utilizing PowerShell for administration tasks • Windows Failover Cluster configuration and maintenance • Windows Server Roles and Features • .NET Framework Components