Job Description :

Hello All,

This is with our direct client.

  1. This would be a Senior MS SQL Developer with very strong knowledge of DTS and SSIS package development and SQL as a whole.
  2. Position would be based out of Parsippany, NJ

Required Skills:

  • Extensive experience in developing enterprise scale applications utilizing MS SQL technologies as a database layer
  • Experience in migrations from MS SQL 2005 to MS SQL 2012+
  • Experience in DTS/SSIS development and migrations
  • Experience programming complex interfaces and processes in a relational database  including structured query language and defined data structures (e.g. DDL and T-SQL)
  • Experience with all phases of the Software Development Lifecycle, including system analysis, design, coding, testing, debugging and documentation
  • Experience with optimizing complex MS SQL code base to achieve maximum perfromance for high volume of transactions and/or large datasets of 1+ TB
  • Expert in MS SQL DDL/DML coding for Stored Procedures, Triggers, UDF
  • Knowledge of the SDLC with Scrum utilizing TFS/DevOps
  • Migration from older to newer versions of / including SQL Server 2005/2012/2014/2016/2019
  • Expert in MS SQL SSIS/DTS development and deployment
  • Solid experience / understanding of multi-tier enterprise application development
  • Knowledge of SQL Profiler and solid experience with performance evaluation and optimizations toolset (e.g. Quest SpotLight, Solarwinds DPA, etc.)
  • Proficient in analysis and documentation of Database models / ERD and T-SQL coding logic
  • Proficient in using source control / code management (e.g. TFS/DevOps/Redgate)
  • Experience in deployment startegies using automated deployment pipelines (TFS/DevOps)
  • Proficient working with Data Encryption technologies available in SQL Enterprise Edition (field level encryption, TDE, key / certificate management)
  • Capable of delivering system components to be integrated into overall application architecture
  • Strong knowledge of emerging technologies.  Posesses strong knowledge of application development technologies, tools, and methodologies.
  • Good understanding of how technology relates to the business, market and industry and applies such knowledge to support the needs of the business.
  • Excellent problem solving, analytical, critical thinking and decision making skills
  • Must be a creative and innovative thinker with the demonstrated ability to bring new ideas and process improvements to fruition     
  • Strong team player with ability to collaborate with all levels of staff
  • Ability to lead, develop, and coach a small team of developers
  • Strong attention to detail with all tasks being carried out to the highest standard

Desired Skills:

  • Experience leading a small team of developers
  • Experience using source code management tools (e.g. TFS/DevOps
  • Experience with SQL Compatibility assessment toolsets
  • Experience with large TB+ databases
  • Knowledge of MS SQL Always-On replication technologies
  • Proficient in Web Service Oriented Architecture
  • Understanding of software Methodologies such as RUP and Agile/Scrum

Similar Jobs you may be interested in ..