SUMMARY:

• Oracle ERP Applications & Database Certified Professional with 15+ years of extensive experience as Enterprise scale Architecture design and providing IT road maps, Oracle Cloud Integrations and Multi cloud Technologies. System/Solution Design, leading, implementing, multi - platform environment and managing Oracle and Microsoft Technologies. Installations, Performance tuning/debug (database & applications), Upgrades, Cloning, Patching, Code migrations, Cross platform migration using Oracle tools and technologies. EBS Oracle Applications Financials, Manufacturing, SCM, BOM, OM, PLM, CSD, FS, HRMS, Payroll, ERP, CRM. Administering Unix/Linux Servers, IBM/AIX/HP, Sun Solaris. Familiarity of ITIL life cycle process and standards.
• Analyze/review the current Architecture and recommend best practice solutions to business.
• Gather Business requirements and Design/plan the right system for the business.
• Playing as a Global Instance advisory role for different technologies in the IT business.
• Have excellent experience on oracle cloud (PaaS, Iaas and Ssas) on ARCS, ERP financials, HCM,PBCS,OTM CPQ, ICS of oracle applications
• Installation, Upgrades, Migration, Application Customizations.
• Hands-on Experience in oracle Technologies 12.2,12.1 EBS, Database 12c,11.2,RAC,ASM,SSO,OAM,Hyperion,ASCP,CZ,Markview,kofax,Vertex etc..
• Installation of Oracle R12.1.1 E-Business suite in Fujitsu Cloud Environment and Upgraded to R12.1.3 with 11GR2 database on end to end including sysadmin responsibilities.
• Oracle Database 12c, 11g, 10g, 9i RAC Installation, Upgrades, Maintenance, and Support.
• Upgrade Multiple Oracle Applications starting from 10 to R12.2.x versions.
• Installation Oracle EBS R12.1.1 on Unix/Linux/Solaris System Administration.
• Linux Installation, Configuration, Networking & Administration.
• Plan and implement Oracle Real Application Clusters (RAC) on UNIX. Application Failover and high transaction volume. High Availability - Real Application Clusters (RAC) and Advanced Replication.
• Oracle Cluster ware 11g with ASM 10g and 11g.
• Experience with Oracle Fusion Middleware 11g installation and administration.
• Experience with Oracle Single Sign on (SSO) and Oracle Internet Directory (OID) implementation and administration.
• Implementing Data Guard setup and Flash Back.
• Implementation of Backup Strategies using RMAN, Oracle Import/Export, VERITAS Netback up, and HP Data storage.
• Concurrent managers & managing Concurrent queues, Printer configuration.
• Configuration of PCP - Parallel Concurrent Managers.
• Have a Good knowledge on Hyperion Product with Data ware House servers.
• Have Experience on Siebel applications and Database related to performance.
• Expert on EBS Financials and OBIEE modules in Oracle E-Business suite
• Designing & Developing for performance. Tuning, configuring DB for Performance, SQL tuning, Instance Tuning, stats pack TKPROF, AWR, ASH, ADDM, Security, Using Indexes and clusters, EXPLAIN PLAN, Appl tracing tools.
• Troubleshoot problems with concurrent managers, Apache, Jserv processes, and database performance.
• Extensively worked on Financials Modules, Inventory, AOL, Alerts, Workflow and System Administration.
• Audit, Capacity planning, tuning & performance enhancements.
• Hands-on experience in data interfacing from Legacy system.
• Good exposure in Project Management activities including Project Scheduling, Phasing, Coordinating Presentations and Workshop Sessions.
• Prepared technical design documents for customizations and conversions using AIM documentation methodology.

TECHNICAL SKILLS:

ERP Applications: Oracle E-Business suite R12.2.x, R12.1.x, R11i, 10, ASCP, Configurator, JD Edwards Enterprise One 8.12.

Cloud Applications: ARCS, HR Taleo, ICS/OIC, PBCS, HCM and Finance Applications

