Database Engineer

About SHEIN   SHEIN is a global online fashion and lifestyle retailer, offering SHEIN branded apparel and products from 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 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. Benefits and Perks   Bonus eligible 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 #LI-ED1 Pay Range $86,400 — $138,000 USD

laptop-ats-crawler v2