Zhiyong Huang (Jason Huang)

Microsoft Certified Senior SQL SERVER DBA/Developer

Address: Arcadia, CA 91006 Mobile: 626-***-**** Email: ad37gx@r.postjobfree.com

Linkedin_URL: www.linkedin.com/in/jason-huang-b86bbb39

SALIENT POINTS:

Over 20 years of professional IT experience with a Bachelor’s Degree in Computer Science from Peking University, Beijing, China. Proficient in all aspects of System Development Life Cycle (SDLC).

Extensive 20-year experience in SQL Server, covering administration, data modeling, designing, developing, maintaining, and tuning database-related applications in both OLTP and OLAP environments.

Expertise in installing and configuring Standalone SQL Server, SQL Server Cluster, SQL Server AlwaysOn, SQL Server Database Mirroring, SQL Server Replication, Log Shipping, etc.

Specialized in SQL Server migration, utilizing AlwaysOn technology for zero downtime upgrades, and installing SQL Server service packs.

Hands-on experience in Database Backup and Restoring (Disaster Recovery) and using PowerShell scripts for automated production database backup verification.

Created Windows PowerShell scripts for managing and monitoring Windows and SQL Server, including Active Directory, user groups, users, scheduled jobs, disk space, database backup restore, and database services.

Proficient in Microsoft Azure Cloud, including Azure SQL Database, SQL Managed Instance, SQL Server VM, setting up backup & restore policies, and managing user permissions.

Experience in setting up Site-to-Site VPN from onPrem to Azure Cloud and configuring Azure Point-to-Site VPN.

Utilized Azure Data Factory for loading data into Azure databases.

Configured Azure App Service and released .NET web applications.

Familiar with Azure SQL Server performance monitoring.

Used AWS to create development and production environments, including IIS, Asp/Asp.net, and SQL Server.

Expertise in Microsoft Linked Server (SQL Server to Server, SQL Server to Oracle Server).

Solid knowledge of SQL Server Very Large Databases (VLDB), including table and index partitioning strategies.

Over 11 years of experience in SQL performance tuning, using T-SQL to optimize queries, employing indexed views, reporting caching, and leveraging tools like SQL Server Profiler and SQL Server Tuning Advisor.

Utilized tools such as SolarWinds DPA, Redgate Monitor, Performance Monitor, and Activity Monitor to check and resolve CPU, memory, network, and disk performance issues.

Implemented OLA for SQL Server Maintenance jobs, including INDEX_REORGANIZE, INDEX_REBUILD, update statistics, and checking missing, duplicate, and unused indexes.

Developed flexible T-SQL programs using Dynamic Management Views (DMV) and Functions to find most expensive queries and troubleshoot performance issues.

Hands-on experience in OLTP and OLAP (Data Warehousing) environments, with a deep understanding of data structures, requirements, characteristics, and typical operations.

Installed and configured SSAS Server, maintaining SSAS Server’s schedule jobs, and having a solid understanding of Microsoft Data Warehousing (SSAS), including concepts, design, star and snowflake schema, partitioning, parallel execution, index, integrity constraint, and ETL.

SQL Server Certified Professional (MCTS) with expertise in implementing, maintaining, and developing Business Intelligence tools like SSIS.

Strong experience in designing and developing T-SQL, including stored procedures, functions, and database triggers, with expertise in data modeling and drawing ER diagrams using tools like Erwin and Red Gate.

Proficient in Delphix masking and visualization.

Excellent interpersonal communication skills and a versatile team player.

TECHNICAL SKILLS:

Languages: T-SQL, SSRS, SSIS, SSAS, PowerShell, C#, VB.net DBA: Azure Portal, Backup/Restore, AlwaysOn, SQL Server Cluster, SQL Server Replication, Log Shipping, SQL Server Reporting Service, SQL Server Analysis Service Operating Systems: Windows Server 2000/2003/2008/2012/2016/2019 & Windows 7/8/10/11 RDBMS: SQL Server 2008/2012/2014/2016/2017/2019/2022, MongoDB, PostgreSQL Tools: Red Gate, SolarWinds, Erwin, System Monitor, SQL Server Profiler, etc. Other Skills: SQL Tuning, Data Warehousing, ETL, VLDB and Partitioning, Data Modeling