Databases: Oracle 12c, 11g, 10g RAC, 9i, 8i, 7. SQL Server, MS Access.

Others: Disaster Recovery, Data warehousing, RMAN, Performance Tuning, Backup and Recovery, Data Guard, ASM

Operating Systems: IBM AIX, Solaris, HP UNIX, RHEL, IBM AS-400, Novell Netware.

Oracle Tools: OEM, AD Utilities, ADI, XML/BI publisher.

Middleware: Oracle Application Server 12c,11g weblogic, 10gAS, 9iAS R2, 11g OAM, 10G SSO, OID, LDAP.

Languages: SQL, PL/SQL, C Shell, Linux Shell Scripting.

Integration Technologies: Service Oriented Architecture (SOA).

Web Technologies: FMW Fusion middle wear, Oracle App Server, Apache, Web Logic, OC4J, JDBC, Oracle Forms and Reports Server.

Hardware: Cisco UCS with Netapp storage, SSD, SAN, HP Data Storage, VERITAS Net Backup.

Reporting Tools: Oracle Reports 6i, Discoverer, and Business Objects 6.0 & XI, Data Warehouse, Hyperion HFM and Planning

Tools: Golden Gate, Oracle J-Developer, Oracle BI Publisher, TOAD, Web-ADI, SQL *Loader, SQL Navigator, PL-SQL Developer, Data Loader, Browser/Query Builder, VMware, CITRIX.

Methodology: Oracle AIM.

Oracle 10g: RAC

Oracle Applications R12: New Features for Administrators

Oracle Database 10g: Work shop for Administrators

Oracle Application server 10g: Work shop for administrators

Oracle11g: New Features for Administrators

Oracle Web Logic Server 11g: Administration Essentials

Oracle 11g: RAC and Grid Infrastructure Administration Accelerated Release 2

Oracle Identity Manager 11g: Essentials

Oracle Golden Gate 11g: Advanced Configuration for Oracle Oracle Identity Governance Suite 11g Certified Implementation Specialist

PROFESSIONAL EXPERIENCE:

Confidential

Enterprise DBA Architect / Cloud Integrations Specialist

Responsibilities:

