Blog | Contact Us | Client LogIn | 1-833-812-4636

.Net SQL Developer

Location:

Matawan, NJ

Description:

We are seeking a .Net SQL Developer for our Matawan, NJ office.

Key Responsibilities:

  • Design and develop automation tasks for high volume data processing
  • Apps development
  • Automation of many of the jobs we do in-house
  • Developing front-end and back-end applications
  • Create database objects such as tables, views, UDFs and UDPs etc
  • Design packages related to the extraction, transformation and loading (ETL) process using Microsoft SQL Server 2012 or later
  • Responsible for data profiling as well as SQL and database tuning / optimization
  • Analyze the client requirements and design technical solutions based on those requirements
  • Develop testing and implementation strategy, conduct appropriate functional and performance
  • testing to identify and resolve process bottlenecks and data quality issues
  • Reviewing query performance and optimizing code
  • Designing and coding database tables to store the application’s data
  • Data modeling to visualize database structure
  • Working with application developers to create optimized queries
  • Creating table indexes to improve database performance and apply appropriate index maintenance
  • Participate in the maintenance of data warehouse

Qualifications:

  • Bachelor’s Degree in Computer Science (CS), Information System (IS), Management of Information System (MIS), Statistics, Analytical Finance, etc.
  • .Net at least 7+ years of strong experience
  • MSSQL 2012 with 7+ years of strong experience, SSIS, ETL as well as T-SQL (Transact SQL) stored procedures and triggers
  • Strong Javascript/Typescript, preferably on AngularJS/Angular, at least with 2+years of experience
  • Distributed Architecture with cloud based technology, good RESTful services development.
  • Strong knowledge in Object oriented design and development.
  • Good understanding of design patterns, refactoring and unit testing & experience.
  • Go/NodeJS with at least 2+ years of experience
  • Experience in Linux environment is a plus
  • Interest in working with complex data sets and leading edge analytic technologies such as machine learning and Power BI
  • Ability to write & troubleshoot SQL code & design stored procedures, functions, tables, views, triggers, indexes, & constraints.
  • Perform daily file import/exporting using SQL Bulk Insert/BCP
  • Setup ad-hoc or automated data hygiene processes
  • Troubleshoot file import/export issues
  • Troubleshoot existing SQL scripts/tasks
  • Exhibit excellent analytical, problem solving and troubleshooting abilities
  • Excellent communication and analytical skills
  • Ability to work in team environment and client interfacing skills.

Contact:

Jennifer Holtz
jholtz@v12data.com

EMPLOYMENT BENEFITS

V12 is an equal opportunity employer and as such, we value people from diverse backgrounds. This principle applies to all aspects of employment, including recruitment, hiring, placement, transfer, promotion, layoff, recall, termination, and other terms and conditions of employment.

In addition to competitive salaries, V12 offers eligible employees a comprehensive benefits package that includes:

  1. Healthcare coverage (including vision)
  2. Prescription drug plan
  3. Dental Plan
  4. Short and long-term disability
  5. Long-term care coverage
  6. Flexible spending accounts
  7. Life insurance
  8. 401(k) with company matching

CONNECT WITH V12