Job Title: Associate Database Engineer
Reports to: Director, Database Reliability Engineering
Job Location: San Diego, CA, USA
Job Status: Exempt
About SHEIN
SHEIN is a global online fashion and lifestyle retailer, offering SHEIN branded apparel and products from a global network of vendors, all at affordable prices. Headquartered in Singapore, with more than 15,000 employees operating from offices around the world, SHEIN is committed to making the beauty of fashion accessible to all, promoting its industry-leading, on-demand production methodology, for a smarter, future-ready industry.
Position Summary
We are looking for an Associate Database Engineer (official title is Associate Database Engineer II) with experience working in large-scale mission-critical environments with zero downtime for our San Diego-based corporate office. The SHEIN DBRE team is a mix of DBA/SRE/DBRE oriented folks whose overarching goal is to provide highly available data services at scale. They strive to build an extremely reliable, performant, and secure database infrastructure through the skillful use of automation. This team is responsible for providing new architectures and scalability solutions to ever-growing business and data processing needs.
Our ideal candidate has a strong understanding of database fundamentals and how the properties of different database systems interact with applications and operating systems. You will be working onsite on a distributed team, with access to multiple customer environments.
Job Responsibilities
- Maintaining scalable, reliable, and robust production database environments (MySQL in Clouds like AWS, Azure, GCP).
- Monitoring for problems and diagnosing and addressing those problems as needed.
- Performance tuning, query optimization, and index tuning.
- Building database tools and scripts to simplify, automate, to reduce operation toil.
- Responsible for working with development teams and engineers to provide a database design guidance.
- Handle Database upgrades and migrations, while monitoring and improving database performance.
- Triage and solve database issues, drive incidents until resolution and employ measures to prevent recurrence.
- Do capacity planning benchmarking on various databases.
- Provide assessments of data integrity, high availability, data security, and privacy.
- Provide 24x7 escalated on-call support on a pager rotation.
Job Requirements
- Bachelor's degree in Computer Science or Information Systems or equivalent technical discipline.
- MySQL specific database experience.
- Experience using AWS/GCP or any other cloud provider.
- A solid understanding of distributed/replicated database topologies.
- Experience working in AWS (EC2 / EBS / S3 Snapshots / Aurora / RDS).
- Systematic problem-solving approach, combined with a sense of ownership and drive.
- Track record monitoring and analyzing system performance, isolating issues or bottlenecks that could impact reliability, performance and scalability.
- Deep understanding of Linux system, ability to deploy open-source software independently.
- Proficient in more than one scripting language (shell/perl/python, etc.)
- A strong desire to be challenged by problems of scale and complexity to make our service better for our customers.
- The ability to remain calm in the face of extreme crises.
- Good verbal and written communication skills, and be able to work effectively with geographically remote teams.
Nice to have
- Experience managing MySQL / Percona Server 5.7 / 8, Aurora at scale
- Experience with Atlassian tools, such as Confluence and Jira
Pay
$87,000.00 min - $137,900.00 max annually. Bonus & RSU offered.
Benefits and Perks
- Healthcare (medical, dental, vision, prescription drugs)
- Health Savings Account with Employer Funding
- Flexible Spending Accounts (Healthcare and Dependent care)
- Company-Paid Basic Life/AD&D insurance
- Company-Paid Short-Term and Long-Term Disability
- Voluntary Benefit Offerings (Voluntary Life/AD&D, Hospital Indemnity, Critical Illness, and Accident)
- Employee Assistance Program
- Business Travel Accident Insurance
- 401(k) Savings Plan with discretionary company match and access to a financial advisor
- Vacation, paid holidays, floating holiday and sick days
- Employee discounts
- Free weekly catered lunch
- Dog-friendly office (available at select locations)
- Free gym access (available at select locations)
- Free swag giveaways
- Annual Holiday Party
- Invitations to pop-ups and other company events
- Complimentary daily office snacks and beverages
SHEIN Distribution is an equal opportunity employer committed to a diverse workplace environment.