Oracle Data
Resume:
BRENDA CHEUNG
Chicago, IL, 60605
*********@*****.***
OBJECTIVE
An Oracle/Sybase Database Architect/DBA position specializing in database
architect, administration, performance tuning and Real Application Cluster
(RAC 9i,10g,11g).
SUMMARY
. Solid experience in Oracle/Sybase data architect, database
administration, logical/physical database modeling and design.
. Strong in detailed project planning and project management.
. Experienced project leader to utilize the latest technology and database
features to launch the projects successfully on time and on budget.
. Proven skill set in database and system architecture, capacity planning,
research, trend analysis, and problem solving.
. Designed, implemented, and documented logical and physical data models
using normalization theory, STAR schema design for trading floor,
administrative databases and Enterprise data warehouses (terabytes).
. Installed, upgraded, configured and administered OLTP and DSS database
management system.
. Heavily involved PL/SQL performance tuning and monitoring (Grid control,
TOAD, SQL scripts). Using analysis tools such as Explain Plan, ASH, AWR,
TKPROF to troubleshoot the performance issues and Oracle Hints to tune
the performance as necessary. With employment of different update
statistics techniques based on the applications requirements, the
significant performance improvement is always achieved.
. Composed detailed project plans for extensive upgrade or migration
projects.
. Performed capacity planning functions to determine future system resource
needs.
. Diagnosed and monitored databases performance and took proactive action
to minimize the problem severity.
. Planned the appropriate physical disks storage layout to gain optimal I/O
performance and fault tolerance.
. Used Oracle role-based security in database systems for applications
requirements and SOX compliances.
. Implemented database backup and recovery strategies for mission-critical
database systems.
. Developed and implemented database security models for test and
production systems.
. Researched and evaluated new technologies in database industry.
. Strong UNIX background and industrial experience in database management
systems.
. Provided 7x24 DBA support to Oracle/Sybase database servers.
. Experienced and excellent in project management, team player and good
communication skills.
SELECTED ACCOMPLISHMENTS
. Led the design and implement multi terabytes financial trading regulatory
data warehouse systems (RAC 10g on Sun Solaris and Linux platforms) using
dimensional data modeling techniques for end user reporting and analysis
applications. The Oracle features such as partitioning, sub-partitioning,
bitmap indexes, data compression, etc are employed for optimizing the
performance and data storage. In addition, several data mart systems were
built to support the regulatory data warehouse systems for end users
usage.
. Led the project to consolidate CBOT time and sales price data from
different data feeds, departments and hardware platforms to a centralized
Operational Data Store (ODS) System. This includes conducting the
feasibility study/survey from different groups and departments, data
modeling design, database system architect and HA technology chosen. The
whole system is implemented in Oracle RAC 10g, Web Logic & Oracle
Application Servers.
. Converted Order Routing floor trading system from Sybase to Oracle
database. Implemented and administrated the Credit Default Swap (CME &
Citadel joint venture CDS system) trading system on Sybase ASE 15.0.2
(Linux Red Hat platform).
. Migrated Oracle database systems from Solaris platforms to Oracle RAC10g
on Linux platform.
. Managed and supported the migration from Tandem Price system to new
ePRICE system, where the data is stored in Oracle Rac 10g database
servers on Solaris UNIX platform. This was part of the Tandem mainframe
decommission project, which saved the company millions dollars
maintenance license fee.
BRENDA CHEUNG, Page 2
SELECTED ACCOMPLISHMENTS (Continued)
. Implemented the eCBOT electronic trade handling system on Oracle RAC for
US and European markets. In addition to RAC HA solution for this trading
system, the Disaster Recovery database is employed with Oracle Dataguard
technology.
. Designed and implemented CBOT Order Routing Floor Trading system using
Sybase database system, MQ, Web Logic, C++, SUN cluster and First Watch.
Participated in application and data model design, database software,
hardware platform and HA solution chosen.
. Converted and upgraded Oracle 6i (client/server) reports/forms to
Internet Explorer browser based system via Oracle 10g Application
Servers.
. Migrated Patrol database monitoring tool to Oracle Grid Control
monitoring system for all Oracle development, QA and production database
servers
. Designed and successfully implemented the IE browser system for traders
and corporate staff to browse the current and historical commodity price
data anytime and anywhere via Oracle Application Servers.
PROFESSIONAL EXPERIENCE
Database Architect/DBA, CME GROUP/CHICAGO BOARD OF TRADE
Feb, 1994 - Mar, 2009
. Built multiple nodes RAC 9i,10g, 11g clusters for OLTP databases/Large
(terabytes) data warehouse (SUN Solaris & Linux) using (Automatic
Storage Management) ASM technology, and partitioned the applications/data
to optimize the database performance.
. Deployed RMAN with Veritas as the enterprise backup procedures for all
Oracle Database servers.
. Wrote test plans for QA group to test databases and applications
performance, to verify node to node Transparent Application Failover and
physical standby database switch over scenarios.
. Implemented Grid Control Oracle monitoring tool, BMC Patrol monitoring
tool for Oracle and Sybase, and CA Ecotools for Oracle and Sybase.
. Designed, implemented and supported Oracle/Sybase trading and
administrative systems (Order Routing, Trades Handling System, eCBOT
Price System, Office Investigation Audit (OIA) System, Matched Trade
System, etc). It includes OLTP database and Tera-scale data warehouse
. Converted data models from Oracle Designer to ERWIN.
. Upgraded and supported Sybase database servers from version 10 to 11.5,
11.9 and 12.5.
. Migrated Sybase database servers from Solaris 2.5 servers to new UNIX
servers running Solaris 2.9 version.
. Upgraded Oracle trading and administrative databases systems. The version
included Oracle 6 to 7, 8, 8i, 9i,10g and 11g. The upgrades covered RAC,
Dataguard Physical Standby databases and multi tetra bytes DSS database
systems.
. Tuned and resolved different Oracle/Sybase databases and applications
issues.
. Implemented SQL BackTrack tools to perform Sybase database servers'
backup and First Watch HA solution for Order Routing database systems.
. Wrote in house database monitoring tools using SHELL, PL/SQL, AWK and
Perl.
BRENDA CHEUNG, Page 3
PROFESSIONAL EXPERIENCE (Continued)
Senior Consultant(DBA/Developer), MOTOROLA
1993 - 1994
Senior Database & System Administrator, DEAN WITTER, 1992 -
1993
Senior Consultant(DBA/Developer), AT&T/BELL LAB
1991 - 1992
Database Administrator/Developer, MOTOROLA
1987 - 1991
EDUCATION
MS, Financial Market and Trading (Illinois Institute of Technology,
Illinois GPA - 3.7/4.0)
MS, Electrical Engineering and Computer Science (U of Illinois at Chicago
GPA - 4.72/5.0)
BS, Mathematics and Computer Science (U of Illinois at Chicago, GPA -
4.65/5.0)
TECHNICAL SKILLS
Oracle 6,7,8,8i,9i,10g,11g Sybase ASE
10,11.5,11.9,12.5,15
Oracle Parallel Server, RAC, HA First Watch
Hot Standby Solution
Hot/DR physical/logical Standby SQL Backtrack
Partitioning Unix Platforms: Solaris/Sun OS,
Oracle 10g Application Server/Forms/Reports Compaq Tru64/DEC
Grid Control, Oracle Enterprise Manager Unix Platforms
(32bits & 64bits):
Red Hat Linux, Solaris/Sun OS,
HP-UX
TOAD, BMC Patrol, CA Ecotools Languages: SHELL,AWK, SED, Vi,Perl,C
Parallel Query, SQL, PLSQL, SQL*Plus Windows NT/2000/Xp
Recovery Manager (RMAN). Data Guard, Ingres/Empress RDBMS
& 4GL
AWD, StatsPack, LogMiner, APEX ERWIN/Oracle
Designer Modeling Tools
Data Pump, ASM, CRS, SQL*Loader SQLServer
Import/Export Utilities, Oracle Application Server,
APEX, Data Warehouse, Informatica
Contact this candidate