• Lead the Team of DBA’s and Multiple vendors alog with Hands-on experience.
• Co-ordinate,attent demos and work with multiple vendors to implement new solutions to the Business.
• Planning,Design, and introduce new technologies to simply the procedures and cost effective for the business requirements.
• Managing Technical team memebers and Providing advise, teaching new methodologies related to problem solving solutions and proactive measurements.
• Responsible for all new databse, ERP applications design starategy along with security.
• Provided best solution for the DR starategy testing without impact of production systems.
• Provided resource, buget estimates for the oracle and Microsoft Technology projects.
• Complete interaction with senior management, support teams and involved in decision making discussions and change management.
• Business strategies and defining a technology road-map and IT systems architecture that will support the strategy.
• Created Strategic road maps for the next 3 to 5 years of Enterprise applications and present to management.
• Excellent Knowledge on upcoming/Future technologies of Multi type cloud Environments like On-premise cloud,Oracle cloud and Hybrid cloud technologies.
• Excellent knowledge of AI and IOT technologies.
• Basic knowledge of AWS and Azure cloud technologies.
• Biggest achievement was since last 4+ years no unplanned outage in the Enterprise systems.
• Worked with AUDIT team and control the SOX related issues.
• Successfully Implemented Multiple oracle Cloud products like ARCS, HR Taleo, PBCS, EBS to Sales force integration using oracle ICS.
• Currently working on oracle cloud HCM and ERP financials implementations.
• Hands-on Experience on End to End cloud integrations with multiple applications.
• Successfully implemented APEX 5.1 version and integrated with EBS application to replace I-seek tool for the Item search, SOX control RATT application, and Time card entries for the shop employees.
• Worked as project lead for all enterprise wise projects for the Architectural designs and Capacity planning.
• Built the initial business case including costs and justifications for the database Upgrade project and determining the testing effort and provide the cost estimate.
• Influence the management team to get it approved for the required budget for the projects.
• Upgraded Oracle EBS, ASCP and Configurator Applications instances from 12.2.3 to 12.2.8 Versions.
• Salesforce and oracle EBS integration using Oracle ICS cloud.
• Integrated Fireapps cloud application with in EBS applications.
• Integrated More4apps Wizards with EBS applications
• Successfully Upgraded all oracle databases and applications from 11G to 12C and ad/TXk 10 with out single issue and with in the budget with limited available instances.
• Lead and drive the full OVM project and successfully completed in 45 days including 60+ third part applications.
• Prepared the technical plan, Re-design complete Oracle EBS architecture and successfully implemented ORACLE OVM from VM ware,Physical servers converted to Virtual.
• As a success of OVM project we saved around 2 Million to our business.
• Successfully handeled and resolved oracle licenses issues.
• Successfully install Hyperion FDMEE and integrated with oracle cloud ARCS application.
• Successfully Upgraded Multiple ERP systems(EBS,ASCP,CZ,BPEL,UPK,SYNCRO and Ecomex) from 11.2.0.3 to 12.1.0.2(12c) database version.
• Implemented purging/Archiving solutions to minimize the data storage and improve the performance.
• As a success of all purging activities we saved around 250 K to our business on storage and maintainance.
• Upgarde R12.2.3 from 11.5.10.2 EBS applications for Multiple Instances Like Oracle EBS finance application, Oracle configurator,Syncro applications and EBS ASCP applications
• Implemented Multinode and PCP-configuration as part of R12.2.3 Upgrade.
• Upgraded Vertex O-series 6 and integrated with R12.2.3 applications.
• Installed Markview application and integrated with R12.2.3 EBS Applications
• Applying Quarterly database CPU/PSU and EBS CPU patches
• Successfully Upgraded java Version from java 1.6 to 1.7 with Secure Sign-on certificates technology
• Worked on Server/Database performance Tuning as part of R12.2.3 Application Upgrade
• Worked on Multiple Performance issues like Forms,Java issues with IE11 Compatability issues
• Provided solution for PLM issues
• Provided solution for Configurator module order booking related issues by creating F5 url for altbatch url
• Involved and worked on New hardware estimation and capacity planning as part of new instances build for the company separation
• Successfully completed SYSAUX purge in 11GR2 RAC databases.
• Perform Post clone steps
• Co-ordinated and provided Guidence to Hosted parter DBA team
• Provide day to day support for multiple applications like EBS,ASCP,CZ,Vertex,Markview,Salesforce,CPQ,SOA,B2B etc…
• Configured Nagios monitoring for all the EBS applications and monitor proactively..
• Day to day activities and User issues Trouble shooting

Environment: Oracle cloud ARCS, HR Taleo, HCM, PBCS, ICS/OIC. Oracle Apps R12.2.x, Oracle 12c, 11G RAC, Oracle 11g weblogic Server, BPEL/SOA,B2B applications, Discoverer 11g,Oracle applications HRMS, Financials, AP, AR, GL, Inventory, I procurement, I Expenses, Order management, Advance pricing, Purchasing, Planning, Projects, OTL Oracle Time & Labor, manufacturing, Sales Distribution, I store, I supplier, Receivables, I expenses, ASCP, UPK,CZ in Linux.

Confidential, CA

Sr. Technical Consultant and DBA Lead

Responsibilities:

