Oracle Database Administrator

Objective:

Oracle Database Administrator

Summary of Qualifications:

• BS in Computer Science

• 4 years experience as a full-time Oracle database administrator

• 10+ Years total technical experience

• Proficient in scripting using SQL/PLSQL

• Experience in performing backup and restore using RMAN

• Knowledge of ETL processes

• Oracle 8i/9i/10g Enterprise Edition experience, Oracle 11g knowledge

• Work environment with Red Hat Enterprise Linux X86

• Oracle Certified Professional (Oracle 9i OCP)

• 10+ years developer experience in Relational Databases (Oracle, SQL Server, Foxpro, Dbase)

Experience:

1. Oracle Database Administrator (Oracle 8 / 10g) 4 years

Distributel Corp. Calgary (Dec 2006 – Current)

www.3web.com | www.cia.com | www.distributel.ca

 Maintaining and monitoring Oracle 8.1.7.0 / 10.1.0.3 databases on production / QA / Dev environments

 Backup and performance tuning

 Oracle Patch update

 Designed and created QA / Dev database environment, and regularly back sync qa/dev data from production

 Daily application management

 System Bugs resolving with PL/SQL

 Reports for managers with Advanced SQL

 Responsible for running and maintaining LD (Long Distance) Billing system

 Provide database technical support to developers

 Oracle database tuning and analyzing query plans and query tuning, partitioning

 Linux shell scripts

2. Oracle 9i DBA Training SAIT, Calgary (2006)

 This is a 10-month hands on training program, implemented on Oracle 9i database in Windows Server 2003 environment then upgraded to Red Hat Linux 3.0 environment.

 Received Oracle 9i OCA / OCP certificates

 Data Warehouse

3. Database Administrator (SQL Server 6/2000, Oracle 7) 4 years

SINOPEC China (the biggest petro-chemical company in Asia) (2000 – 2003) www.sinopec.com

 Maintained and monitored production databases for SQL Server 7/2000 and Oracle 7

 Backup / recovery

 Wrote Triggers / Procedures

 Provide technical support to developers

4. Senior Database Application Developer / Analyst 10+ years

SINOPEC China (the biggest petro-chemical company in Asia) (1987 – 2002) www.sinopec.com

 Participated and developed some projects in enterprise MIS area

 Worked tools include but not limited:

o Oracle 7 in DEC Alpha OpenVMS

o SQL Server 6 in Windows NT / 2000 Server, T-SQL

o PowerBuilder 6 tool for C/S development

o JavaScript / VBScript + ASP development

o SAS development in DEC Alpha OpenVMS

o Visual Basic 6.0 / 3.0

o Foxpro / Foxplus / Dbase

 Leading and Training other developers

Other Training and Education:

• Oracle 9i DBA Training Oracle (2006)

• SQL Server 7.0 DBA Training Microsoft CTEC, China (2001)

• Microsoft Windows 2000 Training Microsoft CTEC, China (2001)

• 1 year Master’s program in Computer Science Tsinghua University, China (1999)

• Bachelor's Degree in Computer Science Hefei University of Technology, China (1987)

Contact this candidate