Manager Oracle
Resume:
Boyu Huang
East Brunswick, NJ 08816
Permanent Resident
*********@*****.***
OBJECTIVE:
Oracle OLTP/OLAP DBA with 9+ Years Hands-On Working Experience.
CERTIFICATION:
Oracle 7, 9i, and 11g Certified Professional
WORK EXPERIENCE:
Large Financial Information Service Company Oracle DBA New York, NY
Nov/2008 – Present
Manage and Develop databases support Muni bond information systems.
Upgrade Oracle 10g to Oracle 11g. Setup Data guard, RAC and Grid control.
Migrating legacy Informix Database to Oracle Database. Work with developers to convert ESQL/C
to ProC and Stored Procedures.
CBS Interactive
Sept/2007 –Nov/2008 Senior Database Administrater New York, NY
Manage and Support (On Call) Company’s data warehouse with size ~3 TB, as well as
cbssports.com cbsnews.com, Startrek.com, Showtime.com. User management and database
security policy enforcement. Physical database design and object management. Physical database
design and object management. Performance tuning and storage management. Advance database
replication and high availability solutions. 24 X 7 support for production database systems. Code
development and support. Platform based database design services. Participate in strategic
architecture planning for global technology trends. Backup and disaster recovery planning. Support
and implement IT Controls. Auditing and SOX support as required. Provide end user support as
needed. RMAN incremental backup, Data Guard, ASM, Oracle RAC, MySQL, SQLServer2005.
Credit Suisse
Nov/2005 – Sept/2007 Corperate Data Manager (DBA/Developer) New York, NY
To manage Corporate Services Data warehouse and application Databases including backup and
recovery, performance tuning, and upgrade(Oracle 10g RAC grid on Linux and Solaris). To
enhance and maintain the contents and structure of the Corporate Services Databases including
Real Estate, Security, Critical Engineering, Archives & Records Management and many other
critical support operations' data. To ensure the accuracy and integrity of the data has increased.
Design, develop and enhance database in order to support CSD applications. This includes
analyzing data requirements, relationships for proper data model and schema design. Create
materialized views as well as create and support batch functions for data distribution to support
other systems and data repositories in the Bank. Generate ad-hoc files to support one-off data
requests. In addition, perform data consolidation, conditioning and integrity check functions to
ensure that the quality of the data content in the CSD databases is kept at the highest level. Support
all other data, database and MIS reporting related tasks. Draw technical expertise from and share
knowledge with other members of the Information Management, Interactive Media Technology,
CAD and CAD/Occupancy teams.
Martha Stewart OmniMedia
April/2004 – Nov/2005 Sr Database Architect and Administrator New York, NY
Responsible to set end-to-end vision of the Company enterprise database layer and to define how
logical design will translate into one or more physical databases, and how the data will through the
successive stages involved. Support issues with data migration(validation, cleanup, and data
mapping). Design oracle database,develop and administrate various environments including OLTP,
24x7 e-commerce and data warehousing (Oracle8i, 9i and 10g RAC). Strong knowledge of SQL,
PL/SQL. Coordinating the efforts of all the database issues with web development team, web
operations team and management service provider in maintaining development and production
databases. Responsible in developing various reports using SQL and XML technologies. Develop
and maintenance of data marts (>1.2 TB) using E.Piphany software. Upgrade oracle 8i to 9i and
10g using verious methods. RMAN backup and recovery. Data Guard and Oracle Stream
configuration and maintainace. Great experience working with Solaris9 and LinuxAS 3, Veritas
Cluster Service.
Outcome Inc
May/2003 – April/2004 Production Services Engineer Boston, MA
Daily production support activities, including trial loading, data extracts, and server recycles.
System administration and monitoring. Software script development. Performance tuning and
troubleshooting. Software installation, Oracle installation and network troubleshooting. Database
management of clustered databases in a RAID environment. Database administration on Oracle
database (RAC) residing on LINUX servers (AS2.1) for transactional and reporting applications.
Data Guard configuration and implementation. Performance tuning database and application with
sql trace, tkprof, statspack. Installation of system upgrades. Management of physical disk resources.
Management of manual and automated data backup and recovery procedures. Data integrity
monitoring and management. Apply patches to servers and databases. Management of security and
integrity controls. Implement physical and electronic redundancy safe guards for the databases and
systems. Develop job queues, monitoring procedures and systems, communication daemons, job
scheduling systems and other services. Assist with resolving performance-tuning issues. Provide
off-hours support for production servers.
Marcel Dekker Inc. (Publisher)
April/2000 May/2003 Oracle DBA New York, NY
Participated, as the only company DBA, in entire life cycle of developing company new website
project that publishes contents (Journals, Books and Encyclopedia) online. Manage Company
production databases, OLAP data warehouse database and testing databases. Closely work with
developers and act as expert technical resource to development staffs in all phases of the
development and implementation process.
Install, upgrade and apply patches for Oracle 7.4.3, Oracle 8.05, Oracle 8i and Oracle 9i as well as
SQL Server6, 7 and 2000. Database Migration from Oracle 7 to Oracle 8i and from Oracle 8i to
Oracle 9i. Create and maintain Databases; Manage users, Managing tablespaces, disk storage,
transition data.
Enforce database security and Audition: Controlling access with roles and views. Defining system
and object privileges. Limiting resource usage with profiles. Authenticating with password aging.
Fine grained access control (VPD). Setup audition on login attempts, object accesses, and database
actions.
Data Modeling: Logical and Physical design of Oracle database based on business requirements
using Erwin. Capturing entities and attributes. Describing relationships. Documenting the changes
and maintaining the versions of E-R diagrams. Forward and Reverse engineering.
Data Warehouse: Dimensional Modeling, Create, Manage and Optimize data warehouse.
Developing data transformations, mappings, and business rules. Perform and monitor routine ETL
process using Informatica to load and transform data from web logs, files and various databases
into data warehouses for data mining. Scripting and Loading data using SQL Loader. Create
Materialized views and Partition tables.
Install and Manage Microstrategy Intelligence Server. Generate reports, templates from data
warehouse using Microstrategy Web and Desktop application (up to version 7.2). Microstrategy
NarrowCast. Implement Microstrategy objects such as attributes, facts, hierarchies and metrics that
conform to the dimensional and Denormalized data models present in the OLAP schema of an
enterprise data warehouse. Generate reports from data warehouse database, Define Microstrategy
prompt, filter, template, consolidation and custom group objects in an enterprise data warehouse
team environment. Great experience (2 years) in Cognos Impromptu and Power Play reporting.
Strong Oracle application development skills (5 years) including creating SQL/PLSQL, Triggers,
Packages, Functions, Stored Procedures, Autonomous Transactions and using oracle building-in
packages.
Pro-active High Performance Tuning: Tuning Application design, effective table design, using
bind-variables, stored procedures. Tuning SQL, generating Explain Plans, SQL_Trace, evaluating
index usage. Using STATSPACK utility to gathering statistics and monitor the database
performance. Tuning memory usage with, cache frequently accessed tables, pin packages in
memory, reducing I/O with multiple buffer pools, monitoring latch contention. Tuning data storage,
monitoring tablespaces and tables usage, defragmentation of segments and identifying chained
rows.
Perform routine Logical and Physical (hot and cold) backup using shell scripts and Recovery
Manager (RMAN). Restore and Copy/clone databases to any location and any specific time.
Perform necessary Database Recovery using RMAN or OS backup sets. Quick disaster recovery
using Standby database/Data Guard. Database Replication using oracle replication manager.
Strong Unix shell, Perl scripting and cronjob in automation of maintaining and monitoring
databases and operation systems. JDBC, SQLJ, DBD and DBI.
Expert in using Oracle Enterprise Manager whole package.
Experience in Oracle 9iAS. Oracle Intermedia. Weblogic. Oracle Portal. SQL Server6, 7 and 2000.
Network in Unix, Configuring Client-Server Environments. MTS configuration. SQL*Net V2 and
Net8, using the Net8 Assistant.
Server Platforms: SUN E4000, E450, IBM AIX RS6000, Window NT and 2000.
Enterprise Application Integrators, Inc
03/1997 04/2000 Oracle DBA/DEVELOPER/Solaris SA New York, NY
Work as both Oracle DBA/Developer and Solaris System Administrator. Manage company
production and develop databases. Administrate Solaris servers.
As an Oracle DBA/Developer:
Install, apply and maintain patches on Oracle databases and Solaris servers.
Work as a SQL Developer to create packages, procedures, functions, triggers, using oracle
building-in packages. Load data using SQL Loader.
Logical and Physical design of Oracle database based on business requirements using ERwin.
Create and maintain Databases; Manage users, Managing tablespaces, disk storage, transition data,
Database security.
Performance Tuning: Tuning Application design, tuning SQL with EXPLAIN_PLAN, Data storage.
Monitoring tablespaces and tables usage, generating statistics using SQL_Trace, TKPROF,
Utlbstat, Utlestat.
Performing routine Logical and Physical (hot and cold) Backup using shell scripts and cronjob.
Performing necessary Database Recovery, Recovery Manager. Expert in using ORACLE ENTERPRISE
MANAGER whole package.
As a Solaris SA:
Install Solaris, Manage Software and Backups. Performance Tuning Servers.
Managing User and Group Accounts. Monitoring User Activity, File and Directory Ownership,
Advanced file permissions.
Shell scripting. Automate administration tasks with scripts and cron.
Disk Configuration, Partition and Format, Veritas Volume Manager.
Internet addresses, executing remote commands: rcp, rsh, rlogin. Establishing trusted hosts.
Resolving hostnames with DNS.
File and print sharing. Configuring NFS, Configuring CacheFS. Setting up the Automounter.
NIS and NIS+.
JumpStart automatic installation.
Aparche Web Server. Samba.
SKILLS:
Languages: PERL5, SQL, PL/SQL, HTML, CGI, JAVA, C++
Database: ORACLE7.4.3, ORACLE 8i and ORACLE 9i, Oracle 10g Oracle Real Application
Cluster(RAC). SQL Sever 7/2000, Microstrategy 6/7, MS Access.
System: UNIX(Solaris 2.5, Solaris 2.6, 8), LINUX (AS 2.1), Windows NT, Windows2000
Hardware: AIX RS/6000, Sparc, Ultra Sparc, E4000, stations and Pentium Machines
EDUCATION:
Computer Courses:
1. Database Administrator and Developer
2. Unix System Administrator
Compu21 Consulting and Training Inc, Jan. 1996 Mar. 1997.
Ph.D in Biophysics SUNY at Brooklyn, NY 1997
B.S. in Biophysics, Sept. 1986.
Department of Biophysics, Fudan University, Shanghai, P.R.C.
Contact this candidate