OBJECTIVE:

• To obtain a position as an Oracle Database Administrator

TECHNICAL SKILLS:

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

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

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

Database Backups: Oracle RMAN, NetApp backup, MySQL, MongoDB

AWS: Oracle EC2 and RDS, MySQL EC2

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

ORACLE Developer Tools: Form Builder, Report Builder

ERP Applications: Oracle EBS 11i, R12

Operating Systems: UNIX, Linux

PROFESSIONAL EXPERIENCE:

Sr. Oracle/MySQL Database Administrator

Confidential

Responsibilities:

• Configured, setup, and created an 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.
• Created a three node Oracle 11g RAC for a B2B Oracle authentication system with a three node Oracle physical active data guard.
• 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 PL/SQL code review for production and quality assurance databases and fine tune queries.
• Created ETL in PL/SQL code to migrate and transform data from external data sources to Oracle OLTP system.
• Created PL/SQL code to archive data into a partitioned table in an OLTP system to improve database performance.
• Greatly improved performance in daily transforms by identifying and reorganizing indexes on major tables.
• Improve performance by identifying the use of nested loops and hash joins on major tables with the use of hints and indexing.
• Installed and configured Golden Gate on 11g database for bi - directional replication.
• Resolved issues in conflicts between the target and source database in Golden Gate.
• Scaled horizontally MySQL on-premises, adding an additional 64 MySQL databases in a multi-level master to slave and master to master configurations to take more customer traffic and accelerate transactions.
• Migrated and scaled MySQL databases from on-premises to AWS EC2, adding 64 MySQL EC2 databases using multiple AWS zones
• Cloned MySQL on-premises to AWS EC2 without effecting on-premises traffic
• Migrated on-premises Oracle database to an AWS Oracle RDS database.
• Performance tuned MySQL databases by adding appropriate indexes.
• Upgraded MySQL from 5.6 to 5.7 in a multi-level master to slave configuration.
• Experience in NoSQL Database MongoDB
• Configuring and setting up MongoDB replica set and performing MongoDB operational routines
• Perform MongoDB backups and restoring backups

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/PL/SQL Developer

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.
• Identified tables major that needed indexing to improved performance
• Improve performance by identifying the use of nested loops and hash joins on major tables with the use of hints and indexing.

Oracle PL/SQL 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 AutoSys 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.
• Implemented table partitioning to improve performance on data warehouse system.

Oracle PL/SQL 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/ PL-SQL Developer

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 (E-R) 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 Grants.
• 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 Grants, Labor Distribution, and Fixed Assets modules. Fined tuned existing PL/SQL queries to improve performance. Created PL/SQL packages for customized functions.

Oracle PL/SQL Developer

Confidential

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 queries to speed up the system. Use Erwin and Power Designer to design and create the Entity-Relationship Diagram and generate the DDL scripts.