SUMMARY:

To obtain a position as a Sr. Oracle Database Administrator

TECHNICAL SKILLS:

Database: ORACLE 7.x 8i 9i, RAC 10g 11g and 12c, Exadata, MySQL

Database Replication: Oracle Data Guard, Streams, Shareplex, Golden Gate

Database Tools: TOAD, Oracle Grid Control, Erwin, ER Studio, DB Artisan

Database Backups: Oracle RMAN, NetApp backup ORACLE

Developer Tools: Form Builder, Report Builder ERP

Applications: Oracle EBS 11i, R12

Computer Programming: PL/SQL, C, Pro C, Perl

Operating Systems: UNIX, Linux, Windows

EXPERIENCE:

Sr. Oracle Database Administrator

Confidential

Responsibilities:

• Responsible for creating, supporting, and maintaining Oracle RAC10g/11g databases in a Linux environment, using, Oracle Data Guard, Shareplex, and Golden Gate replication software for high availability and transactions for an OLTP environment. Confidential database architecture handles millions of transactions daily in a triple architecture with load balancing and failover functionality.
• Responsible for Ticketweb system, which uses Oracle physical active data guard 11g in a primary and standby architecture, and also replicates in multiple reporting Oracle 11g databases.
• Migrated ticketing system from an Oracle Streams 10g architecture to an Oracle 11g physical data guard architecture, using Oracle data pump and RMAN cloning technique.
• Responsible for the B2B Oracle authentication and permissioning system implemented in a three node 11g RAC primary and a three node Oracle physical active data guard.
• Also responsible for MySql databases in a multi - level master to slave and master to master configurations

Sr. Oracle Database Administrator

Confidential

Responsibilities:

• Responsible for creating, supporting, and maintaining Oracle EBS R12 and 10g/11g RAC databases, using ASM in a Linux environment.
• Responsible for cloning entire Oracle financials system from application to database.
• Implement RMAN scripts to backup and restore databases to a point in time and full recovery.
• Responsible for upgrading and patching Oracle ERP system from application to database levels.
• Implement Vertex tax system to an Oracle EBS R12 system.
• Create database monitoring processes, using Linux scripts and Oracle Grid Control 11g.
• Created Oracle Grid Control to monitor all production and development environments, including application and database servers.
• Also, implemented Oracle AMP and ACP (Applications Management and Change Management Packs) to monitor all of our Oracle Financials systems.

Sr. Oracle Database Administrator

Confidential

Responsibilities:

• Responsible for creating, supporting and maintaining 10g RAC databases, using ASM.
• Responsible for PL/SQL code review for production and quality assurance databases and fine tune queries.
• Create RMAN scripts to backup the database.
• Created ETL scripts to pull data from production to the data warehouse, using a combination of PL/SQL stored procedures, data pump scripts, and UNIX scripts.
• Responsible for creating, maintaining, cloning, and upgrading multiple node RAC databases.
• Create a disaster recovery plan to restore the database into another server.

Oracle Database Administrator/Developer

Confidential

Responsibilities:

• Responsible for creating an asset management custom application, gathering system/client requirements and developed and implemented Oracle stored procedures and Perl/Unix scripts.
• Used a combination of Perl scripts and PL/SQL stored procedures to transform the data and migrate to Oracle instances.
• Integrated the application to Confidential to automate all the background processes.
• Created the application interface to determine the communication protocol to interface with other applications.
• Created finance and asset management reports using Oracle Reports and PL/SQL scripts.
• Maintained and supported an Oracle Data Warehouse finance system.
• Create RMAN scripts to backup the database and create a process to restore and recovery the database.

Oracle Administrator/Developer

Confidential

Responsibilities:

• Responsible for the development of Networks Procurement, a business to business purchase request and ordering(PR and PO),system for both a web and client based system, used with Confidential manufacturing supply chain ERP.
• Used Oracle Forms 6i and PL/SQL packages, stored procedures, and triggers to create user interfaces and apply business rules.
• Created reports, using Oracle Report builder 6i.
• Created SQL Loader scripts to load and the migration of data to the Oracle database.
• Responsible for performance tuning SQL scripts and PL/SQL packages.

Oracle Database Administrator

Confidential

Responsibilities:

• Responsible for multiple Oracle database instances, including e-commerce and web statistics databases on a Sun OS server.
• Responsible for the physical and logical backup and recovery implementations.
• Created and updated roles and permissions on Oracle users.
• Created new schemas, using Erwin, to construct and maintain Entity Relationship ( Confidential ) diagrams.
• Created reports for the finance and marketing departments, using Oracle report builder and also Perl language for Web based reports.
• Fined tuned SQL statements to improve performance.
• Created PL/SQL stored procedures and packages for implementing business rules and filtering data.
• Responsible for the migration and mass loading of data to the Oracle database.

Oracle Application Financials Developer

Confidential

Responsibilities:

• Responsible for technical specifications and implementation of ORACLE Financials 10.7 and 11i in the area of Fixed Assets, Labor Distribution, and Confidential .
• Implemented a program to download Fixed Asset information to a scanner to perform physical inventory.
• Used sql loader to upload modified Fixed Asset information to the appropriate tables.
• Created reports, using Report Designer, for Confidential, Labor Distribution, and Fixed Assets modules.
• Fined tuned existing PL/SQL queries to improve performance.
• Created PL/SQL packages for customized functions.

Oracle Developer/Database Administrator

Confidential, California, Edison

Responsibilities:

• Responsible for designing and implementing a system to calculate energy usage for high energy consuming customers, using Oracle as the main database engine.
• Used a combination of PL/SQL stored procedures, and embedded sql, using Pro C, to implement the business rules.
• Used PL/SQL stored procedures and triggers to implement table constraints and calculate derived table entries.
• Responsible for updating Oracle Forms to accommodate new requirements.
• Fine tuned existing squeries to speed up the system.
• Use Erwin and Power Designer to design and create the Entity-Relationship Diagram and generate the DDL scripts.