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 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.

Requirements

Must-haves

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

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlci/cdai

Platform: careers-html
Effort: medium