Summary

Oracle 7 Database Administrator DBA Oracle 8 Database Administrator DBA Oracle 8i Database Administrator DBA Oracle 9i Database Administrator DBA Oracle 10g Database Administrator DBA Oracle 11g Database Administrator DBA

Experience overview

Being an IT professional, I have more than 18 years of experience in database development, database administration DBA , and system analysis in the information technology IT field. He has experience with most of the major databases, data warehousing design, ETL informatics, Oracle EBS, WinSCP, Linux, PL/SQL and T-SQL coding, wrapping implementation, creating and modifying scripts in major computer languages, implementing Oracle patches, TAR, and data modeling using ERwin.

Project Experience

Oracle Database Developer

Confidential

• Participated in the analysis, monitor, and development of DoD contract-ATP project for Dept. of Defense and by using PL/SQL, SQL, RAC and Oracle10g and 11g Database.
• Support the Social Security Administration project for maintain the group of databases by using Oracle 11g and 10g, Oracle Enterprise Manager, RAC on Unix system and IBM system.
• Responsible for implementation with pl/sql programming, modify function on the procedures, functions, and packages on the data warehousing database.

Oracle Database Developer

Confidential

• Participated in the analysis, design, and development of IBM contract-ATP project for Dept. of Homeland by using PL/SQL, SQL, TOAD,RAC and Oracle10g and 11g Database.
• Designed and participated in the system full lifecycle development and documentation of the ATP Logical Design Model and Physical Design Model by using Erwin, MicroStrategy Architect pl/sql programming, Replication, Oracle Database,Oracle 10g, 11g upgrade and , SQL Loader.
• Responsible for implementation with pl/sql programming, Informatica and wrapping function on all procedures, functions, and packages on the data warehousing database.

Oracle Database Administrator DBA

Confidential

• Handles CCIPODEV, CCIPOTST, and CCIPOPRD developing, testing, and production of multi databases RAC , peoplesoft, oracle EBS, oracle10g db on UNIX and Linux Platform.
• Working as a production DBA on FAA projects for OLAP, OLTP, OBIEE, RABACUS, MicroStrategy Architect, PeopleSoft, TC-T2CWP databases.
• Analyzes and solves issues involving Oracle 9i Database by using Enterprise Server and different software packages and sql, pl/sql programming for development database, Oracle EBS.
• Prepares to do CR and pl/sql, sql, Crystal Reports, C, C programming for IMS data warehouse.
• Checks the backup server and backup report status, SharePlex, Oracle10g, Oracle11g, Sybase.
• Studies and analyzes CMS environment in Oracle RAC 11g for production, test, and development.

Oracle Application Developer/DBA

Confidential

• Provided maintenance, customer support, sql and pl/sql programming, MicroStrategy Architect,Informatica and system administration for National Support and Maintenance.
• Worked on multiple database servers for data warehousing, PeopleSoft HRMS on Linux.
• Created scripts and C, C programming for various objects creation/modification using SQL Server, Informix, Oracle 9i and 10g Teradata, TOAD, Oracle Enterprise Server, Informatics ETL, and UNIX on SunOS5.9, PeopleSoft HRMS 8.9, and People Tools 8.47.

Oracle DB Developer/DBA

Confidential

• Responsible for design, maintenance, table space creation, user's creation, and space allocation.
• Worked on multiple database servers SQL Server, Oracle, Informix, Sybase . Data transform between different RDBMS platforms, import/export data, and data population/loading.
• Created scripts and C, C programming for various objects creation/modification using PL/SQL, T-SQL, Linux, Java, data warehousing, data mining, and metadata management.

Data Developer

Confidential

• Provided support for PeopleSoft Financial/CRM on Oracle 7.3, 8, 8i and 9i data modeling T-SQL and PL-SQL programming and data analyzing by using ERwin, Java, data warehousing, SQL Server 2000, JBoss, Informix, Sybase, data warehouse, ERwin, Metadata, Unix Platform, Linux, and NT.
• Worked on the NASD contract.

Oracle DBA and Project Leader

Confidential

• Managed Oracle 8 Database for CDR System on UNIX.
• Worked as DBA and developer for both production and test Oracle Database, SQL Server, and Sybase maintenance and management. Daily duties dealt with user management, space management, PL/SQL tuning, backup, JBoss, Crystal Reports, SQL Loader, DBArtisan, data warehouse, DB2, Exceed, T-SQL, ERwin, PeopleSoft financial package, and data warehouse in Unix/NT environment.

Data Specialist

Confidential

• Focused on software development and information technologies used for accounting, banking, and Point of Sale POS to promote and develop accounting and banking equipment, POS products, Bar Coding system, GUI system, Informix, Sybase, Unix, Oracle PL/SQL, T-SQL development. Served as a DBA for the production database.
• Participated in the design, analysis, and programming of databases, forms, reports, data modeling, and graphics for a government contract on Oracle Database and SQL Server.

System Analyst

Confidential

• Designed and implemented relational database management systems RDBMS for U.S. Congress, various state bar associations, and other major clients by using Embedded SQL, PL/SQL, C, and C on UNIX, VAX/VAM, Novell, and Oracle Database.
• Participated in the analysis, design, and development of Oracle 7 application to create, maintain, and manage all customers, manufacturers, products, and vendors by using PL/SQL, SQL, and Oracle Database.
• Developed the interface for Info Landing to handle telecommunication by using a GUI package, C, MapInfo, and Pascal on UNIX, 3COM, and IBM mainframes.
• Designed and participated in the system full lifecycle development of the Inventory and Accounting systems for A A International Trade Co. by using Turbo C, C , Microsoft C, FoxPro, Oracle Database, and SQL.
• Developed and implemented Chinese Language Driver and Japanese Translator and Accounting System by using C, Lotus 1-2-3, and NjStar.