We provide IT Staff Augmentation Services!

Database Administrator Resume

CanadA

OBJECTIVE

To secure a challenging position in the areas of Database Administrator

SUMMARY

  • 15+ Years IT experience including RDBMS management and support of database applications.
  • Rich Experience in Oracle 8i/9i/10g/11g and SQL Server 2000/2005 Architecture and Management.
  • 8+ years extensive Oracle8i/9i/10g/11g DBA hands on experience (Unix/NT) and 3 years extensive SQL Server 2000/2005 DBA hands on experience in database upgrading, creating, replicating and performance tuning as well as backup & recovery. Good at tuning and trouble-shooting Including SQL statement tuning, Database/Data Warehouse logic/Physical partition, System memory and I/O tuning, and MV for report tuning
  • Solid working experience and extensive knowledge of Oracle /SQL server HA and DR solutions, such as Oracle RAC and Data Guard. SQL server 2005 Database Mirroring, Log Shipping, and Replication, working experience of data distribution technology such as oracle DB link and SQL server Linked server. Extensive experience in database problem determination and resolution.
  • Solid working experience and extensive knowledge of very large databases migration cross different platform.
  • 2 years solid experience in database modeling design include ER modeling for OLTP databases , SSD dimension modeling for OLAP data warehouses as well as databases, data warehouse physical implement and maintenance in projects.
  • Extensive working experience in ETL process and BI reporting process by using Informatica PowerCenter , MS-SSIS, IBM-DataStage, Cognos, MS-SSRS, MS-SSAS
  • Working experience in management very large OLTP database and OLAP data warehouse with Oracle RAC
  • Perform critical data recovery with all means and knowledge. Very strong analytical ability
  • 5 years Unix/Linux and Storage work experience in Sun Solaris/AIX/HP-UX/Redhat/SUSE, strong working experience and extensive knowledge of server level HA solutions such as HACMP, VCS, Service Guard as well as Storage technology such as Disk RAID , oracle ASM , SAN and NAS
  • 2 year experience in VMware administrate, good working experience and extensive knowledge of windows server level HA solutions such as MSCS as well as windows NT Architecture such as Active Directory, Domain Controller, OU etc concept.
  • Certified Oracle 10g Database Administrator and SQL server 2005 IT Technical Specialist
  • Master Degree of Electrical and Computer Engineering in University of Texas at Arlington
  • Dedicate team player and internal commutation skills . Faster learner and organize skills

EXPERIENCE

02/2006 – Present

Database Administrator

Confidential,Canada

  • Provided Oracle DBA support for multiple large databases in production, development and test environments for various types of databases - OLTP and Data warehouse in EAS Financial project
  • Help developed ETL process , data modeling design and BI report performance tuning in data warehouse projects.
  • Implement logical / physical design including create Stage, NDS, DDS, Metadata databases, create Materialize Views, Cube objects in whole data warehouse project.
  • Implement logical /physical tuning in data warehouse project including logical separate fact tables and dimensional tables in different table spaces , doing table partition in fact tables, add bitmap index in fact table
  • Provided administrative supports for Applications with Oracle 10g running on Solaris8/9/10 and AIX 5L boxes
  • Installed, upgraded and patched Oracle software and associated applications
  • Created or cloned Oracle new databases(include OLTP and OLAP), users for Dev, Test environments
  • Wrote UNIX shell scripts and PL/SQL, schedule jobs to monitor database activity
  • Setup SQL trace and Application trace, Monitored and tuned Oracle database performance.
  • Using Oracle tools Explain Plan, TKPROF, Statspack ,10g(AWR, ADDM), and some scripts identified, resolved, or provided recommendations to performance problems ranging from database performance to I/O hardware performance
  • Implemented Oracle database refresh with the hot backup using Duplicate or full export, Used Export/Import to do table level and full database defragmentation.
  • Developed or modified some Oracle backup and recovery scripts. Using Oracle RMAN Implement Oracle backup and disaster recovery
  • Installed Oracle 10g/11g database, Oracle 10g AS and set up 2 node Oracle10g RAC on Linux,
  • Set up and configured Oracle10g Data Guard for DR purpose
  • Installed, upgraded and patched SQL server 2000 to SQL server2005 software, and migrated database to SQL server 2005.
  • Loading and updating new data to SQL server database using bcp utility /SSIS packages
  • Managed SQL server database backup and recover in Test environments
  • Monitored and tuned SQL server 2005 database performance using SQL Profiler and Database Tuning Advisor tools.
  • Configured, setup and tested SQL server 2005 database HA and DR solution

