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