Senior SQL Server Developer & Data Modeling Expert

Staffing Spot, Inc.; Charlotte (NC); On-site; USD 110,000 - 140,000; Full time

Job summary

Staffing Spot, Inc. is seeking an experienced SQL Server Database Engineer to design, develop, and maintain large-scale SQL Server databases.

You will optimize complex queries, implement robust data models, and ensure data integrity across production systems. You will collaborate with backend developers, BI analysts, QA, and reporting teams, performing deployments and code reviews while advancing indexing strategies and performance tuning.

Qualifications

• 8+ years’ experience with Microsoft SQL Server (mandatory).
• 7+ years’ experience with data modeling and database design.
• 7+ years’ experience building DB objects (tables, views, stored procedures, functions).
• 7+ years’ experience with SQL query performance tuning.
• 3+ years’ Agile development experience.
• Experience with Tableau reporting and ETL processes.
• Strong knowledge of SQL, T-SQL, joins, subqueries, CTEs and window functions.
• Experience with indexing, execution plans, and deadlock troubleshooting.
• Knowledge of transactions, locking, blocking, and recovery.

Responsibilities

• Design, develop, and maintain databases using Microsoft SQL Server.
• Write and optimize complex SQL queries, stored procedures, functions, and views.
• Perform database performance tuning and query optimization.
• Develop and maintain indexes, triggers, and database objects.
• Analyze execution plans and troubleshoot slow-running queries.
• Design database schemas, tables, relationships, and constraints.
• Implement data integrity, security, and access control.
• Support database troubleshooting, debugging, and production issues.
• Work closely with backend developers, business analysts, QA, and reporting teams.
• Participate in database deployments, code reviews, and documentation.

Skills

MS SQL Server

SQL

Data modeling

Database design

Tableau

ETL

Performance tuning

T-SQL

Stored procedures

Indexes

Tools

SQL Server Management Studio

Job description

Staffing Spot, Inc. is seeking an experienced SQL Server Database Engineer to design, develop, and maintain large-scale SQL Server databases.

You will optimize complex queries, implement robust data models, and ensure data integrity across production systems. You will collaborate with backend developers, BI analysts, QA, and reporting teams, performing deployments and code reviews while advancing indexing strategies and performance tuning.