Senior Data Engineer - Azure & SQL Performance

Aubrant Digital LLC; United States; On-site; USD 120,000 - 180,000; Full time

Job summary

Aubrant Digital is seeking a Senior Data Engineer to design, build, and tune the data layer powering client applications on Azure and SQL Server. You will own complex query performance, indexing strategy, and concurrency design, partnering with engineers to deliver high-throughput, low-latency data solutions.

You will mentor others in database design, query optimization, and modern data engineering practices while collaborating with product teams to meet business goals.

Qualifications

• 5–8 years of professional data or back-end engineering experience with a strong database focus.
• Expert-level SQL on SQL Server 2019+ including window functions, advanced indexing, and Change Data Capture (CDC).
• Strong proficiency in C# data access using linq2db, LINQ-to-SQL (DBML), Entity Framework, and ADO.NET.
• Excellent written and spoken English; ability to communicate technical concepts to diverse stakeholders.

Responsibilities

• Design and maintain SQL Server 2019+ schemas, indexes, and query patterns for performance, scalability, and concurrency.
• Analyze execution plans, identify bottlenecks, and tune queries, indexes, and statistics; advise on RCSI and isolation level choices.
• Design and operate Change Data Capture (CDC) pipelines and other change-tracking patterns for downstream consumers.
• Implement and review data access using ORM tools; translate business requirements into efficient SQL and C# data access code.
• Partner with engineers to align ORM usage with database performance and avoid ORM pitfalls.
• Design and operate data solutions on Azure, including Azure SQL, storage, networking, and security configurations.
• Contribute to CI/CD for database changes through migration scripts, schema versioning, and automated deployments.

Skills

Query performance

Indexing strategy

Concurrency design

Communication

Mentoring

Ambiguity profiling

Education

Bachelor's Degree in Computer Science

Tools

linq2db

LINQ-to-SQL

Entity Framework

ADO.NET

C#

Azure SQL

Azure Data Factory

Synapse

Job description

Aubrant Digital is seeking a Senior Data Engineer to design, build, and tune the data layer powering client applications on Azure and SQL Server. You will own complex query performance, indexing strategy, and concurrency design, partnering with engineers to deliver high-throughput, low-latency data solutions.

You will mentor others in database design, query optimization, and modern data engineering practices while collaborating with product teams to meet business goals.