EXPERIENCE

Confidential, 06/10-current
Role: Consultant of an Oracle DBA in IBM

• Verify automatically databases monitoring system on AIX, HP, Linux with VMware system.
• Implement monitoring in database alerts, file systems, listeners and database status on 324 servers, 800 oracle databases in version 9i, 10g, 11g with RAC, data guard and total databases size is 76TB.
• · Optimize RMAN on 10g/11g databases for Archive log automatically management.

Confidential, TX 01/10-03/10
Role: Consultant of an Oracle support DBA in Citibank

• Testing export/import for complicated database refreshes on AIX.
• Implement database migration on Oracle RAC systems.

Confidential, TX 02/06-04/09
Role: Oracle DBA/Database System Engineer in an enterprise security data center.

• Determining the Oracle RAC, grid control and data guard architecture.
• Supporting of a large-scale databases in a mission critical environment (>=2 millions events per day) with 24x7 on call rotation.
• Work experience of Oracle with full life cycle such as designing, development, QA, production environment support and troubleshooting.
• Implementing oracle RAC on Linux and EMC SAN storage with ASM; Hands on experience of installation, upgrade and integration.
• Problem resolution for SAN configurations using ASM and ocfs2.
• Hands on experience of oracle grid control implement to centralize management Oracle RAC databases and SQL server.
• Working experience of oracle data guard. Working experience of database design with Erwin.
• Performed SQL level, database level and OS level tuning using Autotrace; STATSPACK, AWR, ADDM, top and vmstat.
• Cloning and refreshing database from Production to Development or QA using RMAN, data pump or export/import.
• Implementing database backup/recovery with RMAN, flashback, data pump or export/import.
• Developed Unix shell, SQL and PL/SQL scripts to carry out routine checks on databases.
• Management database user, security and process access, physical/logical structure capacity plan.
• Planning and installing patch fixes and upgrades in both database and application.
• Building physical standby database using Oracle 10g Data Guard.
• Good communication skills, experience in leading teams on projects.
• Experience in Linux system database administration including operating system installation and configuration and shell scripts.
• Highly self-motivation; Able to create detailed work plans.
• Troubleshooting with TAR and Oracle support; Good problem solve skill through experience and research.
• Knowledge of Oracle Golden Gate administration and Service Oriented Architectures.
• Good documentation and process development skills.
• Experience with change control using remedy.

Confidential, TX 06/05-02/06
Role: Oracle/Oracle11i Application production support DBA

• Management single/multi-node oracle applications instances (11.5.8+) and Oracle databases(9i/10g) on Windows, Linux and Solaris environments.
• Maintain databases which used in the production, QA and Test environments.
• Manager database user, security and process access, physical/logical structure capacity plan.
• Implement patch, object validation and compiling.
• Cloning 11.5.8 database from production or QA to test environment.
• Plans, implements the backup and recovery procedures for the Oracle applications systems.
• Monitors and tuning in Oracle applications and oracle database with quest spotlight and OEM.
• Wrote scripts for automatically databases performance reports.
• Understand business requirements and write and fine tune PL/SQL procedures.
• Strong communication and customer service skills. Working with Oracle support for tickets with SR's.
• Good Knowledge of Veritas NetBackup; Good knowledge of migration 9i to 9i RAC.
• Management SQL servers.

Confidential, NY 06/04-06/05
Role: Consultant migration DBA in manufacturing

• Gather and analyze business requirements, defining functional processes of database.
• Integrated business application into IT environment, data modeling using erwin, deployment of physical Oracle databases based on logical designs; design system requirement; transition of logical database models to physical databases.
• Deployment of physical construction in tables, views/materialized views, index, triggers, PL/SQL; managed tablespaces and constraint.
• Installed Oracle database; Migration MS access to Oracle.
• Optimization database; Monitor the most frequently executed SQL statement, tuning SQL using Explain Plain, trace, Tkprof. Query optimization with CBO and hint.
• Tuning Database server, proactively monitored hit ratios on different components of the SGA included tuning of the shared pool, databases buffers and redo buffers.
• Wrote script to automatically monitoring database status such as alert log checking and storage checking.
• Supporting development and test systems; performing production system certification.
• Copy databases on different servers using tools like export/import, SQLLoader etc.
• Configure client/server communications/software.
• Installation and configuration of webSphere message broker with J2EE.
• Knowledge of Oracle10g and Oracle11i System Administrator.
• Work with developers and change management team to ensure smooth life cycle progress from development through testing and production implementation.

