SUMMARY:

• Over all 18 years of experience in Oracle working as a Core Database Administrator and application DBA on various H/W with UNIX & Windows platform.
• Over 14 years of experience as Apps DBA on R 12/ 11.5.10/11.5.9 on Sun Solaris, HP - UX, AIX, Linux Servers & four years of experience as Core DBA on Sun Solaris, Exadata,HP-UX, AIX, Linux Servers &Windows platform.
• Strong Experience in installing, configuring and administering Oracle Databases and in RAC using ASM file systems.
• Upgraded the databases from 32 bit to 64 bit on Linux platforms.
• Worked as DBA on diverse platforms on Oracle Databases covering HP-UNIX, IBM AIX, SCO UNIX, SUN Solaris, Linux and NT.
• 7+ years of experience in installation of OEM 12c grid control, configuration and installing agents on all database servers.
• Upgraded the Oracle clusterware from 11.2.0.2 to 11.2.0.4 and DB from 11.2.0.2 to 11.2.0.4.
• Implemented high availability solutions, including Clustering, Database Mirroring, and Replication.
• Extensive experience in Oracle Applications Releases(10.x,11i and 12.x), Oracle Databases(7.x,8.x,8i.x,9i.x,10g.x,11g.x and 12c), Database Design and configuration, patching, cloning, migration, upgrades, Applications System/Database administrations, Backup and Recovery, Performance Tuning, pl/sql programming, customization, TDE, Data guard, Data vault and load balancing.
• 5+ years of experience of implementing Active data guard.
• Good understanding of RAC & Clustering technologies on Multi-Node with Parallel Concurrent Processing PCP and Load Balancing LB of Oracle Application.
• Installation and administration of web tools like 10g Application Server, Oracle Internet Application Server (9iAS), and WebLogic, 10g OID, SSO and Oracle Portal.
• Proficient in implementing shared appl tops and upgraded the Oracle apps 11.5.x to 12.1.3 on Test/development instances.
• Experience in performing Backup & Recovery, Experience in the development of client-specific solutions using Confidential SnapManager 2.2 and ONTAP 8.
• Compliance with SOX process, procedures, implement project standards as per SOX.
• 5+ years of Goldengate and supported day-to-day maintenance.
• 3+ years in Oracle SOA.
• Having knowledge on Perforce for version control and code merging.
• Hands on release management process using Kintana/Perforce.

PROFESSIONAL EXPERIENCE:

Confidential, Brea, CA

Senior Oracle E-Business suite DBA

Responsibilities:

• Day to day support activities on RAC databases using ASM instances.
• Standby database implementation and activating the database.
• OEM monitoring and ensure agents are up and running.
• Moving databases from one Linux server to another server.
• Rman backups scheduling and cloning production databases.
• Moving R11i to R12.2.4 from Linux servers to Exadata servers.
• Export /Import using data pump for OBI databases.
• Applied QFSDP and QDPE patches on Exadata systems.
• Applying patches, fixing bug fixes for development team, and implementing in QA.
• Real Application testing was used to quantify the impact of any database change on database performance.

Confidential, Sunnyvale, CA

Senior Oracle Apps DBA

Responsibilities:

