AddThis Social Bookmark Button
Wayne Xin
Buffalo Grove, IL - 60089 USA
Expertise :Dataguard, RMAM, Tuning
Status :
Job Type :
Permanent
Position :

Resume
 

Objective
OBJECTIVE To pursue a full-time position that requires strong knowledge and experience of
Oracle Databases Administration

SUMMARY
Over eight years of extensive professional experience as an Oracle Database
Administrator in RDBMS
Highly experienced in Oracle Database design (physical/logical), application
development, RMAN backup/recovery, DataGuard, RAC, Disaster Recovery,
tuning, documentation, and PeopleSoft Financials/HRMS
Strong skills in Oracle/UNIX(Sun Solaris/AIX)/SQL/SQL*PLUS/Unix Shell Script
Highly self-motivated and possesses strong technical/analytical/troubleshooting
skills
One of the first 500 OCP(Oracle Certified Professionals) worldwide
Energetic, hard-working, fast-learning, easy-going, and an excellent team player
Excellent oral and written communication skills

CERTIFICATE Oracle Certified Database Administrator(OCP).

SKILLS Operating Systems: SUN Solaris, AIX, HP-UX, WINDOWS 95/2000/XP/ NT4.0,
MS-DOS
Languages: SQL, SQL*Plus, PL/SQL, Pro*C, C/C++, Unix Shell Programming,
Visual Basic, Powerbuilder, HTML, FORTRAN, awk
Databases/Tools: Oracle7/8/8i/9i/10g, SAP, RMAN, DATAGUARD, RAC,
STATSPACK, 9iAS, ETL, SQL*Loader, Oracle Enterprise Manager,
SQL*Net, Net8,Oracle Server Manager,TOAD, SilverRun, ERwin,
PeopleTools, Patrol, Cayenne Software, Quest tools, Developer/2000(Forms
4.5, Reports 2.5), Microsoft Access, Powerpoint, Excel

EXPERIENCE CHICAGO BOARD OF TRADE, Chicago, IL
07/2002-Present Sr. ORACLE DBA
Participated in full multiple project life cycles to design relational database system
including OLTP/very large Data Warehouse production databases
Supervised the design and maintenance of database structures
Designed and converted logical design into physical database, planned
database capacity, implemented, and supported the enterprise database architecture
Planned, coordinated, and implemented Oracle software/patches installation
and Oracle database migrations/upgrades
Developed, implemented, and documented the cold/hot/RMAN backup/recovery,
and disaster recovery strategies for corporate database environments
Developed, documented, maintained, and enforced the policies and procedures
designed to ensure the integrity of database environment, including change
control, user access, promotion path requirements, refresh and purging strategies,
and security policies


Wayne Xin
Page 2
Implemented and maintained Data Guard, RAC, 9i AS, and RMAN backups
Proactively monitored, analyzed, and tuned (parallel) queries, applications, and
production databases
Supported PeopleSoft Financials, HRMS databases, People Tools upgrades,
Database clones, and daily changes
On called and supported 24X7 production trading databases
Managed and supported testing, development, QA, and highly available
OLTP/OLAP/DSS and Data Warehouse production databases
Wrote proposals and technical documents, backup, statistic analysis, and export
Unix shell scripts, and DBA utility packages and procedures
Provided support to the project teams
Participated in the evaluation and recommendation of DBA tools and new DBMS
technologies
Configured Patrol monitoring tools and OEM

08/1999-06/2002 WHIRLPOOL CORPORATION, Benton Harbor, Michigan
Sr. ORACLE DBA
Joined the Oracle Database Management group at the headquarter of Whirlpool Corporation, the worlds leading manufacture and marketer of major home appliances and was responsible for the following:
Participated in database architecture development, database design
(physical and logical), engineering, and sizing
Installed, configured, upgraded, migrated, maintained, administered Oracle7,
8, and 8i database servers and clients
Developed, managed, and maintained hot/cold database backup and recovery
procedures
Managed and maintained database replication between primary and secondary
data centers
Provided troubleshooting and technical support to application groups and database
users
Assisted web and system groups to design, develop, manage, and maintain
internet/intranet and its associated back-end databases
Supported Peoplesoft FLS reporting and billing payroll database system
Maintained, monitored, troubleshot, and supported about forty Oracle Databases
running on Unix and NT
Evaluated security policy and made recommendations based on business and
functional requirements
Designed, implemented, and maintained database related internet/intranet
projects (Dealer Storefront, Employee Purchase, Telescope, and Whirlpool &
Kitchenaid, etc.)
Rotated on-call and proactively monitored, tuned, and troubleshot databases
Involved in providing enterprise wide backup and disaster recovery process and
methodology
Wrote shell scripts used to backup(disk-disk, disk-tape), restore(tape-disk), and
monitor storage
Documented standards and procedures, and trained junior DBAs and developers
Strong SQL, PL/SQL, and Shell programming writing skills

