Data Engineer

Data Engineer

Posted 2 weeks ago by 1754460526

Apply
Negotiable
Outside
Remote
USA
Apply
Agile Methodology Amazon Aurora Artificial Intelligence Cloud Computing Cloud Migration Cloud Technology Data Access Database Queries Data Engineering File Servers Indexing Microsoft 365 Microsoft SQL Servers Operational Risk Management Performance Tuning PostgreSQL Query Tuning SQL (Programming Language)

Summary: We are looking for four experienced Data Engineers with expertise in T-SQL to modernize a legacy SQL Server data layer as part of a cloud migration initiative. The role involves optimizing complex stored procedures and data access patterns for migration to modern services. Candidates should possess a forward-looking mindset focused on scalable, cloud-native data engineering and strong collaboration skills. The position is remote, with a duration of 6+ months and potential for extension or conversion.

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

Key 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

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

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

Apply
Similar Jobs
Loading data...