• Installation and configuration of OID for Everest project on our Stage servers and PROD servers.
• Installation, administration, upgradation, cloning of web Centre version 10.3.3 (weblogic) and configuration as per the requirement.
• Installation of 11g R2 RAC Grid clusterware and new scan services for our EBS instance.
• Configured Exadata boxes right from scratch (configuring config.cmd and checkip, getting Exadata box setup with oracle) to go live.
• Configured Load balancer with ACE cookie.
• Installation, configuration and administration of RAC 4 node cluster using 11gr2.
• Cloning the existing EBS instances from development to Stage environments in RAC and from non-RAC to RAC vice versia.
• Upgradation, administration, patching, monitoring, configuration in Non RAC and RAC databases.
• Upgraded the Oracle clusterware from 11.2.0.2 to 11.2.0.4 and DB from 11.2.0.2 to 11.2.0.4.
• Proficient in deploying the code using kintana for SOA, weblogic/webcentre, WSDL.
• Creating different concurrent managers based on the requirements from the Technical team.
• Enabled PCP for our Stage environment and other test environments.
• Creating new responsibilities, concurrent requests and copying them to other development environments using FNDLOAD.
• Performance monitoring, monitoring day-to-day alerts, troubleshooting new issues and resolving them.
• Installation of EM agents on NFS mounts points and configuration done for Oracle Applications in OEM Grid control.
• Installed Jconsole tool for troubleshooting performance and resource consumption of applications running on the Java platform like JVM’s and heap sizing.
• Deploying and configuring BPEL processes in oc4j and WebLogic servers using custom shell script.
• Deploying and configuring business processes in TIBCO admin console.
• Securing BPEL process wsdl url’s in OWSM internal and external gateway.
• Setting up users, roles, groups in SOA and WebLogic.
• Responsible for configuration plans for the BPEL, ESB for deploying in multiple environments.
• Create configuration plans for the SOA Composite, OSB for deploying in multiple environments.
• Examine existing source database and application performance, availability and scalability inhibitors including physical model design characteristics for improved data concurrency and throughput.
• Implemented golden gate setup, created managers, extracts, pump and replicat process for replication.
• Monitored disk status, checking server health using CellCLI commands .
• Used Exachk utility checks health of all S/W components like Database Software, ASM Instance, RAC instance and Exadata Software health.
• Enabled EBS SOA Gateway . Worked with SOA /development team for generating WSDL’s .
• Used Active Data guard feature in Standby databases for our critical production environment.
• Used IORM for managing resources across databases.
• Applied QFSDP, QDPE patches on Exadata hardware components and also database components.
• Release planning, co-ordination with developers, functional and production teams.
• Installed 12.2.4 on Linux 64 bit and well versed on 12.2 concepts including administration and cloning.
• Upgraded the DB from 11.2.0.4 to 12.1.0.2 and also application from 12.1.3 to 12.2.4
• Well versed with adop tool for patching.
• Hands on Kintana user administration, security groups, staging and changing workflow definitions related for administration.
• Used RAT to compare execution profile of the same workload before and after the change to check performance.

Confidential, Pittsburgh, PA

Oracle Apps DBA

Responsibilities:

• Installed AMP 3.1 on our OEM grid control and configured our EBS databases for monitoring concurrent mgrs, forms sessions, db locks, invalid objects and jdbc connections.
• Installed OEM grid agent 10.2.0.5 on all servers and configured them.
• Configured the alerts, thresholds and metrics defined as per the requirement.
• 2 node RAC for Oracle Application 12.1.1 Installation.
• Upgraded from 11i to R12 on Sun Solaris platform.
• Install Monitor, config 2 node Oracle 11g/10g RAC and Oracle ASM for 12.1.1/11.5.10.2 Ebiz.
• Configured Load Balancing and TAF for RAC environment
• Responsible for upgrades, patching, TAR support, database tuning, concurrent manager administration, Forms and Reports troubleshooting and multi-node cloning 11.5.10.2, instances from production to UAT/QA
• Application admin tasks using ADADMIN utility, Monitoring and Tuning
• Generated SQL scripts for creating databases from existing data models from Erwin tool.
• Database upgrading, CPU patch apply
• Administration of Concurrent Managers, Concurrent Processing and apply oracle applications Patches
• Monitoring Apache, forms server, report server etc.
• Tracing & Debugging the applications & Concurrent Programs
• Implementing, Monitoring, troubleshooting Oracle 10g OID/SSO/OAM/OIM/Portal
• Backup and recoveries both user managed and RMAN managed.
• Periodically refreshing different development instance from PROD/UAT/INT instance

Confidential, Dayton, OH

Oracle Apps DBA

Responsibilities:

• Converted the existing tablespaces structure to OATM.
• Upgraded the OEM grid control console database from 10.2.0.3 to 10.2.0.5 and applied latest CPU patches /PSU db patches. Also applied CPU patches on OMS oracle home.
• Enabled Spanish Language, Brazil Portuguese, and Simplified Chinese on Oracle Apps 11.5.10.2 and applied the requisite patches.
• Configured standby databases for our existing Production databases and activated for testing.
• Monitoring and supporting day today activities of the production and development databases and work on urgent issues when fired by pager.
• Used Erwin tool in creating logical, physical, dimensional data models .
• Creating Custom Concurrent Managers and Assigning Work shifts to it.
• Finding long running requests and sessions terminate them if needed.
• Applied database and application patches.
• Performed SQL tuning, application and database tuning.
• Troubleshooting problems with web server, web listener, forms server, and concurrent managers, and database.
• Used expdp/impdp utilities for exporting schemas and importing schemas as per the requirement.
• Monitor database alert log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.). Manage and maintain high volume transactional tables and indexes, database reorganization
• Create tablespaces, tables, and users for custom applications and maintained security.
• Rman utility was used for backup & recovery on Oracle databases for PROD and development/uat databases.
• Used oracle streams for replication in one table between two databases.
• Written/Modified shell scripts to monitor as needed and maintain the Oracle Applications database.
• Installation of BPEL database and configuring SOA.
• Upgrading the databases from 10.2.0.4 versions to 11.1.0.7 and 11.2.0.1.
• Upgraded to Oracle Apps Release 12.1.1 from 11.5.10.2 and also the db from 10.2.0.4 to 11.1.0.7