• Managed 10 members of team including 2 on-site and 8 offshore team members.
• As part of management process I took more than Multiple people interviews and hired multiple resources in different departments with in Fujitsu inluding my team to make company success with High quality resources.
• Participated in Multiple pre,post sales technical solutions and proposals.
• Participated and lead in Multiple project intial discussions, Define project starategy, Design, Planning, capacity planning, Demand management, cost estimations for the the projects to finish intime and with in budget.
• Very good Hands on experience on Oracle OCI cloud as lift and shift technologies.
• R12.2.3 Upgarde from 11.5.10.2 applications along with 11G database Upgrade for Medical Mutual Organization.
• Served post Go-Live support for 3 months for the R12.2.3 EBS applications for Medical Mutual Organization.
• R12.1.3 Upgrade from 11.5.10.2 applications on Solaris Spark machine.
• Upgraded LAD-Localizations(Brazilian,France,Latin America) as part of R12.1.3 Upgrade project with Multi-Language environment for Tecumseh Products .
• Configured MWA Application services in R12 Applications for Tecumseh Products.
• R12.1.3 Upgrade from 11.5.10.2 applications along with DB upgrade from 11GR1 to 11.2.0.3 on Solaris Spark VM machine.
• Applying Quarterly database CPU/PSU and Ebsiness CPU patches along with RPC patches for Confidential Corporation.
• Implemented SSL on R12.1.3 applications on Solaris Sparc VM Machine for Confidential Corporation.
• Configured XML Gateway in the External application of IProcuement Module for Confidential Corporation.
• Provided training and guidence 11G Oracle Identity manager and Oracle access gate for R12 EBS Applications for Powell Industries.
• R12 Upgrade from 11.5.10.2 along with database upgrade to 11G from 10G and OATM conversion for CompuCom .
• Implemented the Hardware Load Balance R12 applications using Big-Ip for CompuCom.
• Implemented the 11G Weblogic OAM for the SingleSignOn users for the R12 EBS Applications for CompuCom.
• Upgrade the Vertex tax calculation tool from 3.0 to 4.2 Q-Series and integrated with R12.1.3 applications for CompuCom.
• Install and integrate the More4Apps tool for the Transaction, Event and Projects wizards with R12.1.3 applications for CompuCom.
• Install the 11G OEM grid control for the monitoring of EBS Applications and Other databases as well for CompuCom.
• Trouble shoot the day to day users issues and Performance improvement suggestions
• Installation of Hyperian Financials HFM & EPM ( 11.1.2.2) installations and administration
• Automated Hyperion cloning process from PROD to DEV without user intervention as per the scheduled time.
• R12.1.3 with 11GR2 database new implementation on Oracle VMware.
• Conveted OATM Table space and Upgrade the database from 10GR2 to 11GR2 for Oracle applications 11.5.10.2 in IBM AIX Platform for Medical Mutual organization.
• Upgarded applications from 11.5.10.2 to R12.1.3 in IBM AIX Platform and RHEL for Medical Mutual organization.
• Install the Oracle applications R12.1.1 and Upgrade the R12.1.3 in Fujitsu Cloud Environment.
• Upgrade database from 10G to 11G along with OATM Migration of 11.5.10.2 Oracle E-Business applications for Medvantex customer
• Install the APEX software 10G version for the SOD Tool for PSCnow.
• Install the SOD Tool V3.23 and integration with Oracle EBS applications for PSCnow.
• Install the Vertex O series V6 and Integrate the Oracle EBS applications for the Tax calculations for PSCnow.
• Implementation and Integrations of Vertex financial modules AP,AR,PO,Procurement,Billing and OHook in the Oracle EBS applications for PSCnow.
• Installation of Fusion Apps with Security level implementation
• Upgrade of Oracle Applications from 11.5.10.2 to R12.1.3 with database 11GR2 with RAC and Mutinode Architecture with Load balacing configuration for Kenan Advantage group
• Configured PCP, Apache,Forms and Reports Load balancing for the Two node applications and Two node RAC EBS Applications Architecture for Kenan Advantage group.
• Migrated o.s and upgraded database from Oracle ERP 11.5.10.2 with 9.2.0.6 to 11gR2 and converted database to RAC and ASM in oracle Linux 5 with 64 bit operating system for customer Kenan Advantage Group
• Upgraded from 11.5.10.2 applications to R12.1.3 E-Business suite applications with Fusion Middle ware modules for Kenan Advantage group.
• Involved as a team member for the SQL server Disaster recovery setup and Log shipping activities from primary to secondary data center.
• Setup Backup jobs and schedules a script for the Archive log removal on daily basis for the Sqlserver 2008 R2 databases.
• Installation of Microsoft SQL Server 2008 R2 and provided production support for the SAP Supported Application with RAC databases.
• Up gradation of database from 10G to 11G for DirecTV client
• Creation of Physical standby database in 11g for the DirecTV
• Installation and Up gradation of database from 9i to 10.2.0.4 for Medvantx
• Production support for 11.5.10.2 with 9i RAC database in Linux Platform for Kenan Advantage Group
• Production support for 11.5.10.2 applications with SSO integration in Linux Platform for Kenan Advantage Group Capacity planning analysis and provide solution for Performance issues for MTD client
• Capacity planning of the database for future growth estimation and performance improvement estimations
• Database design and server level capacity planning estimation with no of concurrent users
• Complete backup by using Snapshot level backup method using Net app Filers
• Involved in the preparation of upgrading document
• Patch analysis for R12.0.6 upgradation patches
• Applied patches by using adpatch utility.
• Up gradation of Oracle Apps from R12.0.4 to R12.0.6 and database from 10.2.0.2 32 bit to 10.2.0.4 64 bit
• Upgrade all the modules from R12.0.4 to R12.0.6 version for Kelly Moore Paints Corporation
• Upgrade of Database from 10.2.0.2 32 bit to 10.2.0.4 64 bit for Kelly Moore Paints Corporation
• Workflow configuration
• Implementation of Mobile Applications in R12 for Kelly Moore Paints Corporation
• Configuration and Integration of UPK Help in Oracle Applications
• Configuration of Loft ware software for Printing Reports
• Installation and Configuration of Discoverer 10g Business Intelligence for Kelly Moore Paints Corporation
• Backup and Recovery (Cold and Hot backup) and RMAN Backup
• Integration and Provided support for Demantra, Seibel, B2B, OTM and SOA architecture applications and databases for DPI Specialty Foods
• Installed 11g Weblogic application server with Portal and BPEL modules.
• Clone and refresh of the Oracle Applications
• Troubleshoot all type of Application, database and performance issues
• Created Tar’s and worked with Oracle support people
• Custom Code Migration to Production servers and as well as Non-Production servers
• 24X7 Support for production database servers.
• Resolved User issues during Shift
• Setup the Monitoring tool to monitor the database and application related issues.
• Troubleshoot the issues while applying the database patches using opatch utility.
• Reviewed and implement the activities to improve the database and apps performance.
• Monitoring and tuning using tools like Enterprise Manager GRID, Oracle cost Based optimizer (CBO), SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager, and Stats pack
• Schedule the gather schema level and table level statistics and concurrent and work flow purge programs.
• Worked on Mobile Applications and troubleshooting issues
• Taken a complete responsibility to deliver this project to get the customer satisfaction

