Data Engineer

Overview

Remote
$50 - $60
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 6 Month(s)
No Travel Required

Skills

Expert in T-SQL - Tsql experts with genetic ai tool expertise

Job Details

Job Description

Resumes that are overly generic or longer than 4 5 pages will not be considered

Job Title: 4 Data Engineers - Expert in T-SQL - Tsql experts with genetic ai tool expertise
Location: Remote (Preferred: Charlotte, NC)
Duration: 6+ Months. Possible extension or conversion

Position Summary

We are seeking four experienced Data Engineers to play a critical role in modernizing a legacy SQL Server data layer as part of a large-scale cloud migration initiative. This position requires deep expertise in T-SQL and SQL Server performance tuning, refactoring complex stored procedures, and optimizing data access patterns to prepare for migration to modern, containerized services and Aurora PostgreSQL.

Candidates should have a forward-looking mindset focused on scalable, cloud-native data engineering and the ability to translate legacy batch and temporary table logic into efficient, in-memory or cached alternatives. The environment is fast-paced and Agile, requiring strong collaboration with backend developers and cross-functional teams.

Key Responsibilities

  • Refactor and optimize 100+ complex T-SQL stored procedures to improve performance, maintainability, and scalability
  • Optimize high-throughput workloads running on Microsoft SQL Server using advanced T-SQL query tuning and indexing strategies
  • Build repository layers and support ORM implementations such as EF Core and Dapper
  • Translate legacy temporary table and batch-processing logic into in-memory or cached alternatives
  • Prepare legacy data access logic for migration to Aurora PostgreSQL
  • Collaborate closely with backend development teams to define efficient, reusable data access patterns
  • Monitor, benchmark, and tune critical database queries to meet performance SLAs

Qualifications & Skills

  • 5+ years of hands-on experience with T-SQL and SQL Server, including advanced query tuning and indexing strategies
  • Proven expertise analyzing and optimizing complex T-SQL stored procedures and execution plans
  • Practical experience with modern ORMs (e.g., EF Core, Dapper)
  • Strong understanding of normalized schema design, transactional integrity, and data modeling
  • Familiarity with PostgreSQL or Aurora PostgreSQL is a strong plus
  • Ability to thrive in a fast-paced Agile environment, working collaboratively across cross-functional teams
  • Excellent analytical and communication skills with strong attention to detail

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Tek Inspirations LLC