Jeffery Chen

Jeffery Chen

Technical Support Engineer

Followers of Jeffery Chen147 followers
location of Jeffery Chen台灣 臺北市 臺北市

Connect with Jeffery Chen to Send Message

Connect

Connect with Jeffery Chen to Send Message

Connect
  • Timeline

  • About me

    Senior Software Engineer at Oath

  • Education

    • National Taipei College of Business

      -
      Bachelor’s Degree Management Information Systems, General
    • Soochow University

      -
  • 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
  • Licenses & Certifications

    • Hyper-V Blue level Certification

      Microsoft
      Jan 2012
    • Microsoft Certified Technology Specialist

      Microsoft
      Jan 2006
    • Oracle Certified Professional

      Oracle
      Jan 2004
    • Microsoft Certified Database Administrator

      Microsoft
      Jan 2005
    • Microsoft Certified Professional

      Microsoft
      Jan 2004