Jeffery Chen

Experience

• 

  SYSCOM COMPUTER ENGINEERING CO.

  Nov 2000 - Nov 2004

  Technical Support Engineer

  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.

• 

  FarEasTone Telecom

  Jun 2005 - Jun 2010

  Engineer

  •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.

• 

  Trend Micro

  -

  Sr.Engineer
• 

  Trend Micro

  Jun 2010 - Jun 2016

  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. 收回

  • Sr.Engineer (Product License System)

    Oct 2012 - Jun 2016

  • (OLAP) Database Architect (Global IT Technology)

    Jan 2011 - Dec 2012

  • Sr.Engineer (Smart Protection Network)

    Jun 2010 - Jan 2011
• 

  Oath

  Oct 2017 - now

  Senior Software Engineer

  •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.

• 

  Verizon Media

  Oct 2017 - now

  Senior Software Engineer