OBJECTIVE

Database Administrator/Database Engineer/Database Developer

SUMMARY

• Master of Computer Science with 7+ years Oracle/SQL DBA experience
• Professional experience of Oracle 11g/10g/9i and SQL server 2008/2005/2000 Database server installation, sqlplus, backup/restore, troubleshooting and performance tuning on 24 * 7 * 365 systems.
• Professional experience of high available technology, like RAC, data guard, cluster
• Installed Oracle RAC software
• Installed data guard software, determined Data Guard architecture
• Extensive performance tuning experience, specializing in instance tuning and SQL optimization.
• Extensive experience with designing and implementing Oracle databases, including systems architect, project management, implementation and tuning.
• Strong team player with great verbal, written communication and interpersonal skills
• Ability to prioritize and complete multiple tasks and detail oriented
• Proven capability to approach problems effectively and creatively in complex environment
• Quick learner, take initiator, and hard worker. Willing to take responsibilities

TECHNICAL SKILLS

Oracle: backup/restore, performance tuning, ADDM, AWR, RAC, Data Guard, RMAN,OEM, partition, flashback, SQL loader, imp/exp
SQL: replication, database mirroring, cluster, partition, backup/restore, t-sql
Environment: Windows, Linux, Solaris
Others: DB Artisan, TOAD, shell scripting, ASM 

PROFESSIONAL CERTIFICATION

• Oracle10g/9i/8 Database Administrator Certified Professional (OCP)
• Microsoft Certified Database Administrator

EDUCATION

• M.S. in Computer Science, Georgia State University, Atlanta, GA, 2002
• M.S. in Electrical Engineering, Shanghai Jiao Tong University, Shanghai, China, 1994
• B.S. in Automation Conrol, Huazhong University of Science and Technology, Wuhan, China, July, 1991

RELAVENT WORK EXPERIENCE

Sr. DBA Confidential Toronto, ON 03/2011-09/2011
Part of a team of database administrators responsible for 300+ Oracle/SQL database Servers. Duties include 24X7 production/application support, regular maintenance, monitoring, tuning, object creation and upgrades. Day-to-day task includes Oracle/SQL Server installation, Data Gurad/ mirroring/replication setup and maintenance, performance tuning, backup/restore, troubleshooting, security patching.
Technologies used: Data Guard, RAC, ASM, Oracle 11g/10gClustering, AWR, ADDM

Database Administrator Confidential
Vancouver, BC 04/2009-10/2009
Worked as a database administrator maintaining 40+ database servers including Oracle 10g/9i and SQL server 2005/2000. Performed database creation, size estimation, security setting, index design, designed database maintenance jobs, performance tuning using AWR, ADDM, troubleshooting, deadlock. Installed and maintained RAC, data guard environment. Supported Oracle developers, performed database tuning, created database reorganization procedures, database alert scripts, monitoring scripts and backup procedures. 
Technologies used: Oracle 10g/9i, Solaris, RMAN, RAC, ASM, Data Guard, OEM, partition, AWR, ADDM, SQL loader, imp/exp, flashback, DML, DDL, index design, log shipping, mirroring, replication

BSA(Database Administrator) Confidential Redmond, WA 12/2007-05/2008
One member of a team of Database Administrators responsible for installation, maintenance support, upgrades, monitoring and tuning of 200+ Oracle and Microsoft SQL Server database servers size up to 7TB. Environments included Oracle 10g, SQL 2005/2000 running on Sun Solaris/windows and Microsoft SQL Server 
Technologies used: Oracle 10g, RMAN, Data guard, RAC, ASM, OEM,AWR, ADDM, SQL loader, imp/exp, partition, replication, log shipping, mirroring, BCP, SQL Profiler, execution plan, index, solaris

Database Administrator Confidential MedfordOregon 01/2007-11/2007
Responsible for Database Administrator to support multi-terabyte database and data warehouse production/development environment Administration included design, maintenance, monitoring, tuning, configuring, object (databases, tables, triggers, indexes, procedures and functions) creation and backing up of databases. Duties included all aspects of Oracle database administration including performance & tuning, Oracle installation and Oracle upgrade, database maintenance, and database recovery. 
Technologies used: Oracle 9i/10g, Solaris, Linux, Data Guard, ASM, RAC, OEM, partition,AWR, ADDM, Toad for SQL/Oracle, RMAN, SQL Loader, database replication/mirroring, ETL, imp/exp

Sr. Test Engineer Achievo Confidential Shenzhen, CN 09/03-08/04

Lead data migration project from Oracle 8i to SQL server 2000. Performed database administration tasks like backup/restore, creating logins, roles, performance monitoring. Reverse engineering of production system from physical data models to logical data models with ERWin. Performed functional test and load test on SQL queries, store procedures. Data migration between Oracle 8i to SQL 2000 using SQL loader, DTS.
Technologies used: Oracle 8i, SQL Loader, Erwin, data mapping, SQL Server 2000, T-SQL, DTS, LoadRunner

Database Programmer(GRA)Confidential Atlanta, GA 08/01-12/02 Designed physical/logical a model for faculty database using ERWin, estimated database size. Implemented tasks like database creating, performing backup/restore, security setting, performance monitoring and data migration. Migrated data from Access/Excel to SQL 2000 using DTS. Designed and developed database using T-sql, ASP.NET

System Administrator Confidential3/94-04/01

Performed all duties necessary to maintain the intranet in the company. Performed database creation, size estimation, security setting, index design, backup/restore database maintenance, performance tuning etc. Designed and wrote database High Level Design and Low level Design. Designed database physical/logical model using ERWin, estimated database size

Technologies used: Oracle 8, SQL Server 7.0/6.5, T-SQL, DTS, ERWin, backup/recovery, performance tuning, data migration, index, database design, Windows NT, IIS 4.0, Proxy 2.0, Exchange Server 5.5

OTHERS
01/2005-12/2006 New Mexico Tech , Socorro, NM