SUMMARY

• In a career spanning over 2 decades extensive experience with administrating and installing various Oracle products.
• Recent experience includes Oracle EBS, Oracle Weblogic and Oracle database server environments.
• Support businesses to integrate new secure technologies into existing stable application implementations.

TECHNICAL SKILLS

Oracle EBS: version 10.7, 11.5.10, 12.1.3.

Oracle Db: server 11g, 12c 19c and all earlier versions. Along with utilities data pump, tkprof, AWR, ASH, Oradebug, OPatch, RMAN, ASM.

Oracle Fusion: WebLogic server 10.3.6. SOA 11.1.1.7, OBIEE, Application Express 20.1, Tomcat 7 Oracle Spatial 9i and 10g

IBM: AIX 7.1,7.2, Linux Redhat, Solaris, HP - UX. Shell scripts. Python, Curl.

Database tools: Shareplex(data replication), STAT(production migration and version control), FogLight(database monitoring) and Toad

PROFESSIONAL EXPERIENCE

Oracle EBS DBA

Confidential - Aliso Viejo, CA

Responsibilities:

• Administer Oracle EBS 12. This has been a multi-tiered and a multi-org environment supporting multiple languages.
• Setting up multiple OC4J servers for scalability on a physical server.
• Administering concurrent manager for the workers, work shifts and specializations.
• Identified and resolved performance issues. Utilized Rest API Web services returning JSON objects for data exchange using Python modules or Curl.
• Installed and administer Oracle SOA environment with B2B for document exchange with vendors. Worked with WLST scripts for monitoring.
• Apply patches to keep environment secure and updated.
• The environment was setup for scalability as a cluster of 2 servers behind a F5.
• Utilized SOA 11.1.1.7 on WebLogic 10.3.6. As a part of SOA setup created JDBC data sources.
• Setup JMS servers and resources including Topics and connection factory.

Oracle EBS DBA

Confidential

Responsibilities:

• Perform SQL tuning as required for utmost performance.
• Installed and setup Oracle OBIEE environment.
• The Oracle database was setup in an ASM environment.
• Production environments are supported by reporting environments refreshed in real-time using shareplex data replication technologies.
• These reporting environments become source for BI and analytics.
• Installed and setup a migration tool, STAT for development team to migrate Apps objects (menu, concurrent programs...).
• Architected and installed Vertex tax rate software.
• It is supporting Oracle EBS, Siebel and salesforce environments as the tax rate source.
• Setup integrated SOA gateway to expose EBS data to be consumed by other applications.

Oracle EBS DBA

Confidential

Responsibilities:

• Oracle EBS 11.5.10, 12.1.1, Oracle 11g, Siebel, Custom application.
• Administer Oracle EBS 11i multi-org environment.
• Cloning production environment for development, testing or user acceptance testing needs.
• Setup and configured job scheduling product AppWorx for scheduling job chains.
• These chains had jobs from EBS and Siebel intermingled for business processes which enable data flow between the environments.
• Designed and created shell scripts for exchange of data securely with banks and other organizations.

DBA

Confidential

Responsibilities:

• Was supporting both an Oracle EBS environment for business support as well as responsible for Oracle R&D environments.
• Setup and refresh test and development instances from production.
• Assisted in products performance queries.

DBA Manager

Confidential

Responsibilities:

• Supporting web applications development team.
• The product was based on Oracle spatial, providing maps for analysis and decision making for organizations.
• Architecting & Installed Oracle Spatial server.
• Designing and supporting ETL processes to load client data.
• Designing and supporting DataMart.

DBA Manager

Confidential - Irvine, CA

Responsibilities:

• Positioned as an active team lead for Database Administrator's (DBA).
• The team is a part of Technology team supporting 52 database instances and associated application systems like PeopleSoft, Clarify etc.
• Installing, patching and managing Oracle Applications 10.7.
• Designing and implementing reporting Oracle instance architecture.
• Implemented table partitioning and complex query tuning.
• Implemented Outer bay technology tool for data purging from Oracle Applications database.
• Snapshot architecture with materialized views for data warehousing system.
• Database design & data modeling. Setup standards for object naming in database environment.
• Test backup and recovery procedures for disaster mitigation.

Oracle DBA

Confidential

Responsibilities:

• Oracle 7.3, Reports 1.1, Forms 3.0, Unix Shell scripting, RPC calls.
• Involved in development of a new product at leading database vendor.
• As a part of systems group responsibilities include development and database management.
• Installing and managing Oracle server instances.
• Developed Pro*C programs with RPC routines to interface with other systems.
• Responsible for product tuning based on rule-based optimizer.
• Redefined complex queries logic to avoid performance problems.

DBA

Confidential

Responsibilities:

• Oracle 5.0, 6.0, 7.1, Forms 2.3, 3.0. Pro*C As an analyst was involved in developing Financial Accounting System for a leading publisher in India.
• Also involved in database administration, support, training and installation activities.
• Responsibilities included developing programs based on analysis and defined specifications.
• Developed Entity Relationship diagrams, normalization & structure charts.
• Was responsible for coding, testing and quality assurance of different modules.
• Was responsible for developing application software and tuning the code for optimal performance.
• As a programmer analyst worked towards developing Hospital Information System for 800 bed hospital.
• Involved in coding different modules.
• The system manages patient registration system, managing patient visits to outpatient departments and special clinics.