SUMMARY:

• Subject Matter Expert (SME) of SQL Server
• 15 years of extensive experience in SQL 2016 / 2014 / 2008
• 10 years in Lead DBA position. Managed a team of 5 DBAs .
• As a single DBA, grow companies from few hundreds of people to few thousands with offices in multiple countries.
• Cloud experience with both Confidential SQL Azure and Amazon AWS
• 3 years of experience in Oracle 9i, 10g, 11g, Express
• 3 year MySQL 5.0 and 5.6
• 2 years PostgreSQL 9.2/9.3
• 3 years of Red Hat Linux
• 10 years EMC and NetApp SAN
• 4 years in VMware and Hyper - V
• 3 years in F5 network load balance and failover
• 10 years of experience in managing partner relationships with HP, Dell, EMC, NetApp, etc.
• 10 years in support of IIS, TCP/IP, VIP, DNS, DHCP, AD.
• 4 years in support TFS, SharePoint, MS Dynamics AX, Axapta.
• Special skills in cutting edge technologies and many un-documented internal details
• Working experience with Power Shell, T-SQL, C#, Python
• Working experience in Financial, Bank, Media, and IT industries.
• Working experience in online transactions, ETL, Data Warehouse, and BI reports.

EXPERIENCE:

Staff Database Engineer, Bellevue, WA

Confidential

Responsibilities:

• Active-Active Database support
• Used high speed transaction replication technology to support Active-Active database s across multiple data centers
• Used Red Gate to troubleshoot and resolve data inconsistency problems
• Migrated Reporting Server from SQL 2008 to SQL 2014
• Developed Report for SSRS reporting servers
• Implemented SSAS for Power BI
• Used Power Shell to automate the file transfer to avoid file lock on drives
• Resolved transaction blocking issues caused by Auto Statistics
• Used IDERA to troubleshoot and resolve deadlock issues

Sr. Database Administrator

Confidential, WA

Responsibilities:

• Identified and resolved problems in Follow ME application by using Merge Replication
• Used Rolling Cluster method to migrate SQL cluster servers to new hardware without downtime.
• Used low impacting Extended Events to troubleshoot SQL errors without using expensive SQL Profile.
• SQL Query Turning, Index Turning on new state wide applications
• Resolved issues caused by disabled index, missing index, and over index.
• Used PowerShell to collect SQL server info to automate administration tasks
• Support MongoDB for analyzing non-SQL, non-relational data
• Used WMI to catch SQL Dead Lock chains and Blocking chains

Sr. Database Service Engineer, Redmond, WA

Confidential

Responsibilities:

• Designed and Implemented large scale High Availability and Disaster Recovery Solution.
• Combined Failover Cluster, Always ON Cluster, and replication across multiple data centers
• Support and automation with PowerShell
• Used PowerShell to manage Cluster servers, Active Directory and Password changes.
• SQL Azure Replication
• Extended replications from local data center to SQL Azure on cloud. Resolved connection, synchronization, and authentication problems.
• Implemented CDC on SQL Always On
• The out of box SQL Always On Availability Group does not support CDC (Change Data Capture).
• Developed special scripts to make CDC work on SQL Always On. SQL Index Tuning
• Identified index problems. Redesigned index which incrusted performance and reduced database size.
• Designed and deployed multiple SQL Reporting Servers to support heavy usage.
• Provided load balance and high availability.

Sr. Database Administrator, Seattle, WA

Confidential

Responsibilities:

• Implemented SQL Audit to enhance security and track Server activities
• Migrating Databases from local SQL server to SQL Azure on the Cloud. Setup private Cloud and SaaS.
• Developed SSIS deployment standard for new ETLs to use SSISDB. Migrated old SSIS projects to new SSIS server
• Evaluated new features of SQL 2016. Made recommendations to simplify current production High Availability and Disaster Recovery strategy. Architecture Reporting, and Data Warehouse system to reduce the time delay.
• Implemented Transparent Data Encryption (TDE) in production databases.
• Used Master Key and Certificate to protect sensitive sales info and customer personal info.
• Encrypt important columns such as SSN, Salary, etc. Make those data keep encrypted through the network transaction.

Database Service Engineer, Redmond, WA

Confidential

Responsibilities:

• Migrating SQL Servers from physical server to SQL Azure on the Cloud and virtual server on the Cloud with Hyper-V
• Moved 150+ SQL Servers with largest databases up to 10 TB to different data centers without down time. to ensure all the applications are failover smoothly.
• Used Reverse Log Shipping to sync databases after failover. Cut the log shipping setup time from few days to few minutes.
• Support Confidential BI applications for Risk Analysis, Fraud Detection, and Reporting
• Used SQL Profiler and DMV-Dynamic Management View, identified long running queries. Resolved problems caused by wrong composite index. Suggested fixes by put index on the correct columns
• Identified ETL problems caused by UNION multiple large tables then try to insert at once. Suggested a cord change which fixed the problem.

Sr. Database Administrator, Bellevue, WA

Confidential

Responsibilities:

