Database Engineer Intern

Summary: SHEIN is a global online fashion and lifestyle retailer, and they are seeking a Database Engineer Intern for their San Diego-based corporate office. The role involves maintaining and optimizing production database environments while providing support and guidance to development teams. 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 Required Qualifications: - This role is applicable only to 2026 graduates (the graduation date must be prior to November 1, 2026) - 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 - Familiar with mainstream AI coding assistants (e.g., Claude Code, ChatGPT, Gemini) and able to leverage them for day-to-day operations tasks such as SQL optimization suggestions, troubleshooting, and documentation generation - Capable of writing effective prompts and iteratively refining them based on model outputs - Aware of AI model limitations and maintains a habit of manually validating results - Has hands-on experience using AI tools to address real MySQL operations scenarios, such as slow query analysis, parameter tuning recommendations, and incident diagnosis assistance - Understands the fundamentals of RAG (Retrieval-Augmented Generation) and is able to structure database operations knowledge into AI-consumable formats, such as knowledge bases, tuning case libraries, and FAQ documents - Has exposure to AI application frameworks such as LangChain or LlamaIndex, or has basic experience with vector databases (e.g., Qdrant, pgvector) - Understands the basics of MCP (Model Context Protocol) integration and is familiar with how AI Agents interact with external tools - Maintains a habit of organizing day-to-day operations experience into structured documents or prompt templates for team-wide sharing and reuse Preferred Qualifications: - 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 Required Skills: MySQL, Azure, Distributed database topologies, Linux system, Golang, Python, Shell scripting, SQL optimization, RAG (Retrieval-Augmented Generation), LangChain, LlamaIndex, Vector databases, MCP (Model Context Protocol) integration, MySQL operations, Database performance tuning, Database upgrades and migrations, Database design guidance, Database monitoring, Incident diagnosis, Capacity planning benchmarking, Data integrity, High availability, Data security, Calmness under crisis, Systematic problem-solving Benefits: 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