SQL Programmer

MSR Technology Group; Bentonville (AR); On-site; USD 83,000 - 124,000; Full time

Job summary

MSR Technology Group is seeking an SQL-focused developer to support an eDiscovery/legal application in Bentonville, AR. You will work on the back end, primarily with SQL Server, stored procedures, and performance tuning to support data from merchandising, recruiting, and other datasets.

The role involves onsite work during standard business hours on a long-term contract, with opportunities to modernize legacy infrastructure and improve data processing across various business domains.

Qualifications

• Experience creating, modifying, and maintaining stored procedures.
• Comfortable working with medium to high complexity stored procedures and combining datasets.
• Strong experience with SQL Server Management Studio (SSMS).
• Ability to troubleshoot and improve poorly performing SQL queries.

Responsibilities

• Modify and maintain stored procedures across production systems.
• Join an existing application environment and collaborate with multiple development/support teams.
• Shield and optimize queries for large transactional datasets.

Skills

Stored procedures

SSMS

Query optimization

Large datasets

Cross-team collaboration

Onsite work

Tools

SQL Server Management Studio (SSMS)

Google BigQuery

Flyway

Job description

Location: Bentonville, AR (Onsite 4-5 days)

Duration: Long-term Contract

Client: Direct Client Need

Hours: Standard business hours

Project Overview

• The team supports a long-standing eDiscovery/legal application used to provide data to areas such as global investigations and claims so they can research and manage litigation-related matters.
• The application has been in place for roughly 15 years, and some of the underlying hardware/infrastructure is reaching end of support or warranty. The team has already started modernizing the environment.
• The application pulls together data from several business areas, including merchandising, recruiting, employee/people data, and other business datasets.
• Data volumes can vary significantly, from relatively small datasets to very large datasets involving areas like sales and transactional data.
• The front end is a .NET application and is handled by an internal associate team.
• The biggest need is on the back end. Data is primarily stored and processed in SQL Server, with significant use of stored procedures.
• A sister team currently supports that environment but has limited bandwidth, which is driving the need for additional SQL development capacity.

Core Requirements

• Experience creating, modifying, and maintaining stored procedures.
• Comfortable working with stored procedures of medium to higher complexity, including combining multiple datasets and applying business logic.
• Strong experience using SQL Server Management Studio (SSMS).
• Ability to troubleshoot and improve poorly performing SQL queries.
• Experience working with both smaller datasets and large transactional datasets.
• Comfortable joining an existing application environment and partnering with multiple development/support teams.
• Able to work onsite in Bentonville during standard business hours.

Nice to Have

• Google BigQuery experience. Helpful, but SQL Server is clearly the stronger priority.
• Experience with Flyway or similar database version control/deployment tooling.
• Experience supporting or modernizing legacy applications and database environments.
• Experience with merchandising/catalog, employee/people, recruiting, sales, or other complex enterprise datasets.
• Exposure to eDiscovery, legal, investigations, or claims-related data would also be relevant.