Mike Qi

Mike Qi

Oracle DBA

Followers of Mike Qi113 followers
location of Mike QiPudong, Shanghai, China

Connect with Mike Qi to Send Message

Connect

Connect with Mike Qi to Send Message

Connect
  • Timeline

  • About me

    Oracle DBA

  • Education

    • Nanjing University of Finance and Economics

      -
      Bachelor's degree in Management E-Commerce/Electronic Commerce
  • Experience

    • HZS Architecture Design

      Mar 2010 - Jun 2015
      Oracle DBA

      1.Monitor oracle database and application performance and perform tuning.Be familiar with oracle rac,dataguard,rman and linux. 2.Maintain the server(AD,Database,File,Printer) 3.Maintain the network equipments,security system,telphone equipment.

    • Microsoft

      Mar 2015 - Mar 2016
      Microsoft APAC support engineer

      Provide Microsoft product support for APAC customers: DNS\​DHCP\​File Share\​NPS\​VPN\​TMG.

    • 友邦保险

      Mar 2016 - Sept 2016
      高级 oracle 数据库管理员

      1.Database 运行状态,日志文件、数据文件状态,Rman和Legato备份情况、系统 资源进行检查,并通过SCOM进行阈值警告邮件或短信通知发送提醒来实现对数据库状态的及时跟踪。2.表空间扩展,数据增长情况进行统计,通过EM和SQL语句对数据库进行健康检查。3. 每月对表和索引待进行Analyze,获取表空间碎片和索引碎片、缺失信息,进行数据库性能调整规划、实施。4.对database异常CPU、、memory、IO资源消耗进行诊断,追踪Block、Top sql信息,采取Kill session等措施,并定位到语句和表,提出优化方案。5.协助App 工程师进行SQL语句分析、调优,存储过程、触发器开发。6.依据AIA(友邦保险) Database管理策略,对新安装的数据库进行Hardening操作,使数据库设置符合策略要求。

  • Licenses & Certifications

    • Redhat RHCE

      Redhat
    • Postgres PCP

      POSTGRES FOUNDATION LIMITED
      Sept 2019
    • Oracle OCP

      Oracle