OBJECTIVE

Database Administrator/Database Engineer/Database Developer

• 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 and performance tuning on transactional 24 * 7 * 365 systems.
• Professional experience of high available technology, like RAC, data guard, cluster
• 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

Database: Oracle 11g/10g/ 9i, SQL 2008/2005/2000 database administration
Oracle: performance tuning, ADDM, AWR, RAC, Data Guard, ASM, AWR, ADDM, 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

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

• M.S. in Computer Science
• M.S. in Electrical Engineering
• B.S. in Automation Conrol

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/10g, MS-SQL 2008/2005/2000, peer-to-peer/merge replication, database mirroring, DBArtisan, Clustering, DTS, SSIS package, backup/restore

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. Upgraded SQL 2000/2005 to SQL 2008.

Technologies used: Oracle 10g/9i, Solaris, RMAN, RAC, ASM, Data Guard, OEM, partition, AWR, ADDM, SQL loader, imp/exp, flashback, SQL server 2008/2005/2000, SSIS, SSRS, SQL Profiler, execution plan, Query Analyzer, 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. Utilized Oracle Enterprise Manager and TOAD for database monitoring and management.

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 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

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

Confidential China 3/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 Confidential, Socorro, NM