To secure a challenging position in the areas of Database Administrator
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
02/2006 – Present
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
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 126.96.36.199)
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
Oracle Database Developer /Administrator
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
1991 – 1993
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