SQL Software Consultant

  • Worcester, MA
  • Posted 3 days ago | Updated 4 hours ago

Overview

Remote
On Site
USD 60.00 - 65.00 per hour
Contract - W2
Contract - Independent

Skills

Documentation
Data Flow
Control Flow
Data Integrity
Stored Procedures
Territory Management
C#
ASP.NET
ASP.NET MVC
Web Applications
Database
SQL
Performance Metrics
Microsoft IIS
Management
Microsoft SQL Server
Optimization
Configuration Management Database
Microsoft SSIS
Finance
Accounting
Marketing
Legal
Customer Support
Online Training
Artificial Intelligence
Insurance
.NET

Job Details

Description

We are looking for a contractor to help us with the maintenance of a software that will be decommissioned and replaced with a new software. While the implementation is taking place, the contractor will be needed to "keep the lights on" performing Maintenance and troubleshooting problems for end users. This will not be a development or Modification role, but a background in development would be useful for troubleshooting problems that arise. The below technical details are the requirements for this long-term contract position for 7-10 months.

SQL Server:

Develop, write, and optimize complex SQL queries to retrieve and manipulate data efficiently
Design, write, update and maintain stored procedures.
Use SQL Server Agent to schedule and manage jobs and to automate SSIS package execution.
Monitor job execution and troubleshoot any issues that arise
Maintain comprehensive documentation of database structures, processes, and procedures
Communicate effectively to ensure alignment and understanding of database-related tasks and projects

SSIS

Develop, deploy and maintain SSIS packages. This includes designing data flow tasks, control flow tasks, and using various SSIS components such as data sources, transformations, and destinations
troubleshoot and resolve issues that arise during the execution of SSIS packages, ensuring data integrity and reliability
Write complex SQL queries, stored procedures, and functions to support SSIS operations.
Document SSIS package configurations and processes

.NET

Support existing Homegrown tools: Commissions, Territory Management
Write, debut and optimize C# code
Experience with ASP.NET and ASP.NET MVC in order to support existing web applications using these frameworks
write complex SQL queries, design and manage databases, and integrate them with .NET applications

SQL Sentry

Configure and monitor SQL Server Agent jobs, event chains, and performance metrics
Troubleshooting and resolving issues related to jobs and event chains.
Configure alerts and notifications for job failures and performance issues

IIS (Preferred - Not mandatory)

Manage IIS including resetting application pools, configuring and decommissioning websites.
Ability to troubleshoot IIS related issues
Knowledge of URL rewrite rules to manage URL redirection and enhance security

Requirements

Microsoft SQL Server, Optimization, Configuration Management, Database Administration, Advanced driver assistance systems, SSIS, Maintenance software, Basic Troubleshooting

Technology Doesn't Change the World, People Do.

Robert Half is the world's first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.

Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app and get 1-tap apply, notifications of AI-matched jobs, and much more.

All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.

2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking "Apply Now," you're agreeing to Robert Half's Terms of Use.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Robert Half