Data Sql Server

Cindy Bai

**** ****** **** **. 224-***-****(Mobile)

Hoffman Estates, IL 60192 **********@*****.***

OVERVIEW

• Highly dedicated Data Architect\Database Administration Manager with o ver 12 years of experience in

data architect, database infrastructure design and implementation, database and middleware administration,

solution architectures, web development and administration

• Specialized knowledge and expertise on enterprise OLTP\OLAP database design, development,

performance optimization, operation and production support, enterprise data warehouse and database

infrastructure system design and build

• Broad work experience and technical knowledge on middleware support and administration, web

development and administration, infrastructure build and maintenance, application support and project

management

• Demonstrated excellent leadership skill managing 4 teams and total 12 direct reports consists with

Database Administrators, Middleware Administrators, Solution Architects, Web Developers and Web

Administrators onsite and offshore

• Proven record of success in resource management, budget planning and cost reduction estimation and have

saved approximately $700,000 for Hospira with creative and efficient solutions on database monitoring

and database system consolidation

• Highly dedicated and built a reputation of 100% delivery of all business critical and infrastructure projects

on time and within budget as well as providing flawless production operational support with excellent

organization and planning skills

• Solid knowledge and experience to integrate, manage and promote physical data models and data model

standards that source data from multiple origins

• Expertise in the enterprise database design, implementation and administration in a wide variety of

industries with various database management systems like SQL Server 2000, 2005, 2008, 2012 and

Oracle 9i, 10g, 11g, Exadata, clustered and non-clustered databases on all platforms

• Extensive experience in database installation, upgrade, management, support and migration in 24x7 high-

availability production database systems with high-volume of transactions in a fast-paced environment

• Adept at maintaining overall health of large and complex database systems that consist with about 4000

production and non-production SQL servers databases and 250 Oracle databases.

• Great communication and interpersonal skills and ability to work directly with business/applications users

and all levels of staff and management.

• Strong ability to cultivated professional relationships with vendors, clients, business, IT personnel, and

various departmental staff.

• Self-motivated and demonstrated the ability to work with minimum directions, meet aggressive deadlines

and juggle multiple and changing priorities.

EDUCATION

M.S. in Computer Science, Distinguished Graduate, DePaul University, Chicago, Illinois, 2002

M.A. in Philosophy, Peking University, Beijing, China, 1998

B.A. in Philosophy, Inner Mongolia University, Huhhot, China, 1995

CERTIFICATE

Implementing a Data Warehouse with Microsoft SQL Server 2012 Oracle 11g: RAC and Grid Infrastructure Administration

Maintaining a Microsoft SQL Server 2008 Database Oracle Database 11g: Administration Workshop I

SQL Server 2005: Performance Tuning & Optimization Oracle Database 11g: Administration Workshop II

SAP Hana In-Memory Database Oracle Database 10g: Administration Workshop II

ITIL Version 3 Foundation Examination Global IT Management Fundamental Training

Cloudera Administrator Training for Apache Hadoop Cloudera Data Analyst Training: Using Pig, Hive, and

Impala with Hadoop

TECHNICAL SKILLS

Database: MS SQL Server 2000, 2005, 2008, 2008 R2, 2012 stand-alone and clustered instances, OLTP &

OLAP maintain and support, VLDB, High Availability, Alwayson, Replication, Log Shipping,

Database Mirroring, Backup and Disaster Recovery, Data Warehousing, MS SQL native and

LiteSpeed Backup/Restore, SQL Server Integration Services(SSIS), DTS, ETL, Reporting

Services(SSRS), Analysis services(SSAS), Notification Services(SSNS), T-SQL, Stored

Procedures, triggers, Data Modeling Design, Database Performance Tuning, SQL Performance

Dashboard, SQL Profiler, PerfMon, Idera Diagnostic/Compliance Manager, Embarcadero

Performance Center, Symentec I3, Red Gate SQL Compare, SQL Multi Script, Erwin, MS

Visio, MDM.

Oracle 8i, 9i, 10g, 11g, RAC, Exadata, SQL *Plus, PL/SQL, *Net, Net8, SQL *Loader,

Import/Export, RMAN, AWR, FailSafe, OEM, Grid Control, Sybase, Cache.

OS and Software: Windows Server 2003, 2008, 2008 R2, UNIX AIX, Solaris, RedHat Linux, SAN, VMware,

