OBJECTIVE

• Seeking a challenging position as a Database Engineer/Developer on data modeling, data processing, and ETL
• SKILLS
• Database Tools: ETL, Oracle 11g, 10g, 9i, 8i, PL/SQL, Pro C, DataPump, SQL Loader, Oracle Enterprise Manager, Oracle AuditVault, TOAD, dbArtisan.
• Languages: PL/SQL, SQL, C, UNIX shell script, Perl, FORTRAN, Pascal.
• Systems: Sun Ultra/SPARC/Solaris/SunOS, HP-9000/HP-UX, PC/Linux/Windows
• Others: JDBC/ODBC, Sarbanes Oxley/SOX.

PROFILE

• Extensive experience with Oracle data warehouse logic structure design, data modeling, ETL processes.
• Solid Oracle PL/SQL experience.
• Data warehouse storage capacity planning, space usage control, and monitoring.
• Database process and user query performance tuning.
• Database user and application access management.
• Database maintenance, management, migration, backup and restore.
• Strong team player.
• Strong problem solving skills.
• PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Database Engineer

• Application data structure design, object creation, process implementation and maintenance.
• Data Logic structure design and implementation.
• Created store procedure toolset APIs PL/SQL for data creation, conversion, access, archive and restore.
• New customer data structure creation.
• Partition management automation partition creation, compression, drop via scheduled jobs.
• Automated customer data archive and restore process with PL/SQL procedures and Unix script.
• Data compression process design and implementation.
• Developed, customized, and monitored various of ETL processes. Customer and application data were loaded into staging tables and merged into existing application data via scheduled unix jobs, SQL Loader, and PL/SQL post processes.
• Application and ETL process performance tuning by SQL optimizing, resource allocation, data statistics collection, and parallel processing.
• Database and application job scheduling via dbms job scheduler and unix job scheduler.
• Data warehouse storage high growth planning, analyzing, controlling, and monitoring.
• Managed Oracle 10g, 11g RAC production data warehouse on SUN Solaris, Linux environment.
• Worked on database application migration from Oracle 9i to 10g, and from Oracle 10g to 11g.
• Develop and QA database refresh with Oracle Data Pump.
• Database user and application permission management by profile, role, resource management.
• Database performance monitoring by OEM, scheduled PL/SQL jobs and shell script jobs.
• Worked extensively with tools like DB Artisan and OEM Grid Control.
• Modified, maintained, and monitored in-house application data reports.

Confidential

Senior Oracle Database Administrator consultant

• Manage Oracle development, QA and production databases for multiple applications. Apply Oracle quarterly CPU patches and DST patch to 8i and 9i DEV, QA and Production databases.
• Installed Oracle 10g and upgrade DEV, QA 9i databases to 10.2.0.2. Implemented scripts for tables, schemas and full database refresh.
• Responsible for assessing all DEV, QA and Production databases compliance with regulatory Sarbanes Oxley requirements. Implemented UNIX and SQL scripts to enhanced database and SQL net security controls and reports to meet Sarbanes Oxley requirements.

Confidential

Senior Database Application Supporter

• Supported warehouse management application systems and back-end Oracle 8i, 9i databases.
• Effectively troubleshoot performance, resource contention, application data flow and connection issues to ensure real-time execution of orders, inventory, and shipment process in customer's databases and application systems.

Confidential

Senior Computer System Analyst

• Oracle 11i E-Business suite database application test system setup and application performance monitoring with Mercury Interactive automated testing tools. Working environment involved Oracle 8i database server, Oracle 9i application server on HP9000/HP-UX 11i, and web client. Major activities include:
• Review functional testing requirements and user procedures with business analyst, IS, and end users. Created test requirements and test plans in Mercury TestDirector for User Acceptance Testing.
• Automated testing script development for Oracle E-Business CRM modules with Mercury QuickTest Professional.
• TestDirector and the associated Oracle database maintenance Oracle Installation, SQL Net configuration, database instance creation/configuration, and backup implementation .
• Implemented infrastructure monitoring including system, network, database back-end server, database application server utilization, response time, usage, and resource availability with Mercury SiteScope.

Confidential

Senior Software Engineer

• Network equipment management application software development.
• Database layer stored procedure development, test, and maintain.
• Monitor databases and database host for capacity planning and performance load, transaction rate, Disk I/O, CPU utilization, buffer tuning.
• Involved a project of high reliable/efficient data loading system to load large amount of network traffic data to a network performance monitoring database using PL/SQL, SQL Loader, and UNIX scripts.

Confidential

Senior Software Developer

Software design and implementation on Norstar Integrated Communications System. Primary responsibilities included Applications Layer and Network Layer feature Implementation using C on real-time system: Designed and implemented information transportation server which transfers protocol specific data elements among related system entities through its message interface to support call features. Completed least cost routing feature to allow different routes to be chosen depending on the time of day for outgoing network calls from an ISDN terminal.

Confidential

Research Assistant and Teaching Assistant, Computer Science Department

• Developed an image processing software package for information extraction in character recognition using C/UNIX on SUN SPARC 10.
• Designed and implemented a texture image classification algorithm using C/UNIX.