Hsiao-Ching (Kathy) Huang

adq4j2@r.postjobfree.com 512-***-**** (cell)

Summary

** ***** *** ******** ************* responsible for the capacity planning, design, development, administration, performance tuning, security, maintenance & 24x7 production support SQL Server 2000-2019 to ensure uptime SLA, efficient on DB/Application/hardware/software/Windows systems.

Expertise in SQL server, installation, configuration, upgrade, patching, security, management, performance tuning on standalone/clustering with SAN storage to ensure availability, optimal systems.

Performed multiple upgrades, migrate from old version (ex. Sql2000) to latest releases, patching, consolidate, multi-layer migration disparate SQL Servers to ensure various version/edition function.

Experienced Database implementation– get requirement, design, development, create DB objects, SP, view, udf, refresh test/QA db with prod, deploy, optimize query, monitor performance tuning to support developers requests and web application availability, high performance, integrity through SDLC.

Experienced SQL Cluster Always-On AG installation, setup, test, administer huge 2T SQL 2016 DBs.

Collaborated with vendors, apps owners, infrastructure team in gathering business requirements, using SQL tools to build systems- manage, plan, implement migration, monitor, fix DB & web applications.

Experienced develop/automate ETL/SSIS processes, Install/configure/create/administer SSRS reports.

Performed automate & ad-hoc backup /recovery databases for various recovery models to ensure HA.

Expertise on setup configure, administer, troubleshoot, maintain databases, storage, DR, HA SQL failover cluster, WSFC, AlwaysOn AG, SQL Replication, Log Shipping, Mirroring.

Experienced Performance Tuning (index, queries, waits, Execution plan, contentions) Query Optimize DMV, PerfMon, SQL Profiler, set metrics on SQL Sentry, Foglight, RedGate analysis troubleshooting.

Experience in planning, setup, config testing and validation & ensure Business continuity on DR server.

Proactively monitor SQL activities, identify, troubleshooting, service outage, CPU, memory, I/O, blockings, disk space. Set SQL Profiler extended events, trace to identify slow running/long run queries,

Automate, monitor, fix issue on DBCC health checkdb, ix(missing/reorg/rebuild), update statistics jobs

Performed Index best practice to for heavy workload, frequent queries, analyzed index distribution, sort

Implement, troubleshooting DTS SSIS process to load data from Oracle, MySQL DB2, flat file to SQL.

Documented SOP for system setup, operations, automate processes, changes, standard ensure accurate.

Implement automation using PowerShell, T-SQL or bash scripts for recurring business processes & DB maintenance tasks as SQL agent jobs and PowerShell moving SQL cluster group when failover.

Experienced installed/setup/test Oracle server, Oracle client tnsnames.ora. SQL Developer, PL/SQL.

Experience ITSM handle requests changes management. Get approvals from apps owners on CAB to implement DB changes, resolve issue to ensure the changes not impact DB performance reliability.

AWS Certified Cloud Practitioner- projects EC2, RDS, IAM, EBF, Elastic scale, Docker, VPC, ACL, Load balancing, NoSQL, Iaas/Paas, using IP, user account, browser to create the database MongoDB.

Experience on Azure SQL Azure DevOps, Azure Portal, DMA, Iaas, Azure Web Service. Practical knowledge of replication from on Premises to Managed instances & between two managed instances.

Technical Expertise

Operating Systems: Windows 2003/2008R2/2012/2016/2019, UNIX/Linux, SAN, NAS, VM, AD

Databases: MS SQL 2005 to SQL 2019, Oracle11g, Sybase 12.5, MySQL, Microsoft Office.

Languages: T-SQL, C, VB, Windows Power Shell scripts, Windows batch job script, Python

SQL Tools: SSMS, SSIS, SSRS, SSAS, BID, Visual Studio 2016, SQL Profiler, PerfMon,

DTS, BCP, Mirroring, LogShipping, Microsoft Clustering Services (MSCS), AlwaysOn AG, Visual Studio, RedGate SQLToolBelt, SQL Compare, Idera Diagnostic Manager, Quest Foglight, SentryOne, Activity Monitor, PRTG, SVN,

Cloud Services AWS Certified Cloud Practitioner, EC2, RDS, MongoDB; Azure, Azure Portal;

DBA Tools: SSMS, Enterprise Manager, DBArtisan, ManageIT, SQL Developer, PL/SQL, Ch

Backup Tools: Idera SQLSafe, SSMS, Maintenance Plan Job, Veritas backup, Office365

Data migration: MSDTS, SSIS, BCP, Data Migration Import/Export Wizard, scripts

Data modeling tool: ER Studio, ERWin, Power Designer, IBM InfoSphere Data Architect,

Internet: IIS10, Sharepoint2016Foundation, SharePoint 2016/2010 Central Administration

Middleware: Asure ID, Planview. BO server, i2 Analyst notebook. HP-QC, Mobil Assets

Professional Experience

Samsung Austin Semiconductor Austin, TX June 2014 – January 2020

Sr. MS SQL DBA

Architected and administered 70+ production servers, 500+ DBs in 24x7 environments, Responsible for all aspects of database administration on SQL Server installation, configuration, upgrade, security, analysis, troubleshooting, problem solving & performance tuning for optimal performance on both clustered & standalone machines with efficient operation, continue improvement for integrity systems.

Primary DBA resource responsible for the build-out, administration, management of SQL 2000/2017 databases design implementation, maintenance, monitoring, tracking requests and resolving issues.

Setup configured Quest Foglight monitor tool to setup baseline and matrix counters to monitor DBs.

Experience in PowerShell scripting to move SQL failover and automate application business processes.

Experience in setup, administering SQL Cluster Always-On AG on many huge over 2T SQL 2016 DBs.