Wengui Xin
Page 3
09/1998-07/1999 CDNOW Inc. Fort Washington, Pennsylvania
ORACLE DBA
Joined the database management group and was responsible for managing test and production databases running on Unix. Responsibilities were as follows:
Participated in database logical design and implemented physical design
Created, relocated, maintained, migrated, and upgraded databases
Managed database space requirements and conducted capacity planning
Provided 24/7 support to production databases
Provided database expertise to development teams
Analyzed operational efficiency of applications using database softwares
Managed database security and data integrity, enrolled users, created roles,
profiles, and assigned privileges
Created and managed tables, indexes, views, schemata, synonyms, sequences,
database links, and snapshots
Utilized ORACLE utilities: Import/Export, SQL*Loader
Designed, implemented, and maintained database backup and recovery strategies
Performed database and application tuning using SQL*Trace, TKPROF,
EXPLAIN PLAN, memory, and disk contention tuning
Wrote shell scripts for automatic backups and routine processes

01/1998-08/1998 MACROSOFT Inc. Consulting, Parsippany, New Jersey
ORACLE DBA AT&T, Shorthills, New Jersey
Supported production and development database systems of an OracleHOLOS
project for an online Customer Information Service running on Unix
Designed and performed backup(hot/cold) and recovery procedures
Optimized database performance, maintained system security
Analyzed and allocated tablespaces, managed data files, rollback segments
Assigned privileges, enrolled users, created roles, controlled and monitored user
access to the databases
Performed database, application, memory, and disk contention tuning
Created and managed tables, indexes, views, schemata, synonyms, sequences,
functions, procedures, triggers, and packages
Wrote shell scripts to perform physical, logical backups, and other routine
Processes
01/1994-12/1995 Stevens Institute of Technology, Hoboken, New Jersey
Graduate Research Assistant
Designed a computerized model (One/Two-Dimensional Transport Model) related to
contamination scenario with various groundwater transport mechanisms using C++
Language. Conducted U. S. Department of Energy Project: Stabilization
/Solidification of Heavy-Metal Contaminated Soils. Duties involved: Specimen
Preparation, Leachability Testing, Hydraulic Conductivity, Samples Analyzing,
TCLP, Data Reduction. Instructed undergraduate students and high school students in
batch adsorption tests. Trained and supervised new employees.
Summer 1995 Metropolitan Laboratories, Inc. ,Norfolk, Virginia
Data analyst/Software Engineer, Summer Internship
Designed and implemented Access database to store information about samples and
analytical data
Wrote a program to calibrate the analyses result accuracy
Wengui Xin
Page 4
01/1982-07/1991 Shenyang Research Institute of Foundry, Shenyang, China
Foundry/Software Engineer
Simulated and modified the molten superalloy solidification situation for blade by computer programming.
Designed and implemented database for Foundry factories, Customers, castings, and Foundry materials
Took charge of the development of a new superalloy used for jet blade of airplane engine.
Developed the directional solidification/single crystal solidification technology of precision investment casting for this superalloy.
Organized and sponsored The World Foundry Products and Information Exhibition
Edited and published The world Foundry Directory book

EDUCATION Master of Science in Computer Science Dec. 1997
Stevens Institute of Technology, Hoboken, New Jersey
Master of Engineering in Environmental Engineering Dec. 1995
Stevens Institute of Technology, Hoboken, New Jersey
Bachelor of Science in Materials Science and Engineering Dec. 1981
Northwestern Polytechnical University, Xi'an, China
POST-GRADUATION TRAINING
SAP Training Center, MicroTek, Oakbrook, Illinois
ADM100
Peoplesoft training, Westchester, Illinois
PeopleTools I (PeopleSoft PeopleTools 8.1.8)
Peopelsoft Server Administration (PeopleSoft PeopleTools 8.18)
Oracle Corporation Training Center, New Jersey
Introduction to Oracle: SQL and PL/SQL
Database Administration workshop
Backup and Recovery workshop
Performance & Tuning workshop
Oracle Corporation Training Center, Chicago
Oracle8, 8i, and 9i New Feature for Administrators
Oracle8 & 8i Backup and Recovery workshop
Oracle 9i Data Guard Administration
Oracle 10g New Features for Administrators
IBM Education center, New York
DB2/UDB Administration workshop for Unix
Advanced Interactive Technology, New York
Visual Basic5.0
MS SQL Server6.5
Window Architecture

INTERESTS Reading, Swimming, Ping-pong, Basketball, Tennis

PERSONAL: US permanent resident

REFERENCES: Available upon request



Employment

2002 -  Present
Senior ORACLE DBA

EXPERIENCE CHICAGO BOARD OF TRADE Chicago , IL Senior ORACLE DBA

Participated in full multiple project life cycles to design relational database system

OLTP,
large Data Warehouse production databases

Supervised the design and maintenance of database structures

Designed and converted logical design into physical database, planned

database capacity, implemented and supported the enterprise database architecture

Planned, coordinated and implemented Oracle software, patches installation

and Oracle database migrations, upgrades

Developed, implemented and documented the cold, hot, RMAN backup, recovery

