SQL Server Architect / Application DBA

EROS Technologies Inc.; Bridgewater (MA); On-site; USD 110,000 - 150,000; Full time

Job summary

A technology services firm is seeking an experienced SQL Server Architect / Application DBA to manage critical SQL Server applications. The role requires over 12 years of MS SQL Server administration experience and expertise in writing complex stored procedures and optimizing query performance. Strong troubleshooting skills and the ability to work independently in a changing environment are essential. The position is contract-based and located in Bridgewater, NJ.

Qualifications

• 12+ years of experience in MS SQL Server Application database administration.
• Solid experience with SQL Server stored procedures and T-SQL queries.
• Experience in performance tuning and optimization using monitoring tools.

Responsibilities

• Responsible for writing complex stored procedures and SQL queries.
• Implement and maintain SQL Server RDBMS systems performance.
• Troubleshoot SQL Server service outages, including after-hours.

Skills

MS SQL Server Application database Administration

Performance Tuning and Optimization

SQL Server stored procedures

T-SQL queries

Troubleshooting SQL Server service outages

Communication skills

Ability to work in a changing environment

Job description

Overview

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.

Job Description

Position: SQL Server Architect / Application DBA

Location: Bridge Water, NJ

Duration: 6-12 Month

Joining Mode: Contract

Responsibilities

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.

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
• Ability to organize and plan work independently
• Ability to work in a rapidly changing environment

Additional Information

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