RE: Req-2 SQL SERVER DEVELOPER :: NYC :: F2F

[anushtha prasad]

Title: SQL Developer

Duration: 6+ Months

Location: NYC, NY
Interview: Phone and Skype

Visa Status: H1b, GC, USC

 

Only submit candidates within 4 hours of nyc who will go on a face to face to close. 

Mandatory Skills:

·         Experience with SQL 2008 R2, 2012 and component services like SSIS ETL, SSAS, SSRS

·         Configuring SQL Server monitoring utilities to minimize false alarms

·         Ensuring that new database code meets company standards for readability, reliability, and performance

·         Providing developers a list of the top 10 most resource-intensive queries on the server and suggest ways to improve performance on each

·         Designing indexes for existing applications, choosing when to add or remove indexes

·         Assisting developers with improving the performance of that query by tweaking it or modifying indexes

·         Conducting SQL Server lunch-and-learn sessions for application developers

·         Advising developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc.)

·         Being a subject matter expert on database design, performance issues, disaster recovery, backups, database maintenance and database archiving

·         DR knowledge with Always On, SQL log shipping, DB mirroring, Replication

·         Experienced with SQL installation on standalone and cluster servers

·         Assess and tune Data base/SQL performance

·         Database migration

·         Creating Packages, cleansing Data and ETL development process

·         Content Manage In addition, the candidate must demonstrate ability to write T-SQL queries to fulfill ad-hoc requests and data integrity checking and have demonstrated ability to write T-SQL stored procedures for code re-use. The candidate must also have experience with DTS / integration service data transformation and manipulation tools.

 

 

 

 

 

Regards ,

Anushtha |  KPG99,INC

3240 E State, St Ext |  Hamilton, NJ 08619
732-515-3900 II anus...@kpgtech.com