SQL Server Architect / Application DBA

Position: SQL Server Architect / Application DBA

Location: Bridge Water, NJ

Duration: 6-12 Month

Joining Mode: Contract

Job Description:-

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.

Skills and Qualifications:-

• 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

• Install and configure new SQL Servers

• 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

• Excellent written and verbal communication

• Flexible, team player, “get-it-done” personality

• Ability to organize and plan work independently

• Ability to work in a rapidly changing environment

All your information will be kept confidential according to EEO guidelines.