RAID, SharePoint, SCOM, Tivoli Storage Manager, EMC Avamar, PeopleSoft Financial/HR,

BizTalk, Toad, Putty, CVS, Crystal Report, ServiceNow, Remedy, ER/Studio, ErWin, Exalogic,

Tomcat, WebLogic, Exalogic, Symentec NetBackup, Autosys.

Languages: ASP.Net, C#.Net, VB.Net, C/C++, Visual Basic, Java, Perl, JavaScript, CSS, ASP, HTML,

XML, XSLT.

PROFESSIONAL EXPERIENCE

Database Administration Manager 6/2013 – present

Hospira, Inc., Lake Forest, Illinois

Hospira is the world's largest producer of generic injectable pharmaceuticals, whose products are used by hospitals

and alternate site providers, such as clinics, home healthcare providers and long-term care facilities. Worldwide

sales in 2014 were approximately $4.3 billion.

• Manage 4 teams and total 12 direct reports consists with Database Administrators, Middleware Administrators,

Solution Architects, Web Developers and Web Administrators onsite and offshore, managed resource demand

and capacity and successfully achieved 100% delivery of all business critical and infrastructure projects on time

and within budget every year while driving operational excellence with flawless production support.

• Led web development on Hospira Web Globalization project and successfully launch Hospira 10 country sites

and bunches of microsites and desktop websites for IV pump devices and newly released drugs like Precedex,

which is Hospira’s single highest source of revenue globally (11%).

• Trued up the licensing for approximately 4,200 Oracle and SQL Server database; consolidated and

decommissioned inactive databases and thus saved approximately $400,000 on database, monitoring and

backup software licensing and storage.

• Led the database monitoring project and successfully planned and deployed Hospira in-house monitoring

solution to monitor 4,200 production and non-production databases within 50% of planned time, which not only

saved $300,000 monitoring tool licensing cost but also improved the monitoring quality with more accurate

alerts and thus mitigated risks.

• Developed strategies and provided architectural solutions to build comprehensive data warehouse for enterprise

wise application data archiving; o ptimized BI ETL processes, designed and built staging and data warehouse

databases; designed and implemented SSIS Packages to automat data collection and loading for tracking

Hospira finished goods inventory and significantly reduced the data loading activity from 24-48 hours to few

minutes.

• Developed and maintained logical and physical data models from functional specifications, data requirements,

and business rules provided by clients; designed and implemented multiple phases of data warehouse with data

extracted from various OLTP systems like contract, rebate, medical device tracking and management systems,

etc., transformed and loaded for a centralized pool of data to report from.

• Designed and built various OLTP\OLAP databases ensuring high availability, scalability, performance and

security like Business Object Data Service Tool, Sales Forces staging databases involved in pharmaceutical

drug global distribution; architected framework to provide data mart solutions on HR, complains, finance, and

risk analysis; designed data marts and cubes for all reporting efforts.

• Created, documented and standardized various database operation and support best practices, policies and

procedures like database build, Disaster Recovery, backup and refresh, patching, health check, auditing, etc. to

keep databases in compliance with IT policies.

• Provide technical expertise and defined strategic architectural design for miscellaneous large business and

infrastructure projects like Data Center Migration, Application and Infrastructure Service Provider Transition,

IT Service Management Tool Transition(from Remedy to ServiceNow), etc..

• Work with business users, application and project teams to gather data requirements, learn the application

process flow, define meta data and identify business rules and implement data rules, design and document

application data models; design standards for using normalized data structures, de-normalized structures, and

dimensional structures.

• Developed data governance process and controls and ensure compliance with enterprise data architecture

principles and standards for the various systems and components; d esigned and implemented data security

including encryption methods.

• Performed operation planning and governing, assessed current database and middleware system landscape and

constructed 5 year operation roadmaps to support business objectives; create database service catalog and model

to deliver world-class technology services to the organization.

• Identify opportunities to innovate, extend and enhance service delivery everywhere possible; keep current with industry

trends, evaluate new technologies and recommend appropriate solutions to support company products and services.

Data Architect\Sr. Database Administrator 12/2011 – 6/2013

Cancer Treatment Center of America, Schaumburg, Illinois

A national healthcare organization specializes in cancer treatment with personalized care model through its 5

cancer hospitals in suburban Chicago, Philadelphia, Atlanta, Tulsa, and suburban Phoenix.