• Installed and Configured SQL 2014 for Production deployment.
• Used Always On as failover in High Availability applications.
• Integrated local SQL to Azure on the cloud.
• Configured BI site to use both Multidimensional and Tabular model.
• Provide connections for applications and manage user logins
• Database Backup and Restore. High Avalibility and Disaster Recovery
• Performance tuning and trobleshooting database issues.
• Transfer data in and out from Postgre SQL databases.
• Database Backup and Restore. High Avalibility and Disaster Recovery
• Performance tuning and trobleshooting database issues.
• Upgraded SharePoint from 2007 to 2013.
• Implemented Power BI on SharePoint.
• Configured SQL database for SharePoint large file support -- FILESTREAM
• Created a new Data Center for private Cloud Service, which provides rapid deployment methods for Dev, Test, and Prod environments.
• Data Center and failover site evaluation and selection, which including power, cooling, and risk assessments.
• Suport Database applications on Amazon AWS
• Used VMware to create virtual servers. Installed Windows 2012 and SQL Server 2012 on virtual server.
• Significantly reduced cost of hardware, data center space, network connections, power, cooling, and administration.
• Used Windows script, SQL DMO, VBScript, WMI, and ADSI (Active Directory Service Interface) to automate administration tasks such as security audit, refresh data to different environments, script database objects and save those to Source Save, and deploy changes to different environments.
• Created Alerts to send page and email when SQL server and user error raised
• Used dedicated connections to access database engine internally and Recovered production database corruptions which caused by SQL Server upgrade
• Created SSIS packages to extract data from SQL server, Excel, and MS Access database and load into SQL server. Used special data access method to provide reliable connections.
• Used NetApp SAN to host large databases 5 TB and provide fast backup, restore, and data transfer.

Database Engineer, Redmond, WA

Confidential

Responsibilities:

• Installed and configured MS SharePoint Server 2007.
• Integrated SharePoint with MS Report Servers (SSRS) for web based reporting site.
• Used Windows Cluster Service and Database Mirroring to provide Business Continuity, High Availability, and Failover for Data Warehouse server and ETL servers
• Used EMC Symmetrix DMX-4 to provide solution for very large databases in TB. Implemented high speed backup, restore, and re-sync for very large reporting databases.
• Implemented role based security for SQL Analysis Services . Granting permissions to different user groups to process and browse Cubes.
• Used SQL Server Services Broker to process report requests from world wide users and avoid system over load during fiscal month end and fiscal year end.
• Used Database partition to reduce I/O contingency during ETL process
• Analyzed the data process for Sales, Marketing, Finance, Budget, Forecast, and Compensation. Provided incremental process solution to reduce the reporting cycle.
• Upgraded OS from Windows 2003 to Windows 2008
• Upgraded Server from SQL 2005 to SQL 2008

Database Engineer, Seattle, WA

Confidential

Responsibilities:

• Designed and implemented database migration plan to move production SQL servers from in-house data center to off-site hosting data center.
• Used log shipping and replication to achieve minimum production down time during the move.
• Support Oracle 9 database on Red Hat Linux Enterprise 4.
• Used Oracle Enterprise Manager to centralize the Oracle administration task.
• Used Oracle RMAN backup with recovery catalog to protect the database.
• Manager Oracle users, permissions, create schemas, tables, views, synonyms, and indexes using PL/SQL
• Upgraded production SQL servers from SQL 2000 to SQL 2005.
• Combined Database Snapshot and Database Mirroring to provide database auto failover and reporting function in one configuration. Resolved conflicts between online transaction and up-to-minute reporting system.
• Used SQL server 2005 Integration Services (SSIS) for ETL, used Analysis Services (SSAS) to build Dimensions and Cubes for data warehouse.
• Used Reporting services (SSRS) to create online report, and used Notification Services (SSNS) to send ads and promotions to customers

Database Engineer, Redmond, WA

Confidential

Responsibilities:

• Designed and implemented database migration plan to move Confidential critical applications from non-MS datacenter to MS data center. Synced large databases using Merge Replications and Log Shipping. Provided smooth failover without service interruption.
• Integrated and converted applications with Apache web services and customer database to standard MS SQL database application.
• Conducted Database and Index re-architecture for Confidential Windows Life applications.
• Stabilized the system operations, increased the system availability, and scaled the system out to cover major cell phone provides in US and in the world.
• Used GeoCluster to provide database failover without shared drive.
• Identified and resolved many different deadlocks, blockings, memory leaks, network connection problems in many MS online and mobile applications.
• Tested SQL server and database migration from SQL 2000 to SQL 2005.

Sr. Database Administrator, Seattle, WA

Confidential

Responsibilities:

• Standardized database backup, restore, and maintenance plan
• Used EMC SnapView, Mirror View, and SAN Copy for SQL server and databases
• Configured log shipping to create standby SQL server for hot backup and provide reliable online services
• Installed MS Cluster Services to configure active/active and active/passive fail over clusters
• Used IPMon to monitor and track the SQL server and database activities
• Used BigIP for load balance and server rotations
• Upgraded SQL server and database from local drive to EMC ClARiiON CX600 SAN.
• Provided technical advise to production, staging, test, and develop environments.
• Tuned indexes, stored produces, triggers, queries, and views to improve the performance of large image database and search servers
• Application implementation for MS BizTalk Server 2004/2000 and MS Axapta
• Designed database and server consolidation plan using use technologies from SQL2005, such as witness server, database mirroring, database snapshot.
• 24 x 7 support for production media and image business.
• Support workflow, ordering, finical, HR, data warehouse, and report applications
• Support nasty replications, link servers, and cross server queries.