I am a Vancouver based independent SQL Server Consultant, one of four Certified Master of SQL Server in Canada. I love SQL Server, helping people to accomplish thier projects, resolving toughest issues actively and proactively, and improving their working efficiency. I frequently speak in Local SQL Server community and SQL Saturday. If you can’t reach me from any links in my blog, you will see me there.

President – UltryDyna Technologies Ltd. (2010 to Now)
We are your the most reliable SQL Server resource. We are focusing on assisting you to build robust scalable SQL Server systems and applications, removing your system/data issues, and finding an efficient way to make your work simple.

  • Database Desing: OLTP, Data Mart, Data warehouse, OLAP Cubes.
  • System Design: Distributed System, High Availability, Disaster Recovery, Replication, and Capacity Planning.
  • Database Administration: Performance Monitoring/Tuning, Automation, and Toubleshooting.
  • Programming: Complex Data Processing, ETL, Data Archiving, and Data Cleansing.
  • Training: SQL Server System, DBA, Programming, and Data Processing.

Supervisor, Database Administration – National Money Mart Company (2005 to 2010)

  • Lead of group of professionals to perform database administration, development, and implementation of data warehouse/BI.
  • Adopted variety of programming languages to build monitoring/automation framework over thousand of SQL Server instances.
  • Distributed database system design and implementation.
  • Performance tuning and capacity planning.
  • Data warehouse design and implementatioin.

Programmer – 3Log System Inc. (2001 to 2005)

  • Database architect – Logical and physical database modeling.
  • Design, development and implementation of core business logics in both SQL server and Oracle.
  • Design and implementation of row level security, replication and DTS.
  • Front-end application programming, software testing and customer support.
  • Development DBA.

System/Software Engineer – Winfo Computer Company, China (1994 to 2001)
This was my first job after the university. I played many roles in this company and built up my own knowledge base.

  • Business analysis, Client/Server application design and development
  • Designed and implemented projects for 8 companies by using Microsoft SQL sever 6 and Oracle 7.
  • System design and training

Certificates

  • Microsoft Certified Master – SQL Server 2008
  • Microsoft Certified IT Professional – Developer and DBA on SQL Server 2005
  • Microsoft Certified Solution Database Administrator
  • Microsoft Certified Solution Developer
  • Microsoft Certified System Engineer + Internet