SUMMARY

• Over 11 years of IT experience.
• Demonstrated expertise in Oracle DBA and Oracle FMW Administrator.
• Expertise in Production DC and DR setups for Oracle DBA & Oracle Fusion Middleware 11g stack on Virtualization (VMware) and Oracle VM.
• Well experienced in installing, Configuring and administering the Oracle Fusion Middleware 11g, 10g products.
• Good Technical knowledge in Oracle Fusion Middleware, Oracle Database, PL/SQL, SQL.
• Experience in Installing and Supporting applications in cloud services.
• Experience in administering & supporting EXA - DATA and EXA-LOGIC services.
• Good knowledge on hardware sizing for the environment setups of DC, DR, UAT, SIT and DEV.
• Well versed with cloning, clustering, patching, Upgrading and performance tuning of Oracle Fusion Middleware products and Oracle Database.
• Well experienced in Installing, Configuring, Upgrading, and administering Oracle 9i/10g/11g standby and RAC database instances.
• Good experience in database design, PL/SQL programming on Oracle 9i/10g/11g.
• Good Experience in taking backups of Oracle standby and RAC instance databases.
• Experienced with writing UNIX scripting & jobs.
• Expertise in taking AWR, ADDM, reports and Performance Tuning of Oracle Databases
• Expertise in installing and administering WebCenter Suite, SOA, Identity Management
• Well versed with setting up SSO between OAM and FMW products and EBSO, HRMS, OBIEE, Siebel CRM for seamless navigation.
• Involved in full life cycle implementation of Web Applications in both Standalone, High Availability and Integrated environments.
• Good Communication skills and Comprehensive problem solving ability.
• Ability to liaise within a team and as an Individual.

TECHNICAL SKILLS

Programming: PL/SQL, PSP, C, C++, HTML, XML, Oracle Web Server PL/SQL, UNIX Shell Scripting.

Java Technologies: JSP, XML, JavaScript, AJAX, EJB, JDBC

Database Skills: Oracle 9i/10g/11g, MS SQL server

Operating Systems: Linux, Windows 2000/NT, UNIX (Solaris, AIX), VM

Application/Web Servers: Oracle Application server10g, Weblogic 11g, Glass Fish, OHS, Apache, Oracle Traffic Directory.

Oracle Technologies: Oracle Portal, APEX, Oracle Identity Management (OAM, OAAM, OES, OIM, OID, OIF, OUD, OVD), SOA, Forms 6i,10g, Oracle Discoverer, WebCenter, Enterprise Content Management, IPM, SES, MDM, Weblogic 11g & 12c.

PROFESSIONAL EXPERIENCE

Confidential

Technical Consultant (DBA, Administrator)

Responsibilities:

• Installation and Configuration of Oracle SES database product and integrate it with Siebel CRM application.
• Install, configure and troubleshoot Oracle Golden Gate & monitor for data replication.
• Refresh test databases with the production data.
• Generate the AWR and ADDM reports to analyze the bottlenecks and fix the issues in database
• Monitor & manage the databases with the Oracle Enterprise grid control.
• Exporting and importing data between different application databases.
• Taking Oracle dataset backups and restoring them.
• Worked on setting up the Oracle Data Integrator tool.

Confidential

Senior Technical Consultant (DBA, Administrator)

Responsibilities:

• Performed Installation of Oracle database, WebCenter, Content Management & SES on Development instance and develop procedures for implementation in Production.
• Performed SSO of WebCenter, ECM & SES with OAM & OID for Single Sign on(Dev, Test & PROD)
• Integrated SES with WebCenter for the enterprise search facility.
• Migrated all the SES from customer supported environment to Oracle Cloud Supported systems.
• Integrated WebCenter 11g with OAM & OID for Single sign on.
• Integrated Content management with OAM and OID.
• Did the OAM auth authentication and set the OID authenticator for Single Sign On.
• Upgraded WebCenter from 11.1.1.5.0 to 11.1.1.6.0
• Migrated APEX data from customer supported environment to Oracle Cloud Supported systems.

Confidential

Oracle Database Administration

Responsibilities:

• Installing, configuring, Upgrades and Supporting Oracle Databases Versions(9i,10g & 11g) on Redhat Linux,AIX, Sun Solaris.
• RAC (Real Application Clusters) installation and Administration.
• Configuring High Availability solution like Dataguard (physical and logical standby) and Patching. Applying CPU (Critical Patch Update), PSU (Patch Set Update) and One-off Patches.
• Worked on taking and restoring backups on Exadata database servers.
• Database performance tuning:
• Troubleshooting Database slow and root cause analysis
• Troubleshooting Database high CPU utilization issue
• Tuning memory structures (buffer cache, shared pool etc.)
• Analyzing the deadlock issue(ora-60), Self deadlock issues and analyzing the trace file
• Generating the AWR, ADDM report and analyzing.
• Good knowledge on Golden gate and its implementation.
• Query Tuning:
• Collecting the statistics in regular interval, identifying the stale statistics.
• Tuning the query when it became slow and Troubleshooting Slow session issue
• Troubleshooting Wrong result issue.
• Used sql tuning advisory and sql access advisory
• Troubleshooting queries after the database upgrade or migrate
• Identifying and Troubleshooting wrong index usage
• Exporting and importing data from production to Test databases.
• Worked on troubleshooting RMAN backup issues and backup sets.

