SKG Consulting
Senior SQL Database Developer (Hybrid) - #21332
SKG Consulting, Trenton, New Jersey, United States
Overview
Seeking a Senior SQL Developer to join our data team in analyzing, developing SSIS projects, custom reports and work closely with the team on any SQL issues. This is an excellent opportunity for an ambitious and agile person looking to grow and learn in a very fast-paced environment. This is a hybrid role and requires 3 days per week on site.
Responsibilities
Develop SSIS projects to handle ETL, transmission, encryption, and archiving of files received and generated.
SQL Database Tuning and Performance.
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.
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.
Requirements
Requires a four-year degree in Computer Science/Information Technology.
Minimum 5+ years working as a Database engineer or a related role.
Minimum of three years SSIS experience.
Minimum of two years’ experience with C# and/or VB.NET.
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 2012 or later.
Extensive knowledge with SSRS/SSIS/T-SQL.
Experience with C# and/or VB.NET.
Technical knowledge of MS SQL Server internals with emphasis on query performance.
Knowledge and know-how to troubleshoot potential issues; experience with best practices around database operations.
Require ability to work independently with minimal supervision.
Ability to multi-task with several complex and demanding projects.
#J-18808-Ljbffr
Responsibilities
Develop SSIS projects to handle ETL, transmission, encryption, and archiving of files received and generated.
SQL Database Tuning and Performance.
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.
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.
Requirements
Requires a four-year degree in Computer Science/Information Technology.
Minimum 5+ years working as a Database engineer or a related role.
Minimum of three years SSIS experience.
Minimum of two years’ experience with C# and/or VB.NET.
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 2012 or later.
Extensive knowledge with SSRS/SSIS/T-SQL.
Experience with C# and/or VB.NET.
Technical knowledge of MS SQL Server internals with emphasis on query performance.
Knowledge and know-how to troubleshoot potential issues; experience with best practices around database operations.
Require ability to work independently with minimal supervision.
Ability to multi-task with several complex and demanding projects.
#J-18808-Ljbffr