Database Engineer

MidwayUSA; Columbia Township (MO); On-site; USD 70,000 - 110,000; Full time

Benefits offered by this job

Profit sharing

401(k) matching

Flexible PTO

Health plans

Tuition assistance

Professional development

Job summary

MidwayUSA, a privately held eCommerce company in the outdoor industry, seeks a Database Engineer to build fast, secure, scalable data solutions supporting a customer-first experience in a fast-paced team.

Responsibilities include writing and tuning SQL queries, designing data structures, and ensuring data integrity and security. The role offers growth opportunities, flexible PTO policy, and a collaborative culture.

Qualifications

• Bachelor's degree is required.
• 1-3 years in a database related role.
• Passionate about databases and best practices.
• Desire to grow skills across the database role.

Responsibilities

• Write and tune Microsoft SQL queries for fast data storage and retrieval.
• Create and maintain T-SQL stored procedures, views, and functions.
• Review indexing to improve query performance.
• Participate in agile development with applications and web teams.
• Ensure data integrity and security in database design and operations.

Skills

Bachelor's degree

1-3 years experience

Database passion

Code quality

Education

Bachelor's degree

Tools

Microsoft SQL Server

PowerShell

Job description

MidwayUSAu00A0is 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 Bacheloru2019s 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 u00A0Columbia, 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 u00A0MidwayUSAu00A0(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, u00A0MidwayUSAu00A0has offered u00A0JUST ABOUT EVERYTHING for Shooting, Hunting, Fishing, and the Outdoors with an unyielding focus on Customer Satisfaction.

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

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

MidwayUSAu00A0is a tobacco & smoke-free campus