Job Summary:
Under general supervision, the Sr. Database Reliability Engineer II will be responsible for the installation, configuration, upgrade, administration, monitoring and maintenance of data systems in the company. The role includes the development and design of database strategies, system monitoring and improving performance and capacity, and planning for future expansion requirements. Leads root cause analysis for performance issues, researches and participates in implementation of related new technologies. The Sr. Database Reliability Engineer II will mentor/coach team members including Database Administrators. They may also plan, co-ordinate and implement security measures to safeguard the database.
Job Expectations:
-
Installing and upgrading the database server and application tools
-
Allocating system storage and planning future storage requirements for the database system
-
Developing database queries for applications and programs as needed
-
Diagnosing database problems and coming up with resolutions
-
Ensuring compliance with database vendor license agreement
-
Monitoring and optimizing the performance of the database
-
Planning for backup and recovery of database information
-
Contacting vendors for technical support
-
Serves as the subject matter expert on DRE issues, improvements and implementations
-
Mentors and coaches new and/or less experienced DRE’s on the team
-
Participate in on-call rotation and incident escalations as necessary
The duties and responsibilities described above may provide only a partial description of this position. This is not an exhaustive list of all aspects of the job. Other duties and responsibilities not outlined in this document may be added as necessary or desirable, with or without notice.
Knowledge, Skills and Abilities:
Required:
-
Strong knowledge of relational and nosql databases
-
Strong knowledge of T-SQL and experience with Microsoft SQL Server
-
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 working with high traffic databases
-
Experience in setting up and managing fail-over clusters
-
Experience in database mirroring and replications
-
Experience in AWS (RDS, EC2, S3, IAM etc.)
-
Experience migrating MSSQL databases to postgresql
-
Experience in managing infrastructure as code, such as terraform, ansible, etc.
Experience Requirements:
Generally requires a minimum of eight (8) to fifteen (15) years of experience with the Microsoft SQL Server. Experience in working with NOSQL databases would be an advantage.
Education Requirements:
Bachelor’s Degree in Computer Science or related field required, or equivalent work experience
Master’s Degree preferred
Judgment/Reasoning Ability: Able to identify, troubleshoot and resolve problems quickly using sound judgment, poise and diplomacy. Ability to use judgment and reasoning skills, and determine when to escalate issues, as required, in a timely manner.
Physical Demands (Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.) The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.
While performing the duties of this job, the employee is required to sit, stand, walk, reach, bend and move about the facility.
Work Environment: The noise in the work environment is usually moderate. Other factors are:
-
Ability to travel
-
Hectic, fast-paced with multi-level distractions
-
Professional, yet casual work environment
-
Office environment
-
Ability to work extended hours as required
#LI-JC1
Employees (and their families) that meet eligibility criteria as outlined in applicable plan documents are eligible to participate in our medical, dental, vision, and basic life insurance programs and may enroll in our company’s 401(k) plan. Employees will also be eligible for Time Off and Paid Sick Leave pursuant to the company’s policies. Employees will enjoy paid holidays throughout the calendar year. Eligibility requirements for these benefits will be controlled by applicable plan documents.
Hired applicant may be awarded Restrict Stock Units and receive annual bonuses pursuant to eligibility and performance criteria defined in the respective plan documents and policies.
For more information on iHerb benefits, visit us at iHerbBenefits.com.
Anticipated Pay Scale:
$139,020—$215,903 USD
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 [email protected]. 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.
Top Skills
Similar Jobs
What you need to know about the Charlotte Tech Scene
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
