LEAN XU
Summary
Systematic Database Developer with 15+ years of experience in designing, engineering architecture and data modeling. Proven track record managing all phases of software development lifecycle (SDLC). Analytical thinker quickly and effectively identifies and resolves technical problems.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Principle Database Engineer
O'Neil Digital Solution
09.2022 - Current
- Centralized management of multiple database instances through consolidation projects, resulting in reduced operational complexity, 500+ MSSQL instances, 100+ PostgreSQL instances, 10+ RedShift, 20+ MySQL, 5+ Oracle,
- Designed and implemented effective database solutions and models to store and retrieve data.
- Collaborated with cross-functional teams to develop scalable, high-performance database solutions.
- Planned and installed upgrades of database management system software to enhance database performance.
- Streamlined backup processes for faster recovery times in case of system failures.
- Provided expert guidance on database design best practices, resulting in more scalable and maintainable systems.
- Installed and configured middleware in Linux and Windows environments.
Senior Database Administrator
HengTian Services LLC
06.2014 - 09.2022
- Created and updated database designs and data models.
- Set up and controlled user access levels across databases to protect important data.
- Developed scripts and processes for data integration and maintenance.
- Modified databases to meet needs and goals determined during planning process.
- Maintained complex SQL queries, views and stored procedures in multi-database environment with little supervision.
- Documented analysis results and provided performance improvement feedback.
- Reduced downtime by proactively monitoring server health, identifying potential issues, and executing preventative measures.
- Trained junior staff members on SQL Server administration tasks, fostering continued professional development within the team.
- Participated in troubleshooting efforts for complex database-related issues as part of a collaborative problem-solving approach among colleagues.
- Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
Senior Database Administrator
STRONG(ShiQiang) Education & Technology Corp
06.2013 - 06.2014
- Assisted in migrating databases to newer versions or alternate platforms, minimizing disruption to business operations.
- Conducted regular performance audits, identifying areas for improvement and adjusting configurations as needed.
- Troubleshot database issues to create and resolve trouble tickets.
- Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.
- Promoted a culture of continuous improvement within the department by implementing best practices in change management, including code reviews and post-mortem analyses to identify areas for future growth.
Database Administrator
Real Life Network Technology Ltd, Zhejiang
09.2009 - 06.2013
- Streamlined backup and recovery processes, enhancing overall system stability and availability.
- Ensured database security with implementation of role-based access control and regular vulnerability assessments.
- Reduced data retrieval times for business users by creating indexed views and optimizing stored procedures.
- Built databases and table structures for web applications.
- Enhanced reporting capabilities by designing efficient ETL processes that improved data accuracy and completeness.
- Set up and controlled user profiles and access levels for each database segment to protect important data.
- Created and updated database designs and data models.
Java Developer
BaoXun E-commerce, Hangzhou
03.2007 - 08.2008
- Collaborated in team-based, Agile environment to accomplish objectives by deadlines.
- Ensured seamless integration of Java-based applications with databases, APIs, and other systems.
- Reduced software bugs by conducting thorough unit testing and collaborating with QA teams.
- Reviewed code and debugged errors to improve performance.
- Developed robust Java code for Insurance Broker applications.
Education
Bachelor of Arts -
University of The West
Rosemead, CAMaster of Science - Computer Science
California State University - Channel Islands
Camarillo, CASkills
Databases(MSSQL, PostgreSQL, Oracle, MySQL)
Programming(Bash, Go, SQL)
Query Optimization
Backup and recovery
Replication Techniques
Performance Tuning
Linux Operating System
Cloud Database Services
Certification
- CKA (Certified Kubernetes Administrator)
- CKS (Certified Kubernetes Administrator Security Specialist)
- OCM (Oracle Certified Master 11G)
- OCP (Oracle Certified Professional 11G)
Languages
Chinese (Mandarin)
Native or Bilingual
Timeline
Principle Database Engineer
O'Neil Digital Solution
09.2022 - Current
Senior Database Administrator
HengTian Services LLC
06.2014 - 09.2022
Senior Database Administrator
STRONG(ShiQiang) Education & Technology Corp
06.2013 - 06.2014
Database Administrator
Real Life Network Technology Ltd, Zhejiang
09.2009 - 06.2013
Java Developer
BaoXun E-commerce, Hangzhou
03.2007 - 08.2008
Bachelor of Arts -
University of The West
Master of Science - Computer Science
California State University - Channel Islands
- CKA (Certified Kubernetes Administrator)
- CKS (Certified Kubernetes Administrator Security Specialist)
- OCM (Oracle Certified Master 11G)
- OCP (Oracle Certified Professional 11G)
Similar Profiles
Leonel HernandezLeonel Hernandez
Network Operations Center Engineer at O'Neil Digital SolutionsNetwork Operations Center Engineer at O'Neil Digital Solutions
Colin GrigsbyColin Grigsby
Software Engineer III at O'Neil Digital SolutionsSoftware Engineer III at O'Neil Digital Solutions
ABDULLAH ABU OLWANABDULLAH ABU OLWAN
SR. Specialist Business Operations Support at Al Fanar Digital SolutionSR. Specialist Business Operations Support at Al Fanar Digital Solution