Senior Database Reliability Engineer II

Summary

Join iHerb as a Sr. Database Reliability Engineer II and be responsible for the installation, configuration, upgrade, administration, monitoring, and maintenance of data systems. You will develop and design database strategies, monitor system performance, and plan for future expansion. This role involves leading root cause analysis for performance issues, researching and implementing new technologies, and mentoring team members. You will also plan and implement database security measures. The position requires significant experience with Microsoft SQL Server and other database technologies. A Bachelor's degree in Computer Science or a related field is required.

Requirements

• 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
• Minimum of eight (8) to fifteen (15) years of experience with the Microsoft SQL Server
• Bachelor’s Degree in Computer Science or related field

Responsibilities

• Install and upgrade the database server and application tools
• Allocate system storage and plan future storage requirements for the database system
• Develop database queries for applications and programs as needed
• Diagnose database problems and come up with resolutions
• Ensure compliance with database vendor license agreement
• Monitor and optimize the performance of the database
• Plan for backup and recovery of database information
• Contact vendors for technical support
• Serve as the subject matter expert on DRE issues, improvements and implementations
• Mentor and coach new and/or less experienced DRE’s on the team
• Participate in on-call rotation and incident escalations as necessary

Preferred Qualifications

• Master’s Degree
• Experience in working with NOSQL databases

Benefits

• Medical, dental, vision, and basic life insurance programs
• 401(k) plan
• Time Off
• Paid Sick Leave
• Paid holidays
• Restricted Stock Units
• Annual bonuses