01/2004-01/2006

Database Administrator

Confidential,China

  • Helped Logical and physical design Oracle OLTP database and OLAP data warehouse for VanceInfo Technologies Inc’s projects, participated technical meeting to evaluate hardware vendors, made recommendation to purchase hardware from database perspective, worked closely with system administrator to setup file system layout for databases
  • Provide Oracle DBA support for multiple large databases in production, development and test environments for various types of databases within RAC - OLTP and OLAP
  • Installed Oracle software, created database on unix Solaris/AIX boxes and upgraded all instances of VanceInfo Technologies Inc oracle databases to the latest patch level of oracle 9i (version 9.2.0.6)
  • Helped design Oracle database tables for client applications to eliminate redundancy and optimize applications’ performance,
  • Set up RMAN from scratch to back up Oracle database to tape directly, set up failure over plan for a mission critical production database
  • Restored an Oracle mission critical production database to current state without data lost when a user ran a script to delete production data by accident, resized/added data file to tablespace, table reorg and index rebuild, Refreshed QA database from production on monthly basis, Configured and set up data archiving for purchase order and FI document
  • Daily checked application/database on regular basis, Set up job to collect statistics, verified all database tables and cleaned up logs, took database snapshot for the purpose of db performance analysis, wrote a script to check oracle errors on alert file and sent a message to dba group when error occurred
  • Online supported application users, checked Oracle, SQL Server on daily basis, Created application users and controlled users’ privilege to perform activities on database
  • Supported multiple VanceInfo Technologies Inc applications through oracle database support
  • Applied support packages to VanceInfo Technologies Inc landscape, performed Application client copy, opened service connection to Application, performed biweekly payroll procedure
  • Supported VanceInfo Technologies Inc document archiving system including document scanning/binding/exporting with EASY software
  • Created SQL Server database and database maintenance plan on Microsoft windows NT machine
  • Performed 24 x 7 on call duty to support VanceInfo Technologies Inc Oracle/SQL Server databases

1998-2001

Oracle Database Developer /Administrator

Confidential,China

  • Perform regular DBA activities: database installation and creation; users management; rollback segments and tablespaces management; security; backup and recovery, etc.
  • Write Bourne shell scripts for monitoring/health check to alert team of database uptime/downtime status, sizing issues, which ensured 24X7 availability
  • Database performance tuning and troubleshooting
  • Design and develop server-side functions in software projects: using PL/SQL to develop packages, procedures and triggers; using Pro*C to develop database access interface for application
  • Develop, implement, and provide operational support of distributed application programs in a production environment (advanced replication, materialized view, database link)

1993 – 1998

Unix Administrator

Confidential,China

1991 – 1993

Programmer

Confidential,China

TECHNOLOGY SKILLS

  • Languages: SQL, PL/SQL, PHP, C , Shell Scripting
  • Database: Oracle8i/9i/10g/11g, SQL Server 2000/2005, DB2, Mysql, Access
  • ETL: Informatica PowerCenter, SQL Server DTS/SSIS, DataStage
  • Modeling tools: Erwin, Visio
  • OLAP/Reporting: Informatica PowerTransformer/PowerPlay , SQL Server Analysis Services, SQL Server Reporting Services, Cognos. Crystal Report
  • Oracle Tools: SQL*PLUS, RMAN, Export/Import, SQL*Loader, DataPump. 9i/10gOEM 10g grid control
  • SQL Server Tools: SQL Profiler, DTA( Database Tuning Advisor ) , SSMS, DTS/SSIS,SSAS,SSRS
  • Operating Systems: Sun Solaris 8/9/10, AIX 5L, HP-UX, Linux Redhat/SUSE, Windows NT/95/98/2000/2003/XP
  • Third Part Tools: TOAD, Spotlight, LiteSpeed
EDUCATION

MSEE

BSEE

PROFESSIONAL TRAINING & CERTIFICATES
  • Oracle 10G Certified Database Administrator
  • SQL SERVER 2005 IT Technical Specialist
  • Unix training (Solaris/AIX/HP-UX/Linux)
  • Oracle Enterprise Manager 10g Grid Control Ed 1.1
  • Oracle9i Database Performance Tuning
  • Data Archiving Training
  • Data Warehouse and BI report training
  • Oracle9i Database: New Features for Administrators R2

Hire Now