Confidential

Oracle Fusion Middleware Administration

Responsibilities:

• Support all the Oracle FMW services.
• Setting up weblogic and SOA clustered environment for high availability and failover.
• Upgrading SOA, AIA and IPM products from 11.1.1.3 to 11.1.1.6 along JVM and Weblogic.
• Performance Tuning of various WebLogic Servers, SOA, IDM, Webcenter and related resources (Memory parameters, JDBC Connection Pools).
• Integrating SOA with EBS R12.
• Analyzing Thread Dumps.
• Deployed applications/composites in EM console and OSB console.
• Installing, Upgrading, Troubleshooting, and fixing all the Identity Management related in customer environments.
• Support all the escalated issues with best of the solutions.

Confidential

Senior Technical consultant (DBA, FMW Administrator)

Responsibilities:

• Supporting Agilent OAM, OIM, OID environments.
• Agilent has the Identity Management setup for integrating its EBS R12 with OAM 10g, also ADF application(Ice project) integrated with OAM.
• Agilent support included troubleshooting OAM (SSO), OIM (Xellerate) and OID issues.
• Support changing SSL certificates on OID/OAM and make sure the activity completes in the scheduled time without any extensions.
• Suggesting customer on how to setup the DR environment.
• Setting up mail notifications in weblogic for any admin related activities.
• Supporting customer applications for testing and fine tuning.
• Troubleshooting replication related issues in OID.
• Fine tuning weblogic servers for HA there by reducing the restart of services.

Confidential

Senior Consultant (Administrator, DBA)

Responsibilities:

• Worked on installing Oracle Portal 11g and all its components on IBM AIX P5 system along with the other Application Tracks (CRM, HRMS, FINANCIALS and SOA) for POC.
• Installed Web Gate for integration of Portal with OAM, thereby providing Single Sign-On access to different applications like HRMS, CRM, Financials, MDM, Documentum, DWBI, SOA and Core-Insurance.
• Worked on successful implementation of the project POC and Production Go-Live for Confidential .
• Contributed for the Web/App/DB Server Hardware sizing and validating the same for DC, DR, Test, UAT and Dev environments.
• Architecting the whole Oracle Portal Web, Application and Database servers in lieu with other applications for Production set up for better scalability.
• Supporting 28 application servers 3 Fusion applications and respective custom applications.
• Installed and configured 10gR2 RAC database in DC and DR, Test & UAT.
• Installed and upgraded IDM, Oracle Portal 11g (11.1.1.4.0 ) and all its components.
• Installed WebCenter Suite 11g and its components. Worked on Integrating WebCenter services (Discussion Forums, Wikis) with Oracle Portal.
• Worked on integrating Portal and WebCenter Services with OAM.
• Wrote clone script to install Oracle Portal 11g on different instances.
• Worked to make the servers withstand the 1500 concurrent users with ease.
• Worked on writing scripts for taking timely back up of RAC database.
• Administering Oracle Application Servers, WebLogic servers and Oracle Database.
• Handling the PMP work of the project.
• Worked with the Sanovi disaster recovery team for timely recovery between the DC and DR.

Environment: Oracle 10gR2 RAC Database (10.2.0.4.0 ), Oracle Portal 11g, Oracle IDM, Oracle WebCenter Services 11g, WebLogic Server (10.3.4, 10.3.0), Webgate, IBM AIX P-5.3, Red Hat Linux.

Confidential

Senior Consultant (Administrator, DBA)

Responsibilities:

• Worked for the successful POC, Production setup and go-live of the project.
• Worked on preparing the hardware sizing requirement for the portal and Oracle database.
• Installed Fusion 11g components like WebCenter Suite11g (11.1.1.4.0 ), Web-Center Services (Discussion Forums, Wikis) in cluster on the virtualization software.
• Setting up Oracle Database 11g RAC setup for HA.
• Setting up access for Internet and Intranet users.
• Securing and implementing SSL on the web servers.
• Implemented Single Sign On with Central IDM.
• Fine tuned weblogic Managed servers for better performance.
• Tuned the database for better Performance.

Environment: Oracle Web Center Suite 11g (11.1.1.4.0 ), Oracle Portal 11g, Oracle Identity Management (10.1.4.3.0 ), Oracle 11g RAC Database, WebLogic Server (10.3.4, 10.3.1), IBM AIX P5.3, Red Hat Linux.

