Sql Server Manager

Resume: Beng Ho Ng (a.k.a Camelia) Email: *********@*****.***

Address: **** ***** *** ** ******** WA 98006 Cell: 425-***-****

Career Objective:

Seeking for a FTE position as SQL DBA, I have comprehensive experience in the Information

Technology industry using leading edge hardware and software technologies to address a

variety of business processes. My many years of IT experience with good communication skills;

leadership; design; implementation and technical skills will add immediate value and integrity

to the organizations efforts towards the implementation of its product, services and technology.

Qualifications:

10+ years combined experience with SQL Server enterprise 2000,2005, 2008 R2 & 2012

10+ years combined experience with Windows enterprise servers 2000, 2003, 2008

10+ years combined experience analyzing, troubleshooting, and providing s olutions for

technical issues on Web UI/IIS/OS/SQL servers : SSRS/SSIS/SSMS/SSAS/OLAP

10+ years of experience in complete life cycle of software product development from

gathering, analysis, architecture, design, testing and pre & post development

7+ years combined experience with SQL Server Analysis/OLAP 2000, 2005, 2008 R2

Demonstrated expertise in upgrading, installing and configuring SQL servers

standalone/Clustering

Familiar with installing and configuring web servers (IIS)/3rd party applications with

application integration

Work on critical, highly complex customer problems that spans multiple services in

multi-tiers environment

Provide support on all stages of database implementation and deployments and

experience with SQL Server High Availability technologies and backup/recovery

TECHNICAL SKILLS

Database Systems : SQL Server Enterprise 2005/2008 R2/2012

SQL Database Components : SSIS, SSAS/OLAP, SSMS, SSRS, HA AlwaysOn

Enterprise Applications : EPIC Clarity (EPIC Console and Compass) 2010

Operating Systems : Windows Server 2000/2003/2008 R2

Network Protocols : TCP/IP layers, Kerberos, DNC/DHCP, SSL

Programming Languages : T-SQL, MDX, Powershell, XMLA, scripting, HTML

Web Skills : .net framework 3.5/4, IIS 6.0/7/7.5

Distributed Technologies : Active Directory, Web Services, Load Balancing

Version Control Tools : VSS,CVS, PVCS, Source Depot, Team Explorer (TFS)

Tools/Applicatios : Perfmon, SCOM 2007, SQL Profiler, WinDbg,

: BIDS, Litespeed 6, Omniture Insight (BI), SQL diagnostic

manager (Idera), SharePoint 2010, Visual Studio

2008/2010, Team Explorer Foundation server (TFS) 2010

Basic knowledge : Oracle, TOAD, Java, Linux shell scripting, Unix

PROFESSIONAL EXPERIENCE

Employer: KFORCE, FL, April 2012 till present

Project completed at client site: University of Washington Medical Center, WA

Position: SQL DBA for Production Support

Job Descriptions:

Resolved SQL performance issues due to server performance and network settings

Resolved SQL ETL delay and errors due to poor indexing and hop server space issues

Ran diagnostic tools to identify database performance bottlenecks, and take appropriate

corrective actions to improve database performance

Provided production support on EPIC Clarity ETL processing and daily SQL ETL jobs

Reviewed data warehouse architecture and implemented change to current SQL

security system on UW Medical IT services so that to prevent security threats

1

Resolved connection issues due Kerberos authentication failures and double hopping

Provided technical expertise to BI analysts and others on SQL related topics

Created daily ETL reports using T-SQL and HTML

Created SQL troubleshooting guide for team members

Skills used:

SQL Server Enterprise 2000/2005/2008 R2, Windows Server 2000/2003/2008 R2, SQL

Profiler, Perfmon, BIDS, EPIC Console and EPIC Compass 2010, Clarity tools, Visual Studio

2010, Active Directory, Citrix, SQL Diagnostic manager (Idera)

Employer: GlobalLogic Inc, VA, Aug 2010 Mar 2012

Client site: Microsoft Corporation, Redmond WA

Position: Tier 3 production support engineer as SQL DBA for BICI Ops team

Job Descriptions:

Provided technical expertise to Program Managers, developers and testers in BRD

meetings: BRD(Business Requirement Document), functional spec, design, test p lan,

system integrations, build and deployment to PPE and production

Installed and/or upgraded to SQL 2008 R2 standalone and clustering servers

Installed and configured OLAP, Reporting servers and WebUI/IIS servers

Migrated countless of databases and OLAP databases from one server to another

Performed MSN/IPAK and SQL patches/hotfix/out-of-band patch as needed

Provide solutions to development teams when proposed solutions do not comply with

architectural, configuration, performance, or security guidelines

Worked with team on 24/7 production support on all production servers

Managed log shipping/backup failure, source issues, deadlock/blocking, general

server/system issues, clustering issue, SAN issues, UI timeouts, performance tuning

Resolved technical issues in SQL/OLAP cubes/UI/ETL delay/Omniture Insight servers

Created using T-SQL to automated daily monitoring reports

Worked on Disaster Recovery planning like log shipping, restore/backups, clustering,

and High Availability like BCP and mirroring

Worked on critical, highly complex customer problems that span multiple services and

multi-tier environments

Worked with Web Services issues to help reproduce and resolve customer issues

Supported MDS that utilized network load balancing in a web farm environment

Skills used:

SQL Server Enterprise SSIS/SSRS/SSAS 2000/2005/2008, SSRS 2008 R2, Windows Server

2003/2008 SP2/2008 R2, Powershell 2. SQL Profiler, Perfmon, BIDS, IIS 7/7.5, Litespeed 6,