Confidential, CT 12/03-06/04
Role: Project manager in CRM environment

• Direct the support staff for retail industry, system and data processes.
• Project implementation in CRM\'s reporting and analytics support.
• Using Oracle 11i to optimize CRM management in sales, service and marketing units.
• Strong knowledge in retail business process.
• Solid experience with PMI (project management lifecycle processes); and ability to plan and organize development work and deliverables.
• Area management comes with good creativity and energetic.

Confidential, CT 12/01-12/02
Roles: working for ADVO as Oracle9i/DB2 DBA on Solaris, AIX and NT

• Installed, configuration Oracle9i database.
• Logical/physical data modeling with normalization and denormalization of data.
• Using STATSPACK monitor database performance, collection data for both proactive and reactive tuning.
• Setup AUM and undo retention, dynamically undo management.
• Auditing oracle database including system level, object level, roles using Audit trail; customized audit by trigger and oracle scripts; controlled server-side security by securing network.
• Implement Oracle backup and recovery procedures in logically and physically.
• Tuning database in OS, SGA, parameters and SQL including instances management and TAR support.
• Development SQL, PL/SQL, OS scripts.
• Implement new or modify existing DB2 database objects such as instances, databases, tables and indexes.
• Establish and implement policies and procedures for DB2 database administration, backup and recovery.
• Proactively monitor and tune DB2 database system performance.
• High ability to work at new technology with quickly learn, translate them into business application.

Confidential, NY 01/00-12/00
Roles: Oracle8i DBA in Ecommerce Company on Solaris and NT

• Installation Oracle 8.1.6, configuration OEM and Net8.
• Created, maintain 12 databases for OLTP on development, testing and production.
• Assistant of data architecture in logical/physical design using Rational rose.
• Created table spaces and database files based on the OFA model. Implemented the transformation of the logical data model to physical model and resulting data structures. Performed 24x7 production support.
• Making structural changes to the databases when database design was modified.
• Using OEM to perform database space growth analysis, such as table growth, memory usage, extents fragmentation, I/O contention, rollback segment contention and storage usage.
• Performed SQL tuning by using Autotrace, Explain Plan, and Tkprof. Implement distributed transactions.
• Developed Unix shell and SQL scripts to carry out routine checks on databases.
• Cloning database for different function test.
• Implement ETL tool OWB, SQL*Loader, partition and PL/SQL in data warehouse.
• Analyze, perform Unit, Integrated as well as System Level testing, quick resolved any errors and bugs by Trace and Alert files.
• Strong organization ability to interact with individuals and groups at all levels.

• Participated DSIII project--a network management system in Borland C++ and JAVA
• Installation Oracle, created and maintain databases, tables, views and indexes.
• Managed and developed the new database schemas.
• Managed and implement databases backup/restore.
• Installation and maintain SQL system.
• Data loading by SQL*Loader in data warehouse.
• Assistant of HR to create new hire process on SQL server.
• Using SQL server in general ledger, medium management, and customer management.

Database: Oracle8/8i/9i/10g/11g, MS SQL2005/2008, DB2, MS Access/Excel, ETL
System: UNIX(Solaris, AIX), Linux (RHEL AS3.5/4), EMC SAN,Windows (NT/2000/XP), VMWare, VPN
Languages: JAVA/JDBC, J2EE, C++, SQL, PL/SQL, Unix shell
Tools: SQL*Plus, OWB(Oracle Warehouse Builder), grid control(OMS), RMAN, Oracle Data Guard, Oracle RAC, ASM
Applications: Arcsight3.5/4.0, Remedy7, Oracle 11.5.8, FTP, telnet, Erwin/Rational Rose, Oracle designer, TOAD, Lotus Notes, PowerPoint, Putty, MS office, MS project manager, SportLight, webSphere WMQ5.3, SAP
Education: MS in Computer Science-University of Bridgeport CT
BS in Industrial Electronic - Shanghai University China
Certificate: 10gRAC