CERTIFICATIONS:

MCTS (SQL Server 2008 Implementation & Maintenance)

MCTS (SQL Server 2008 Database Development)

MCTS (SQL Server 2008 Business Intelligence Development and Maintenance)

MCSA (Microsoft Windows 2003)

MCP 2.0 (Certified Professional)

EDUCATION:

Bachelor’s degree in Science (Major Computer Science) - Peking University, Sept 1985 – July 1989

PROFESSIONAL EXPERIENCE:

LA Care Health Plan, Los Angeles, CA Senior SQL Server DBA, March 2015– Feb, 2024

Responsibilities:

Manage over 200 SQL Servers, including development, test, UAT, and production servers.

Install, configure, and maintain SQL Servers, including standard and Failover Cluster SQL Server, AlwaysOn, Replication, Reporting Service, Integration Service, Analysis Services.

Migrate and upgrade SQL Server versions, utilizing tools like SolarWinds and Red Gate for performance monitoring.

Manage database backup & restore using SQL Server Maintenance Plan and implement TDE encryption for production databases.

Deploy SSAS, SSIS packages, and SQL Server Reporting Service, along with creating and maintaining SQL Agent jobs.

Use OLA for SQL Server Maintenance Solution, INDEX_REORGANIZE, INDEX_REBUILD, update statistics, and resolve performance issues.

Configure and manage High Availability (HA), including Windows cluster, SQL Server AlwaysOn group, and attentive listener.

Implement SQL Server Transaction Replication and Database log shipping for Disaster Recovery (DR).

Configure Microsoft Azure Cloud, including Azure SQL Database, SQL Managed Instance, Azure SQL Server VM. It is Infrastructure-as-a-Service (IaaS)

Set up and configure Azure Site-to-Site VPN and Point-to-Site VPN for migrating databases between on-premises servers and Azure SQL Server.

Use Azure Data Factory for data loading to Azure databases.

Create and configure Azure App Service and release .NET web applications.

Monitor Azure SQL Server performance and use PowerShell for server monitoring.

Utilize T-SQL for query optimization and rewriting query statements for better execution plans.

On-call support for production SQL Server issues and collaboration with Microsoft support.

Agile1 Co., Ltd Glendale, CA

Position: SQL Server DBA (30%) / Developer (70%) Duration: Sep 2012 – March 2015

Agile1 Co., Ltd specializes in integrated services and technology designed to drive value and mitigate risk. With a total workforce solution responsibility covering over 3000 employees, including clients like MillerCoors and Delta, my primary role involved calculating payroll for our clients' contract employees.

Environment:

