SQL Server Developer / Performance Tuning - REMOTE - W2 or 1099 ONLY

SQL Server Developer / Performance Tuning - REMOTE - W2 or 1099 ONLY

Posted 1 week ago by 1754552229

Apply
Negotiable
Outside
Remote
USA
Apply
Agile Methodology Amazon Aurora Artificial Intelligence Cloud Computing Cloud Migration Cloud Services Cloud Technology Data Access Database Queries Data Modeling File Servers Indexing Microsoft 365 Microsoft SQL Servers Microsoft Visual Studio Operational Risk Management PostgreSQL Query Tuning Software Development SQL (Programming Language)

Summary: The role of Senior SQL Server Developer / Data Engineer involves modernizing a legacy SQL Server data layer for a global Fortune 500 company in the Food Services industry. The position focuses on optimizing complex SQL procedures and ensuring high-performance data access in preparation for cloud migration. The ideal candidate will work remotely and collaborate with backend developers to enhance data access patterns. This role requires a strong background in SQL Server and experience with ORM implementations.

Key Responsibilities:

  • Play a critical role in ensuring high-performance data access and preparing the system for eventual migration to cloud services.
  • Refactor 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.

Key Skills:

  • 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.
  • Understand how to write test and structure SQL process query.
  • Examine execution plans, indexing its choosing, and optimizing the performance of those things.
  • Development Tools: TSQL development, Visual studio database tools, AI tool - Amazon Q preferred (Any prompting is good).
  • Understanding how to understand execution plan.
  • Look at series of tables, understand the joins, what indexes are appropriate or inappropriate.
  • Ability to simply complexity.
  • Strong at using AI for optimizing SQL (amazon Q).

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Sr. SQL Server Developer / Data Engineer REMOTE Charlotte NC Preferred

About our Customer:

Our direct customer, a global Fortune 500 company & a leader in the Food Services industry is looking for Senior SQL Server Developer / Data Engineer ( to Modernize a legacy SQL Server data layer by translating complex joins and procedures into optimized, scalable patterns for containerized services.

Responsibilities:

  • Play a critical role in ensuring high-performance data access and preparing the system for eventual migration to cloud services.
  • Refactor 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:

  • 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
  • Understand how to write test and structure SQL process query
  • Examine execution plans, indexing its choosing, and optimizing the performance of those things
  • Development Tools: TSQL development, Visual studio database tools, AI tool - Amazon Q preferred (Any prompting is good)
  • Understanding how to understand execution plan
  • Look at series of tables, understand the joins, what indexes are appropriate or inappropriate
  • Ability to simply complexity
  • Strong at using AI for optimizing SQL (amazon Q)
Apply
Similar Jobs
Loading data...