Confidential

Oracle Consultant

Responsibilities:

• Make estimates of different components for development.
• Interact with the client on daily and weekly calls.
• Design the intranet portal web site to be consistent with the Public site.
• Worked on developing Portal forms and Reports.
• Change the existing code of the portal forms for better performance.

Confidential

Oracle Portal Consultant

Responsibilities:

• Worked on creating tree structure of folders where users can upload the documents into the created folders.
• Worked on Ajax and Java Scripting.
• Worked on creating PL/SQL portlets and implemented java script where validations are required.
• Worked on generating PDF and Excel output for HTML reports.
• Does unit testing of the whole process for proper functionality.
• Documenting all the process and related data objects used.

Confidential

Oracle Portal Consultant

Responsibilities:

• Develop JSP pages as the front end with the user authentication.
• Develop PL/SQL procedures.
• Deploy the application on the middle-tier and render it in the portal page.
• Installed the Oracle database Application Express and developed the issue tracking system for the Confidential .

Confidential

Oracle Portal Consultant/Administrator

Responsibilities:

• Provide Administration support to production, staging and test Oracle Portal instances.
• Administer the Middle-tier, Infrastructure components.
• Renewing the SSL certificates in the Oracle Wallet Manager.
• Running SVU in Report/Clean up mode, running PDA scripts on the application server side for gathering configuration details.
• Run database schema validation scripts for logging the errors in Portal Repository.
• Worked with Oracle Support team to triage and fix the inconsistencies in Portal.
• Writing shell scripts to schedule cron jobs.
• Developed and deployed java Web application which allows the users to access the other websites integrated with portal.
• Worked with the DBAs and UNIX administrators in bringing up the application server environments.
• Monitoring the log files and troubleshooting for better performance.

Confidential

Oracle Portal Consultant

Responsibilities:

• Implemented SSO functionality for E-business suite 11.5.10.2.
• Integrated E-Business Suite with Portal as a partner application and synchronized user information.
• Developed portlets using PDK APIs and LDAP APIs against the data.
• Developed forms for entering data in the database.
• Created External Applications and linked them to the page.
• Developed Omni chart, bar graph portlets which represents the up to date data from the database.
• Developed Survey portlets, Web Clipping portlets.
• Developed JSP forms using Jdeveloper 10.1.3.2.
• Migrated portal pages, Providers from the development server to the production server.
• Worked on functionality gathering of the project MDES (Manufacturing Data Entry System).

Confidential

Oracle Portal Consultant

Responsibilities:

• Developed PL/SQL portlets using oracle PDK APIs.
• Developed java portlets and integrated them with the pages to show data on the portal pages.
• Worked on developing News Feeds to show the latest news of the Stuart Maue Group.
• Worked on JavaScript validation for the portlets for mandatory fields.
• Developed portlets using Oracle WebServer 2.0 PL/SQL web toolkit.
• Worked on customizing Discoverer Reports.
• Migrated portal pages, providers from the development server to production server.
• Held meetings along with the Project Manager for the functionality gathering of the project.
• Developed ‘’Use Case’’ documents for the project.

Confidential

Oracle Portal Consultant

Responsibilities:

• Being the core Member of the project, developed customizable PL/SQL Portlets using Oracle PDK APIs, Dynamic pages in oracle portal.
• Designed the Database structure and imported the data from the MS SQL server database to the oracle database.
• Designed pages and integrated them with the database through procedures and Packages and Triggers.
• JavaScript validations for the mandatory fields.
• Developed Portal forms and Charts.
• Take backup of Portlets, Pagegroups by Import/Export methodologies.
• Registering Providers.
• Developed java portlets and registered them on to the Portal.
• Using Enterprise Manager for Portal Administration.
• Interacting and advising the client for functional changes that are required.

Confidential

Oracle Portal Consultant

Responsibilities:

• Developed Portal Pages for the Display of the reports using page templates, portlets and Items.
• Created Partner Applications so that users can log into the E- Business Suite Home, on logging into the Portal page depending on the user preferences.
• Created links to the external applications like links to the personal mail servers.

Confidential

Oracle Technical Consultant

Responsibilities:

• Developed code using PSP, PL/SQL packages, JavaScript and DBA concepts.
• Used different Packages to assign the Jobs and raise the alerts.

Confidential

Software Developer

Responsibilities:

• The Recruiter database has got huge data which needs to be migrated from the development instance to the Production instance using MS SQL server Import and Export data console.
• Worked on MS SQL Query Analyzer and Enterprise Manager for comparing the data between the test and the development instance.

Confidential

Software Developer

Responsibilities:

• Worked on Jfree charts for integrating the chart features to simair.
• Developed decision support engine classes in java, which are used in the business logic of simair.
• Developed Servlets for business logic navigations.
• Developed forms and Program code based on the design requirement.
• Testing the Programs after approval and Installation.