20242 – SQL Database Developer

Published
April 27, 2022
Location
Morris County, NJ
Category
Job Type
Compensation
$110K

Description

Job Purpose:

 

Analyzing, developing SSIS projects, custom reports, and work closely with the team on any SQL issues. Manage new implementations, resolve any integration issues timely manner.

 

Duties and responsibilities:

 

  • Manage data projects by being a liaison between client and database developers.
  • Develop time estimates for assigned tasks.
  • Develop SSIS projects to handle ETL, transmission, encryption, and archiving of files received and generated.
  • Design, develop, and maintain database tables, stored procedures, and supporting objects.
  • Build and support operational reports for company and clients.
  • Work with data team to provide operational support, resolve recurring problems.
  • Document database topology, architecture, processes, and procedures.
  • Develop SQL queries and support ad hoc requests for data.
  • Assist with capacity planning and resource expansion through data aggregation and analysis.
  • Work with project managers to ensure that reports and metrics identify business needs and opportunities for process improvement.
  • Identify inefficiencies in the database platform and provide solutions to the management.
  • Develop time estimates for assigned tasks.
  • Use problem-solving skills to assist in resolution of business problems.
  • Develop analytical skills to resolve technical problems.
  • Identify root causes for problems and propose solutions to prevent recurring.

 

Qualifications:

 

  • BSCS with 3+ years MS SQL experience.
  • Thorough understanding of database structures, theories, principles, & practices.
  • Ability to write & troubleshoot SQL code & design stored procedures, functions, tables, views, triggers, indexes, & constraints.
  • Extensive knowledge of MS SQL Server 2005/2008/2012/2014.
  • Knowledge of SSIS/SSRS is a plus.
  • Experience with C# or VB.NET.
  • Technical knowledge of MS SQL Server internals with emphasis on query performance.
Apply
Drop files here browse files ...