Database Administrator and BI analyst

• Oct 2018 - Present

Database Administrator

• May 2017 - Oct 2018

• 9Spokes MySQL Galera Cluster and MongoDB Replica set system infrastructure and database management, Galera Cluster capacity planning, backup recovery, performance and SQL query tuning, reporting system design and optimization. Database automation scripts using salt, adopting flyway for database CI/CD implementation, DR planning and switchover. • Resolving Galera cluster out-of-sync issue, developing MySQL, MongoDB database auto deployment and upgrading and migration scripts. Write SQL scripts to ETL data for BI system and reporting. Integrating NoSQL and MySQL system for BI and business growth forecasting. • Developing SQL procedures for ETL and metrics reports, Optimized MySQL, MongoDB, data and Log files collection procedures and generated PowerBI reports on a regular basis, leading to growth in customer acquisition. Show less

Database Administrator

• Sep 2016 - Apr 2017

Responsible for Transactor Technologies oracle database and system management . DB server provisioning (KVM) and system monitoring using Zabbix (Linux and windows agents) . Oracle DB capacity planning , performance tuning, data clearance , and DR planning and implementation by using dataguard. .AWS RDS, Tomcat WebServer/Nginx management and troubleshooting. Responsible for Transactor Technologies oracle database and system management . DB server provisioning (KVM) and system monitoring using Zabbix (Linux and windows agents) . Oracle DB capacity planning , performance tuning, data clearance , and DR planning and implementation by using dataguard. .AWS RDS, Tomcat WebServer/Nginx management and troubleshooting.

Technical Manager

• May 2010 - Jul 2016

• May 2010 – Present: China Telecom Corporation Limited Beijing Research Institute, Beijing, China o Maintaining all IT hardware and software for clients including UNIX/LINUX servers, FC switches and storage, good understanding of HP superdome and IBM Pseries server hardware. o Performing database (Oracle, MySQL) design and maintenance of China Telecom National Billing HSS System, Provincial Billing System. Keep the 4 nodes Oracle 11g RAC database 24*7 running (DB size: 10T), good troubleshooting skills by using AWR and third-party tools; o Configuration and maintenance of Virtual Machines(Linux, Windows) using VMware vSphere; o Providing Hadoop cluster for development team. o Performing remote support of systems including remote monitoring of servers, services and networking ensuring high uptime meeting corporate SLAs. o Project work management and maintenance for all clients. Show less

chief system engineer

• Jun 2004 - Apr 2010

Plan and implementation China Customs Core Oracle Database Upgrade (TB Level) and Migration( OS: from AIX to HPUX; Oracle: From 9i to 10g) in 2007; Design and implementation China Customs Remote Disaster Recover (application level) System in 2006; H2000 Oracle Database Performance Tuning; China Customs Data Centre Design and Implementation; All these project win China Customs Science and Technology Award. Position Description Responsible for China Customs Import/Export H2000 management system(OLTP) , Import/Export Decision Support System (OLAP) UNIX system and Oracle database management; Keep 24*7 mission critical databases up and running; manage disaster solution for the existing systems. optimize system resources, manage storage capacity plans, backup/restore strategy for production databases, Oracle database training and skill transfer. Oracle Certified Database Administrator for 9i/ 10g (OCP DBA 9i/10g). Brocade Certified Fabric Professional, BCFP Show less

Senior software/system Engineer

• Jul 2001 - Mar 2004

In 2001 - 2004 design and development in China Customs H2000 management system (OLTP Application), training and Coordinate Local Customs engineer (Beijing Customs/Shanghai Customs. , 43 other sites) for deployment of H2000 across China, troubleshooting and performance tuning of H2000 middle-ware and Oracle database.; Responsible for design, development of H2000 project middle tier subsystem using Microsoft COM+ , .NET techniques; Windows server ,VMware management, MOM/SCOM development and management Responsible for Deployment, design monitoring policy of Microsoft Biztalk Server, SQLServer, other products using Microsoft operation manager Responsible for Software Stress Testing using MI Load Runner Show less