Jr. Database Administrator

| Greater LA Area

It's fun to work in a company where people truly BELIEVE in what they're doing!

 

We're committed to bringing passion and customer focus to the business.

 

 

 

 

About iHerb:

iHerb is one of the leading global e-commerce retailers with its emphasis on Nutritional and Wellness products. Our mission is simple…providing the best overall value for natural products through "e-simplicity." Our values can be best defined as an environment in constant and continuous pursuit to conscientiously meet the needs of our customers, business partners, and team members while doing our part to safeguard the environment. 

 

Job Summary:

Under general supervision, the Jr. Database Administrator will be responsible for the installation, configuration, upgrade, administration, monitoring and maintenance of databases in the company. The role includes, system monitoring and improving database performance and capacity.. They may also plan, coordinate and implement security measures to safeguard the database.

 

Job Expectations:

  • Installing and upgrading the database server and application tools

  • Developing database queries for applications and programs as needed

  • Production deployments of T-SQL statements.

  • Responsible for the creation, maintenance, upgrades, performance, integrity and security of the databases across the organization.

  • Monitoring and optimizing the performance of the database

  • Planning for backup and recovery of databases

  • Maintaining archived data

  • Generating various reports by querying from database

  • Multitasking between projects

 

Knowledge, Skills and Abilities:

  Required:

  • Basic knowledge of SQL and experience with Microsoft SQL Server

  • Basic knowledge of relational databases

  • Basic knowledge of T-SQL and database programming

  • Full understanding of database transactions and how they work.

  • Experience in optimizing query plans

  • Experience in database security

  • Experience in working with SQL profiler

  • Experience in database mirroring and replications

 

Experience Requirements:

  • Experience in working with GCP, AWS, Azure would be nice to have.

 

Education Requirements:

Bachelors Degree required. An emphasis in Computer Science preferred.

Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • .NETLanguages
    • C#Languages
    • JavascriptLanguages
    • SqlLanguages
    • jQueryLibraries
    • jQuery UILibraries
    • ReactLibraries
    • ReduxLibraries
    • Twitter BootstrapLibraries
    • AngularJSFrameworks
    • ASP.NETFrameworks
    • HadoopFrameworks
    • Node.jsFrameworks
    • SparkFrameworks
    • CassandraDatabases
    • Maria DBDatabases
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • RedisDatabases
    • Google AnalyticsAnalytics
    • OptimizelyAnalytics
    • BalsamiqDesign
    • IllustratorDesign
    • InVisionDesign
    • PhotoshopDesign
    • SketchDesign
    • UXPinDesign
    • AsanaManagement
    • ConfluenceManagement
    • JIRAManagement
    • Microsoft ProjectManagement
    • SmartsheetManagement
    • ZendeskCRM
    • IterableCRM
    • IterableEmail
    • Google AnalyticsLead Gen
    • Google Data StudioLead Gen
    • TableauLead Gen

Location

Pasadena is known for it's charm and sophistication with the best night life, restaurants and bars this side of L.A! - Technology roles in Irvine, CA

An Insider's view of iHerb LLC.

What's something quirky about your company?

“Everyone is really different, nice and cool to be around. People are comfortable to be themselves, which is not common.”

Christopher

Junior Software Developer I

What's the biggest problem your team is solving?

“Most of the challenges stem from the extreme growth of the company in addition to keeping up with the technological advances in the market. We migrate and change quickly to adapt, which is the fun part because we are continuously learning.”

Alina

Senior Software Developer I

How does the company support your career growth?

"Everyone here is so brilliant. The teams are open and receptive to questions and work with you by providing constructive feedback, in addition to the camaraderie that supports consistent learning and development."

Kristine

Junior Software Developer I

How do you empower your team to be more creative?

"More so than empowering individuals, you have to hire the right people, trust them and let them do what they are good at.”

Alireza

Director of Software Development & Platform

What's the biggest problem your team is solving?

"The problem my team is currently solving is how to integrate robots into the warehouse. iHerb recently brought on a new team of engineers to design the robots and my team will be interfacing with them. This will involve a range of sub-problems from path finding for robot navigation to dynamic location management."

Ian

