SQL Server Architect / Application DBA

This SQL Server Application DBA position will be responsible for the writing complex Stored Procedure / SQL queries and also implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of .Net applications. This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills.

• 12+ years MS SQL Server Application database Administration experience required

• Solid experience in writing and improving SQL Server stored procedures and T-SQL queries.

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

• Using Profiler traces and other tools to find the most frequently run queries

• Using free tools like sp_BlitzIndex® and DMV queries to answer questions about index usage

• Troubleshoot SQL Server service outages as they occur, including after-hours and weekends

• Configure SQL Server monitoring utilities to minimize false alarms

• As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies

• Deploy database change scripts provided by third party vendors

• When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes

• Experience working with Windows server, including Active Directory