Sql Server Data

Michael Zhang

Summary:

**+ years of overall software engineering experience with in-depth knowledge of relational database design.

10+ years of extensive experience in SQL Server database development.

Outstanding ability in trouble shooting large-scale database performance issue and providing timely solutions.

Designed and supported database driven applications with both Web and Client-server interfaces.

Expert level T-SQL programming experience with SQL Server 2012/2008/2005/2000 including Stored Procedures, Triggers, Views, Tables and Indexes.

PowerShell to automate lower environment refreshes, and in SQL Agent jobs for Adhoc server snapshot refreshes, etc..

Extensive experience with multiple hops of transactional replications.

Designed and coded c# utility application to automate routine tasks for database administration

Hands on experience with SSIS, SSAS, SSRS.

Extensive performance tuning.

Extensive Experience writing SSIS and DTS Packages.

Designed and implemented database backups and recovery procedures.

Created database application objects including stored procedures, functions, triggers, and indexes.

Skills:

Programming Languages and Skills: MS SQL Server 2012, 2008, 2005(2000), Visual Studio.net 2012, 2008, T-SQL, C++, C#, PowerShell, Visual Basic 6/Visual Basic .net, ASP.Net, ADO.NET, OOP, Java, MYSQL, PL-SQL, Visual Source Safe, HTML, XML, Rational Rose, Toad Modeler, Apex SQL tools, Red Gate tools, DTS, InstallShield Universal, Win Runner, Load Runner

Work Experience:

Aurea/iSTA-North America, Alpharetta, GA Jun 08 - Present

(Utility billing service)

Senior Database Administrator

Managed multiple complex mission critical client clustered 2008 SQL database servers, database performance tuning, data transfer through logshipping, replication, BCP, Database backup and restore, Database optimization.

Developed SQL Server databases, translated data and managed implementation to ensure successful execution of the application.

New client data migrations.

Created data warehouse application consisting of SSIS packages to update client warehouse dimension and fact tables with current production data. Created a SSAS snowflake schema cube for invoice revenue, and various reports created in SSRS using this cube. Also involved in executing, processing, maintenance, and support of this project.

KPI report packages and support

Created PowerShell scripts to add volumes and load test to the Compellent SAN and to create and mount snapshot volumes on VMs. Wrote PowerShell scripts to refresh client dbs on an adhoc server which is based on Equallogic SAN snapshots.

Managed user access to SQL servers in various environments

Supported SQL code deployment in various environments

MedAssets, Alpharetta, GA Jul 06 - Mar 08

Senior SQL Database Developer/Administrator

Duties included development, installation, administration, and maintenance of SQL Server 2005 databases.

I developed and implemented several dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS)

Physical and logical database design.

Extensive experience with T-SQL scripting.

Troubleshooting performance problems and creating, debugging, and optimizing stored procedures.

Managing SQL Server user access.

Extensive performance tuning which significantly reduced processing time for long running stored procedures used in populating database warehouses.

Created a program tool and complex SQL scripts to convert large databases (from BPI to CDMM) to support new enterprise applications and web applications.

Designed and coded admin tools using C# and SQL SMO and DMO for managing the end user, application users and application roles among hundreds of databases in several distributed environments, effectively reducing hours of work to a few minutes.

Maintained change control and version synchronization among different databases environments (development, quality assurance, user acceptance, and production).

Maintained and updated DTS packages and SSIS projects.

McKesson, Alpharetta, GA May 98 - May 06

SQL Database Developer/Support Jun 01 - May 06

Logical and physical design for several MS SQL Server databases (EIW, HIS, AUDIT). Supported operation of the databases of more than 2000 users with 50 GB data.

Designed and developed utility tools to manage database routine tasks.

Supported application development for multiple databases by coding stored procedures, functions, triggers, and DTS packages.

Designed and successfully executed database backup and recovery plans.

Supported both remote and onsite client hospital SQL Sever Administrators for escalated critical issues and data recoveries.

Received merit bonus for having showed outstanding troubleshooting ability and customer relation skills when performing comprehensive on-site Windows OS and SQL server support, upgrades, and data recoveries.

Resolved performance problems by index tuning, data purging, troubleshooting application bottle necks as well as a reduction in execution times for long running stored procedures.

Created SQL scripts to perform routine database maintenance tasks and alerts.

Designed and implemented database security schemas for the hospital data web reporting tool.

Wrote SQL scripts for databases installations and configurations.

Created data development bug tracking system using SQL and C#.

Software Engineer May 99 - Jun 01

Designed and coded a complex and versatile system input simulation application to generate HL7 ADT messages for patient information and medical record images and COLD documents to populate databases for both functional testing and load testing and escalation issues for trouble shooting.

The resulted data and image documents are being used by both QC and development for load, functional, and unit testing. The application enables the business unit to comply with the new HIPAA requirement with regard to patient information confidentiality.

Designed and coded an InstallShield Universal 11.5 (Java) script that installed and automatically configured a web based java patient record application to work with JBOSS or WebLogic.

Maintained and handled critical escalation issues for LaserArc sites by making code changes in C++. Maintained C++ components of Horizon Patient Folder system.

Testing automation technical lead Apr 98 - May 99

Organized group effort to automate functional tests of complex medical record document applications using Win Runner and Test Director.

Extensive scripting in Win Runner and Load Runner scripting for VB and web applications running on SQL server and WebLogic server.

EarthCall Communications, Inc., Atlanta, GA Aug 97 - Mar 98

(Tele-communication industry)

Network Administrator

Managed a mission critical NT4.0, NT3.51/Novell network, SQL Server, Foxpro, MS Exchange Server.

Iterated System Inc., Atlanta, GA Feb 97 - Aug 97

(Imaging Software Company)

System Engineer

Tested Oracle Video DB Server and its clients, Designed and implemented an Access database for Testing and Support Team's hardware and software inventory.

Maintained company's web site, developed an InstallShield script for RealVideo with Osprey board drivers and ClearVideo fractal encoder set up.

Education:

Master of Science program in Computer Information System,

Georgia State University, Atlanta, GA

Ph D in French Language and Literature,

University of Alabama, Tuscaloosa, AL

Certification:

MSDBA, MCSE, ITIL training

Achievement:

Regarded as a go-to person for escalated complicated technical issues.

Received merit pay increase.

Praised by clients when working to support their db systems for being patient and helpful.

Recognized by a VP as a good problem solver and was promoted subsequently to team lead position.

Reduction of several hours of running stored procedures to minutes.

Contact this candidate