Environment: Oracle Apps R12.x, Oracle 11G RAC,10G RAC, Oracle 10g Application Server, Developer 10i, Discoverer 10g, Oracle applications HRMS, Financials, AP, AR, GL, Inventory, I procurement, I Expenses, Order management, Advance pricing, Purchasing, Planning, Projects, OTL Oracle Time & Labor, manufacturing, Sales Distribution, I store, I supplier, Receivables, I expenses, ASCP, Linux

Confidential, Kansas

Sr. Oracle Apps DBA Consultant

Environment: Oracle Apps R12, 11.5.10.2, Oracle 11G, Oracle 10G RAC, Oracle 10.2, Oracle 10g Application Server, Developer 10i, Discoverer 10g, Oracle applications HRMS, Financials, AP, AR, GL, Inventory, I procurement, Order management, Advance pricing, Purchasing, Projects, OTL Oracle Time&Labour, manufacturing, Sales Distribution, I store, Receivables, SCM, Solaris, IBX-XIV,AIX, Linux

Responsibilities:

• Trouble shoot the Database issues and Users Calls Handling during Shift
• Clone the Applications and database using Rapid Clone utility.
• AD utilities and AD ADMIN tasks
• Creation of physical database structure such as Table Spaces and indexes etc.
• Creation of users, profiles and roles.
• Database and Applications Tuning
• Installation of 10G software and created database manually.
• Up gradation of database from 9i to 10G
• Taken the AWR,ADDM,ASH, SQL Tuning Advisor, SQL Trace, Explain Plan, Stats pack and Tkproof reports and then review the Performance analysis based on these reports
• Creating POS Interfaces for dataware House databases
• Clone the database manually as well as RMAN backup clone.
• Installation and configuration of Oracle Applications R12.0.4.
• Up gradation of Applications from 11.5.10.2 to R12.
• Implementation of PCP Concurrent node configuration
• Installation and Configuration of Discoverer 10g Business Intelligence
• Implementing the OBIEE modules in oracle applications.
• Upgrade all the financial modules from 11. version
• Implementation and configuration of Single-sign on Process SSO with OID server
• Worked on Shared Application Top Environment
• Configuration and implementation of single sign on process with OID LDAP server S.S.O
• Backup and Recovery (Cold & Hot Backup) with RMAN backup.
• Space Management
• Supporting Tickets from users
• Custom Code Migration to production as well as on Test instances
• Creating samba shares to access the information from UNIX servers to windows machines.
• Workflow configuration and troubleshooting issues
• MWA server issues.