and disaster recovery strategies for corporate database environments

Developed, documented, maintained and enforced the policies and procedures

designed to ensure the integrity of database environment, change

control, user access, promotion path requirements, refresh and purging strategies

and security policies

Wayne Xin

Page 2

Implemented and maintained Data Guard, RAC, 9i AS and RMAN backups

monitored, analyzed and tuned query, application, and production databases

Supported PeopleSoft Financials, HRMS databases, People Tools upgrades

Database clones and daily changes

On called and supported 24X7 production trading databases

Managed and supported testing, development, QA and highly available

OLTP, OLAP, DSS and
large Data Warehouse production databases

Wrote proposals and technical documents, backup, statistic analysis and export

Unix shell scripts and DBA utility packages and procedures

Provided support to the project team

Participated in the evaluation and recommendation of DBA tools and new DBMS

technologies


1999 -  2002
Senior ORACLE DBA

WHIRLPOOL CORPORATION Benton Harbor , Michigan Senior ORACLE DBA

Joined the Oracle Database Management group at the headquarter of Whirlpool Corporation, the worlds leading manufacture and marketer of major home appliances and was responsible for the following :
Participated in database architecture development, database design

physical and logical, engineering and sizing

Installed, configured, upgraded, migrated, maintained, administered Oracle7

8 and 8i database servers and clients

Developed, managed and maintained hot, cold database backup and recovery

procedures

Managed and maintained database replication between primary and secondary

data centers

Provided troubleshooting and technical support to application groups and database

users

Assisted web and system groups to design, develop, manage and maintain

internet, intranet and its associated back end databases

Supported Peoplesoft FLS reporting and billing payroll database system

Maintained, monitored, troubleshot and supported about forty Oracle Databases

running on Unix and NT

Evaluated security policy and made recommendations based on business and functional requirements

Designed, implemented and maintained database related internet, intranet

projects Dealer Storefront, Employee Purchase, Telescope and Whirlpool and
Kitchenaid, etc.

Rotated on-call and monitored, tuned and troubleshot databases

Involved in providing enterprise wide backup and disaster recovery process and methodology

Wrote shell scripts used to backup, restore, and monitor storage

Documented standards and procedures and trained junior DBAs and developers

Strong SQL, PL/SQL and Shell programming writing skills

Wengui Xin


1998 -  1999
ORACLE DBA

Page 3 CDNOW Inc Fort Washington , Pennsylvania ORACLE DBA
Joined the database management group and was responsible for managing test and production databases running on Unix. Responsibilities were as follows :
Participated in database logical design and implemented physical design

Created, relocated, maintained, migrated and upgraded databases

Managed database space requirements and conducted capacity planning

Provided 24/7 support to production databases

Provided database expertise to development teams

Analyzed operational efficiency of applications using database softwares

Managed database security and data integrity, enrolled users, created roles

profiles and assigned privileges

Created and managed tables, indexes, views, schemata, synonyms, sequences

database links and snapshots

Utilized ORACLE utilities : Import, Export, SQL*Loader

Designed, implemented and maintained database backup and recovery strategies

Performed database and application tuning using SQL*Trace, TKPROF

EXPLAIN PLAN,
memory and disk contention tuning

Wrote shell scripts for automatic backups and routine processes


1998 -  1998
ORACLE DBA

MACROSOFT Inc Consulting Parsippany , New Jersey ORACLE DBA AT and T Shorthills , New Jersey
Supported production and development database systems of an OracleHOLOS

project for an online Customer Information Service running on Unix

Designed and performed backup and recovery procedures

Optimized database performance, maintained system security

Analyzed and allocated tablespaces, managed data files, rollback segments

Assigned privileges, enrolled users, created roles, controlled and monitored user

access to the databases

Performed database, application, memory and disk contention tuning

Created and managed tables, indexes, views, schemata, synonyms, sequences

functions, procedures, triggers and packages

Wrote shell scripts to perform physical, logical backups and other routine


 - 


 - 




Education

Master of Science in Computer Science
Stevens Institute of Technology, Hoboken, New Jersey

Master of Engineering in Environmental Engineering
Stevens Institute of Technology, Hoboken, New Jersey

Bachelor of Science in Materials Science and Engineering
Northwestern Polytechnical University, Xi'an, China



Miscellaneous
POST GRADUATION TRAINING

SAP training

ADM100

Peoplesoft training, IL

PeopleTools I

Peopelsoft Server Administration

Oracle Corporation Training Center, New Jersey

Introduction to Oracle : SQL and PL/SQL

Database Administration workshop

Backup and Recovery workshop

Performance and Tuning workshop

Oracle Corporation Training Center, Chicago

Oracle8 8i and 9i New Feature for Administrators

Oracle8 and 8i Backup and Recovery workshop

Oracle 9i Data Guard Administration

IBM Education center, New York

DB2, UDB Administration workshop for Unix

REFERENCES : Available upon request.





Quick People Search



People like Wayne

Popular skills