We provide IT Staff Augmentation Services!

Database Administrator Resume

3.00/5 (Submit Your Rating)

Vancouver, BC

TECHNICAL SKILLS:
Database Administration: MS-SQL 2008/2005/2000, Oracle 10g/9i, SSRS, SSIS, DTS, T-SQL, backup/restore, database replication/mirroringperformance tuningSQL 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+ database servers, such as SQL server 2005/2000, Oracle, etc.
  • Performed database creation, size estimation, security setting, index design etc. Built and maintained database jobs, performance tuning using SQL profiler, troubleshooting sql server errors, deadlock.
  • Upgraded SQL 2000/2005 to SQL 2008.

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
Responsible for production/development database support, maintenance, database design and BI project implementation.

  • 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, database replication. Performance tuning using sql profiler, execution plan.
  • Designed and created data warehouse, data mart and maintaining datamart and delivering data daily/weekly . Implemented ETL processes using DTS packages SSIS, SQL Loader. Built and maintained report using SSRS
  • Implemented inventory/sales/customer/promotion using ERWin, t-sql coding, designed/modified view, trigger, procedure, index.
  • Implemented database link, database replication between SQL server and Oracle server

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 gathered requirements for the migration of e-government system. Modified the design as per the changes in requirements.
  • Designed ERD and database logical model, estimated database size. Reverse engineering of production system from physical data models to logical data models with ERWin.
  • Worked with developer to improve database performance. Developed database using t-sql, view, trigger, procedure, index, table design, performance tuning. Migrated data from Oracle 8i to SQL 2000 using DTS.
  • Performed functional test and load test on SQL queries, store procedures and forms. Code Management using VSS. Contributed to Quality related activities by taking up roles as Defect Prevention Coordinator and Software Configuration Management.

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. Migrated data from Access/Excel to SQL 2000 using DTS.
  • Designed and developed database using T-sql, ASP.NET

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
  • 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.
  • Participated in the software engineering life cycle for company Management Information system. 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. 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

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 
Department of Computer Science, Confidential Tech, 
M.S. in CS Confidential University 
M.S. in EE Confidential University, 
B.S. in EE Confidential University

We'd love your feedback!