Confidential, Rockville, MD

Oracle Apps DBA

Responsibilities:

• Installation of 9.2.0.6 and 10.2.0.3 on Sun Solaris and Linux platform.
• Upgraded the Oracle Applications 11.5.8 to 11.5.10.2, database to 10.2.0.3 from 9.2.0.6 on Sun Solaris 2.8 platform to Linux ES4 platform.
• Cloning the Oracle Applications from Production to Development servers.
• Upgrading the Application software from 11.5.8 to 11.5.10.2
• Upgrading the database from 9.2.0.6 version to 10.2.0.3 version.
• Doing cross platform migration using Export/Import from Sun Solaris to Linux server.
• Installing Red hat Linux ES4 on the Linux servers and configuring them.
• Installed OEM grid control on Linux x86 and scheduled jobs, gather statistics, patches, upgrading the agents, security patches and alerting.
• Used Erwin tool in comparing the database structures using the existing data models.
• Configuring send mail, X-window and Workflow mailer on Linux ES4 server.
• Used rman backups for cloning from Production to Development servers.
• Proficient in using expdp/impdp utilities for exporting a schema and importing into a different schema and used for transportable tablespaces.
• Supporting the development and testing team during implementation of the Project And on all DBA related issues.

Confidential, Cincinnati

Oracle Apps DBA

Responsibilities:

• Was part of a team of 3 DBA’s supporting all of Confidential database platforms.
• Applied patches and service packs to keep the database at current patch level.
• Perform database capacity planning; create, administer and maintain databases; install and patch
• Developed common set of tools to aid in troubleshooting & maintenance on all database platforms
• Install and configure Oracle Clusterware and oracle software.
• Installation and configuration of Oracle 9i RAC for E-Business Suite Environment.
• Configured Load Balancing and TAF for RAC environment
• Performance tuning using tkprof and explain plan.
• Cloning of Databases from Production to development servers using rman utility.
• Cross platform, migration from HP-Unix to Windows server 2003 used expdp/impdp utilities.
• Administration of OEM like monitoring the databases, server load, invalid objects,cpu,blocking
• Locks, long running sessions, scheduling jobs and alerting based on the metrics.
• Supporting day-to-day user related issues, troubleshooting them and resolving them.
• Maintenance of Oracle Applications on test databases.
• Killing hung sessions on all databases, which are causing locking.
• Performing the jobs of System Administration for Oracle Application.
• Creation and maintenance of menus, Users, Responsibilities etc.
• Creation and maintenance of Customize Applications.
• Administration and maintenance of Concurrent managers.
• Registration of Forms, Reports, Concurrent Programs.
• Supporting the development and testing team during implementation of the Project and on all DBA related issues.

Confidential

Oracle Apps DBA

Responsibilities:

• Installation of Oracle Applications Version 11.5.10.2
• Database Administration.
• Oracle Application Server Configuration.
• Client Installation.
• Maintenance of Oracle Application Instances including applyi0ng patches.
• Enabled Kuwait Localization and Seed data using Data Installer and HR Global Patch.
• Enabling and setting up the environment for HRMS Daily Business Intelligence reports.
• Performing the jobs of System Administration for Oracle Application.
• Administration and maintenance of Concurrent managers.
• Creating Custom Concurrent Managers and Assigning Work shifts to it.
• Registration of Forms, Reports, Concurrent Programs.
• Cloning of instances for development and testing.
• Supporting the development and testing team during implementation of the project and on all DBA related issues.

Confidential

Oracle Apps DBA

Responsibilities:

• Installation of Oracle Applications Version 11.5.9.9.2.0 Database Administration.
• Oracle Application Server Configuration.
• Installation of OEM and configured agents on all the servers. Scheduled alerts 24 hrs. based on
• Requirements, defined user metrics, jobs scheduled and generated reports.
• Maintenance of Oracle Application Instances including applying patches, Backup & Recovery.
• Performing the jobs of System Administration for Oracle Application.
• Creation and maintenance of menus, Users, Responsibilities etc.
• Creation and maintenance of Customize Applications.
• Administration and maintenance of Concurrent managers.
• Creating Custom Concurrent Managers and Assigning Work shifts to it.
• Registration of Forms, Reports, Concurrent Programs.
• Implementation of oracle Student System integrated with Oracle Enterprise Resource Planning.
• Integrating above with third party tool’s Oracle discoverer (Web Reporting), Oracle ADI (GL Reporting).
• Implementing Portal (For student to access from worldwide).
• Cloning of instances for development and testing using rman utility.
• Discover installation & configuration on Sun Solaris 2.9.
• Supporting the development and testing team during implementation of the Project and on all DBA related issues.

