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
Nice to Have
- Knowledge of Postgres or Aurora PostgreSQL is a strong plus
Technical Stack
- Microsoft SQL Server
- TSQL
- Visual Studio Database Tools
- EF Core
- Dapper
- Amazon Q
- Aurora PostgreSQL
Work Mode
This is a remote position open to candidates within the United States.
All your information will be kept confidential according to EEO guidelines.
