•Be able to handle MS SQL Server, MySQL and Oracle database simultaneously for Yahoo EC service.•System event handling & Performance Tuning by using not only technical but cross-team collaboration skills.•Leverage CI/CD to automate database deployment.•Evaluate and implement on-Premises databases migration to AWS Aurora/RDS MySQL and MS SQL Server.

Responsibilities:•Trend Micro global license database (MSSQL) architecture design, troubleshooting and performance tuning.•PLS private cloud (VMWare) sustain tasks and VMs provision.•Design online system monitoring portal (SSRS), let Dev/QA members know the system bottleneck, and prevent potential problems.•Use SSRS & Datazen to visualize global channel market statistics in dashboard, let global PM can get the latest data via mobile device.•Database upgrade (SQL 2008 -> 2012) assessment, and leverage Always-on instead of SQL cluster.

Responsibilities:•Design global IT private cloud analytical system (SSAS + Performance Point), let IT managers can quickly get all VM utilization data.•Design global IT DB auditing data warehouse. (Compliance Manager + SSRS), in order to fit JSOX compliance.•Define IT global database standard and best practice in document, to reduce human error and easy to manage large scale databases.•Research for open source database HA solution (MySQL + CentOS Linux + DRDB), to save cost and keep system design's flexibility and high availability.•Research and define global IT database replication solution (OGG, Sybase, Informatica, MSSQL…), to solve heterogeneous DB replication and cross-geographic performance problems.

Responsibilities:•Maintain SPN_Dashboard portal & ETL (Hadoop -> MSSQL) process.•SPN Smart Feedback Report generation & database (MySQL) maintenance.

•Analyze sales' requirements & specifications to develop matching functional reports and applications for decision making needs.•Develop DW ETL and Day-to-day supervision (Oracle -> MSSQL).•DW database maintenance jobs. ex. architecture design, troubleshooting, performance tuning. •Use BO (Business Object) and Analyzer…BI tools to rapid develop BI reports to customers.

Responsibilities:•DBMaker database global technical (on-site) support, include customers from Taiwan, Japan...•DBMaker database APAC training instructor, include customers in Taiwan, Korea...•Come out DBMaker knowledge base articles.•Support system development using VB, ASP.•Administration of R&D AD, mail, file, FTP, and Web servers.