This site uses cookies. To find out more, see our Cookies Policy

Application Support DBA in Bohemia, NY at The Nature's Bounty Co.

Date Posted: 1/24/2019

Job Snapshot

  • Employee Type:
    Full-Time
  • Location:
    Bohemia, NY
  • Job Type:
  • Experience:
    At least 3 year(s)
  • Date Posted:
    1/24/2019

Job Description

For more than 70 years, The Nature’s Bounty Co. has enriched the lives of consumers around the world and stood as the leader in health and wellness by introducing innovative products and solutions to the marketplace. Putting science and the highest quality standards at the heart of our business, the brands of The Nature’s Bounty Co. are some of the most trusted in the world. Always motivated by nature’s bountiful effects on people’s health, our vision for health and wellness has inspired leading brands such as Nature’s Bounty®, Sundown Naturals®, Solgar®, Osteo Bi-Flex®, Ester-C®, MET-Rx®, Pure Protein®, Balance®, Body Fortress®, Puritan’s Pride® and Organic Dr.®, among others. As a leading global manufacturer, marketer, distributor and retailer of vitamins, nutritional supplements, sports & active nutrition and ethical beauty products, The Nature’s Bounty Co. is committed to supporting wellness in all its forms.

Job Description

The Application Support DataBase Administrator (DBA) will provide database support to The Nature’s Bounty Co.'s mission critical E-Commerce applications.  The DBA will co-develop database and data feed solutions, participate in the build and deployment cycle and contribute in all phases of development projects while providing support to existing clients. 

Additional responsibilities include, but are not limited to:

  • Maintain and enhance database code to support web-based, mission-critical, high-volume, high-performance E-commerce applications
  • Work with senior members of the database development team to develop solutions that meet business goals
  • Develop and administer feeds (SQL Server Integration Services (SSIS) packages) to ensure flow of data and media to and from business partners
  • Core database functions, SSIS packages and assisting application teams with end-to-end data flow and connectivity through web services
  • Develops, imports to and extracts from existing SQL databases
  • Use various source and targets to build data feed flows – XML, Flat File, Services, Functions etc.
  • Database programming and relational design concepts in support of interactive and batch systems
  • Participate in design and code reviews of solutions
  • Diagnose and define database performance issues with web-based applications
  • Troubleshoot the issue to determine appropriate course of action, escalate issue, if warranted
  • Respond to ad hoc requests for support and analysis
  • Debug and analyze existing code with minimal documentation available, by analyzing database structures, querying, running Profile Traces, and reviewing SQL logs when needed
  • Performs analysis and makes development recommendations to improve application performance
Qualifications

  • 3+ years of Microsoft SQL Server Development and Administration experience. SQL Server 2008 and later
  • 3+ years of supporting a highly transactional e-commerce environment
  • Strong experience with SSIS, Extract, Transform, Load (ETL), Extract, Load, Transform (ELT), Transact Structured Query Language (TSQL) and Stored Procedures
  • Exceptional knowledge of various tools to troubleshoot issues. SQL Server Profiler, Index Tuning, query executing plans, optimization, statistics etc.
  • Excellent analytical skills
  • Strong communication skills
  •  Ability to multi-task and lead difficult and complex work assignments
  • An undergraduate degree in MIS, Computer Science, or related field, or equivalent experience
  • Any Microsoft database certifications a plus
Additional Information

The Nature's Bounty Co. is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.

The Nature's Bounty Co. offers a competitive salary and a comprehensive benefits package, which includes health and dental plans, voluntary short-term and long-term disability, life insurance, flexible spending accounts, 401(k), tuition reimbursement, generous associate discounts and more!

Please contact Human Resources at 631-244-2120 if you should need a reasonable accommodation to submit your information for our on-line job postings.