Must have 3.5 - 6 years of experience in MS SQL DBA.

Experience with Database Administration for MSSQL Server.

Actively and consistently supports all efforts to simplify and enhance the customer experience.

Designs and maintains access and security administration.

Designs, implements and maintains backup and recovery strategies on Database Management Systems.

Supports multiple services and multiple databases of medium complexity with multiple concurrent users, ensuring control, integrity, and accessibility of data.

Troubleshoots alerts (alert log, Jobs, Disk Group, Tablespace, etc.) and performance issues.

Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools

Experience with backups restores and recovery models.

Experience with SQL in a virtualized environment (ESX and Azure).

Knowledge of Always-On,  High Availability (HA), and Disaster Recovery (DR) options for MSSQL Server.

Experience in implementing operational automation using scripts.

Identify areas of the SQL environment that are suited for automation and then implement a solution using a variety of tools from applications such as HPSA or through scripting (PowerShell, TSQL).

Knowledge of indexes, index management, and statistics.

Experience working with Windows servers, including Active Directory and proper disk configurations.

Performs capacity planning of SQL server environment and provides recommendations to management to sustain business growth.

Designs, implements, and maintains  Disaster Recovery (DR) methodologies and creates documentation.

Gathers business requirements and designs and implements multiple projects along with production support.

Creates standard operational procedures and templates.

Acts as mentor for Database Administrators and Associate Database Administrators.

Performs research and provides plans to remediate complex business problems.