Confidential, Edinburgh, UK

Oracle Apps DBA

Responsibilities:

• Installation of Oracle Applications Version 11.5.9 on vision, test and Production.
• 9.2.0 Database Administration.
• Oracle Application Server Configuration.
• Client Installation.
• Maintenance of Oracle Application Instances including applying patches, Backup & Recovery.
• Performing the jobs of System Administration for Oracle Application.
• Creation and maintenance of menus, Users, Responsibilities etc.
• Creation and maintenance of Customize Applications.
• Administration and maintenance of Concurrent managers.
• Creating Custom Concurrent Managers and Assigning Work shifts to it.
• Registration of Forms, Reports, Concurrent Programs.
• Copying all the datafiles from backup and recreating the control file to bring up the database.
• Discover installation & configuration on Sun Solaris 2.9.
• Performance Tuning.
• Configured Workflow Notification Mailer.
• Application printer configurations.
• Upgradation of Application software from 11.5.8 to 11.5.9.
• Cloning of instances for development and testing.
• Supporting the development and testing team during implementation of the Project and on all DBA related issues.

Confidential, New York

Oracle DBA/ Applications DBA

Responsibilities:

• 8.1.7 Database Administration.
• Performance tuning using tkprof and explain plan.
• Application printer configurations.
• Technical assistance to developers and consultants in implementation.
• Applied patches for bugs and product enhancements and upgrades on Oracle Application 11i.
• 7x24-production database support.
• Trouble shooting the daily production instance problems.
• Creation of application users, responsibilities and menus.
• Monitoring application performance.
• Creation of custom concurrent manager and assign the custom reports.
• Monitoring the concurrent managers.
• Discoverer installation & configuration on Sun Solaris
• Safeguarding database, reorganization of databases, Monitoring tablespaces, Indexes, extents, setting up database privileges and roles and customizing user access to database.
• Backup of Databases and File Systems.

Confidential

Oracle Apps DBA

Responsibilities:

• Oracle Application 11i Installation on Windows NT.
• Applied patches for bugs and product enhancements and upgrades on Oracle Application 11i.
• Creation of application users, responsibilities and menus.
• Managing concurrent managers and application printer configurations.
• Discoverer installation & configuration on Windows NT.
• Backup of Databases and File Systems.
• Maintenance of Oracle Application 11i Production System.

Confidential

Oracle Apps DBA

Responsibilities:

• Oracle Application 11i Installation on Windows NT.
• Applied patches for bugs and product enhancements and upgrades on Oracle Application 11i.
• Creation of application users, responsibilities and menus.
• Managing concurrent managers and application printer configurations.
• Oracle E-mail server and Call center components installation on Windows NT.
• Discoverer installation & configuration on Windows NT.
• Backup of Databases and File Systems.
• Maintenance of Oracle Application 11i Production System.
• System Administration.

Confidential

Oracle DBA

Responsibilities:

• Oracle administration includes safeguarding database, reorganization of databases, monitoring tablespaces, indexes, extents, performance tuning, customizing user access to database.
• Developed and implemented a menu-driven utility to monitor and to on-the-fly information
• On users, database free-space, extents, tablespaces, tables and indexes.
• Created SNAPSHOTS for objects of BANCS 2000 central database to update corporate
• Database for MIS reports purpose.
• Implementation, Upgradations, Maintenance, Training to Users in Bancs 2000 Banking
• Application software.
• Implementation of Backup and recovery solution.
• Implementation of Cross Platform Migration.
• Installation of network software for ATM is in the production database.
• Installation software for ATM’s.
• Setting up the address, gateway etc.
• Checking up the connectivity from all sides.
• Testing the ATM is whether transactions are correct.

Confidential

Oracle DBA

Responsibilities:

• Implementation of data design.
• Oracle Software Installation on Platform SCO UNIX
• Oracle database creation according to the requirements.
• Allocating system storage and planning future storage requirements for the database.
• Creating the required tablespaces, users, and roles for the application.
• Estimating the space requirements for various data structures used in the application.
• Setting up the default parameters for the Banking software.
• Backup, Export/Import and various database issues.
• Monitoring the database to ensure smooth running of daily activities.