Apply for job

SQL Developer - Long-term Contract

For our direct client in Northern NJ, we seek an experienced SQL Server developer for a long-term (12-24 months) contract.  

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.  

Job ID: 4399

  • Accepted file types: docx, doc, pdf, rtf, wps, txt, html.