TECHNICAL SKILLS:
Database Administration: MS-SQL 2008/2005/2000, Oracle 10g/9i, SSRS, SSIS, DTS, T-SQL, backup/restore, database replication/mirroring, performance tuning, SQL Profiler, Query Analyzer, SQL(DML, DDL), CDC
Database modeling: ERWIN, database architecture, conceptual/logical/physical data modeling, E-R modeling, 
Data Warehousing: Enterprise data warehouse Design, data mart, OLAP cube design and construction, ETL. SSAS
Others: Business Problem Analysis, software development life cycle

PROFESSIONAL EXPERIENCE

Database Administrator Confidential Vancouver, BC 04/2009-10/2009
Worked as a database administrator, maintaining 40+ production database servers, such as SQL server, Oracle, etc.
Technologies used: SSIS, SSRS, SQL Profiler, execution plan, Query Analyzer, SQL(DML, DDL), index design, maintainence, log shipping, mirroring, replication, Oracle, BCP, CDC

Business System Analyst(Contractor) Confidential Redmond, WA 12/2007-05/2008

• Worked as a database administrator, maintaining 200+ production database servers size up to 7TB.
• Wrote script to implement database administration automation, such as backup, index maintenance, file group maintenance, blocking, CPU/Memory information, user/mailbox information
• Performance tuning using SQL Profiler, troubleshot SQL server errors including blocking, dead lock, security
• Setup and maintained database mirroring, log shipping, replication.

Technologies used: SSIS, SSRS, SQL Profiler, execution plan, Query Analyzer, SQL(DML, DDL), index design, maintainence, log shipping, mirroring, replication, Oracle, BCP

SQL Database Administrator Confidential MedfordOregon 01/2007-11/2007
Responsibilities as production/development database support. Responsibilities included database administration, database design, performance & tuning, backup/restore and database security.

• Created and maintained production, development, and test databases
• Performed database creation, size estimation, security setting, index design, database maintenance, etc.
• Implemented database administration tasks like designing disaster recovery strategy, performing backup/restore, database performance monitoring, security setting, auditor, database replication.
• Performed database performance monitoring, security setting.
• Proactively scheduling and facilitating necessary server upgrades to accommodate growth and ensure acceptable system performance and response times.
• Supported, maintained and performance tuning weekly jobs and a monthly Data Warehouse load, interfaces, reporting and OLAP, SQL server related jobs.
• Designing and creating data warehouse, data mart and maintaining datamart and delivering data daily/weekly
• Ensure databases adhere to corporate standards and policies
• Implemented ETL processes using DTS packagesSSIS, SQL Loader
• Implemented inventory/sales/customer/promotion system using t-sql, designed/modified view, trigger, procedure, index, performance tuning using sql profiler, execution plan.
• Built report using SSRS, maintaining SSRS.

Technologies used: SQL Server 2005/2000, T-SQL, ETL using SSIS/DTS, SSAS, SSIS, SSRS, Oracle 9i/10g, Toad for SQL/Oracle, OLAP, ER-modeling, dimensional modeling

Sr. Test Engineer Confidential. Shenzhen, China 09/03-08/04 Planned, developed and executed database testing for e-government system.

• Analysis and requirements gathering for the migration of e-government system
• Defined the logical entities, attributes and relationships using Data Normalization.
• Designed ERD and database logical model..
• Designed database physical model and estimating database size
• Reverse engineering of production system from physical data models to logical data models with ERWin.
• Migrated data from Oracle 8i to SQL 2000 using DTS.
• Performed functional test and load test on SQL queries, store procedures and forms.
• Modified the design as per the changes in requirements.
• Interacted with the client on a daily basis and attended status meetings.
• Worked with developer to improve database performance.
• Created and maintained development, QA and audit database environments
• Performed database administration tasks like backup/restore, creating logins, roles, granted permissions, database performance monitoring.
• Attended status meetings and sending team status reports.
• Developed database using t-sql, view, trigger, procedure, index, table design, performance tuning.
• SQL Code review for tuning and performance optimization
• Code Management using VSS.
• Contributed to Quality related activities by taking up roles as Defect Prevention Coordinator and Software Configuration Manager.

Technologies used: Erwin, SQL Server 2000, T-SQL, DTS, data migration, Oracle 8i, Rational Rose, VSS, LoadRunner, WinRunner

SQL Database Programmer (GRA) Confidential, Atlanta, GA, 08/01-12/02 Designed the data model for faculty database, implemented using IIS 2000+ ASP.NET+SQL 2000.

• Designed database physical/logical model using ERWin, estimated database size.
• Implemented tasks like database creating, performing backup/restore, security setting, performance monitoring and data migration.
• Designed database physical/logical model using ERWin, estimated database size.
• Designed and developed database using T-sql, ASP.NET Migrated data from Access/Excel to SQL 2000 using DTS.

Technologies used: SQL Server 2000, Erwin, DTS, T-SQL, IIS, ASP.Net

System Administrator Confidential 03/94-04/01

Performed all duties necessary to maintain the intranet in the company , which consists of 6 servers in 2 locations with ISDN connection . The software used included SQL server 7.0, Windows server, etc Designed disaster recovery strategy, performing database backup, recovering and repairing systems in the event of data corruption or system failure Implemented tasks like database creating, performing backup/restore, security setting, performance monitoring and data migration.

• Performed database creation, size estimation, security setting, index design, database maintenance, performance tuning etc.
• Designed database physical/logical model using ERWin, estimated database size Designed and wrote database High Level Design and Low level Design.
• Participated in the software engineering life cycle for company Management Information system.
• Database monitoring and performance tuning Built intranet servers with directory replication, RAS connectivity , sql server, MIS system. troubleshot and administrated user accounts.
• Developed MIS database/table/view/trigger/procedure/index using T-sql, performance tuning t-sql. Code and Test enhancements and new features in VFB.
• Debug problems found in QA or at Customer Sites. Assistant with product documentation.

Technologies used: 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

CERTIFICATIONS:
Microsoft Certified Database Administrator 
Oracle10g/9i/8 Database Administrator Certified Professional

EDUCATION 

M.S. in CS 
M.S. in EE 
B.S. in EE