• Leading the data warehouse architect to design database and data warehouse for the company’s major reporting engine initiative; designing database layer, ETL process and strategy, reporting GUI and software development.• Lead database architect in OLTP database complete re-architecture initiative• Solved many production crisis introduced by legacy design issue and followed up by architectural redesign.• Introduced tier and distributed database design to the enterprise.• Designed and implemented many software and database changes that led to dramatic improvements in performance, manageability, traceability, and scalability.• Instantly brought positive customer reactions on the enterprise scale and drastically increased customer retention rate by performance tuning database/web application: In 1 month, reduced 75% of the total timeouts that for years have been viewed by the existing team as impossible to tune. In another 2 months, close to completely eliminated all timeouts (over 99%). • For the first time, the company finally gained transparency and history info on all application processes by my process tracing and performance benchmark utilities that gather critical statistics and performance indicators with little or no impact on system resource consumption. • Effectively analyzed the enterprise platform, performance tuned server and database configurations.• Created sql server 2005/2008 performance dashboard.• Successfully design and executed production SQL Server 2005 and 2008 upgrade projects• Performed all DBA duties described in my previous job experiences below.

• Successfully lead DBA team of 4, performance tuned production database and Business Intelligence system in support of the Corporate headquarter and Franchisee network.• Played leading role in architectural design and implementation of 3 major sql 2005 database and applications that realized multi-million dollar revenue gains for the company.• Lead the team fixed, redesigned, and performance-tuned data warehouses and cubes. Managed to create and deliver 2 major Reporting Services solution to the corporate.• Design and created Service Catalog database and reporting platform for all systems and technology services.• Consistently helped the company designed and implemented successful business technology projects in business requirements gathering, use case creation, functional design, database design, application and database security model, scalability design, configuration management, data integrity and performance testing, change management, and production release process.• Starting on the first day of the job and within 3 months, effectively cleaned up major legacy sql server issues and brought production system back to a stable and secure state. Some of the issues were long failing jobs, data integrity issue, web-application performance issue, and ineffective alerts, etc• Quickly became the innovative and cohesive force among all teams in the technology department in achieving process improvements, efficiency gain, and quality control.• Immediately implemented production change management process in the database area

• Prevented the company from losing the major customer by discovering and resolving a major and chronological production performance issue in two days, which for nearly a year, the entire development team and production support team have struggled to troubleshoot and attempted fixes without success. I have further proven my leading and organization skill by leading and organizing dev, QA, network, system, hardware, customer, and production support teams towards final resolution through a two weeks cycle.• Successfully lead the DBA team pursuing technology innovation and process efficiency improvement and redesign. Continuously improved company’s production infrastructure, provided innovation ideas• and insights, and kept up the company with the newest technology including third party tools and sql server 2005.• Built numerous utilities for better database management process, discovered and resolved numerous existing production problems, and recorded findings with documentations.• Played one of the leading roles in disaster recovery 2nd site sql server build, process design, third-party DR technology evaluation, and documentation• Composed and set up numerous standards including security, database maintenance, server build, linked server, and naming conventions, etc.• Rebuild/rotates hardware resources for all server environments• Flawlessly executed all the DBA tasks as mentioned in my previous work sections below.

• Prevented the company from losing the major customer by discovering and resolving a major and chronological production performance issue in two days, which for nearly a year, the entire development team and production support team have struggled to troubleshoot and attempted fixes without success. I have further proven my leading and organization skill by leading and organizing dev, QA, network, system, hardware, customer, and production support teams towards final resolution through a two weeks cycle.• Successfully lead the DBA team pursuing technology innovation and process efficiency improvement and redesign. Continuously improved company’s production infrastructure, provided innovation ideas • and insights, and kept up the company with the newest technology including third party tools and sql server 2005.• Built numerous utilities for better database management process, discovered and resolved numerous existing production problems, and recorded findings with documentations.• Played one of the leading roles in disaster recovery 2nd site sql server build, process design, third-party DR technology evaluation, and documentation• Composed and set up numerous standards including security, database maintenance, server build, linked server, and naming conventions, etc.• Rebuild/rotates hardware resources for all server environments• Flawlessly executed all the DBA tasks as mentioned in my previous work sections below.

• Designed numerous consumer-based OLTP, Reporting databases and Data Warehouses; dramatically improved application performances• Successfully lead sql server DBA team managed over 35 Enterprise Sql servers, including OLTP, batch, data warehouse, web application, and OLAP/Analysis Service servers, and hundreds of databases that totals to over 6 terabyte of data. Numerous VLDB are ranging from 60 gigs to 300 gigs.• Optimized the servers performance by cpu, memory, and disk utilization (performance monitor, profiler, process monitor etc), database lock control, query optimization tuning, replication, log-shipping, master server jobs, database architecture and redesign including file and file group management, index tuning and server system configuration• Developed numerous software application tools to better managed the servers, including database log file growth management, database archiving, duplicate records auto-deduping, user access control, disk space consumption report, database list and file growth reporting, etc.• Secured the servers by effective ‘Change Management’ (e.g., code review process for production application install, documentation, etc), server disaster recovery design, database backup and restore, database integrity check, and controlling and managing servers security access and setup• Successfully build numerous Sql servers, including licensing, configure OS, OS system configuration and tuning, install Sql application, Sql application configuration and tuning.• Effectively setup alerts on Sql database level and server level, for server performance counters, disk space growth, database file and log growth, database lock, and job failures etc.• Developed thorough documentations for databases, servers, applications, Sql jobs, etc, along with Sql tips and tricks, better practice of database architecture design, server performance counter monitor, etc.•

• Solely and successfully designed, built, and administrated relational databases for economical investigation of a $100 million damage international litigation case.• Skillfully designed and built data warehouses, creating OLAP applications, and generating statistical analysis graphs and reports• Contributed greatly to the company’s litigation damage collection by performing complex data analysis and manipulation using automated scripts, stored procedures, indexes, cursors, and user defined functions for large databases over 80 gigs in size.• Dramatically boosted the company’s business analytical/business intelligence practice in clinical and pharmaceutical industry on applying probability, statistical modeling and algorithmic solutions to problems requiring quantitative analysis.• Successfully managed and analyzed data for numerous clinical cases.• Prevented the company from major project flaws by employing extreme attention to detail, thorough documentation, organizational ability, broad business knowledge, and insight to fulfill the client’s needs.• Seamlessly upgraded SQL Server 7.0 to SQL Server 2000.• Ensured optimal database performance by effectively performing database normalization, upgrades, replication, backup and restore, partitioning, capacity planning, index, transaction log and performance tuning.• Secured the database environment by designing and setting up a multi-user database system with assigned user security roles, triggers, views, rules, and constraints for database security. • Effectively trained and provided supervision and direction to project assistants and interns.