Innovations technological

Sql Server DBA

637 South Clinton Avenue, Trenton, NJ

In Person Only

Contractor will design, implement and manage SQL databases including upgrading, patching and cloning of Dev, Test, Training and Prod  instances. Experience with SQL Server 2012 is Required. Team Foundation Server exp. Highly Desired. Oracle exp Desired. Job Summary

Expertise required in partitioning, indexing schemes, table compression, SQL programming and architecture design using Microsoft SQL Server 2012 or later versions. Experience with SQL Server 2008 R2  is also required.  Must have the ability to work closely with end-users to understand, design, and deliver effective and stable solutions to business requirements as well as recommend configuration changes to improve performance of the database environment.  Candididate will complete other related duties as required.

Required Knowledge

5+ years' experience performing database analysis, design and administration

5+ years SQL programming and architecture design using Microsoft SQL Server 2008 R2 or 2012 or later versions

Experience in Database security and encryption and database failover and high availability

Demonstrable mastery of SSIS and SSRS

Experience with latest version of SQL Server

4+ years' experience working with Team Foundation Server

2+ years' experience with .NET Framework 4.0/4.5, LINQ and Entity Framework

2+ years' experience with Web Services, WCF and ASP.NET Web API

- Experience with features such as partitioning, indexing schemes, table compression, etc.

- Must be a team player and able to work with and through others

- Ability to work in a fast-paced environment with rapidly changing priorities and work items based on business needs

- Ability to re prioritize and Strong Problem solving and root cause identification skills and strong verbal/written  - communications and presentation skills

Education:  BS or equivalent university degree

Preferred skills:

Experience with SQL database backup and restoral process including log shipping, experience in Team Soft Automation, TFS automated build and 2+ years Oracle database administration, programming and architecture design experience.