• Developed logical and physical data modelling, performed database design, transforming and data loading

process; led, managed and deployed multiple business critical projects including building and implementing

new Data Warehouse systems and migrating them from SQL 2008R2 to SQL 2012; highly efficiently and

innovatively installed and configured 11 SQL 2012 servers in one week by automating the installation and

configuration process.

• Administer and support large and complex 24x7x365 high-availability production database systems consists

of 350 SQL servers plus 30 Oracle instances in a fast-paced multiple hospital environments; installed and

configured more than 50 stand-alone and clustered SQL and Oracle database servers; migrated and upgraded

numerous databases from SQL server 2000, 2005 to 2008R2 and 2012.

• Creatively architected and deployed an enterprise-wide electronic patient medical record database systems

across 5 major hospitals; built a complex 4 node Window cluster with 2 stand-alone SQL instances as

transaction server and 1 SQL cluster instance as reporting server for each hospital, which saving to the

organization about $750,000 on cost; upgraded and migrated database from SQL server 2008R2 to 2012 and

synchronized patient data between transaction and reporting server using Windows clustering and SQL Server

2012 AlwaysOn.

• Successfully delivered multiple Oracle database projects for HR\Payroll ahead of time thus making up for

the delay caused by other departments; installed and configured Oracle Disaster Recovery database servers for

corporate HR\Payroll database system successfully; duplicated the production databases as a standby databases

using RMAN.

• Actively involved in building DBA team and played a key role in hiring, training, motivating and

supervising new and junior team members by providing directions, leading and managing projects, setting goals

and priorities, and building and maintaining standards; provided extensive technical and strategic advice and

guidance to senior managers and technical resources and ensured project adherence to company wide data and

database standards and policies.

Data Architect\Sr. Database Administrator 05/2011 – 12/2011

Follett Corporation, River Grove, Illinois

A bookstore provider with $2.7B revenue manages more than 900 bookstores nationwide and provides

management systems, support services, and textbooks to over 1,800 independently managed bookstores.

• Led and managed large and complex Higher Education group Data Warehouse database system upgrade

that involves seven database servers and all SQL Server components including SQL Engine, Analysis Server,

Reporting Server and Integration Server; acted as all around player as database administrator, system analyst

and project manager by evaluating hardware and software requirements, creating upgrade plan, monitoring

project process and timeline and implementing the actual upgrade.

• Architected and implemented new data structures and attributes, transformed and loaded data into corporate

Data Warehouse; provided architectural solutions and performed data integration from miscellaneous data

sources into shared databases; reviewed and enhanced CRM data models by providing feedback regarding good

modeling practices; delivered complete database solutions for new higher education database sub-systems.

• Performed high-level design of large database systems and led DBA team to deliver large projects;

maintained and supported 200 plus SQL Server 2000, 2005, 2008 and 2008 R2 stand-alone and clustered

instances and 30 Oracle 9i, 10g, 11g instances on Windows and AIX UNIX in a mixed OLTP and data

warehouse environment; provided development support for in-house applications and vendor products.

• Created and established standard of operating procedures for database support and monitoring; adopted and

implemented industry best practices; coached, mentor and facilitated junior team members’ growth and

professional development; interacted with cross-functional team and served as liaison to the business for DBA

team.

Database Administrator 12/2006 – 04/2011

Career Education Corporation, Schaumburg, IL

A Fortune 1000 company, as a world's leading provider of post-secondary educational services, offers doctoral,

master’s, bachelor’s, and associate degrees to approximately 90,000 students across the world in a variety of

career-oriented disciplines through its more than 75 located throughout the world.

• Developed, deployed, maintained and troubleshot many SSIS packages for the enterprise data warehouses and

online reporting systems; designed, tested and implemented High Availability and Disaster Recovery for

production and non-production environment with Transactional Replication, Log Shipping and Database

Mirroring; numerous experience in replication rebuild and troubleshooting for enterprise application releases

and database patches.

• Sufficiently architected, planned and migrated several large and mission-critical transactional and reporting

production databases from SQL Server 2000 to 2005 and gained Blue Train high performance award; played a

key role in enterprise-wide largest database infrastructure re-architecture, upgrade and data migration from SQL

Server 2005 to 2008R2 as well as SAN upgrade and Unisys server replacement.

• Developed standards, procedures, guidelines, and processes to enable the integration of multiple source