Adobe - Insight 5.4, HTML, Excel Pivot 2010, Web and clustering servers, TFS 2010, Visual

Studio 2010, Microsoft Office 2010, SharePoin t 2010, Cluster servers, .Net Framework 4.

Employer: Microsoft Corporation, WA, Apr 2008 July 2010

Position: Sr. IT System Development Engineer for Data Warehouse, Search and Displays

Job Descriptions:

Performed maintenance support and troubleshoot large production SQL servers with

high transactional volume e.g., index maintenance, table and file group partitioning,

performance tuning, update statisctics,SQL jobs failures, etc.

Performed Windows/SQL patching, disaster recovery planning, log shipping,

restore/backup plans, SAN allocations and fixed ETL issues

Worked with BI development and operations teams to successfully delivered a million

dollar global marketing project using load-balanced, scale-up and scale-out approaches

on SQL/SSAS/SSRS 2005/2008

Participated in data warehousing system architectural design, reviews and provide

expert advice on BI data marts projects from planning, designing, development and

implementing to deployment

2

Performed data and domain migrations, SQL and SSAS/OLAP servers consolidation,

and transition plan for Razorfish BI Operations (Vivaki/ Publicis group)

On-call rotations in supporting high transactional volume of OLTP and replications,

heavy cubes processing OLAP and Data Warehousing production servers

Planned and implemented data refresh on PPE servers over 50 databases in OLTP and

data warehousing servers

Performed log shipping for HA and DR on Feedstore/datamarts servers

Worked on clustering for SQL database and cube processing servers that require high

availability and scalability

Installed SCOM, created alerts and monitor jobs using SCOM monitoring

Skills used:

Windows 2000/2003/2008 32/64-bit servers, IIS 6/7, SQL Server Enterprise 2000/05/08,

SSAS 2005/2008,.Net Framework 3/3.5, BIDS 2005/2008, Visual Studio 2005/08, Office

Project 2010, SharePoint 2010, CVS and Team Explorer Foundation, SCOM 2007

Employer: Altus Technologies, VA, Jan 2006 April 2008

Client Site: Microsoft Corporation, Redmond, WA

Position: Sustained Engineer for Adcenter & SQL DBA for Search and Display Ads

Job Descriptions:

On 24/7 rotations provide production supports for SQL server enterprise

2000/2005/2008, IIS, file servers and applications servers

Migrated over 100s data marts/OLAP databases and some system databases

Upgraded and Installed SQL server enterprise SSAS 2000/2005/2008

Provided technical expertise on SAN space allocations in SQL/OLAP/Reporting servers.

Rebuilt and fixed corrupted databases in production environment

Deployed SQL hotfix/releases to PPE (pre-production) and production environment

Performed daily operations: monitoring, storage management, backups, index

maintenance, security patching and troubleshooting database systems or cache servers

Performed SQL server profiler, tracing (e.g., blocking/locking information), optimizes

and tunes users database

Worked on OLTP transactional and Snapshot Replications, restoring of databases,

failover clustering, log shipping, mirroring, online indexing, various methods of update

statistics to optimize the users database systems

Performed on-call supports on overall production systems from SQL database servers,

applications servers, WebUI servers, Log shipping servers, clustering servers, Algorithm

EV servers, IIS and cache server

Skills used:

Windows 2003 32/64-bit servers, ASP.NET, C#, SQL server 2000/2005/2008 32/64-bit, .net

framework 2/3, IIS 6.0, Visual Studio .net 2005, T-SQL, VSS and BIDS.

Employer: Cibersites, Oklahoma City, OK (No longer in business)

Date joined: Aug 2005 Nov 2005

Position: SQL Developer

Job Descriptions:

Worked with Trizetto on their healthcare system requirements and solutions

Modified the existing stored procedures and Java code to add business functionality of

the new features.

Participated in Unit Testing and System Integration Testing the application

Worked in adding new features on current presentation layer/UI and modify their

existing database programs and/or add new features to the current database system

Involved developing SQL scripts to generate test data, write store procedures to

interface with 3rd party software

Wrote XML configuration file to interface with 3rd party products code review, unit

testing, and documentation

3

Skills used: Windows 2000 server, ASP.net, Java, C#, Oracle 9i, T-SQL, SQL Server 2000,

Toad, IIS 6.0, PVCS, Unix, and DOS.

Other Employer History: Jan 2000 May 2005, I worked as Graduate Research Assistant and

managed eight major undergraduate and graduate Computer labs for the College of Business at

the University of Oklahoma. During those times, I also assisted professors in tutoring students in

SQL database and Oracle designer/database to undergraduate students in the labs.

EDUCATION

University of Oklahoma, 2002 & 2005 Masters in M.ED, GPA.3.94, Concentrations:

Computer Applications and Distance Education (E-Learning)

University of Oklahoma, 1999, Bachelors of Business Administration (Distinction),

GPA.3.53, Major: Management Information Systems (MIS)

Stamford Group of Colleges of Singapore/Chartered Institute of Marketing,

Singapore & UK, 1994, Diploma in Marketing (Certificate I & II)

References:

1. Tom Johnson, Data Warehouse Manager, University of Washington Medical IT

Services, email:********@****.***, office phone: 206-***-****

2. Mussie Woldeselassie, DW Teammate, University of Washington Medical IT Services,

email:*************@***.**********.***, cell:206-***-****

3. Akshaya Arora, DBA Lead, Microsoft Corporation (Adcenter), Email:

*******@*********.***, cellphone: 682-***-****

4. Gayathri Malolan, Manager, Global Logic Inc, Email: ********@*****.***. Cell:847-

340-4023

4

Contact this candidate