SQL Server DBA with AlwaysOn Availability Groups

New Jersey  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Description

SQL Server DBA with AlwaysOn Availability Groups

DETAILS

Location: Montvale, NJ

# of Positions: 1

Position Type: 6+ month Contract

Salary/Hourly: $65ph up to $79ph W2 for the right professional

ABOUT THE OPPORTUNITY 

GTN Technical Staffing is looking for a SQL Server DBA with AlwaysOn Availability Groups for a 6+ month contract with a global company to manage a large transactional database (1.3 TB). This is a fast-paced, collaborative project where the team will be relying on your judgment, expertise and creativity to deliver the best possible results.

The SQL Server DBA will:

Design logical database models and provide technical guidance during each phase of the development process

Provide performance tuning and optimization of existing SQL code

Provide technical support for the database environment and database objects such as stored procedures, functions, triggers, tables, and views

Work with developers, business analysts, other team members and clients to review the business requirements and translate them into database objects

Participate in T-SQL code reviews and technical quality standards reviews with the development teams

Collaborate with the database administration team to support the database deployment and maintenance Maintain technical documentation, such as run books and ticket documentation, providing information to support organizations such as the help desk and QA teams

Work with business owners and analysts in planning and estimating throughout the complete life cycle, as well as identify and evaluate alternatives and present the most efficient and cost effective solution Work as part of an agile environment (Scrum) Create, maintain and publish data models, data dictionaries and entity relationship diagrams using industry standard tools and technologies Develop and practice standards for database architecture, administration, security, design, backup, recovery, development and deployment for departmental use Provide SQL best practice training (T-SQL, Data Modeling, performance tuning, etc.) to developers

TOP REQUIREMENTS:

Advanced skills as a SQL Server DBA with AlwaysOn Availability Groups

Strong SQL Server Performance Tuning skills

T-SQL/Stored Procedures/Function programming and design

Optimization of existing SQL code

Minimum 8 years of progressive experience developing, unit testing and troubleshooting SQL Server 2005, 2008, 2012, 2014. This includes SSRS, SSIS, as well as experience with Visual Studio Team Foundation Servers.

Experience working with large development teams

ADDITIONAL REQUIREMENTS:

5+ years in logical and physical database modelling, as well as designing database schema, stored procedures, triggers, and other database related objects

Strong analytical skills

Knowledge of basic Client Server architecture, secure coding practices, and computer networks

Knowledge of software development or testing (preferably on the MSFT technology stack)

Able to work independently and as part of a team

Excellent written and verbal English skills (including comprehension)

Experience with PowerShell or other Scripting languages

Additional assets:

Experience with NOSQL and/or Big Data technologies is a plus

Bachelor's Degree in Computer Science is preferred

Start date
ASAP
From
GTN Technical Staffing
Published at
23.12.2015
Project ID:
1042096
Contract type
Freelance
To apply to this project you must log in.
Register