Oracle Management

Michelle Yang

** ********* ******

Winchester, MA 01890

E_mail:*****@*******.***

Tel: 617-***-****

OBJECTIVE

To attain a Data/Database Architect position by continuous efforts and

dedication

QUALIFICATIONS

10+ years Oracle7/8x/9i/10g/11g Design, Development and Administration

experience with various platforms: AIX, HP-UX/Tru64, Sun Solaris,

Z/Linux, and Windows

< 10 years DBA/Architect experience in application and production

environment in various industries: Financial, IT management,

TeleCommunication and Software

< 4 years of Information/Data Architect and management experience in

OLTP transactional data model and Data Warehouse dimensional data model

systems

< In-depth knowledge and experience with Database Design and Data

Modeling

< Intensive experience in data definition, data quality control and

data security

< Solid experience in Oracle HA/DR solutions 9i/10g RAC and DataGuard

< Working knowledge of Sybase, MS SQL-Server, Progress and DB2

< Oracle Certified Database Administrator (OCP): Oracle 7/8/8i/9i

< Microsoft Certified Professional: MCP+Internet, MCSE

< Excellent Communication, Organizational and Interpersonal skills

< Motivated team player with strong analytical and problem solving

skills

EDUCATION

Jan. 2005 to May 2007 NorthEastern University

Master of Science majoring in Information Technology

Sept. 1991 to July 1995 The Union University

Bachelor of Engineering majoring in Computer and Application

EMPLOYMENT HISTORY

Jul. 2006 to now State Street Bank, Boston

Principle Database Architect

< Lead DBA as well as Data/Database Architect in Trading Services and

Research financial sector

< Involved in Logical/Physical design and data modeling to map the

logical business needs to the physical implementation of database

structure and schema

< Participated in the design of the Fixed Income Trading transactional

system(OLTP), staging DB and Research data warehouse (DW) dimensional

model

< Create transactional (3NF) data model for OLTP and start schema and

snow flake dimensional model in Database Warehouse environment

< Work with the business team to define data requirements and conduct

design and use case reviews with project team

< Define data access policies and enforce data security via data

encryption, data masking and VPD

< Lead the implementation of Oracle 10g RAC on VCS with Oracle 10g

dataguard to support High Availability and DR and establish Corp

deployment standards

< Perform database tuning, SQL tuning, table/index re-organization, CPU,

Memory, I/O tuning, database performance analysis and reporting

< Manage, prioritize tasks and delegate work to offshore database

support team

< Present project overview, status report and post-project review to

management team

< Work with technical, business and management team to ensure to follow

the enterprise procedures (change control, project management, best

practice, etc.)

Sep. 2004 to Jul. 2006 Iron Mountain, Boston

Sr. Database Administrator/Architect

< Technical Lead position in database management department

< Supported Multi-Terabytes Database and maintained Oracle eBusiness

Suite environment on various platforms

< Participated in the logical database design and the physical

implementations of the information management projects

< Lead Corp-wide database HA/DR solutions and security standards

< Led system backup tuning project in RMAN and Veritas Netbackup

environment, gained 300% backup performance

< Designed and developed RMAN web reporting system using Oracle HTML DB

< Configured performance monitoring tool VeritasI3 (Precise) and 10g OEM

to support database performance analysis and performed DB and SQL

tuning

< Implemented database security policy using database auditing and

shell scripts

Mar. 2001 to Sep. 2004 Rogers Communications Inc. Toronto

Sr. Database Analyst/Architect

< Worked as Apps/Prod DBA and Database Architect on the different

implementation and customization of projects in Telecom Industry

< Provided technical customer services for Wireless/Cable/Media clients

to meet their application/business and operational requirements

< Supported and managed 85 production/development databases (Oracle,

SQL-Server,

Sybase, Progress), which range from Gigabytes to Terabytes in size

< Installed and setup Oracle9i RAC in a cluster server environment for

database High Availability and Scalability

< Developed backup/restore/recover strategy and archive scripts and

