*Data Engineer (12+ years of Experience)* (TSQL, AI Tool) (W2, Contract to Hire role)

  • Charlotte, NC
  • Posted 21 days ago | Updated 7 days ago

Overview

Remote
Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 6 Month(s)
Unable to Provide Sponsorship

Skills

Amazon Web Services
Data Modeling
Microsoft SQL Server
PostgreSQL
SQL
Transact-SQL
Stored Procedures
T-SQL
AWS
Amazon Q
AI Tools
Visual studio database

Job Details

Kellton Tech is a full-service software development company, offering end-to-end IT solutions, strategic technology consulting and product development services in Web, SMAC (Social, Mobile, Analytics, Cloud), ERP-BPM, and IoT space Our methodology of inventing infinite possibilities with technology helps us develop best in-class and cost effective solutions for our clients.

 

Currently Kellton Tech is looking for talented resources for one of our listed client. Below are the position details:

 

 

Position:Sr. Data Engineer (12+ Years)
Work Location: Remote (Charlotte, NC preferred)

Duration: 6 month contracts w/ potential to extend or convert

Job Description:
Modernize a legacy SQL Server data layer by translating complex joins and procedures into optimized, scalable patterns for containerized services. You'll play a critical role in ensuring high-performance data access and preparing the system for eventual migration to cloud services.

1.TSQL development

2Visual studio database tools (how to write perspective)

3AI tool - Amazon Q preferred. Any prompting is good

 

Understanding how to understand execution plan

look at series of tables, understand the joins, what indexes are appropriate or inappropriate '

Ability to simply complexity

Strong at using AI for optimizing SQL (amazon Q)

 

**Responsibilities:**
- Refactor 106+ SQL stored procedures for performance and maintainability
- Refactor and optimize existing stored procedures for high-throughput workloads on Microsoft SQL Server
- Build repository layers and support ORM implementations (EF Core, Dapper)
- Translate temp-table and batch logic to in-memory or cached patterns
- Prepare data access logic for compatibility with Aurora PostgreSQL
- Collaborate with backend developers to define efficient access patterns
- Monitor, tune, and benchmark critical database queries

**Requirements:**
- 5+ years working with SQL Server, query tuning, and indexing strategies
- Expertise in analyzing and optimizing stored procedures and execution plans
- Experience with EF Core, Dapper, or similar ORMs
- Solid understanding of normalized schemas, transactional integrity, and data modeling
- Knowledge of Postgres or Aurora PostgreSQL is a strong plus
- Comfortable working in a dynamic, fast-paced environment leveraging Agile principles

Apply: Interested candidates can apply with their detailed word formatted resume along with their contact information\availability to raj DOT sekhar AT Kellton DOT com

- 7.0.3.5.92.9.15.7

 

Thanks for all your time!

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.