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.