Senior DevOps Engineer

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

About Aubrant Aubrant Digital is a leader in multi-shore custom application development. We are passionate about solving our clients’ business problems through consultative teamwork, innovative software, and proven processes. We’ve served more than 50 clients and delivered hundreds of high quality, custom enterprise applications. Our clients value us as integral team members who get the job done on time and on spec, and we are proud of our high client retention rate and under 2% staff turnover. With offices in New Jersey, Boston, Costa Rica, and Eastern Europe, we execute the full software lifecycle, from architecture and design through development, QA and application maintenance & support. Our company culture emphasizes client service, trust-based relationships, and innovation. As a Senior Data Engineer, you will design, build, and tune the data layer that powers our clients' mission-critical applications on Azure and SQL Server. You will own complex query performance, indexing strategy, and concurrency design, and you will architect the data access patterns that connect application code to the database through linq2db, LINQ-to-SQL, Entity Framework, and ADO.NET. You will partner with application engineers, architects, and product teams to deliver high-throughput, low-latency datasolutions, andyou will mentorothers on database design, query optimization, and modern data engineering practices.

What qualifications make you an Aubrant Senior Data Engineer?

• A database craftsperson who treats query performance, indexing, and concurrency as first-class engineering concerns rather than afterthoughts.
• A clear communicator who can explain execution plans, locking behavior, and data access trade-offs to engineers, architects, and product stakeholders.
• Comfortable operating with ambiguity, capable of profiling production workloads and proposing concrete solutions backed by evidence.
• A mentor who raises the bar for the team through code review, query review, and pattern guidance.
• Customer-obsessed and outcome-focused, balancing delivery speed with the long-term health and scalability of the data platform.

Responsibilities:

Database Engineering & Performance:

• Design andmaintainSQL Server 2019+ schemas, indexes, and query patterns that meet performance, scalability, and concurrency requirements.
• Analyze execution plans,identifybottlenecks, and tune queries, indexes, and statistics; advise on RCSI and isolation level choices.
• Design andoperateChange Data Capture (CDC) pipelines and other change-tracking patterns to support downstream consumers.

Data Access & Application Integration:

• Implement and review data access using linq2db, LINQ-to-SQL (DBML), Entity Framework, and ADO.NET; choosethe right tool for each scenario.
• Translate business and application requirements into efficient SQL and C# data access code that is performant, testable, and maintainable.
• Partner with application engineers to align ORM usage with database performance characteristics and avoid common anti-patterns.

Cloud Data Platform & Delivery:

• Design andoperatedata 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.
• Mentor engineersondatabase design, query optimization, and data accesspatterns;set standards for the team.

Qualifications:

• Bachelor's Degree in Computer Scienceor a related discipline, or equivalent experience; MUST be proficient in written and spoken English (85%).
• 5 to 8 years of professional data engineering or back-end engineering experience with a strong database focus.
• Expert-level proficiency in SQL on SQL Server 2019+, including complex queries, window functions, set-based operations, query plan analysis, indexing strategy, statistics, RCSI, isolation levels, and Change Data Capture.
• Expert-level proficiency in database performance tuning , including bottleneck identification, index design, query rewrites, and concurrency design under production load.
• Strongproficiencyin C# data access using linq2db, LINQ-to-SQL (DBML), Entity Framework, and ADO.NET; ability to choose theappropriate toolfor each scenario and avoid ORM performance pitfalls.
• Strongproficiencyin Python for data engineering tasks, scripting, and automation.
• Hands-on experience with Azure data services (Azure SQL, storage, networking, security) and deploying production data workloads in Azure.
• Experience with database CI/CD, schema versioning, and migration tooling.
• Solid Git, code review discipline, and familiarity with modern engineering practices including testing and observability.
• Experience with Azure Data Factory, Synapse, or other Azure analytics services is a plus.
• Experience designing event-driven or streaming data architectures is a plus.
• Excellent analytical and problem-solving skills;strong communication, collaboration, customer orientation, innovation mindset, and adaptability under ambiguity.

Originally posted on Himalayas