SQL Database Engineer

KellyMitchell Group; Saint Peters (MO); On-site; USD 62,000 - 90,000; Full time

Benefits offered by this job

ESOP

401K

Onsite amenities

Job summary

KellyMitchell is seeking an experienced SQL Data Engineer in St. Peters, MO to design, develop, maintain, and optimize SQL Server databases and data pipelines. You will collaborate with Software Engineers and Data Scientists to ensure data is reliable and accessible for reporting and analytics.

The role is fully onsite five days per week with a direct hire. Qualified candidates have 4+ years of SQL Server experience, strong T-SQL skills, and a track record of query optimization and scalable data

Qualifications

• Bachelor's degree in Computer Science, 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.
• Ability to work onsite in St. Peters, MO, five days per week.

Responsibilities

• Design new databases, enhance existing databases, and develop complex SQL queries and T-SQL stored procedures.
• Troubleshoot database issues, investigate tickets, identify root causes, document findings and implement fixes.
• Optimize slow-running queries through indexing, execution plans, and design improvements.
• Apply database design principles to build reliable and efficient data solutions.
• Analyze internals and performance to improve SQL Server efficiency.
• Design, build, monitor, and maintain data pipelines using ETL/ELT processes.
• Collaborate with Software Engineers and Data Scientists to improve data flow for reporting and analytics.
• Gather requirements and translate business needs into technical solutions.
• Monitor database health and performance and take action when systems fail.
• Ensure data is accurate, accessible, reliable, and structured for BI.
• Identify opportunities to improve database reliability, maintainability, performance, and operational efficiency.
• Maintain a positive, collaborative, and proactive approach to problem-solving and continuous learning.

Skills

SQL query optimization

Data troubleshooting

Analytical thinking

Onsite collaboration

Education

Bachelor's degree in CS / MIS

Tools

SQL Server

T-SQL

Stored procedures

ETL/ELT pipelines

Python

C# / .NET

Job description

Job Summary

Our client is seeking an experienced SQL Data Engineer to design, develop, maintain, and optimize SQL Server databases and data solutions. This role will focus on database engineering, complex SQL and T-SQL queries, stored procedures, database performance tuning, and data pipeline management. The ideal candidate will have strong hands-on experience with SQL Server, database design, query optimization, indexing, execution plans, and stored procedures. This individual will work closely with Software Engineers, Data Scientists, and business stakeholders to improve data flow, troubleshoot database issues, and ensure data is structured and accessible for reporting and analytics.

Contract Details

• Employment type: Direct Hire, Full-Time
• Work location: St. Peters, MO
• Work arrangement: Fully onsite, 5 days per week

Core 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

Required Skills/Experience (Must-Haves)

• 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
• Ability to work onsite in St. Peters, MO, five days per week

Preferred Skills/Experience (Nice-to-Haves)

• 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
• Database monitoring, reliability, and issue resolution
• Analytical thinking and root cause analysis
• Cross-functional collaboration and communication
• Proactive problem-solving and continuous improvement
• Positive attitude and willingness to learn
• Location: St. Peters, MO
• Work arrangement: Fully onsite, 5 days per week
• Hands-on technical environment focused on SQL Server, T-SQL, stored procedures, database design, and performance optimization
• Collaboration with Software Engineers, Data Scientists, and other technical stakeholders
• Opportunity to contribute to database engineering, data pipelines, reporting solutions, and overall data reliability
• Onsite amenities include a cafeteria, fitness facilities, instructor-led fitness classes, and recreational activities
• Additional onsite perks may include discounted tuition opportunities and access to select local sporting events
• Pay Range: The approximate pay range for this position is between $45.00 and $65.00. Please note that the pay range provided is a good faith estimate. Final compensation may vary based on factors including but not limited to background, knowledge, skills, and location. We comply with local wage minimums.
• Employee-owned Profit Sharing (ESOP)
• 401K offered

About KellyMitchell

At KellyMitchell, our culture is world class. We’re movers and shakers! We don’t mind a bit of friendly competition, and we reward hard work with unlimited potential for growth. This is an exciting opportunity to join a company known for innovative solutions and unsurpassed customer service. We’re passionate about helping companies solve their biggest IT staffing and project solutions challenges. As an employee-owned, women-led organization serving Fortune 500 companies nationwide, we deliver expert service at a moment's notice.