Homeoffice Sr. SQL Data Engineer - Remote (USC & GC only) presso Lenmar Consulting Inc.

Food Processing

Strong experience how to write, test and structure SQL process query

TSQL development

Visual studio database tools (how to write perspective)

AI tool - Amazon Q preferred. Strong at using AI for optimizing SQL (amazon Q)

Examine execution plans, indexing its choosing, and optimizing the performance of those things

Understanding how to understand execution plan

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

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.

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

All your information will be kept confidential according to EEO guidelines.