Sr. Database Reliability Engineer II
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
The anticipated pay scale for this position can be found below, however the pay range applicable to you may vary by geographic location based on where the job is located or where you work. The final pay offered to a successful candidate will be dependent on several factors that may include but are not limited to the type and years of experience within the job, the type of years and experience within the industry, education, etc. iHerb, LLC is a multi-state employer and this pay scale may not reflect positions that work in other states or locations. 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
About the job
Apply for this position
Sr. Database Reliability Engineer II
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
The anticipated pay scale for this position can be found below, however the pay range applicable to you may vary by geographic location based on where the job is located or where you work. The final pay offered to a successful candidate will be dependent on several factors that may include but are not limited to the type and years of experience within the job, the type of years and experience within the industry, education, etc. iHerb, LLC is a multi-state employer and this pay scale may not reflect positions that work in other states or locations. 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