implemented RMAN integrated with Veritas Netbackup

< Implemented EMC BCV Split Script to copy the image backup of

production database to Data Warehouse for historical data analysis

< Maintained/Managed DataMart using SAS solution and ETL to

extract/transform/ load data between OLTP system and DataWarehouse

< Designed Disaster Recovery solutions and documented Disaster Recovery

Plan, performed different restore/recovery scenario testing in DR

environment

< Mentored and collaborated with other project members to provide high

quality solutions and to tight delivery deadline and reduce Total Cost

of Ownership

Jul. 1995 to Feb. 2001 Daleen Technologies, Toronto, Ontario

Oracle Application DBA Software Configuration Management

< Designed and built databases for mission critical applications such as

web-based customer self-care, web-enabled partner management and

billing system.

< Configured and managed Oracle Database using Oracle Enterprise

Manager(OEM), RMAN, other tools such as TOAD, Web DBA, EMC DB-Tuner

< Managed System Security and controlled user access using roles and

privileges

< Designed and implemented database Backup-Recovery strategy to support

24x7 database availability

< Implemented performance tuning in the area of application SQL tuning,

oracle instance, memory tuning and disk I/O

< Developed stored procedures/database triggers for DBA purpose by using

DBMS packages, native dynamic SQL(oracle 8i)

< Generated and populated data for database scalability testing

Prominent Achievements

< Perfected almost all of technical features of the database internals

< Facilitated database tuning in different critical areas and achieved

substantial performance improvement

< Developed an archive of SQL and Unix Shell scripts to report database

activities and problems

< Exploited communication skills and problem determination skills

Oracle Developer/Project Lead

< Designed and implemented corporate intranet with Oracle Network

Computing Architecture(NCA) for internal information distribution and

workflow management

< By adopting the NCA, the system saved 80% of the resources and the

energy for maintaining clients, thus getting the utmost satisfaction

from users

TECHNICAL SKILLS

Operating System: IBM AIX, HP-UX/ HP Tru64, Sun Solaris 7/8/9/10,

Zlinux, Linux Red Hat 3, VERITAS Cluster Server, Windows NT/XP/2000

Database / Tools: Oracle RDBMS 7/8.x/9i/10g/11g, SQL-Server2000/2005,

Sybase ASE 11/12.5, Data Warehouse/DataMart, ODS, ERwin, IDEF,

Oracle9i/10g RAC, OEM, Oracle Streams, Dataguard, RMAN, Replication,

Symantec I3(Precise), DBArtisan, QUEST Spotlight/TOAD, Oracle HTML DB,

Oracle Designer/Developer

Networking and Storage: Client Network Computing Architecture(NCA),

Storage Area Netwrok/Network Attached Storage (SAN/NAS), EMC Symmetrix,

VERITAS VCS/VVR/Netbackup, EMC PowerPath, TimeFinder, SRDF Link

Language, Web and Application: SQL, PL/SQL, C, Pro*C, SQLJ, Java,

JavaScript, Perl, Unix Shell Scripting, SAS, HTML/XML, PeopleSoft HRMS,

Siteminder/LDAP, Websphere, HA/Failover, SAS Data Warehousing/ETL,

Informatica, DataFlux

PROFESSIONAL TRAINING

< Database design and management NorthEastern

University (2004)

< Dataware house design and BI NorthEastern

University (2005)

< Oracle10g Database New Features Oracle University,

Boston (2007)

< Project Management Basics Rogers

Communications Inc. (2004)

< Oracle9i Database New Features DesTech - Oracle,

Toronto (2003)

< Oracle Performance and Tuning DesTech - Oracle,

Toronto (2001)

< Veritas Netbackup for Oracle RMAN Veritas Software Corp

(2001)

< HP Posix Shell Scripting HP Canada

Education (2000)

< Oracle Database Administration Oracle University

(1996)

< Unix and Internet Configuration of Unix Orient E.I. Center

(1997)

< Sybase DB Administration & Backup Sybase Education (2004)

Contact this candidate