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.