Database Engineer

CarShield • St. Peters, MO

1d • Onsite

About The Position

We are seeking a mid-level SQL Server Developer who understands the intricacies of handling data at scale.

These are some of the duties you will be expected to perform:
Design new databases, enhance existing ones, write SQL queries and Transact-SQL (T-SQL) stored procedures.
Troubleshoot issues when tickets come in, find/document and implement elegant solutions.
Performance tune slow queries by re-writing, indexing and improving database design.
Work closely with Software Engineers and Data Scientists to improve data flow from collection to reporting.
Gather requirements from stakeholders when needed, document and implement them.
Maintain a positive, can-do attitude and a strong desire to learn and excel.
Monitor our databases, and take action when any system fail.
Learn new skills required for your job.

Requirements

• Must be able to work in-office in St. Peters, MO, 5 days a week (this position is fully on-site).
• Bachelor's degree in Computer Science, MIS or equivalent work experience.
• 4+ years of experience as a SQL Server Data Engineer.
• Deep understanding of SQL, database design, normalization.
• Good understanding of Database Engine internals such as buffer pool, parallelism, execution plans, indexing.
• 2+ years of experience creating, managing and monitoring data pipelines (ETL/ELT).
• Positive attitude, with a strong desire to learn and excel.
• Experience working with C#, .NET, and/or Python.
• 2+ years of experience with Business Intelligence (BI) tools.

Responsibilities

• Design new databases, enhance existing ones, write SQL queries and Transact-SQL (T-SQL) stored procedures.
• Troubleshoot issues when tickets come in, find/document and implement elegant solutions.
• Performance tune slow queries by re-writing, indexing and improving database design.
• Work closely with Software Engineers and Data Scientists to improve data flow from collection to reporting.
• Gather requirements from stakeholders when needed, document and implement them.
• Maintain a positive, can-do attitude and a strong desire to learn and excel.
• Monitor our databases, and take action when any system fail.
• Learn new skills required for your job.

Benefits

• Salary commensurate with experience.
• Group Insurance (Medical, Dental, Vision, Life, etc.).
• 401k with Employer Match.
• Discounted CarShield policies.
• Discounted Tuition at Lindenwood University.
• Professional development opportunities.
• Basketball, and other recreation available on-site.
• Fitness facilities, with the option to take classes led by on-staff personal trainer (at St. Peters headquarters).
• And more!

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level