Job Application for Database Administrator at iHerb

Back to jobs

iHerb’s Data Platform department is responsible for developing and enhancing database infrastructure to support the growth of the business and to promote highly available, stable and secure database systems.
Reporting to the Team Lead of Data Platform, the Sr. DBA will contribute to the overall engineering, design, build and high level support of all existing and new Microsoft SQL Server systems (SQL 2016 higher), mongoDB systems, DynamoDB as well as several other data stores owned by the data platform team. As a Senior team member, the successful candidate will need to work closely with our stakeholders and team members to develop consensus and find solutions to problems facing their business constituents.
The Sr. DBA II will work with IT development teams to assist in the implementation, development, deployment and administration of the databases that support the company's IT data integration initiatives. This candidate should be able to lead projects from inception to completion with little or no supervision.
Duties and Responsibilities
● Responsible for ensuring availability and performance of all iHerb databases.
● Work to ensure that the proper resources are allocated to the databases, and to ensure high
resilience and performance.
● Proactively monitor the database systems to ensure secure services with minimum downtime.
● Responsible for providing trend analysis to the management team to enable them to make
informed decisions regarding resource management.
● Responsible for troubleshooting and problem solving SQL development issues.
● Responsible for assisting developers to optimize, tune and enhance database queries
● Responsible for improvement and maintenance of all databases, to include rollout and upgrades.
● Responsible for implementation and release of database changes according to agreed timescales
and costs.
● Responsible for proposing and implementing database architectural changes to make database
infrastructure highly scalable and optimized
● Take on technical leadership responsibilities of database projects across various teams in the
organization
● Responsible for mentoring developers on data modeling best practices and enabling them to
come up with a optimized data model
● iHerb operates a 24x7 e-com platform. On-call / off-hours deployments and support will be
required.
Skills / Attributes Required
● Masters in Computer Science or related field are desirable
● 8+ years of in-depth SQL Server Database architecture and administration experience
● 1+ years of experience on NoSQL technologies in MongoDB, DynamoDB, TimeScaleDB, etc
● Experience in designing highly scalable database architectures and data models
● Extensive experience in High availability designs, Business Continuity processes, and conducting Disaster Recovery exercises
● Experience of managing SQL server & mongoDB clusters
● Strong self-sufficiency and initiative working on Database projects
● Experience in mentoring team members
● Practical experience in monitoring and tuning databases
● Experience with T-SQL, SSIS, stored procedures, Javascript, JSon, Powershell, Shell scripting
● Strong knowledge of Multi-Instance implementations and methodologies
● Experience with database clustering, Availability Groups, Replication, Log Shipping and Change
Data Capture
● Experience of managing SQL Server on AWS cloud platform
● Experience with CI/CD processes and scripting languages: Ansible, Terraforms, Jenkins
● Knowledge of Kafka or other streaming processes is desirable
● Technical certifications (AWS, SQL Server, MongoDB) are desirable

#LI-OJ1

Staffing Agency Submission Notice
iHerb does not accept unsolicited 3rd party ("Agency") candidates. If you are an Agency, please send any requests to be considered as a supplier in our Vendor Management System to staffingvendors@iherb.com. Do not contact iHerb employees directly. If requested to work on a role, any Agency candidates would be presented through the internal recruiting organization.

About iHerb
iHerb is on a mission to make health and wellness accessible to all. We offer Earth’s best-curated selection of health and wellness products, at the best possible value, delivered with the most convenient experience.

We’re the world’s largest eCommerce platform dedicated to vitamins, minerals, and supplements, and other health and wellness products. For more than 25 years, we’ve been making it simple for people all over the world to purchase the highest quality products. From supplements to skincare to grocery items, we ship over 50,000 products, from over 1,800 brands direct to our customers in 180+ countries.

Our vision is to become the #1 destination for health and wellness across the world.

With a passion for wellness and a mind for innovative solutions, iHerb team members share a vision for a healthier world that drives them each day. Our 5 Shared Values unite our global team:

Focus on the Customer · Empower Our People · Be Entrepreneurial & Pivot Quickly ·
Embrace Diversity & Inclusion · Strive for Simplicity

iHerb Benefits
At iHerb, we are dedicated to offering programs designed to help our employees and their families stay healthy, live well, and plan for their financial future. Built on a strong foundation, our programs provide options and upgrades with flexibility, protection, and security in mind. For the comprehensive benefits list, visit www.iHerbBenefits.com. For our international team members, you may be eligible for benefits depending on the country where you are employed. The Talent Acquisition Partner/local HR representative will go over the benefits you are eligible for.

iHerb is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status. iHerb provides equal employment opportunities to all applicants for employment and prohibits discrimination and harassment.

First Name

Last Name

Phone

Location (City)

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter

Accepted file types: pdf, doc, docx, txt, rtf

Are you currently an iHerb Core Team Member?

Select...

If you answered "Yes" that you are currently an iHerb core team member, what is your Employee ID? (say N/A if you are not currently an iHerb core team member)

Have you previously been employed by iHerb as a Core Team Member?

Select...

Do you have any relatives currently working at iHerb?

Select...

If "Yes", please provide the name(s) of iHerb employee(s) you are related to. If "No", you can say N/A.

How did you first hear about this position?

Select...

Were you referred to this position by a current iHerb employee? If "Yes", please note that person's name below. If "No", you can say N/A.

Are you currently, or have you ever been yourself or related related by blood, marriage or adoption to any officer, director or employee of PricewaterhouseCoopers (PwC) or any of its subsidiaries or affiliates (Price Waterhouse or Coopers & Lybrand)?

Select...

Are you engaged in any business activities that would be in direct conflict with iHerb's business or customers?

Select...

If "Yes" list business activities here. If "No", you can say N/A.

Are you 18 or older?

Select...

Please select the country of the position you are applying to.

Select...

Are you legally authorized to work in the country where this job is located? Proof of legal authorization to work in-country will be required upon employment.

Select...

Will you now, or will you in the future, require sponsorship for employment visa status (e.g., H-1B visa status; Transfer of Sponsorship, etc.) to work legally in the country where this job is located?

Select...

What are your compensation expectations (gross) for the position you have applied for today? (enter numbers only)

What is your current annual salary (gross)? (enter numbers only)

How would you classify your overall level of proficiency in English?

Select...

Chinese Name

What is the name of your current company?

What is your current job title?

LinkedIn Profile

Careers Privacy Statement

Select...

iHerb Holdings, LLC. and its subsidiaries, including iHerb Netherlands B.V. and iHerb Shanghai (collectively, "iHerb") collects personal information from you as part of its job application and recruitment process. The entity that is responsible for this information is the iHerb entity for which you apply for a job. The personal information you provide on this form will be used by iHerb to process your application and manage career opportunities at iHerb. This information also will be shared with our service providers who perform recruitment services on our behalf, including our service provider who operates this careers site on our behalf. For more information about our use of your personal information and the rights available to you under applicable law, please see our Careers Privacy Notice.

Employment Application - Certification

I certify that all responses and attachments herein are true and complete to the best of my knowledge. I authorize the investigation of all statements and attachments in the application for employment, as may be necessary in arriving at an employment decision. In the event of employment, it is understood that false or misleading information given or attached in my application or interview(s) may result in discharge.

By typing my name below, I understand I am electronically signing the application and that this is a legal representation of my signature.

Database Administrator

Apply for this job