Lenmar Consulting
Sr. Data Engineer - Charlotte, NC
Lenmar Consulting, Charlotte, North Carolina, United States, 28245
We have this W2 Contract opportunity for a Sr. Data Engineer with our Direct Clients in Charlotte, NC. Please Let us know if this is something that interests you.
Sr. Data Engineer - CPGJP00001696 Location: Work Location: Remote (Charlotte, NC preferred) Duration: 6 month contracts w/ potential to extend or convert Pay Range: $60-70//hr W2 (No Benefits)
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.
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
Thanks and Regards,
Valerian D'Cunha Lenmar Consulting Inc (a Kellton Company) 185 Hudson Street, Suite 1440, Jersey City, NJ D: 201-484-0120 F: 201-946-1790 E: vdcunha@lenmarit.com
Sr. Data Engineer - CPGJP00001696 Location: Work Location: Remote (Charlotte, NC preferred) Duration: 6 month contracts w/ potential to extend or convert Pay Range: $60-70//hr W2 (No Benefits)
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.
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
Thanks and Regards,
Valerian D'Cunha Lenmar Consulting Inc (a Kellton Company) 185 Hudson Street, Suite 1440, Jersey City, NJ D: 201-484-0120 F: 201-946-1790 E: vdcunha@lenmarit.com