SUMMARY

• Oracle E - Business suite R12/R11i Applications, Database 12c/11g and Middleware Administrator, Data analyst and Developer. Worked with Oracle Corporation in Oracle Managed Cloud Services (OMCS), Confidential Ltd and Confidential .
• 16 years of total IT Experience in the Oracle technology areas including Apps DBA, Oracle DBA and Middleware DBA, Data Analyst and Developer.
• Oracle E-Business Suite R12.x and 11i Administration, Database 11g Administration on Oracle Linux and Exadata servers.
• Performed Oracle EBS and DB Upgrades - R12.2 from 12.x and 11i.
• Performed Database upgrade of 11g from all lower versions.
• Worked with RAC, ASM, Clusterware, Data guard, EM Grid control and RMAN tools.
• Experience in R12.2 Online Patching using ADOP end-to-end cycle, troubleshooting.
• Implemented bi-directional replication using Goldengate 11g with Oracle-Oracle and Oracle-MySQL setup.
• Performance tuning using AWR, Statspack.
• Expertise in Oracle Weblogic Server Administration
• Experience in installing and administering Oracle Webcenter, Webcommerce and Endeca integration.
• Installed and configured Oracle Identity management products (OAM/OID).
• Installed and configured Oracle Data Integrator (ODI) and EDQ/EDQP.
• Installed WLS and created master/work repository schemas and data objects with RCU.
• Worked closely with Development teams, guided and helped in implementing a ETL strategy with high availability setup of ODI.
• Experience working with Developers, Functional teams, Business leads and Oracle Support teams for issues and Bugs.
• Planning and implementation of Release and Change Management processes.
• Leading and managing operations/projects with offshore team coordination.

TECHNICAL SKILLS

Operating Systems: Oracle Enterprise Linux 5.x and 6.x, Redhat Linux, AIX, Windows.

Oracle Applications: Oracle E-Business Suite R12.2.x, 12.1.x, 11i, and EM 11g.

Databases: Oracle Database 12c, 11g/10g RAC/Non-RAC/ASM, Data guard, MySQL.

Languages: PL/SQL, SQL, Perl, PHP, Java and Shell scripting.

Oracle FMW: Weblogic Server, Oracle Goldengate, SOA Suite, RCU, Web center/Endeca, LDAP, SSO, OIM, EDQ, ODI and ADF.

Tools: Microsoft Project, Microsoft Office, Visio, Erwin, MS Excel, MS Word, Outlook, MS Power point and MS Access.

Environment: Exadata Engineered systems and commodity Oracle Enterprise Linux Server VMs.

Web Servers: Apache, Oracle AS 10g, IIS.

Practices: PMP and ITIL.

PROFESSIONAL EXPERIENCE:

Confidential

Principal Apps DBA

Environment: Oracle Enterprise Linux, Solaris 10.

Responsibilities:

• Manage Customer requirements with strong focus on customer’s business needs, prioritize tasks as per customer’s needs, come up with solutions, implement and meet or exceed customer’s expectations.
• Oracle EBS Technical upgrade from 12.1.3 to 12.2.3 and Database 11g from 10g.
• Administration of EBS, RAC/Non-RAC Databases, EM11g, ASM and boundary applications for multi-tier, multi-Terabyte Prod/Non-Prod environments.
• Setup, Configuration and Administration of physical standby Active Data guard instance.
• Data replication from MySQL to Oracle using Oracle GoldenGate for a boundary application.
• Install and configure of FMW components with SOA suite, ODI and EDQ/EDQP.
• Performance tuning, Incident and Problem management, RCAs.
• Lead offshore teams in 24 x 7 operating model.
• Documented processes, procedures and provide guidelines/inputs to team and management.

Confidential, Santa Clara, CA

Principal Applications DBA/Architect

Responsibilities:

• End to End production support for customer’s Applications for Electronic Measurement products division.
• Administration including Patching, Cloning, Backup & Recovery, Monitoring and resolving issues/incidents.
• SLA Mainitenance, problem management and RCAs
• Upgrade of Oracle EBS R12 from 11i, Database upgrade to 11g.
• WLS Administration for deployed internal JEE applications.
• Performance tuning including SQL tuning and Application tuning.
• Data center migration support from HP-UX to AIX environment.
• Worked as a collaborative leader across technical, administrative and management staff levels.

Confidential

Production DBA Manager

Responsibilities:

• Responsible for managing operations on customer's production instances.
• Planning and handling of technical upgrades including point release and major releases.
• Handled migration of Teradata client in to on-demand infrastructure including OS upgrades RHEL4 to 5, Discoverer upgrade.
• Handled RAC stabilization and Apache Stabilization patching.
• Planned and managed R12 upgrade/stabilization for clopay customer production instances.
• Handled JRE upgrades, AD and ATG upgrades for all the customers.
• Worked with Support and development teams for the functional and performance issues through SRs and Bugs.
• Applied several patches, data fixes and customer code objects to the instances.
• Played key role in ISO initiatives by being an internal quality auditor for the change and release management processes across the organization.

Confidential

Senior DBA

Responsibilities:

• Installation, upgrades, configuration, capacity planning, administration of Oracle Applications.
• Initial setup, installation and configuration of Apps environment and Database.
• Setup and initial configuration of two database environments for an internal client/server application. Developed interfacing scripts for data migration between the applications.
• Data loading, cleansing and porting between multiple databases.
• Written and implemented shell and SQL scripts for automating various maintenance activities of databases.
• Written custom programs and scripts in PL/SQL and Perl for some of the requested functionalities (similar to ETL) from time to time.
• Analyze client requirements and create DB/APPs environment to support business needs.
• Quality Processes implementation for internal development and within the IT services group.

Confidential

Project Lead/DB Architect

Responsibilities:

• Involved in Pre-sale technical activities including business requirement specifications, estimation, proposal and presentations/demos to client, which resulted in winning the bid.
• Analysis, Design, Development and Customization of Management Application in JSPs and Oracle Database.
• Database design and documented the data model for the application.
• Installed, configured and setup the database for the development, staging and production environments including a Disaster recovery site.
• Documented all the Database maintenance procedures including backup/recovery strategies.
• Trained the IT administrative users on the application usage and database procedures.
• Involved and worked with a third party vendor in evaluating the open sources Liferay and MVN Forums.

Confidential

Technical Lead/DB Programmer Analyst

Responsibilities:

• Analysis, Design and Development of client/server application and deployment in three interconnected counselling locations over a WAN. The software facilitates centralized admissions with counselling of students.
• Developed PL/SQL procedures for the backend business rule processing for the core Admission modules.
• Initially involved in Pre-sale technical activities including business requirement specifications, estimation, proposal and presentations/demos to client, which resulted in winning the project.

Confidential

Technical Lead

Responsibilities:

• Maintenance and custom development for content management system (Interwoven Teamsite).
• Implementation of Idiom World server for GEMS Website.