Database Engineer

Database EngineerSan DiegoSHEIN 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, SHEIN remains committed to making the beauty of fashion accessible to all, promoting its industry-leading, on demand production methodology, for a smarter, future-ready industry. Founded in 2012, SHEIN has more than 16,000 employees operating from offices around the world, and continues to expand operations globally. Join SHEIN and be the future!Position SummaryWe 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 ResponsibilitiesMaintaining 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 RequirementsBachelor'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 HaveFluency in MandarinExperience 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.Benefits and PerksBonus eligibleHealthcare (medical, dental, vision, prescription drugs)Health Savings Account with Employer FundingFlexible Spending Accounts (Healthcare and Dependent care)Company-Paid Basic Life/AD&D insuranceCompany-Paid Short-Term and Long-Term DisabilityVoluntary Benefit Offerings (Voluntary Life/AD&D, Hospital Indemnity, Critical Illness, and Accident)Employee Assistance ProgramBusiness Travel Accident Insurance401(k) Savings Plan with discretionary company match and access to a financial advisorVacation, paid holidays, floating holiday and sick daysEmployee discountsFree weekly catered lunchDog-friendly office (available at select locations)Free gym access (available at select locations)Free swag giveawaysAnnual Holiday PartyInvitations to pop-ups and other company eventsComplimentary daily office snacks and beveragesPay Range $86,400 - $138,000 USD