Post Job Free

Resume

Sign in

Sql Server Customer Service

Location:
Boise, ID, 83704
Posted:
October 12, 2010

Contact this candidate

Resume:

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



Contact this candidate