This is with our direct client with Sivic Solutions.
- This would be a Senior MS SQL Developer with very strong knowledge of DTS and SSIS package development and SQL as a whole.
- 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