Lead DB Consultant
Previous Job
Previous
Lead DB Consultant
Ref No.: 18-26045
Location: Livingston, New Jersey
Start Date: 04/16/2018
Lead DB Consultant
Livingston, NJ

 
FTE - $110K
Lead DB Consultant (1 No): 
·       8+ yrs Experienced in software design and development process including requirements definition, design and data modeling, Data Querying and Analysis, database architecture and maintenance.
·       Strong experience in MS SQL Server Database Development and Administration
·       Extensive experience with SQL Server in constructing stored procedures, triggers, tables, user functions, views, indexes, relational database models and SSRS
·       Experienced in Relational Data modeling (Logical and Physical), Normalization and building Referential Integrity Constraints.
·       Experienced in coding and reviewing Stored Procedures and provide suggestion to improve the performance.
·       Good communication & customer interaction skills
·       Exposure to XML Data type and Xquery in SQL server
·       Manage 2-3-member DB team
·       Review the team work
·       Identify areas for automation
·       Well versed to interact with Business Managers & executive leaders on Data dashboard'
. XML Querying - MUST
Experience in NOSQL - MUST
.Net/Automation Tech Lead (1 No)
·         Required to be fluent in scripting languages, particularly PowerShell v2.0 and v3.0 (v4.0 desirable) and VBScript (level 5 required).
·         Deep troubleshooting of Windows 7/Unix client issues required (minimum 4).
·         Needs to be well-rounded in his understanding of desktop, server, and network concepts (minimum 4).
·         Should have good knowledge of SCCM 2012, AD, Exchange etc. other Microsoft products.
·         Minimum 5 years experience in the following areas: ASP.NET using C#, SQL Server 2000+
·         Experience modeling database schemas and implementation using high-performing stored procedures, views, functions, etc. using SQL Server
·         Dedication and proven track record of delivering working, tested and high-quality software on a schedule
·         Ability to work independently as well as collaboratively
·         Ability to multi-task and manage multiple assignments in a fast-paced environment
·         Excellent written and verbal skills