SQL Server 2005/2008/2012 (SSRS, SSIS, SSAS), Windows 2008/2012, IIS, .Net (C#, VB.net)

Eight production servers, including two for SQL Server 2012, five for SQL Server 2008 R1/R2, and one for SQL Server 2005

Over 50 client databases with sizes ranging from 20G to 500G

Responsibilities:

SQL Server DBA tasks, including installation, configuration, and management of SQL Server instances.

Planned the customer requirement, Using Data modeling (CDM, LDM, PDM) to modify database Infrastructure (create new table, new column ) to satisfy customer requirement

Utilized tools like Ignite, Database Engine Tuning Advisor, and Resource Governor for performance monitoring and tuning

Database design, including the addition of tables, views, indexes, scheduled jobs, triggers, and logins

Implemented database changes using tools like RED Gate SQL Compare, SQL Data Compare, and SQL Source Control

Managed database backup, restore, integrity checks, and index rebuilding for disaster recovery plans

Planned and executed Microsoft SQL server upgrades and patches

Implemented data loading from client FTP using SSIS and SQL Agent jobs

Developed SQL stored procedures/functions and provided technical documentation

Troubleshooted and resolved database issues

Installed MySQL and NoSQL (MongoDB) for testing and searching technical skills in resumes

Medversant Co., Ltd Los Angeles, CA

Position: Senior SQL Server DBA (50%) / SQL Developer (50%) Duration: March 2006 – Sep 2012

Medversant Co., Ltd is a leader in technology solutions for managing healthcare provider information.

Environment:

SQL Server 2000/2005/2008 (SSRS, SSIS, SSAS), Windows 2000/2003/2008, IIS, .Net (C#, VB.net)

Responsibilities:

SQL Server DBA tasks, including installation, configuration, and management of SQL Server instances and clusters

Configured Database Mirroring, High Availability, and Database Replication

Developed backup/restore plans for disaster recovery and configured linked servers, database mail, and SSRS

Maintained and optimized SQL Server performance in a 24x7 environment

Utilized T-SQL for database programming and automation

Used SSIS for exporting/importing customer data and SSAS for data analysis

Created and deployed reports using SSRS

Configured AWS Windows Server and migrated applications to AWS (including EC2, S3, RDS etc.)

Setup and configure Microsoft IIS and Sql Server Database for .net program)

Created test environments using AWS for offshore developers

IDS (Insurance Data Service) Co., Ltd Hemet, CA

Position: Senior Web Developer & SQL Server Developer Duration: Jan 2005 – March 2006

Responsibilities:

Designed and developed business objects, data access layers, and SQL Server databases using C# and VB.net

Assisted junior developers and created web forms and user controls

Set up source control (TFS) and deployed applications in QA and production environments

Cie NET - China (Pitney Bowes – China) Beijing, China

Position: Web Developer & SQL Server Developer (Project Leader) Duration: July 2002 – Nov 2004

Worked with Pitney Bowes Project team to provide printing and mail services for White & Case (Law Office). Responsibilities included:

Designing and developing business objects using C# and VB.net

Developing stored procedures and T-SQL in SQL Server 2000

PostLinx Co Ltd. Toronto, Canada

Position: Senior Software Developer & Fox Pro Developer Duration: Jan 1999 – June 2002

Worked on the Direct Mail system, assisting Royal Bank, Bell Canada, and GM. Responsibilities included:

Development in Visual Basic, Access, FoxPro, and PRS (Print Software)

Assisting Oracle DBA (PL/SQL) for Salvation Army database management and reporting

Al medio Co., Ltd. Tokyo, Japan

Position: Senior Software Developer Duration: Oct 1997 – Nov 1998 (Supervised a team of 5 people)

Authored web DV Transfer Compressor program using MPG2 (Java program)

Developed software in Windows 3.1, Win9X/NT using Visual C++ and Visual Basic

Toko Testac Co Ltd. Yokohama, Japan

Position: Software Developer Duration: Nov 1990 – June 1994

Developed software in N88_Basic, C, and MASM to test automobile materials

Generated reports on material characteristics

Beijing No. 5 Semiconductor Company Beijing, China

Position: Software Developer Duration: Sept 1989 – Oct. 1990

Designed circuits for the Program Control Telephone using CAD under MS_DOS

Established the company’s first personnel database using dBase III under MS_DOS

Other Skills:

Networks & OS: Windows (3.1/9X/XP/7/10/11), Windows Server (2000/2003/2008/2012/2016/2019), Active Directory, DNS, DHCP, Web Farm, Network Load Balance, Windows Cluster, IIS, SMTP Server, Team Foundation Server 2017

Virtualization Environments: ESX VMware Server, vSphere/vCenter, VRanger

Cisco Network: Cisco 2811 router, Cisco 5505 firewall, Cisco SA 540, Tiger Switch 10/100/1000

Antivirus: Symantec Endpoint Protection

Cloud: Amazon S3 Organizer & EC2, Microsoft Azure SQL Database/Elastic Pool/SQL Managed Instance

Languages & Version: Visual Studio 6.0, Visual Studio asp.Net (2003/2005/2008/2010/2012/2015), Crystal Report 8.5, PRS (Print Software)

Hardware: Rack Server Dell (Power Edge 710), PC (Desktop & Laptop)

Office Tools: Microsoft Office (2003/2007/2010/2016), SharePoint 2010/System Center 2012, SolarWinds, Microsoft Access 7.0, Microsoft FoxPro 6.0

Language Proficiency: English, Japanese, Chinese

Contact this candidate