Sql Server

DEBORAH GUO

**** ********** **. *****: (***) **2 - 9698

Solon, OH 44139 E-mail: ******@*****.***

OBJECTIVE: An experienced IT professional seeking a challenging Database related

position.

QUALIFICATION SUMMARY:

•Extensive experience with database design, development, modeling (UML, Rational Rose, Dimensional)

and administration.

•Strong SQL server skills, installation, configuration, implementation, administration and ETL (DTS,

SSIS).

•Expertise experience of Oracle administration, including installation, configuration, backup, migration

and tuning.

•Strong programming background in ASP, Visual Basic, VBScript, JavaScript, SQL, PL/SQL and Crystal

Report.

•Hand on experience system support and oracle / SQL application support.

•Hand on of Network processing, configuration, Protocols and Firewall.

EXPERIENCE SUMMARY: IT Professional with over 10 years of experience in the IT Industry.

Extensive professional experience with SQL, Oracle Database support, development, administration, ETL

process and application support.

LANGUAGES: HARDWARE: OPERATING SYSTEMS:

SQL IBM PC’S WINDOWS 9.0 / NT / XP

PL/SQL SUN SPARCS HP UNIX & LINUX

T-SQL DELL PC & Server Windows 2003 / 2008 Server

XML / HTML VMware / Virtual PC

JAVA / VB SCRIPT Web Services

VISUAL BASIC Hyper-V

ANCILLARY SKILLS:

ORACLE 8i /9i /10g /11i ASP .NET

SQL SERVER 2000/2005/2008 PL / SQL MS VISIO

DEVELOPER 2000 SQL*PLUS ERWIN

VISUAL STUDIO MS ACCESS MS IIS

CRYSTAL REPORT MS PROJECT Apache Tomcat

TOAD FOR ORACLE

DEBORAH GUO

7219 Winchester Dr. Phone: (440) 542 - 9698

Solon, OH 44139 E-mail: ******@*****.***

EXPERIENCE:

06/12 to 12/12 VNA Ohio, Cleveland, OH

Position: Sr. Application Analyst / SQL Database Administrator

•Managed the SQL Server database, including database setup, upgrade,

migration, backup, performance, trouble shooting and problem solving.

•Designed the database Disaster Recovery plan, restore plan and etc.

•Conducted and troubleshooting ETL process utilizing DTS and SSIS.

•Supported customer application, including the server and user support.

12/09 to 06/12 Keithley Instruments Inc., Solon, OH

Position: Consultant

•Managed the Database Marketing database, including the backup, performance

and trouble shooting and problem solving.

•Designed the intelligent database infrastructure to accommodate the Database

Marketing usage, including logical, physical and dimensional BI design

utilizing Toad for Oracle

•Designed and developed the Database Marketing Target Database and Contact

List reporting system.

•Designed and developed Marketing Report regarding the Lead, Opportunity,

Product, Geographic, TSA, etc.

05/07 to 02/09 CGI Inc., Cleveland, OH

Position: SQL Database Administrator

•Managed the SQL 2000 and SQL 2005 databases, in a MS Cluster and Non-

Cluster environment, including implementation, backup, restore,

performance monitoring, optimization, migration and trouble shooting, etc.

•Developed Database recovery strategy, including different backup plan, restore

database and validate backup files.

•Completed database ETL project to transfer medical / pharmacy code utilizing

SSIS package for SQL 2005.

•Conducted customer application support, including medical claim, medical

audit, and business intelligent report.

•Completed Data Warehouse medical data transfer utilizing DTS and SSAS.

•Managed and improved support for Data Warehouse, including star schema,

cube design, modification and Business Intelligent Management refresh.

•Managed database system software installation, configuration, upgrade,

maintenance, security control, system integration and change management.

DEBORAH GUO

7219 Winchester Dr. Phone: (440) 542 - 9698

Solon, OH 44139 E-mail: ******@*****.***

EXPERIENCE (Cont.):

•Provided end user database support, including security login, server object

setup, trouble-shooting and all other database related issues.

•Plan, design, test and implement upgrades for the Databases,

Including migrations from SQL 2000 to 2005

•Monitored Database system performance, server disk healthy, and automate

DBA tasks.

•Developed and maintained database support documentation.

•Managed databases and database server upgrade utilizing WSUS.

04/05 to 05/07 UGS Corp., Livonia, MI / Cleveland, OH

Position: Database Specialist / Technical Consultant

•Managed Database server (oracle, SQL) installation, configuration, upgrade,

migration, performance tuning, problem solving and documentation.

•Implemented Oracle Database / application migration for auto industry.

•Completed data center project utilizing SQL replication, DTS and migration.

•Implemented industry ERP system client / server installation, configuration,

integration, problem solving and customer support.

•Completed implementation of Oracle / SQL database application installation,

configuration and integration.

•Provided Oracle / SQL database application architecture solution support.

•Completed OS installation, including window 2000 /2003 server, web services,

VMware and Virtual PC installation

•Developed test cases and conducted installation validation.

01/03 to 04/05 Tecnomatix Technologies, Inc., Northville, MI

Position: Database Analyst / Database Administrator

•Managed Database server (oracle, SQL) installation, configuration, upgrade and

migration, backup, turning, problem solving and documentation.

•Completed Oracle / SQL Database creation, documentation and problem

solving.

•Implemented SQL database replication setup, monitor and DTS package to

transfer data.

•Developed database tracking system utilizing SQL and .net frame work.

•Implemented manufacture ERP system client / server installation, configuration,

integration, problem solving and customer support.

•Completed OS installation, including window 2000 / XP /2003 and UNIX

installation.

DEBORAH GUO

7219 Winchester Dr. Phone: (440) 542 - 9698

Solon, OH 44139 E-mail: ******@*****.***

EXPERIENCE (Cont.):

•Developed user interface and stored procedure to support application

development.

07/99 to 05/02 Tweddle Litho Company, Clinton Township, MI

Position: Application Developer

•Analyzed, designed and developed the intranet web applications utilizing

Visual InterDev, ASP, HTML, VBScript, JavaScript and SQL

Server.

•Analyzed, designed and developed database driven applications using the

concept of OO Database Design, Visual Basic, COM, SQL and DTS

Package.

•Designed, Implemented maintained and administrated the SQL Server

database, including user management, backup, automatic job routine, DTS

Package and troubleshooting.

•Developed and designed Dynamic Report Application system utilizing Visual

Basic, COM, SQL and Crystal Report.

•Maintained and modified user application ( Visual Basic and Web) and

conducted technical support to the customer.

EDUCATION: M.S. in Computer Information Systems, University of Detroit Mercy

M.S. in Mechanical Engineering, University of Strathclyde, UK

B.E. in Polymer Materials, East China University of Technology

Contact this candidate