Overview
Skills
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!