Database Engineer

MidwayUSA•Columbia, MO

3d•Hybrid

About The Position

MidwayUSA is hiring a Database Engineer to build fast, secure, and scalable data solutions supporting a customer-first experience. The role works in a fast-paced team environment while respecting work/life balance. The Database Engineer participates in agile project development with application and web developers, writes and tunes Microsoft SQL queries, and creates custom T-SQL stored procedures, views, and functions. The role reviews indexing, designs logical schemas and normalized data structures, preserves data integrity across large and complex transactional datasets, and contributes to logical and physical system architecture. It also involves ethically handling customer and business privacy data. Database administration duties include monitoring, configuring, and optimizing Microsoft SQL Server databases using PowerShell; maintaining high availability and disaster recovery; ensuring fast on- and off-site backups; troubleshooting performance issues; and securing databases through cybersecurity standards, including patching. The role collaborates with teammates and department members to share knowledge, author and review code, document strategies, monitor the environment, and triage production issues on a rotational basis. MidwayUSA is located in Columbia, Missouri. The company generally favors working in the office to promote teamwork, with a flexible work-from-home policy for occasional needs. Candidates must complete a background check and drug screening after receiving an offer. The campus is tobacco- and smoke-free.

Requirements

Bachelor’s degree.
At least 1 year of experience in a database-related role (the posting states 1–3 years minimum).
Passion for databases and a desire to follow best practices.
Desire to grow skills in any part of the database role.
Value code quality and well-tested code.
Ability and willingness to collaborate and share knowledge with teammates.

Responsibilities

Participate in agile project development with application and web developers to deliver quality solutions to end users and customers.
Write and tune Microsoft SQL queries for efficient data storage and retrieval.
Create custom T-SQL stored procedures, views, and functions as needed for project work.
Review indexing to improve query performance.
Design logical schemas and normalized data structures for custom applications.
Preserve data integrity in custom transactional databases with large and complex datasets.
Participate in system architecture, including logical and physical design of the environment.
Handle customer and business privacy data ethically.
Monitor, configure, and optimize Microsoft SQL Server databases using PowerShell.
Maintain high availability and disaster recovery.
Ensure fast on-site and off-site database backups for reliable recovery.
Troubleshoot and resolve database performance issues.
Secure databases by meeting cybersecurity standards, including patching.
Collaborate with team and department members to share knowledge, author and review code, document strategies, monitor the environment, and triage production issues on a rotational basis.

Benefits

Personal growth through a management relationship emphasizing support, empathy, clearly communicated expectations, and consistent modeling of company values.
Promotion-from-within strategy.
Generous annual profit sharing.
Matching 401(k).
Flexible PTO policy.
Paid parental leave.
Health plan options, including HSA, plus dental and vision benefit options.
Life insurance and short- and long-term disability insurance options.
Tuition assistance program.
Learning subscriptions, including Pluralsight, with unlimited access to thousands of expert-led online courses.
Career, leadership, and professional development opportunities, including conferences, events, and seminars.
Supplier pro-deals and employee discounts.