Associate Database Engineer

About the job
Job Title: Associate Database Engineer II
Reports to: Director, Database Reliability Engineering
Job Location: San Diego, CA
Job Status: Exempt, FT
About SHEIN
SHEIN is a global fashion and lifestyle e-retailer committed to making the beauty of fashion accessible to all. We use on-demand manufacturing technology to connect suppliers to our agile supply chain, reducing inventory waste and enabling us to deliver a variety of affordable products to customers around the world. From our global offices, we reach customers in more than 150 countries.
Position Summary
We are looking for a Associate Database Engineer II with experience working in large-scale mission-critical environments with zero downtime. 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.
Sure, everyone has their favorites, but understanding database fundamentals and how the properties of different database systems interact with applications and operating systems is a key to our success. You will be working from onsite on a distributed team, with access to multiple customer environments, potentially with people and computers around the world, we are looking for U.S. based applicant at this time.
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
$101,400.00 min. - $166,800.00 max annually, Bonus & RSU offered.
SHEIN Benefits and Culture

• 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 Technology LLC is an equal opportunity employer committed to a diverse workplace environment.