You will administer and support SQL Server environments across various stages of the application lifecycle.
Responsibilities
Support application teams by enhancing, troubleshooting, and performance tuning SQL Server databases in Production, Test, and Development environments, including SharePoint farms.
Install, upgrade, configure, test, and deploy complex database software, including ALWAYS ON configurations.
Develop and implement database recovery plans and procedures, analyzing database performance to recommend tuning and application changes.
Implement user authentication and validate database security protocols across systems, and review system designs for new database development.
Script batch data loads and operational job automation, and modify database structures to meet new requirements.
Required Skills
7+ years of experience supporting operating systems, database management systems, or related fields.
6+ years of hands-on administrative experience with SQL Server RDBMS.
6+ years managing backup, recovery, and high availability scenarios.
6+ years in hands-on development and tuning of databases in SQL Server, including Performance Tuning and TSQL programming.
6+ years of hands-on query experience with SQL and scripting skills.
4+ years of strong knowledge and experience on Always ON High Availability groups.
4+ years of strong knowledge and experience on database migrations.
3+ years of experience with SQL Server database space management/storage design and capacity planning.
4+ years demonstrating ability to communicate verbally and in writing with all levels of staff and management.
3+ years demonstrating ability to generate entity relationship diagrams, create database documentation, data dictionaries, and document system architecture.
Preferred Skills
Working knowledge of Cohesity Backup Appliance.
Working knowledge of Cloud Technology and governance.