Software Developer II

What are iHerb LLC. Perks + Benefits

iHerb LLC. Benefits Overview

Perks include snack and beverage stations, on-site gym's, video arcade rooms, sand volleyball court, team happy hour and networking events and etc...iHerb is dedicated to providing comprehensive medical, dental and vision plans by contributing 75% or more of the monthly costs associated, regardless of one's level of coverage.

Culture
Volunteer in local community
iHerb is committed to helping great causes here at home and around the world. We partners with organizations like the Boys and Girls Club, Susan G Komen, Ronald McDonald House, Exceed, etc...
Partners with Nonprofits
Worldwide, we’ve donated over $5 million. iHerb facilitates two schools in Cambodia in addition to supporting the Cambodian Children's Fund and New Hope Cambodia in support of children's education.
Friends outside of work
Eat lunch together
Intracompany committees
iHerb's iFit and iFocus teams are dedicated to organizing company events in addition to creating wellness programs and initiatives. The overall health and wellness of our team members is priority!
Daily stand up
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Open office floor plan
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
iHerb Team Members can contribute up to $2700 annually to their FSA.
Disability Insurance
iHerb provides both short and long term disability coverage for it's Team Members.
Dental Benefits
iHerb provides both a DHMO and PPO thru Cigna Dental
Vision Benefits
Health Insurance Benefits
iHerb contributes 75% or more to the monthly costs associated with health plans ranging from Blue Shield's HMO, HMO+, PPO and HDHP.
Life Insurance
iHerb provides all full-time Team Members with a 100% company-paid $50,000.00 life/AD&D policy. In addition, Team Members have the option to elect additional life/AD&D coverage plans.
Pet Insurance
Wellness Programs
Onsite Gym
Team workouts
Retirement & Stock Options Benefits
401(K)
401(K) Matching
iHerb contributes a 100% match up to 4% of the Team Member's election. This is a "Safe Harbor" plan, absent from a vesting period , therefore the money that iHerb contributes is yours from day one.
Company Equity
iHerb provides a generous Profit Sharing and Phantom Unit Plan that provides equity to employees based on a minimal vesting period.
Performance Bonus
iHerb's annual discretionary bonus program is generous to say to say the least! Bonus plans are aligned with the individual and overall success of the company and Team Member.
Child Care & Parental Leave Benefits
Child Care Benefits
Generous Parental Leave
Family Medical Leave
Vacation & Time Off Benefits
Generous PTO
Acme Co. employees receive between 15 and 20 days per year of paid time off based on years of service.
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Game Room
Stocked Kitchen
Happy Hours
Happy hours are hosted On occasion .
Relocation Assistance
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Our tuition reimbursement plan offers an annual max of $5250 with a maximum total match of $5250.
Lunch and learns
Cross functional training encouraged
Promote from within
Continuing Education stipend
More Jobs at iHerb LLC.46 open jobs
All Jobs
Data + Analytics
Design + UX
Dev + Engineer
HR
Legal
Marketing
Operations
Product
Developer
new
Los Angeles
Developer
new
Los Angeles
Data + Analytics
new
Los Angeles
Developer
new
Los Angeles
Developer
new
Los Angeles
Developer
new
Los Angeles
Product
new
Los Angeles
Developer
new
Los Angeles
Data + Analytics
new
Los Angeles
HR
new
Los Angeles
Developer
new
Los Angeles
Operations
new
Los Angeles
Developer
new
Los Angeles
Developer
new
Los Angeles
Product
new
Los Angeles
Developer
new
Los Angeles
Developer
new
Los Angeles
Operations
new
Los Angeles
Operations
new
Los Angeles
Developer
new
Los Angeles
Data + Analytics
new
Los Angeles
Developer
new
Los Angeles
Developer
new
Los Angeles
Developer
new
Los Angeles
Developer
new
Los Angeles
Design + UX
new
Los Angeles
Data + Analytics
new
Los Angeles
Design + UX
new
Pasadena
Developer
new
Los Angeles
Operations
new
Pasadena
Design + UX
new
Pasadena
Marketing
new
Pasadena
Developer
new
Los Angeles
Data + Analytics
new
Los Angeles