databases of enterprise data warehouse; and providing DBMS platform technology recommendations to all major

projects; proactively performed database monitoring, auditing and reporting; established standard operation

procedures and best practices on database operation and installation; inventively automated SQL agent job

failure monitoring and notification and change control tracking by developing and deploying daily reports using

SSRS.

•Administered and maintained overall health of 70 plus production database servers and 200 plus development, test

and QA database servers with every feature set of SQL Server including High Availability, Transactional

Replication, Log-Shipping, Database Mirroring, Disaster Recovery, Data Warehouse, Backup and Recovery,

Integration Service, Reporting Services and Analysis Services.

• Extensive experience in SQL server 2000, 2005, 2008 stand-alone and cluster installation, configuration,

upgrade, and maintenance; efficiently completed complicated SQL 2005 5-instance on 3-node cluster installation

and databases migration for corporate email archiving project; productively fulfilled multiple urgent requests on

SQL 2005 and 2008 cluster installation with very short notice and received compliments from the application

owners.

• Innovatively developed and implemented dual backup strategies using LiteSpeed new features to satisfy business

needs which significantly reduced the daily data loading time for the university group’s data warehouse;

creatively simplified and improved the security restoring of 200 database refreshes in non-production

environment to achieve centralized and dynamic management; significantly improved database refresh reliability

by adding failure detection mechanism and email notification features.

Database Administrator 06/2004 – 12/2006

Kingsway Financial Services, Inc., Elk Grove Village, Illinois

Kingsway provides nonstandard automobile insurance, personal and commercial lines property and casualty

insurance through its 5 subsidiaries in the United States and Canada.

• Administered 4 production, 10 plus development and test SQL Server and Oracle database systems;

provided consistent 24x7 support to production database systems; installed, configured, managed and supported

Oracle 9i, 10g, SQL Servers 2000 and 2005 clustered and non-clustered instances in a SAN environment.

• Thoroughly evaluated and consolidated the various existing database systems and achieved improved data

integrity and eliminated redundant data thereby saving thousands of dollars in annual cost; provided valuable

and fundamental information for building future database systems.

• Successfully migrated production databases from Oracle 10g to SQL Server 2005 using SSMA; p erformed

extensive and various data migration between Oracle servers, from Oracle to SQL Server and the other way

around; created numerous knowledge based articles and detailed project plans.

• Tuned database servers and optimized queries and stored procedures; proactively monitored and analyzed

the server load with in-house applications; assisted the development team to identify the performance

bottlenecks in database, OS and network.

Database Administrator/Consultant 04/2004 – 06/2004

Sylogex, Inc., Des Plaines, Illinois

An IT consulting firm that specializes in industry-specific solutions, strategic outsourcing, wireless deployment

and integration services.

• Efficiently migrated SQL Servers 2000 databases from one healthcare practice management system to another

and ensured the integrity and quality of enterprise data; implementation yielded substantial cost savings.

• Performed administration, monitoring and support to the migrated databases; designed lots of databases, tables,

stored procedures, views and functions; documented the database architecture and maintenance procedures.

Database/Web Developer/Consultant 11/2003 – 01/2004

Sabio Academy, Schaumburg, Illinois

An academy School specializes in teaching, via the Internet, competition level Math and Science to middle and

high school age students.

• Successfully redesigned and implemented the client’s academic web sites, which enabled more timely

updates; installed, configured and maintained the back-end MS SQL Server 2000 databases; created SQL Server

DTS packages to export and import data from various source to SQL Server.

• Evaluated existing data model and redesigned the database structure to stay current with the client’s

business requirements; created and modified numerous SQL agent jobs and monitored disk space usage;

developed database security policies to ensure proper level of user access.

Database Developer/Consultant 08/2002 – 12/2002

Motorola Inc., Schaumburg, Illinois

A Fortune 100 company with global presence and impact provides wireless and broadband communications

products and services to enterprises and governments as well as delivers personalized information to consumers

both in the home and on the go.

• Developed database applications populating data from flat files to MS SQL Server databases using T-SQL

and VC++ for the client’s web-based training events; p erformed installation, configuration and maintenance of

SQL Server 2000 production database servers.

• Developed and maintained the client’s database-driven e-learning website that provided on-line

multimedia training efficiently and inexpensively; trained coworkers on database administration, web

development, GUI design and implementation.

Contact this candidate