Confidential, CA

Sr.Technical Analyst (Oracle Apps DBA)

Environment: Oracle Apps R12, Oracle 11g, 10g, RAC, Oracle 10g Application Server, Developer 6i, Discoverer 10g, Oracle applications HRMS, Financials, AP, AR, GL, Payables, Purchasing, Inventory, I procurement, Linux, Solaris, Aix, Hp-Unix, windows 2000.

Responsibilities:

• Involved in the full life cycle of the project. Migrating Customers applications to Outsourcing standards (both @oracle and @Customer). Upgrading the Instances to the latest apps versions (R12, 11.5.10). Upgraded the Databases from 9i to 10g & 11g. Resolving the TAR’s opened by the Outsourcing Customers
• Tuning Oracle database and SQL statements to increase the performance of the billing applications for LHS Communications
• Tuning Oracle Applications (AP and AR), Web time and Web Customer applications
• Oracle support for converting web applications from single threaded application to multi-threaded applications
• Installation and maintenance of Apps R11.5.10 instances on Sun Solaris for Applied Materials
• Analog Billing System and integration with FinApps for Nextel Communications
• Installation, configuration, cloning and upgrades of Oracle databases and Oracle E-Business Suites 11i AD utilities, patching
• Debugging Concurrent Managers and requests
• Performance tuning of databases and oracle Applications
• Installation and support of oracle Application server 9i and 10g
• Clone the Oracle database and Applications by using Rapid clone utility through Hot backup(Online clone)
• Implementation and configuration of Single-sign on Process SSO.
• Provided solutions to other teams in oracle on demand project like Config, Cemli, Patch, Upgrade and monitoring teams.
• Workflow Configuration and Java Notification mailer setup
• Convert database and Applications Character set to UTF8.
• Pasta printer type Configuration
• AD utilities like adadmin, adconfig, adctrl, adpatch, adsplice, admrgch etc...
• Restriction of menu and function against specific responsibility as per business needs to achieve better security control.
• Provided support for multiple clients in oracle on demand for all multi-org, multiple HR business groups, multi-country, multi-language, multi-currency.
• Troubleshoot the client connectivity issues like Forms, SSWA & JTF login, Portal, OID, Infra tier and Mid tier application services issues
• Troubleshoot the XML publisher and Reports issues
• Troubleshoot the issues related with TOAD & sql*plus along with connectivity
• Monitor and Maintaining/auditing User Activities to ensure database security
• Reorg tables / Rebuild indexes as required and gather stats for CBO (On demand, though automated).
• Trouble Shooting Concurrent Programs and MWA server Applications issues
• Observed the no. of transactions per day and long running transactions the concurrent manager jobs.
• Create Custom Responsibilities, managing Application Security
• Create Menus, Functions, Profile Options, Concurrent Programs, Request Sets, Request Groups, value set, flex fields, alerts, defining and registering custom appl tops and third party module oracle ids with the applications, changing passwords of product schemas, apps, applsys and system schemas etc
• Concurrent manager administration and maintenance.
• Ensure security with in Applications environment by applying critical security patches
• Migration of Table spaces to OATM
• Converted database from single instance to RAC 2 Node database
• Installation and up gradation of database from 9i to 10G.
• Configure the ASM and Data guard in 10G
• Configure the Hard ware level Load balancing in RAC database.
• Defined Customized Transaction Concurrent Managers, their work shifts and specialization rule
• Reviewed the database level and application level statistics.
• Review the O.S level performance which is consuming more CPU based on the TOP and SAR commands report
• Monitor the o.s level blocks and filer level statistics with the help of O.S administrators.
• Document all the observations and need to prepare the compatible suggestions to improve the performance of the database
• Taken the AWR,ADDM,ASH, SQL Tuning Advisor, Explain Plan, Stats pack and Tkproof reports and then review the Performance analysis based on these reports
• Identified the sql statements which needs to be tuned to improve the performance

