SQL Database Engineer

KellyMitchell Group is recruiting for an unnamed client seeking an SQL Data Engineer to design, maintain, and optimize SQL Server databases and data solutions. The role focuses on complex SQL and T-SQL, database performance, and ETL/ELT pipelines, while collaborating with technical teams and stakeholders to support reporting and analytics.

Responsibilities

• Design new databases, enhance existing databases, and develop complex SQL queries and Transact-SQL (T-SQL) stored procedures
• Troubleshoot database issues, investigate incoming tickets, identify root causes, document findings, and implement effective solutions
• Optimize slow-running queries through query rewriting, indexing strategies, execution plan analysis, and database design improvements
• Apply database design principles, normalization, and SQL Server best practices to build reliable and efficient data solutions
• Analyze SQL Server Database Engine internals, including buffer pool behavior, parallelism, execution plans, and indexing, to improve performance
• Design, build, maintain, and monitor data pipelines using ETL/ELT processes
• Collaborate with Software Engineers and Data Scientists to improve data flow from collection and processing through reporting and analytics
• Gather requirements from stakeholders, translate business needs into technical solutions, and document and implement database changes
• Monitor database health and performance, identify potential issues, and take appropriate action when systems fail
• Ensure data is accurate, accessible, reliable, and structured to support reporting and business intelligence needs
• Identify opportunities to improve database reliability, maintainability, performance, and operational efficiency
• Maintain a positive, collaborative, and proactive approach to problem-solving and continuous learning

Preferred

• 2+ years of experience working with Business Intelligence (BI) tools
• Experience with C# and the .NET development environment
• Experience with Python for automation, scripting, data pipeline support, or process improvement
• Experience supporting reporting and analytics solutions through efficient database design and data delivery
• Familiarity with data integration, data transformation, and pipeline monitoring
• Experience collaborating with Software Engineers and Data Scientists on data-intensive applications
• Experience implementing database performance improvements and SQL Server optimization best practices
• Experience automating database monitoring or routine data engineering tasks
• Business intelligence tools
• C#
• .NET development
• Python
• Scripting
• Data pipeline support
• Process improvement
• Analytics solutions
• Data delivery
• Data integration
• Data transformation
• Pipeline monitoring
• Data-intensive applications
• Database performance optimization
• SQL Server optimization
• Database monitoring
• Data engineering tasks
• Cross-functional collaboration

Benefits

• Medical, Dental, & Vision Insurance Plans
• Employee-Owned Profit Sharing (ESOP)
• 401K offered
• Onsite amenities include a cafeteria, fitness facilities, instructor-led fitness classes, and recreational activities
• Discounted tuition opportunities
• Access to select local sporting events

Company

• IT staffing and project solutions for technology organizations
• St Louis, Missouri, USA
• https://www.kellymitchell.com/
• Founded in 1998
• 1001-5000 employees

Qualifications

• Bachelor's degree in Computer Science, Management Information Systems (MIS), or equivalent work experience
• 4+ years of experience as a SQL Server Data Engineer
• 2+ years of experience creating, managing, and monitoring data pipelines using ETL/ELT processes
• Strong hands-on experience with Microsoft SQL Server, SQL, and Transact-SQL (T-SQL)
• Demonstrated experience creating, managing, and optimizing stored procedures
• Deep understanding of database design, normalization, and relational database concepts
• Good understanding of SQL Server Database Engine internals, including buffer pool, parallelism, execution plans, and indexing
• Strong experience troubleshooting database issues and optimizing slow-running queries
• Understanding of how data is consumed by applications, reporting solutions, and analytics platforms
• Ability to investigate performance issues, identify root causes, and implement effective database solutions
• Strong analytical, troubleshooting, and problem-solving skills
• 2+ years of experience working with Business Intelligence (BI) tools
• Experience with C# and the .NET development environment
• Experience with Python for automation, scripting, data pipeline support, or process improvement
• Experience supporting reporting and analytics solutions through efficient database design and data delivery
• Familiarity with data integration, data transformation, and pipeline monitoring
• Experience collaborating with Software Engineers and Data Scientists on data-intensive applications
• Experience implementing database performance improvements and SQL Server optimization best practices
• Experience automating database monitoring or routine data engineering tasks

Required skills

• Business Intelligence, Database Design, ETL/ELT Data Pipelines, Indexing, Microsoft SQL Server, Query Optimization, Relational Database Concepts, Root Cause Analysis, SQL, SQL Server Database Engine Internals, Stored Procedures, Transact-SQL (T-SQL)

Preferred skills

• Experience with C# and the .NET development environment

Experience

• 4+ years