Job description

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!

Requirements