SQL Server Developer

Dexian; Georgia; On-site; USD 100,000 - 160,000; Full time

Job summary

Dexian seeks a hands-on database developer in Georgia to own stored procedures, T-SQL code, and data-movement processes for an enterprise data platform. You will work closely with backend teams and lead initiatives to adopt advanced data solutions.

The role involves daily coding, establishing standards, CI/CD deployment, and partnering with .NET developers to translate requirements into robust database objects. You will prototype AI capabilities like vector search to enhance business insights.

Qualifications

• Hands-on experience with MS SQL Server and T-SQL.
• Experience designing stored procedures, functions, views, and triggers.
• Experience with ETL/ELT, batch loads, and incremental data synchronization.
• Familiarity with CI/CD for database deployment.
• Ability to review data-access code from EF, Dapper, ADO.NET.

Responsibilities

• Design, develop, test, and maintain stored procedures, views, and triggers on SQL Server.
• Develop complex T-SQL scripts for data movement and ETL/ELT processes.
• Optimize queries with indexing and execution plan analysis; resolve blocking and deadlocks.
• Maintain schema changes and deployment scripts via CI/CD.
• Ensure data integrity and security of database code.
• Collaborate with the .NET backend to map requirements to DB objects.
• Review data-access code from EF, Dapper, ADO.NET.
• Participate in sprint planning and code reviews.
• Build reference architectures and reusable templates for enterprise data platform.
• Prototype AI capabilities like vector search and model serving.
• Identify high-impact use cases with stakeholders.

Skills

T-SQL

SQL Server

ETL/ELT

CI/CD

Data security

Entity Framework

Tools

Dapper

ADO.NET

SSMS

Job description

Position Summary

We are seeking a hands-on database developer with expertise in both high-performance T-SQL on SQL Server and building on a data platform. The successful candidate will own stored procedures and data-movement processes that support enterprise applications, collaborate closely with backend development teams, and lead initiatives to adopt advanced enterprise data solutions. This role involves daily coding as well as establishing best practices and standards for the team.

Key Responsibilities

• Design, develop, test, and maintain stored procedures, functions, views, and triggers on Microsoft SQL Server.


• Develop and manage complex T-SQL scripts for data movement, including ETL/ELT processes, batch loads, and incremental data synchronization.


• Optimize query performance through indexing, execution plan analysis, and resolving issues such as blocking, deadlocks, and long-running jobs.


• Maintain database schema changes, deployment scripts, and version control using CI/CD pipelines.


• Ensure data integrity, security, and auditability of database code.


• Collaborate with the .NET backend team to translate application requirements into well-designed database objects and data-access patterns.


• Review and improve data-access code from application sources such as Entity Framework, Dapper, and ADO.NET.


• Participate in sprint planning, design reviews, and code reviews as part of the engineering team.


• Support enterprise data platform adoption by building and establishing reference architectures, connection patterns, and reusable templates.


• Build and deploy enterprise data solutions, including semantic modeling and sample queries, to facilitate business user access.


• Prototype and implement additional AI-related capabilities on the data platform, such as vector search and model serving.


• Work with business stakeholders to identify high-impact use cases and evaluate outcomes.

Why This Opportunity May Be Appealing

This role offers the chance to work at the forefront of enterprise data innovations within a collaborative environment. You will have the opportunity to lead impactful projects, influence core data architecture, and work with cutting-edge tools and platforms. The position also provides professional growth in a high-demand skill set, supporting a variety of data initiatives across the organization.

Dexian stands at the forefront of Talent + Technology solutions with a presence spanning more than 70 locations worldwide and a team exceeding 10,000 professionals. As one of the largest technology and professional staffing companies and one of the largest minority-owned staffing companies in the United States, Dexian combines over 30 years of industry expertise with cutting-edge technologies to deliver comprehensive global services and support.
Dexian connects the right talent and the right technology with the right organizations to deliver trajectory-changing results that help everyone achieve their ambitions and goals.To learn more, please visit https://dexian.com/.
Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.