Sr. Database Developer

Description

About USANA

Since 1992, USANA has provided the world with the highest-quality products focused on nutritional supplements, skincare, and a healthy lifestyle. But our commitment to excellence goes far beyond our products. USANA is dedicated to share our vision of health by empowering a global family of incredible employees based in more than 20 different markets around the world.

Community is at our core. It is our commitment to always strive to be open-minded listeners, hold ourselves and others accountable, be respectful, and celebrate the strength that comes from collaboration. Through initiatives like our Diversity, Equity, and Inclusion Council, we create a company culture where all members of the USANA Family feel cared for, included, and valued.

USANA has repeatedly been named one of Utah's Best Companies to Work For by Utah Business magazine, one of America's Best Companies to Work For by Outside Magazine, one of the Best Places to Work for in the Direct Selling Industry by Direct Selling News, and named a top employer by Best of State.

Who We Are Looking For

We are looking for an experienced individual to join the USANA database team as a senior database developer. In this position, you will be responsible for designing, developing, and maintaining complex database solutions for our organization. You will work closely with data architects, senior developers, and business stakeholders to deliver high-quality database solutions that meet business requirements and technical standards.

What You Will Do as USANA's Senior Database Developer

• Utilize your expertise in PL/SQL and T-SQL to design, build, and optimize triggers, functions, procedures, and packages for our relational data models

• Implement advanced indexing techniques (e.g., BIT Map indexes, index-organized tables) and leverage relational database optimization strategies (e.g., HASH joins, NESTED LOOPS, Oracle Hints, parallel query execution) to significantly improve query response times for data-intensive operations.

• Write dynamic SQL to efficiently generate directly into SQL blocks

• Regularly analyze, design, refactor, and fine-tune our online transaction processing (OLTP) databases

• Apply your experience with NoSQL databases (e.g., Couchbase, Redis, Mongo) to design and implement solutions that complement our relational data models for specific use cases

• Collaborate with architects, developers, and business stakeholders to understand database requirements and design solutions that meet business needs and technical standards

• Data architecture experience with high-volume transactional databases

• Data modeling experience along with using tools such as ER Studio or Erwin

Background and Skills You Will Need

• 5 + years of experience developing for Oracle and SQL Server databases using TSQL and PL/SQL

• 3+ years of experience in the analysis, design, development, deployment, and tuning of large-scale distributed, transactional e-commerce database applications

• Expert knowledge of Oracle PL/SQL and SQL Server TSQL best practices and development methodologies or standards

• Data partitioning techniques to manage, support, and performance tune very large databases (VLDBs)

• Excellent analytical, interpersonal, communication, and presentation skills

What Will Make You Standout

• BS degree in Information Systems or Computer Science

Benefits of Being Part of the USANA Family

We offer incredible benefits like health, dental, vision, life, and disability insurance; on-site medical and mental health clinic, chiropractic visits, massages, fitness classes, and a full-service gym; free and discounted USANA product; 401k match and profit-sharing bonuses; internal and external opportunities for learning and development; paid parental leave for both primary and secondary caregivers, and generous paid time-off to help you balance work and home!

__

USANA Health Sciences, Inc. will never ask candidates to submit personal identifiable information via email or attachments. Such information will be only be collected by candidates logging into and submitting through our secure HR management portal. If you are requested to provide information via an unsecure source, please delete the email and contact USANA directly.