Proven technical support on application integration and critical SM databases migration from a cluster to a new cluster successfully – setup trace on SQL Profiler to find the connects ions, users, applications, hostname, SQL statements analyze the coming data & dependencies then work with apps owner to migrate databases & processes jobs to ensure the application & Databases are run successfully.

Worked with developer to develop SSIS script, write/tune stored procs for business, monitor processes.

Migrated SQL2000 to SQL2012 with jobs, worked with apps owner to rewrite/upgrade DTS to SSIS.

Implemented the Disaster Recovery solution by setup, test, validate DR servers & daily sync processes.

Automate setup SQL monitor processes for sql restarted, failover, connections, disk space, long run queries, resource usage, contention issue, memory, I/O, blocking, failed jobs, get alert if process failed.

Performed daily backup, db/ix maintenance, system health check, monitoring, alert on system issues.

Planed and deployed production changes on database systems by enter ticket with job scenario file to ITSM, present in CAB meeting with all stakeholders to get approval from change management team.

Experience DB design conceptual/logical/physical data models (3rd NF) to meet business requirements.

Worked closely with apps owners to monitor database system performance, proactive identifies, fixes db, apps or secure issues to ensure delivery of database service within the SLA’s and performance set.

Experience develops purge process for messaging system and archival for various monthly processes.

Experience on setup user groups, computers on the Active Directory for SQL server databases logins.

Developed SSIS from various sources text file, excel, SQL, Oracle, Mysql for application process job.

Supported HID Global AsureID badging system-install, upgrade HID on Badging server & client’s PC.

Texas Department of Public Safety Austin, TX November 2007 – March 2014

MS SQL DBA

Provided operational database services support on 60+ SQL servers – planned, design, implement, administered and maintenance production database systems to ensure nonstop all agency’s systems &issues are quickly identified & resolved for system availability, securely managed & ready for review.

Performed SQL 2000/2012 Installation, configuration, security, maintenance of Implements databases.

Technical support, implement and management the Datawarehouse Finance DW SSIS and SSAS.

Performed backup database by setup maintenance plan, setup policy in Idera SQL Safe console, veritas.

Worked with developers to design Order Center by analyze, implement business rule, build and maintain logical/physical data models, metadata, schema and data dictionary.

Experience in collecting, transforming business requirements into technical specifications, including source data streams destination and integrations, transformations to Finance DW SQL database.

Setup configured RedGate belt monitor tool to setup baseline and matrix counters to monitor DBs.

Defined the data architecture framework, standards and principles, including modeling, metadata, security, reference data such as business objects, timesheet, drug categories & employees master data.

Provided technical support SQL server database tickets troubleshooting, identify, resolve system issues.

Used best practice to setup SQL server- pre-install (setup service account, security), installation and post-installation tasks (TempDB maintenance, configure memory, setup default db path, db mail, operation roles, alerts, backup health checkdb,, Index, ETL, monitoring process and jobs).

Experience to install Oracle server 11,9 and setup Oracle client, ETL connect /load data to SQL servers.

Experience in administering multiple node SQL instances on Failover Cluster built on SAN with RAID.

Developing, automate DTS/SSIS process, install/design/administer Power BI, SSRS reports for FMS

Performed SQL monitoring identify slow-running queries, bottlenecks, error msg, locking, full latency.

Provided performance tuning using SQL Profiler, SQL Sentry and dmv scripts to find long run queries.

Experience DB design conceptual/logical/physical data models (3rd NF) to meet business requirements.

Texas State Auditor’s Office Austin, TX December 1999 – October 2007

SYBASE DBA

Performed Complex Sybase SQL DBA work – logical/ physical database design, Installed, configured, upgrades, security for Sybase12.0 -12.5.4, built databases and application-related objects in Sybase, and troubleshoot fixing problems, performance tuning to ensure reliable, integrated data for all systems

Provided timely technical support on analyze business rules, upload big volume, various format data, verify data integrity, configure special device on application at all levels of technical sophistication.

Tuned databases and application queries, performed security login management, and db backup restore.

Monitor Sybase server using SQL Activity Monitor, setup counters to ensure reliable, efficient systems.

Developed procedures and policy to maintain database integrity, recover databases from system failure.

Used Power Designer to create and maintain of Data Model &Data Dictionary for production databases.

Sybase DBA Texas Workforce Commission Austin, TX March 98 – Nov 99

Performed database design, implement, security control, backup (cron job), recovery and performance tuning for TWIST, LMI and ECC application system to ensure data integrity.

Designed TWIST(Texas Workforce Information System Technology) by collecting, transforming business requirements into functional areas like intake/outreach, security/admin/maint and reports then using Data Architect to draw relational data diagram with key entities and the relationships.

Performed installation, configuration and upgrade Sybase server 11.5/11.9.2 on DEV, Test Prod ASE.

Planned, developed, implemented and maintained database systems, security control & utilization.

Provided technical support to write stored procedures, triggers, verify data integrity, troubleshooting.

Installed/Configured NetGateway, DirectConnect to access mainframe with RPC call for DB2/MVS.

Monitored Sybase servers and troubleshooting /fixed system issues as needed.

Developed and implemented scripts to perform monthly real time Data Warehouse loading process for LMI(Labor Market Indicator) and ECC (Employment Child Care) apps systems on Sybase IQ.

Education

Master in Computer Science Major, Math Minor in Texas State University, San Marcos, Texas

Computer Science and Math course credits in University of Texas at Austin, Texas

Bachelors in Business Administration (Accounting/Finance) in Taiwan University Taipei, Taiwan

Certification in AWS Solution Architect, Austin Community College, Austin, Texas

Contact this candidate