SUMMARY

• 10+ years SQL Server DBA/Developer experiences including SSIS and SSRS.
• 5 years C# Developer using SQL Server as backend.
• 7 years SQL Server Support Engineer with Microsoft, specialized in resolving critical production issues such as server down, performance, database troubleshooting, corruption and recovery.
• Certified with MCITP SQL Server 2005 Developer and Database Administrator, MCSE, MCDBA.
• A performance tuning expert specialized with troubleshooting and problem solving.

TECHNICAL SKILLS

Platforms: HP HP - UX 10.10, 10.20, Sun Solaris 2.5.1, IBM AIX 4.1.4, 4.2.0, Windows NT.

Software Language: C.

PROFESSIONAL EXPERIENCE

Data Engineer

Confidential, San Diego, California.

Responsibilities:

• Completed unit test and bug fix of a redesigned ETL project with 5 SSIS package to meet teh new standard requirements.
• Created a new Power BI reports dashboard with 13 pages according to teh design spec in two weeks beating teh tight timeline. Deployed an automation to production for update teh company holiday schedule based on company’s holiday policy which need to be updated yearly.
• Helped QA Profisee forms and update teh ones which are not working properly.
• Designed and completed a new 3 pages ETL job dashboard with Power BI.

Software Engineer

Confidential

Responsibilities:

• Prepare aggregated data source from Cosmos data stream ETL to Azure database via Avocado an Microsoft internal tool can connect to both Cosmos and Azure database.
• Also halped on prepare test data in sample documents for in document search project to create semantic search test data.

Software Engineer

Confidential

Responsibilities:

• Marketplace & Serving Dev Confidential to work on Power BI reports using Cosmos bigdata data source.
• Created Scope jobs to produce teh report data set in Cosmos, then transfer teh data set over to Azure SQL Server for Power BI data source.
• Helped completing a Real Time Billing Analytics report’s yearly page.

Sr. ETL Engineer

Confidential

Responsibilities:

• Searched for required data source on Kusto, completed teh Encryption Report by Datacenter design spec and teh first draft of teh report using Power BI desktop and Kusto explorer.
• Helped upgrade a work station to Windows Server 2016 Datacenter edition to allow more remote desktop connections as needed.

Sr. DBA

Confidential

Responsibilities:

• Troubleshooting SQL Server crash with exceptions, found teh cause and fix teh problem.
• Working with SQL Servers 2008 and 2012, 2014, 2016 database servers for installation, upgrade, and performance turning.
• Has designed and coded teh automation for their backup process to be capable of auto rerun only teh missing full backups. also automated teh integrity check process to be able restart only teh databases not completed.
• Working with Relativity databases and identify missing indexes and resolve critical production performance issues.
• Recently completed an automation using a single stored procedure to refresh development database and made teh process to be much more reliable and faster.
• Has used Azure instance for deploy new report stored procedure to it.

Contractor

Confidential

Responsibilities:

• Resolve production issues on SQL Servers 2008 and 2012 database servers.
• Help troubleshoot performance issue for long running jobs.
• Has automated a process to boost replication latency by automatically turn on teh SubscriptionStreams setting to use multithreading on teh distribution job when latency gets high, and turn it off when been blocked.
• Also, automated a re - index process to rebuild and defragment teh indexes with multithreading processes.
• Diagnostic deadlock issue with Extended Events.
• Manage database mirroring.
• Deploy hotfix and data fix release and halp resolve encountered issues.
• Has automated teh database refresh process from production to development server with a single stored procedure call.
• Troubleshoot and fix performance problems for production servers by capture teh main high CPU processes with teh query used, figured out teh index it was missing to resolve teh issue.
• Manage data space usage.
• Install SQL Server 2012 clustered servers.
• Automated a re-index process to de-fragment indexes.
• Troubleshoot and fix customized SSIS packages after it failed or needs to upgrade to teh higher version.
• Created SSRS reports for database space usage with monthly and weekly rate plus a database inventory reports.
• Help recoding teh failed job for customer’s archiving process. Recode a C# program to produce teh missed database backup report which connecting to each serve in teh company domain to list out teh database didn’t has current backup.
• It was a new program created by a previous DBA just left company.
• Teh program didn’t handle exceptions and didn’t report teh correct information.
• Now it sends out teh missed backup report with an error report if their is any error occurred such as connection timeout or login failure and handles all exceptions.

Contractor

Confidential

Responsibilities:

• Has worked with developer Confidential to provide advice for resolving SQL Server Service Broker queue backing up issue.
• Also worked in Xbox Live Tools Confidential and created new TFS reports using TFS data warehouse database, TFS OLAP Cubes and MDX queries.

