Desired Skills and Experience
- Demonstrate extensive knowledge of all aspects Microsoft SQL Server including administration, replication, backup/restore procedures and related components such as Reporting Services, Analysis Services and Integration Services.
- Install, configure, monitor and maintain databases in the production, development, and quality assurance environments.
- Recommend and implement solutions for SQL performance monitoring and tuning.
- Assist with Windows Server configuration and management as it relates to MS SQL Server installation and performance.
- Understand SAN based storage and related technologies, specifically as applicable and useful to MS SQL Server installations.
- Process database change requests, including the creation and modification of databases, tables, views, stored procedures, triggers, jobs, etc. in accordance with change control policies.
- Analyze problems, anticipate future problem areas and implement solutions.
- Work outside of normal business hours as required for completing projects, working on deployments and resolving system outages.
- 5 years of experience with Microsoft SQL Server 2008 / 2012 / 2014 supporting high traffic websites.
- Experience with the implementation and support of database replication.
- Experience working with very large databases.
- Understanding of Windows Server (2008 R2/2012 R2) configuration and management, specifically as it relates to MS SQL Server installations and mission critical systems.
- Excellent understanding of coding with Microsoft T-SQL and stored procedures.
- Experience with SANs (NetApp/EMC), specifically with aspects related to MS SQL Server.
- Understands and is able to properly implement backup and disaster recovery procedures.
- Excellent work ethic and willingness to put in significant extra time as needed.
- Experience with PowerShell scripting, TFS/Visual Studio Database Projects and SSDT is a plus.