Senior SQL Developer/DBA

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

Description

Senior SQL Developer/DBA

DETAILS

Location: Montvale, NJ

# of Positions: 1

Position Type: 6+ month Contract

ABOUT THE CLIENT

Awards earned by this Client

  • Working Mother's Magazine 100 Best Companies for Working Mothers
  • Diversity Magazine's Top 50 Companies for Diversity
  • Fortune Magazine's Best 100 Companies to Work For
  • Training Magazine's 125 Top Training Companies
  • Business Week Magazine 50 Best Places to Launch a Career
  • Hispanic Magazine Corporate 100 Leaders
  • Companies That Care Honor Roll

ABOUT THE OPPORTUNITY

GTN Technical Staffing is looking for a Senior SQL Developer/DBA for a 6+ month contract with a global company that has a large transactional database (1.3 TB). The Senior SQL Developer/DBA will be passionate about SQL because you will be managing this large volume of data. 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 Senior SQL Developer/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 knowledge of T-SQL/Stored Procedures/Function programming and design
  • 6+ years of experience in overall SQL Server Performance Tuning and 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. Advanced level of knowledge in using these technologies is preferred.
  • 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
Duration
6months +
(extension possible)
From
GTN Technical Staffing
Published at
06.10.2015
Project ID:
995412
Contract type
Freelance
To apply to this project you must log in.
Register