jobright.com
Sr. Data Engineer - Remote (USC & GC only)
jobright.com - Charlotte, North Carolina, United States, 28245
Work at jobright.com
Overview
- View job
Overview
Join to apply for the
Sr. Data Engineer - Remote (USC & GC only)
role at
Jobright.ai . Lenmar Consulting Inc is seeking a Senior Data Engineer to enhance their SQL processes. The role involves optimizing SQL performance, modernizing data layers, and collaborating with backend developers to ensure efficient data access. 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. Qualifications: Required: 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. Preferred: Strong experience in writing, testing, and structuring SQL process queries. Experience with Visual Studio database tools. Knowledge of AI tools like Amazon Q for SQL optimization. Company: Lenmar Consulting Inc, established in 1998, specializes in food processing and professional services, providing highly-skilled financial professionals and IT staffing solutions. Headquartered in Jersey City, NJ, with 501-1000 employees. Seniority level
Mid-Senior level Employment type
Full-time Industry
Software Development Additional benefits inferred include medical and vision insurance, and 401(k). #J-18808-Ljbffr
Sr. Data Engineer - Remote (USC & GC only)
role at
Jobright.ai . Lenmar Consulting Inc is seeking a Senior Data Engineer to enhance their SQL processes. The role involves optimizing SQL performance, modernizing data layers, and collaborating with backend developers to ensure efficient data access. 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. Qualifications: Required: 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. Preferred: Strong experience in writing, testing, and structuring SQL process queries. Experience with Visual Studio database tools. Knowledge of AI tools like Amazon Q for SQL optimization. Company: Lenmar Consulting Inc, established in 1998, specializes in food processing and professional services, providing highly-skilled financial professionals and IT staffing solutions. Headquartered in Jersey City, NJ, with 501-1000 employees. Seniority level
Mid-Senior level Employment type
Full-time Industry
Software Development Additional benefits inferred include medical and vision insurance, and 401(k). #J-18808-Ljbffr