* ** *

Wenhong Lu

***** ****** **** ** • Clarksburg, MD 20871

admpko@r.postjobfree.com

CAREER OVERVIEW

• Current

o More than 7 years of management experience in IT industry o Database administration and development in SQL Server built with AlwaysOn o Database migration to Azure.

o Cloud server management

o Microsoft Windows management and Powershell scripting

• Past experiences

o Oracle administration and development

o Siebel Development and Administration

o Web site and software development with HTML, stylesheets, ASP, javascript, Visual Basic

o Some experience with .NET and java

o Report development in MS SQL Reporting Services

o Medical research

CORE QUALIFICATION

• Strong problem-solving skills

• Self-motivated

• Very organized

• Detail-oriented

• Fast learner of new tools/languages

• Team player

EXPERIENCE

Dimension Data / NTT Ltd., Reston VA

Group IT Operations Manager (09/2013 – present)

SQL Server, Cloud VM, Powershell

Service-Now

• Responsible for SQL server backup, restore, migration, SQL server job synchronization.

• Developed automation scripts to restore databases to DR on Azure.

• Developed automation scripts to synchronize SQL jobs across different servers.

• Played a key role in migrating the servers from NTT cloud to Azure.

• Manage a Group Operations Support team across 3 shifts and 4 countries to support two mission critical 24x7 applications accessed by global users. 2 of 5

• The team maintains more than 100 servers behind the applications that are used for development, QA and production.

• SQL server administration including backup, restore, log shipping, replication, AlwaysOn management.

• SQL scripting for reporting and data upload and archive.

• Windows Powershell scripting to manage system related tasks such as documenting, monitoring, troubleshooting and maintenance.

• Provide technical support at networking, server, database and application level.

• System migration to different hosting companies, data centers and different platforms.

• Build and maintain VMs on Cloud platform.

• Ensure system uptime, manage system updates and changes.

• Manage software licenses and SSL certificates.

Dimension Data, Reston VA

Database Administrator / Software Engineer (09/2001 – 09/2013) SQL Server, MSSQL RS, SSIS

ORACLE, Siebel

PVCS, Visual Studio

ASP, AJAX, javascript, VB, java

JasperServer, iReport

• SQL Server administration and database development and maintenance including database backup, migration, routine archiving of old data.

• Wrote SSIS packages and stored procedures to perform complicated database tasks such as data extraction for different regions.

• Responsible for massive data updates based on client's needs.

• Integrated Microsoft SQL Server Reporting Services with custom application and developed canned reports.

• Integrated JasperServer Reporting tool with custom application and developed ad hoc reporting capability for clients.

• Developed in-house web site for e-procurement in ASP, AJAX and javascript, and VB.

• Served as primary DBA support for Oracle databases for GSOA Siebel, Netcool, and Siebel Sales.

• Performed database server installation, upgrades, application data setup, database backup, recovery and performance tuning.

• Generated reports from Oracle databases for management needs.

• Served as tech lead for Siebel Sales implementation in US.

• Administered and performed ongoing change request and generated reports in Siebel for management needs.

• Responsible for Siebel and Oracle upgrade and troubleshoot.

• Administration of PVCS Version Manager and Tracker.

• Provide supports to Microsoft Great Plains daily uses. Timebridge Technologies, Mclean VA

Senior Database Administrator (09/2000 – 09/2001)

ORACLE, Erwin, ASP

• Served as primary DBA support for ten internal Oracle databases and client databases. Databases were monitored 24x7 through DBAPLUS, an internally 3 of 5

developed database monitoring software. Performed database troubleshooting, backup, recovery and tuning.

• Developed and maintained two web sites for Managed Services group to keep track of client information, network information and client installation processes. Data are retrieved from OpenView database with added table structures. KPMG CONSULTING Inc., Arlington VA

Database Administrator (11/1999 – 09/2000)

ORACLE, SQL Server, Sybase, ERwin, PVCS, SQA

• Performed senior DBA role for KPMG PPG group.

• Developed and maintained different versions and different RDBMS databases for Performance Series Software (PS). PS provides a standardized approach to accounting, budgeting, asset management, procurement events, and strict financial controls.

• Performed database installation and upgrade.

• Loaded data in various test databases to assist development and testing.

• Assisted Developers to develop database scripts and stored procedures.

• Composed release notes for Performance Series Software (PS).

• Supported clients in database performance tuning and database structure management.

BOOZ.ALLEN & HAMILTON Inc., Seabrook MD

Database Administrator / Software Developer (10/1998 – 11/1999) ORACLE, ERwin, Visual InterDev, Java Applet, MS Access, Visual SourceSafe

• Developed and maintained databases for NASA Integrated Services Network, and database to support End-to-End Architecture Model.

• Designed and implemented a database to serve as data repository for NASA web users.

• Implemented ERwin as the primary database design, development and documentation tool.

• Acted as technical lead in reviewing and incorporating software enhancements prepared by other team members.

• Implemented and administers MS Visual SourceSafe as a source control tool for Software development.

• Created web sites for internal tracking of NASA Integrated Services Requests. Cleverex System, Inc., Rockville MD

Database Administrator / Developer (01/1998 -10/1998) ORACLE, Developer 2000, MS Access, Visual Basic

• Developed an employee sign in and sign out system to record daily sign in and sign out activity. Application allows employer to generate various reports.

• Developed a project-tracking system to keep track of project status. The application developed by Visual Basic allows editing and reviewing data stored in an Oracle database.

• Installed Oracle database servers and related software.

• Developed and troubleshoot training databases.

4 of 5

Advanced BioScience Laboratories, Inc., Frederick MD National Cancer Institute

Research Fellow (09/96 - 12/1997)

GCG, Gene Construction Kit, DNA strider

• Applied various sequence analysis software to the construction of retroviral gene transfer vectors.

• Applied ImageQuant software for quantitative analysis of the data from PhosphoImager System.

• Participated in HIV research.

University of Massachusetts at Amherst, Amherst MD Ph.D Candidate (09/1992 - 09/1996)

MS Access, MacVector

• Generated an EST (Expressed Sequence Tag) database for filarial genome project. SOFTWARE TRAINING

Siebel, VA

Siebel Core Consultant Course

System and Information Services Co., MD

Solaris 8 Certification Prep Course

System and Information Services Co., MD

Oracle8i Hands-On

Cleverex System Inc., MD

Oracle Database Development and Administration

Developer 2000 (Forms, Reports)

Visual Basic 5.0

Learning Tree International, MD

SQL Server 6.5 Administration

TCP/IP Internetworking on Windows NT

Microsoft Visual InterDev

Enterprise Web Development with Active Server Pages Advanced BioScience Laboratories, Inc., MD

UNIX

GCG sequence analysis in UNIX

EDUCATION

Ph.D. in Molecular Biology University of Massachusetts at Amherst 1996 5 of 5

Bachelor University of BeiJing Medical School 1991

Contact this candidate