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-now
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,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 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,China 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 Windows server, SQL server 7.0 etc

• Built intranet servers with directory replication, RAS connectivity , sql server, MIS system. troubleshot and administrated user accounts
• Designed disaster recovery strategy, performing database backup, recovering and repairing systems in the event of data corruption or system failure.
• Participated in the software engineering life cycle for company Management Information system, designed MIS database using ERWin
• Performed database creation, size estimation, security setting, index design, database maintenance, performance tuning etc.
• Designed and wrote High Level Design and Low level Design.
• 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