Database Engineer

MidwayUSA; Columbia (AL); Presencial; USD 90.000 - 120.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Profit sharing

401(k) matching

Flexible PTO

Health plans (HSA)

Life insurance

Tuition assistance

Professional development

Employee discounts

Descripción de la vacante

MidwayUSA, located in Columbia, MO, is seeking a Database Engineer to build fast, secure, and scalable data solutions that power a customer-first experience in a collaborative, fast-paced environment.

You will write and optimize MS SQL queries, design databases, and ensure reliability with backups and security while growing your skills across the database domain.

Formación

• Bachelor’s degree required.
• 1–3 years in a database-related role.
• Passion for databases and best practices.
• Desire to grow skills across the database role.

Responsabilidades

• Write and tune Microsoft SQL queries for fast data storage and retrieval.
• Compose custom T-SQL stored procedures, views, and functions as necessary for project work.
• Review indexing to improve query performance.
• Design logical schema and normalized data structures for custom applications.
• Preserve data integrity on custom transactional databases for large datasets and participate in system architecture design.
• Monitor, configure and optimize the performance of Microsoft SQL Server databases using PowerShell and ensure high availability and disaster recovery.

Conocimientos

Microsoft SQL

T-SQL

PowerShell

Query optimization

Database design

Data security

Educación

Bachelor's Degree

Herramientas

SQL Server

Descripción del empleo

MidwayUSA is a privately held eCommerce company in the Outdoor industry. We are looking for a talented Database Engineer excited to build fast, secure, and scalable data solutions to support a customer-first experience in a fast-paced team environment while still respecting your work/life balance.

About the Role

Database Development:

• Participate in an agile project development with Application and Web Developers to provide quality solutions to end users and customers
• Write and tune Microsoft SQL queries for fast and efficient storage and retrieval of data
• Compose custom T-SQL stored procedures, views, and functions as necessary for project work
• Review Indexing to improve query performance

Database Design & Modeling:

• Design logical schema and normalized data structures for custom applications
• Preserve data integrity on custom transactional databases for large and complex datasets
• Participate in system architecture (logical and physical design of the environment)
• Ethically handling privacy data for customers and business

Database Administration:

• Monitor, configure and optimize the performance of Microsoft SQL Server databases using PowerShell
• Maintain high availability and disaster recovery
• Ensure fast database backups on & off-site for a reliable recovery solution.
• Troubleshoot and resolve database performance issues
• Keep the databases secure by meeting cybersecurity standards, including patching

About You

• You will have a Bachelor’s Degree
• You will have 1-3 years minimum in a database related role
• You are passionate about databases and have a desire for best practices
• You have a desire to grow your skills in any part of the database role
• You value code quality and well tested code
• You love to collaborate with your team and members of the department daily to share knowledge, author, review code, document strategies, monitor the environment and triage production issues on a rotational basis

What We Offer

• Personal growth through a management relationship prioritizing support, empathy, clearly communicated expectations, and consistent modeling of Company Values
• Promote from within strategy
• Generous annual profit sharing
• Matching 401(k)
• Flexible PTO policy and paid parental leave
• Excellent choice of health plans (including HSA), dental, and vision benefit options at an affordable price
• Life insurance, short and long-term disability insurance options
• Tuition assistance program
• Learning subscriptions to Pluralsight and others with unlimited access to thousands of expert-led online courses
• Opportunities for career, leadership, and professional development with conferences, events, and seminars
• Supplier pro-deals and generous employee discounts

About MidwayUSA

MidwayUSA, located in Columbia, MO, is an industry-leading internet retailer of over 200,000 shooting, reloading, gunsmithing and hunting products. Both country kids from Missouri, Larry and Brenda Potterfield turned their passion for shooting sports into a career by opening a small gun shop in 1977 that would eventually become MidwayUSA (www.midwayusa.com). They instilled family values like honesty, integrity, and respect for others into the business, and strive to maintain this culture with each Employee added to their growing team. For over 45 years, MidwayUSA has offered JUST ABOUT EVERYTHING® for Shooting, Hunting, Fishing, and the Outdoors with an unyielding focus on Customer Satisfaction. MidwayUSA is one of only two organizations to be a three-time recipient of the Malcolm Baldrige National Quality Award

MidwayUSA believes working in the office is the best way to promote teamwork, but we understand life can be complicated sometimes so we’ve created a flexible work from home policy should the need occasionally arise.

MidwayUSA requires all candidates post-offer to submit to a background check and drug screening as a condition of employment.

MidwayUSA is a tobacco & smoke-free campus