M&T Bank is looking for a Sr. SQL Data Engineer to lead the modernization of a legacy SQL Server data layer. You will translate complex joins and procedures into optimized, scalable patterns for containerized services, ensuring high-performance data access and preparing the system for eventual migration to cloud services.

What You'll Do

Refactor 106+ SQL stored procedures for performance and maintainability
Optimize existing stored procedures for high-throughput workloads on Microsoft SQL Server
Build repository layers and support ORM implementations like EF Core and 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 data access patterns
Monitor, tune, and benchmark critical database queries

What We're Looking For

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
Comfortable working in a dynamic, fast-paced environment leveraging Agile principles
Strong experience writing, testing, and structuring SQL process queries
Expertise in TSQL development and Visual Studio database tools
Proficiency in examining execution plans, indexing choices, and optimizing performance
Ability to analyze table relationships, understand joins, and determine appropriate indexes
Strong experience using AI for optimizing SQL, with Amazon Q preferred