Confidential

Sr. Software Engineer (Oracle Apps DBA)

Environment: Solaris, Oracle 9i, Oracle 10G with RAC, Oracle Applications 11.5.10, 11.5.9.

Responsibilities:

• Upgraded Oracle Apps from 11.5.9 to 11.5.10 and database from 9i to 10g
• Applying patches through ADPATCH Utility
• Cloning of Oracle Application through Rapid Clone
• Cloning of Oracle Database through (Flash Copy)
• Configure the RMAN with Catalog and Target Databases.
• Recover the database by using RMAN Recovery Policies
• Complete backup by using VERITAS net backup method (VERITAS volume manager)
• AD utilities and AD ADMIN tasks
• Configuration changes in Oracle Application
• Profile changes and Space Management
• Supporting TAR ’s
• Database Patching on RAC Databases
• Backup and Recovery (Cold and Hot backup) through SYNC/SPLIT
• Upgrade database from 9.2.03(32 Bit) to 9. Bit)
• Developed in Logical and Physical Design of Databases using Designer 2000 writing server side stored procedures/ triggers.
• Export/Import the database Schema level backups
• Create DBlinks to access the other databases.
• Custom Code Migration to production as well as on Test instances
• Workflow Configuration and Notification mailer setup
• Printer Configuration in o.s level as well as Application level.
• Configure and Troubleshoot the XML publisher and Reports issues
• Creating samba Shares
• VSS Server Maintenance
• Support and Maintain of ERP Production Servers

Confidential

Software Engineer (Oracle DBA)

Environment: Linux, Oracle 9i, Oracle 8i Oracle Applications 11.5.9, 11.5.8

Responsibilities:

• Applying patches through ADPATCH Utility
• Cloning of Oracle Application through Rapid Clone
• Generate & Compile forms & reports
• Designed Logical and physical database for business transaction functionality
• Creation of physical database structure such as Table Spaces, indexes and Space Management
• Creation of users, profiles and Roles.
• Database Tuning
• Backup and Recovery (Cold & Hot Backup).