Wen-Jin Zeng (Alex) Zhangjiang Hi-Tech Park, Shanghai, China
Mobile Phone: (86-136*-****-***
Email (MSN): abhz8j@r.postjobfree.com
Skype: hans9zeng AIM: alex9zeng Gtalk:
abhz8j@r.postjobfree.com
WORK EXPERIENCE
Jul. 2009 - eBay, US-invested company
Present Senior Oracle Database Administrator
. Administered 300+ production DB as member of SWAT DBA
. Upgraded 10+ Oracle DB from 9i to 10g
. Built 30+ physical standby and 3+ logical standby
. Cutover 30+ DB from primary to standby
. Review/Tuning SQL for application teams
. Wrote DBA 5+ tools in Perl scripts
. Installed/upgraded 10+ Shareplex for Oracle
. Worked with Oracle support to improve 10g to 11g upgrade
performance
Jun. 2006 - HP, US-invested company
Jun. 2009 Senior Oracle Database Administrator
. Be trained in USA and work as DBA in a global team,
duration 3 months
. Worked in USA as System and Application DBA, duration 3
months
. Supported 50+ DB as Primary system Oracle DB, duration
1.5 year
. Supported 20+ DB as Backup SQL Server DBA, duration 6
months
. Supported 30+ applications as app. DBA, including design
consultant and performance tuning, duration 1.5 years
. Administered DB up to 7TB in size, including
backup/restore, clone and migration, duration 2 years
. Administered 200+ Oracle DB in Oracle Grid Control,
duration 1 year
. Upgraded 100+ Oracle Enterprise Agent from 10.2.0.1 to
10.2.0.3
Mar. 2005 - TeleNav, US-invested company
May 2006 Senior Oracle Database Administrator
. Administered 3 production DB and 1 US production DB
. Review SQL and Java code as key member of code review
committee
. Designed/Implemented PL/SQL packages for Gas Price
project
. Designed/Implemented POI Data Maintenance System using
Java, Tomcat
. Technology consultant in National Data Integration
project
May 2003 - eTang, US-invested company
Sept. 2004 Oracle Database Administrator
. Administered 5 production DB
. Designed/Implemented one-station DB backup & recovery
project
. Designed/Implemented DB Capacity project using Perl and
Apache
. Designed/Implemented Customer Service System using Java
and C
Jul. 2002 - ARES, Taiwan-invested company
Mar. 2003 C Software Engineer
. C developer in DBTEL2049 and DBTEL2051 mobile phone
project
. C developer in PanasonicG60 mobile phone project
EDUCATION
. Bachelor of Engineering, HuaZhong University of Science
& Technology, Wuhan Hubei China, Jul. 2002
TRAINING
. Oracle Database 11g: RAC Administration, Sept. 2010
. Oracle Database 11g: New Features for Administrators,
Mar. 2009
. Oracle Enterprise Manager 10g Grid Control Ed2, Mar.
2008
. Oracle Database 10g: Real Application Clusters, Jun.
2006
. Oracle 10g workshop II Ed2, Sept. 2006
. SQL Server 2005 development, EastHome Beijing, Mar 2008
. SQL Server 2005 administrator, EastHome Beijing, Jan.
2007
. SQL Server 2000 administrator, Shanghai OpenLab, Oct.
2006
. Siebel 8.1.x Installation and System Administration,
Aug. 2010
. Advanced Microsoft Excel skills Training, 51JOB, Jan.
2009
CERTIFICATION
. OCP 10g, Jun. 2008
. CET-6, Dec. 2001
SKILL
. Oracle Database, Very Good
. PL/SQL, Very Good
. SQL Tuning, Very Good. Real cases: Performance improved
10K times by gather statistics for indexes; Improved 10
times by remove distinct inside existing sub-query;
Improved 30K times by changing union to union all and
optimize joins with understanding application logic;
etc.
. Application Tuning, Good. Read cases: Response time
decreased to 1 sec. from 10 sec. after using PL/SQL
procedure instead of Java code; etc.
. Shell/Perl, Good
. SQL Server database and MYSQL database, Fair
ENGLISH
. Reading, Very Good
. Oral English, Good
. Writing, Good