SQL Server Architect / Application DBA

EROS Technologies was founded with a simple motive of offering the clients exactly what they want, how they want and when they want it. By leveraging for its clients its technological edge and right-sourcing advantage, EROS in a short period of time has grown to become one of the most trusted strategic technology partners. Treating every client as the top priority, we customize our solutions and services to align with the unique needs of each client.

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.