Confidential

Responsibilities:

• Code Coverage process which produces teh report from daily build; Unit and Component test automation for each build and teh shrink database process which provides a small footprint copy of teh production environment with over 170 databases.
• Originally developed a high-level parallel SSIS packages all driven by stored procedures, then upgraded teh system by redesigned teh process with a multi-level parallel processing C# project using SMO objects and XML configuration files.
• Teh new process improved runtime 7 times faster in a multi TB multi partition environment.
• Created a new plug-in component for a Check-in wizard process to automate teh gated check-in for packing teh change list into a SD Pack and submit a buddy build job.
• Revised a Windows form project DSV editor for XML editing in UI and fixed all teh bugs and performance issues.
• Perform architect and code review for database related projects.
• Troubleshoot build performance and discovered teh multi-threading option was not enable.
• After enabled teh option it cut more tha half off teh build time.
• Troubleshoot working directory issue in VS 2010 test manager, filed a bug and working with product Confidential got teh bug fixed, obtained a hotfix for it.

SQL Server senior

Confidential

Responsibilities:

• Completed teh planning and architecture evaluation and review of teh data center upgrade.
• Has developed a fully automated two way failover log shipping with one stored procedure call for setup or failover for one or all databases on teh server.
• Designed and implemented transactional replication with filters to fulfill teh requirement to send only teh customer’s own data.
• Created a complex DTS package to download data from 26 tables in parallel and package teh data in a zipped file for customer to continue download their own current data.
• Troubleshoot deadlock issues with newly developed software and resolve teh issue by reorganized teh clustered index, rewrote teh update statements to combine all 11 updates into one single update.
• Helped developers with complex query design.
• Completed database documentation for teh core production database.
• Coded 13 sets of TSQL statements for alerts using functions and stored procedures with parameters.
• Worked as part of teh DEV Confidential to create reports using SQL Server Reporting Services in Visual Studio for new release version.
• My other daily responsibilities including performance turning, index review, and deadlock troubleshoot.

SQL Server Support Engineer

Confidential

Responsibilities:

• Worked in SQL Server Data Engine support group, halped customer identify issues related to corruption, performance, coding and database design.
• Has expertise on reading perfmon log, profiler trace and blocking script.
• Routinely used these troubleshooting tools and analyzing teh data to identify problems related to application software, hardware or configuration settings.
• For individual query issue, I analysis teh execution plan to identify if their is a performance issue related to optimization process.
• For issues related to AV and assertions, I read user dump and search in teh source code to find teh cause of crashes.
• Has often halped customer to rewrite their stored procedure to improve speed or workaround problems in one case convert teh vertical data view to a horizontal view and get teh data set in a single statement which improved teh performance from 20 minutes down to 700 ms and created a solution object to share dat technique for teh support Confidential .
• On another case, my rewrite used a function to identify teh wild character in teh parameter in order to use teh correct where clause speeded up teh sp and cut teh execution time more tha half.
• With another case, I resolved an out join gets an incorrect result problem with a rewrite of teh statement and views.
• Stayed as one of teh top three for most cases closed in a year cross all three support sites.
• Participated Yukon bug bash and filed 8 bugs and DCR’s.
• Was teh first dedicated support engineer for Microsoft ITG for 3 years.
• Has halped resolving critical production related issues such as log shipping for SAP, performance issues for Siebel system and new platform hang problem for our security Confidential .
• Provided my instant consulting and support services for our dba and system admin.
• With direct system access I often be able identify problem quickly, and provide a solution or a fix without any time delay.
• Has teh privilege as part of teh production Confidential to take part of SAP upgrade planning processes.
• For Shiloh I has filed 64 bugs, 6 DCR’s and filed 8 SQL 2005 bugs and 4 DCR’s.
• Worked closely with other groups such as NT, Messaging, COM+, IPRAS support to identify problems in teh OS, MSDTC, mail system, and network.
• Completed MCSE 2000 and MCDBA 2000 certifications.

Advanced Support Engineer

Confidential

Responsibilities:

• Diagnosis of teh database engine at teh source code level.
• Patching customer production system through dial-in, and use UNIX debugger attach to teh engine process for troubleshooting.
• Understand teh internal of teh product well and passed both teh Certified Professional test in first attempt.
• Started working with web page, using HTML by self-learning.
• Passed Online III exams in first attempt to become a certified dial-up and patching engineer for Informix.
• Greatly improved soft skills for handling customers under difficult circumstances.
• Worked in first level support to identify performance and database design issues, and then moved to teh server down group later.