Search Job

Search

Call Us Now

+1 908 222 8055

Job Detail

SQL Server developer

Experience Level

10+ years Year(s)

Location

Northern NJ

Posted Date

12/04/2019

Job Requirements

 

In this role you will assist in database and ETL development on a large-scale, global software project.

 

Responsibilities:

  • Assist with upgrade of current application to SQL 2016 and carry out complete analysis and development for the upgrade.
  • Design and develop database objects, tables, stored procedures, views, triggers and SSIS packages.
  • Review query plans and tune performance tuning the stored procedures and T-SQL.
  • Upgrade SSRS reports to 2016 version.
  • Write archiving and purge processes

Skills:

  • Work well in a team environment and in harmony with other team members
  • Experience working with teams located across different locations and onsite offshore model
  • Minimum 10+ years of experience in software development using Microsoft SQL Server, Azure SQL, T-SQL and T-SQL language (queries, views, procedures),
  • Must have experience in troubleshooting and resolving database integrity issues, complex query performance optimizations, blocking and deadlocking issues, table partitioning, data replication/restore process Design and development of Microsoft SQL Server databases(MS SQL Server 2016/2014/2012).
  • Experience in development of SSIS packages to Extract Data, Transform, Load (ETL) data into SQL Server from different environments;
  • Experience in Database Maintenance plans for the performance of SQL Server, which includes Database Integrity Checks, Update Database Statistics and Re-index the fragmented indexes.
  • Design database by adding tables, relationships, create stored procedures, views, Triggers, Functions and performance tuning of SQL queries
  • Experience with SSRS Reports development.
  • Experience with Azure (Managed SQL /PaaS services ) will be an added advantage.

Immediate interview and hire! Send resume today for immediate consideration. All work is on-site in the northern NJ work location.

Long-term (12-24 months) contract

General skills

Must have

Software Dev. with SQL Server

10+ years of experience.

Languages

Must have English Native or bilingual proficiency

 

 

Quick Contact

* Name :
*Email ID :
*Phone:
* Message :