Database Engineer

SHEIN; San Diego (CA); On-site; USD 86,000 - 138,000; Full time

Benefits offered by this job

Health Savings Account with Employer F

Flexible Spending Accounts (Healthcare

Company-Paid Basic Life/AD&D insurance

Company-Paid Short-Term and Long-Term 

Volunteer Benefit Offerings

Employee Assistance Program

401(k) Savings Plan with company match

Vacation and holidays

Free weekly catered lunch

Dog-friendly office

Free gym access

Complimentary snacks and beverages

Job summary

SHEIN is seeking a Database Engineer for its San Diego corporate office to help build and maintain highly available database infrastructure. You will work on MySQL-based systems, leverage Azure, and contribute to automation and tooling to reduce operational toil.

You will collaborate with a distributed team to design, tune, and scale databases, ensuring security, integrity, and performance for mission-critical workloads across the enterprise.

Qualifications

• BS in CS or Information Systems or equivalent technical discipline.
• Strong MySQL experience with scalable production environments.
• Experience with Azure or other cloud providers.
• Understanding of distributed/replicated database topologies.
• Ability to deploy open-source software on Linux and automate tasks.
• Proficient in multiple scripting languages and problem solving.

Responsibilities

• Maintain scalable, reliable production database environments.
• Monitor, diagnose, and address database issues promptly.
• Performance tuning, query optimization, and indexing improvements.
• Build tools and scripts to automate operations and reduce toil.
• Collaborate with development teams to guide database design.
• Handle upgrades, migrations, and capacity planning.
• Provide data integrity, high availability, and security assessments.
• Offer 24x7 on-call support on pager rotation.

Skills

MySQL

Azure

Distributed DBs

Scripting Go/Python

Linux basics

Problem solving

Communication

Education

Bachelor's degree in CS/Info Systems

Tools

Percona Tools

Orchestrator

Ghost

Clickhouse

MongoDB

StarRocks

Job description

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 160 countries. Founded in 2012, SHEIN has nearly 18,000 employees operating from offices around the world, with U.S. Headquarters located in Los Angeles.

In SHEIN, we work with outstanding, creative, and capable peers. We share an energetic and open culture for capable people to discern, work and ignite as a team.

At SHEIN, our culture is driven by our core values: Customer First, Take Ownership, Deliver Results, Make Change, and Celebrate Diversity. These are not just words, they are the principles that guide our work as we strive to meet the needs of our customers around the world.

Position Summary

We are looking for a Database Engineer 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.
• 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 Azure or any other cloud provider.
• A solid understanding of distributed/replicated database topologies.
• 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.
• Good understanding of Linux system, ability to deploy open-source software independently.
• Proficient in more than one scripting language (golang/python/shell, 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

• Fluency in Mandarin
• Experience managing MySQL / Percona Server 8 at scale.
• Experience managing distributed database, like Clickhouse, Hbase, MongoDB and Starrocks etc.
• Experience with Percona tools, Orchestrator, Ghost etc.

Pay Transparency

The base salary range for this position in the selected city is $86,400- $138,000 annually.

Compensation may vary outside of this range depending on a number of factors, including a candidate’s qualifications, skills, competencies and experience, and location. Base pay is one part of the Total Package that is provided to compensate and recognize employees for their work, and this role is eligible for additional discretionary bonuses.

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