SUMMARY:

• 15 years of experience as an Apps DBA consultant
• Worked on 8 end - to-end lifecycle ERP implementations in Oracle DB
• 13 years of experience Oracle E-Business suite in its installation, administration and implementation on different platforms
• 2 years of experience as an Oracle Core DBA for SAP with sap basis admin.
• 8+ years of experience for Oracle Database RAC/Non RAC installations on different platforms like Redhat Linux, Oracle Linux, HP-Unix, Windows and Solaris
• 8+ years of experience in Oracle Discoverer and Developer Reporting.
• 1+ year of experience in Oracle OLAP Express Server and Sales Analyzer
• Experience in Oracle E-Business Suite 11.5.8, 11.5.9, 11.5.10, R12.0.6, R12.1.1, 12.1.3, 12.2.2.
• Oracle Database 8i, 9i, 10g, 11g and 12c & RAC setup on Windows, Redhat Enterprise Linux AS 4/5/6/7 and HP-Unix PARISC 11.3. Solaris, IBM-Z
• Installation and configuration of Oracle E-Business suite with RAC DB and Load Blncr.
• Customized payroll module setup and integration in Oracle E-Business suite
• Administration and management of Oracle E-Business suite which included patching using adpatch, rapid cloning using adpreclone.pl and adcfgclone.pl, schema password change using fndcpass, files version identification using adident, administration, compilation and re-linking application objects using adadmin etc.
• Oracle Discoverer 11g setup in Web logic, integrated in Oracle E-Business suite.
• Regular monitoring and performance tuning for application & concurrent processes.
• Importing data into Oracle E-Business suite using application interfaces.
• Configuring Shared Storage Location and Raw Storage Devices and ASM.
• Installation and Configuration of Database and Enterprise Manager Grid Control (OEM 11g) and Enterprise Manager Cloud Control (EMCC) 12c.
• Configuration of Oracle Data Guard (including active and logical) for data replication on standby database
• Oracle Secure Backup for Tape Drive Backup Management
• Database Upgradation using DBUA and upgrade scripts. DB Modeling using ERwin
• Oracle Goldengate, OBIEE BI Publisher Installations and configurations.
• Managing migration from one operating system to another and non oracle database to Oracle Database with the help of SQLDeveloper.
• Manipulating with Data using Export, Import, Data Pump or SQL Loader utilities
• Managing logical and physical storage structure e.g.(Datafiles, Tablespaces, Extents)
• Configuration of Oracle Database Vault and Audit Trail and audit on DDL, DML etc.
• Installation of RAC Database with OCFS, OCR and ASM
• Configured Oracle Internet Directory (OID) and using Single Sign on (SSO) feature.
• Performance Tuning using SQL Tuning Advisor, Statspack, ADDM and AWR report
• Adjust Initialization Parameters at Optimum level and gain maximum Hit Ratio
• Automating scheduled jobs like gather statistics, also at OS level like cron jobs
• Design and Implement of comprehensive Backup policy
• Configuration of Oracle database archiving policy using Oracle ILM.
• Configuration and usage of RMAN for complete and incremental backups
• Make Recovery Procedures for all scenarios
• Configure Oracle Gateway services to execute oracle queries on non-Oracle database
• Manage complete or partial recovery test through RMAN and SQL commands
• OLAP Express Server 6.3.4, Sales Analyzer 6.4.0 configuration/administration.

TECHNICAL SKILLS:

Oracle Apps DBA: Oracle E-Business Suite 11i, R12.1, 12.2

Core DBA: Oracle DB 8i, 9i, 10g,11g, 12c

Enterprise Manager: 10g, 11g (EMGC), 12c and 13.2c (EMCC)

Fusion Weblogic: 10g, 11g 11.1.1.9

Oracle Application Functional: Financials,Inventory and purchasing.

Oracle OLAP:   Oracle Express Server and Oracle Sales/Financial Analyzer Expert

PROFESSIONAL EXPERIENCE: 

Confidential, Cleveland, Ohio

Sr. Oracle Apps DBA

Responsibilities:

• Performed patch analysis, applied patches (one-off, mini packs, developer 6i patches) and checked the patch impact along with managing patch history.
• Upgraded Oracle E-Business Suite to (R12.2.6) from R12.1.3 for trial runs. Planning the upgrade and doing trial runs with UAT approval with minimizing the final cutover downtime plan to 24 hours.
• 4 Regional upgrades including 9 languages support. 2 of regions Asia, Europe are already upgraded to 12.2.
• Installed Oracle Weblogic and Install BPEL,SOA configurations integration with ERP.
• Perform Cloning of OBIEE BI Publisher and OTM from old environment to new environment. Also created a new schema in EBS with a new ETL layer batch jobs to fetch financial data from E-Business suite.
• Monitoring and Tuning Application functional mainly custom code from enterprise cloud control grid and specially after Mar17 on latest version 13.2.2.0 EMCC using sql tuning advisors and sql monitoring.
• Performed the fixing issue regarding weblogic, OBIEE, BPEL,SOA,OTM etc.
• 11g Database Upgrade/Support to 12c.
• Continuous Performance monitoring and Database Tuning and application using OEM Tuning Pack, Diagnostics Pack, STATSPACK and E-Business management pack.
• Gathered requirements for storage, kernel parameters, backup policies, space required for backup and performed capacity planning for building new application and database.
• Preparing status updates and regularly tracking project milestones and updating share point folders with project related documents.
• Oracle Fusion Middleware 11.1.1.9 management for domain and node cluster configuration and Few Custom Forms/Reports application deployment and Oracle Access Manager integration for SSO.
• Have knowledge and experience in handling RAC databases using ASM and troubleshooting.
• Handling day to day requests, application & database security, System administration, code migration requests
• Coordination with different teams (server, storage etc) to plan for big upgrade which involved server, storage, apps, DB upgrade etc.
• Analyzing patches for Oracle applications and Oracle databases using patch analysis wizard from OAM.
• Applying Oracle Apps adop patches in development, SIT and QA instances and keeping track of them so that they are applied in all future instances of that release till production
• Done configuration of Reverse proxy external Tier with SOA integration and Server+Responsibility hierarchy management for iSupplier Portal module and related custom responsibilities.

Confidential, Milwaukee, Wisconsin

Sr. Oracle DBA

Responsibilities:

• Performed patch analysis, applied patches (one-off, bundle PSU patches) and checked the patch impact along with managing patch history.
• Installed Oracle Weblogic and Install BPEL,SOA Application configurations integration with ERP.
• Performed the fixing issue regarding weblogic BPEL,SOA etc.
• 11g Database Upgrade/Support to 12c.
• Worked for plugable databases in 12c for reducing maintenance and operation overhead.
• Continuous Performance monitoring and Database Tuning and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK.
• Scheduling RMAN backup of database using catalog DB and TDPO tape backup.
• Performed Data Centre Migration of Application and Databases.
• Gathered requirements for storage, kernel parameters, backup policies, space required for backup and performed capacity planning for building new application and database.
• Preparing status updates and regularly tracking project milestones and updating share point folders with project related documents.
• Configuring and managing Oracle Active Data Guard and logical standby for DSS.
• Building Pre-prod instances using Flashback Database Concept so that we can revert back to a past point-in time and delivered Pre-prod instances to client for testing purpose.
• Provided hypercare support after successful Go-Live.
• Proactive monitoring of databases for table space sizes, monitoring database growth, setting system and object privileges, user logins and passwords.
• Oracle Fusion Middleware upgrade from 10g to 11.1.1.7 to be used by Few Custom applications and Oracle Access Manager for SSO.
• Have knowledge and experience in handling RAC databases using ASM and troubleshooting.
• Involved in backup and recovery using RMAN.
• Knowledge of regular database admin tasks like tablespace management, object level maintenance, oracle database patching, database upgrade and installation.
• Experienced in applying patches in R12 environment.
• Have expertise in activities like maintaining instances, maintenance of file system and taking appropriate backups for security and consistency.
• Validating & Creating grants & synonyms on Application schemas, Performed jar file/forms generation as a post patch step, relinking the Oracle executables.
• Worked in 24x7 DBA support environment providing off hours support, Scheduled job execution, planning and emergency maintenance handling
• Handling day to day requests, application & database security, System administration, code migration requests
• Database and application performance tuning.
• Worked on automating repetitive tasks, documenting and maintaining knowledge repository for issues and best practices.
• Coordination with different teams (server, storage etc) to plan for big upgrade which involved server, storage, apps, DB upgrade etc.
• Managed over 20 instances, which included both oracle apps and other applications.
• Analyzing patches for Oracle applications and Oracle databases.
• Applying Oracle Apps Patches in Development and Test Instances and keeping track of them so that they are applied in all future instances of that release till production
• Writing shell scripts for day to day work to automate activities.

Confidential, Omaha, NE                                                

Environment: Oracle  Database10g, Oracle  Database 11g,Oracle  Applications 12.1.1, Toad, DBartisian, MobaXterm, ASM, Oracle  Enterprise Manager (OEM) Grid Control, RMAN, Red Hat Linux ES6.

Responsibilities:

• Providing Support to  Oracle R12.1.3 E-business suite application.
• Worked on 10g, 11g databases, and R12.1.3 E-business suite applications.
• Maintaining, Monitoring and Administering for Oracle applications environment on RAC architecture
• Performed Multi Node installation of Oracle EBS R12.1.3
• Cloning the Oracle Applications R12 environment from Production to UAT, QA, DEV boxes.
• Setup the RAC one node.
• Set up Printers,Workflow mailer and Wallet in Oracle Applications R12.1.3  Prod, UAT,QA,DEV Environments
• Worked closely with Functional/Developers and helping them in fixing issues
• Applying latest patches from Oracle Support to the Test and Production Instances for resolving issues or Enhancing features.
• Cloning R12 ERP Instances from Production to Test, Development Instances and coordinate with Testing and Development Teams.
• Backups- Logical and Physical for Multiple Instances.
• Controlling and Monitoring of User Access to the Database including Granting and revoking of Privileges and Roles and Tablespace Quotas.
• Experience in Upgrading 11gR1 to 11gR2 and applied PSU including for security quarterly updatess.
• Raising the Service Request and working with Oracle Team.
• Installed and configured 10g Discoverer on a  Oracle Application environment.
• Installed Web ADI on the user’s desktops and fixed the Application Problems.
• Oracle Discoverer deployment with latest Fusion Middleware 11.1.1.7
• Created users, responsibilities, Menus, Functions and migrated them to remaining environments through FNDLOAD In Oracle Applications Environment.
• Scheduled the Rman Backup scripts in a cron job.
• Applied  Patches for Developers Bug fixes  and Scheduled Maintenance on OracleApplications
• Implemented DR setup on the Oracle Applications R12 environment as per Client Standards.
• Oracle Applications Parallel Concurrent Processing Administration & tuning for R12 applications.
• Created OMF managed Tablespaces on ASM environment.
• Done Full Exports and Imports of the database at schema as well as tablespace level for different customers.
• Performed the Restore of Oracle 11g databases on a two node RAC environment.
• Install, configure and write scripts for RMAN 
• Daily DBA activities as Performance Monitoring, Instance Health Check etc
• Working with FNDCPASS to change Passwords of APPLSYS,APPLSYSPUB and SYSADMIN
• Provided 24*7 Production support in Oracle Production Databases as well as OracleApplications environments.
• Rapid Cloning R12 with hot Databases duplicate from Production to UAT, QA, DEV databases through rman.

Confidential, Chicago, Illinois

Environment: Oracle E-Business Suite 12.1.3 upgradation over Sun Solaris

• Upgradation of E-Business suite from 11.5.10 to 12.1.3 with all interfaces and with all latest patchsets in 76 hours.
• Administration, configuration and cloning of Oracle E-Business suite 12.1.3 with Oracle Database 11GR2 over Oracle Sun Solaris.
• Configured physical standby active dataguard in maximum performance read only mode for R12 DB for replication through archived log application at DR site.
• Configured re-sync with 20 minutes delay for application server replication at DR site.
• SSO integration in R12.1.3 E-Business suite to comply with logon standard and create ease for end users.
• Cloning of production environment on Sapphire, Jade, Ruby and Emerald staging servers for R12. Each server having 4 nodes each. 1 DB and 3 Apps clustered nodes with PCP.
• OBIEE BI Publisher 11.2 Installation and configuration.
• Patching of oracle application using “adadmin” and “adpatch” and database using OPatch. Applying One-Off and Security patches. Merging patches from Patch wizard using OAM and then applying them.
• Tuning and optimizing oracle application database parameters for maximum users load capacity and configuring hardware load balancing for application.
• Write shell scripts and setup database/application backup and some scheduled activities.
• Oracle E-business application system administration activities using FND utilities like FNDCPASS, FNLOAD etc especially before and after cloning activity.
• Upgradation of Enterprise Manager Grid Control (OEM) to 11.1 and registering all DB and Fusion Middleware targets using central agent deployment and pushing new agents to all servers.

Confidential, Northfield, Illinois.

Environment: Oracle E-Business Suite 12.1.3 over OVM, Extracts based Up-gradation from 11i, Discoverer and XML Publisher setups.

• Administration, configuration and cloning of Oracle E-Business suite 12.1.3 with Oracle Database 11GR2 over Oracle virtual machine (OVM) and OCFS with Oracle linux on blade servers.
• Extraction of data from legacy 11i environment and create its change in change management system serina to deploy across all system landscape environments and moving to Production environment with approval of authorizing stake holders.
• RMAN configuration and its testing and integration with comvalut library for new environment tape backups.
• Configured physical standby dataguard in maximum performance mode for R12 DB for replication through archived log application at DR site.
• Configured re-sync with 20 minutes delay for application server replication at DR site.
• Cloning of production environment on Dev, Sup, TST and UAT servers for R12. Each server having 4 nodes each. 1 DB and 3 Apps node with 1 CCM and 2 WEB Tiers.
• Patching of oracle application using “adadmin” and “adpatch” and database using OPatch. Applying One-Off and Security patches. Merging patches from Patch wizard using OAM and then applying them.
• Tuning and optimizing oracle application database parameters for maximum users load capacity and configuring OC4J and Forms load balancing at application level for WEB Tiers.
• Write shell scripts and setup database/application backup and some scheduled activities.
• Installation and configuration of Oracle Goldengate 11.2.1.0.20 for real time fast replication
• Oracle E-business application system administration activities using FND utilities like FNDCPASS, FNLOAD etc especially before and after cloning activity.
• Installation of Enterprise Manager Grid Control (OEM) 11.1 and registering all DB and Middleware targets using agents
• Oracle Fusion Middleware hosting support for Discoverer and SSO.
• Incorporating Master data and legacy system data in database through populating interface tables in application and importing them.
• Activating audit trail and making triggers specific triggers on objects for tracking specially for DDLs.
• Configuration of Database vault and controlling user roles to respective authorizations for security.
• Scheduling DBA admin jobs from system admin responsibility e.g. (Purge alerts and logs, purge concurrent requests and logs, Gather schema statistics etc)
• Configuration of XML Publisher component/module and used license manager to add advance collections.
• Configuration of Oracle Discoverer and defining its EUL layer for integration with E-Business suite to get flexible real time reports.
• Defining https (Hyper Text Transfer Protocol Secure) in context of E-Business Application server with SSL terminator for secured access.
• Defining workflow setup and using workflow builder to configure specific roles assignment for attributes of workflows for authorizing them to fire on particular events under specific role.

Confidential, Aliso Viejo, CA

Environment: Oracle E-Business Suite 12.1.1 installation over RAC and migration of data, Discoverer and XML Publisher setups.

• Installation and administration of Oracle E-Business suite 12.1.1 with Oracle Database 11G RAC using Oracle Clusterware File System (OCFS) and Oracle Cluster Ready (OCR) with Automatic Storage Management (ASM) on new servers environment.
• Extraction of balances from chart of accounts of old release 11i (11.5.8) running on old servers.
• Import and data load into new environment and posting that data to verify accounts for testing.
• Cutoff and reimport of data again in between test run and cutoff date to make new environment up to date for go live.
• Comprehensive Backup policy with RMAN configuration and its testing with data protector library integration for new environment.
• Configured DataGuard for R12 physical standby server replication through archived log application at DR site.
• Configured re-sync for application server replication at DR site.
• Cloning of production environment on Dev and QA servers for R12.
• Oracle Single Sign On SSO Upgradation and Integration in E-Business suite 12.1.1.
• Patching and cloning of the oracle application and database.
• Tuning and optimizing oracle application database parameters for users load.
• Write shell scripts and setup database/application backup.
• Periodically testing Recovery procedures.
• Oracle E-business application system administration activities using FND utilities like FNDCPASS, FNLOAD etc.
• Installation of Enterprise Manager Grid Control (OEM) 10.2.0.5 and registering targets after installation of agents
• Incorporating Master data and legacy system data in database through populating interface tables in application and importing them
• Activating audit trail and making triggers for tracking record for specific DDL statements for reports supporting annual audit queries.
• Configuration of Database vault and restricting roles for security
• Scheduling DBA admin jobs from system admin responsibility e.g. (Purge alerts and logs, purge concurrent requests and logs, Gather schema statistics etc)
• Patching application using “adadmin” and “adpatch” and fixing XLA accounting issue. Also applied upgrade patchset for XLA
• Configuration of XML Publisher component/module and using license manager to use it in XML based reports.
• Configuration of Oracle Discoverer and defining its EUL layer for integration with E-Business suite to get flexible real time reports.
• Defining https (Hyper Text Transfer Protocol Secure) in context of E-Business Application server with SSL terminator for secured access
• Provide 24/7 support for successful business running

Confidential, Atlanta, GA

Environment: Oracle E-Business Suite Upgradation to 12.0.4 over RAC and Install & Configure Application cluster

• Provided DBA support for Upgradation of Oracle Financials, Human Resources and Payroll
• Provide maintenance, patching and general DBA functions for the production, development and testing instances: Patching, Cloning, Tuning, Backup & Recovery.
• SYSADMIN activities for Upgradation of E-Business Suite releases from 11.5.10 to R12.0.4 on HP UX 11.2.
• Configuration of E-Business with F5 Big-IP type load balanced application servers.
• Troubleshoot and execute solutions to database issues & middle tier issues.
• OBIEE BI Publisher configuration and creating ETL layer to run fetch data from E-Business suite at night.
• Plan and conduct unit, system, acceptance, integration, and performance testing.
• Lead cross functional teams in resolution of performance problems and tuned database for best performance.
• Using AD utilities like admrgpch to merge the patches and apply them.
• Configured Dot-Matrix Printers with Oracle Applications.
• Configured the system to view the invoices in a PDF Format.
• Oracle Application Development Framework ADF support.
• Proactively monitored the applications and database through shell script alerts.
• Cloned Instances from Production whenever required for testing or development.
• Used FNDLOAD for responsibility, menu, value sets and profile migration.
• Write scripts for assigning users with new responsibilities and change profile values.
• Upgraded the E-Business suite database from 10.2.0.2 to 10.2.0.4.
• UAT and successful changeover to upgraded database.
• Used DBV (DB verify) utility to check corruption in database data files before upgrade.
• Space Management - Re organized and restructured tablespaces and data files across SAN to divide IO.
• Managing and Monitoring Concurrent Jobs, Concurrent Managers and Application Users.
• Creating heterogeneous database link in Oracle database to integrate it with other applications.
• Configure and use Oracle Gateway for running non-Oracle queries in our database to comply requirements of other applications.
• Installation and configuration of Oracle Goldengate 11.1.1 for real time replication of large database streams.
• Involved in disaster recovery planning and implemented database backups and disaster recovery strategies using RMAN and data guard.
• Configure RMAN for integration with differential incremental backup policy. Also to check block corruption.
• Configure backup retention time in RMAN and checking periodically obsolete and expired backups to delete.
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
• Install Oracle enterprise manager (OEM) with its repository using emctl utility.
• Encrypting stored data for privacy and security which is crucial for media companies.
• Implementing network and domain security by customizing sqlnet.ora and allowing specific domain and IPs only for connectivity.
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• UNIX Shell scripting for backup and monitoring of databases.
• Worked as 24x7 production support DBA and supported on holidays, weekends and beyond regular hours
• Implemented DataGuard for DR site and Oracle Gateway for integration of ERP database with other applications

Confidential, NYC, NY

Environment: Oracle Database Server Upgradation with Load Balanced Application

• Device a strategy for Database upgrade and make a replicated environment before upgrade.
• Used DBV (DB verify) utility to check corruption in database data files before upgrade.
• Step by step patch set upgradation of Oracle Database from 9i to 10g then to 11g on Redhat Linux AS5 with OS clusters using DBUA.
• Run pre upgrade checking and post upgrade scripts for this process.
• New DB deployment after database modeling and design using Erwin.
• Restructuring large number of extents objects and their size and partitioned them horizontally according to data accessibility requirement.
• Archived old data and maintained its history for reference.
• Integration of database with F5 Big-IP type load balanced application servers.
• Backup policy management and Oracle secure backup configuration for tape backups.
• Taking logical backups by datapump and replicating in DEV environment for quick replication of Database.
• Install Oracle enterprise manager (OEM) with its repository using emctl utility.
• Configure RMAN for integration with differential incremental backup policy. Also to check block corruption.
• Configure backup retention time in RMAN and checking periodically obsolete and expired backups to delete.
• UAT and successful changeover to new platform and upgraded database.
• Encrypting stored data for privacy and security which is crucial for media companies.
• Implementing network and domain security by customizing sqlnet.ora and allowing specific domain and IPs only for connectivity.
• Performance tuning using SQL Tuning Advisor, modified execution plan, SQL/PLSQL joins modifications and using hints to use custom indexes.
• Granting sysdba and dba role and controlling dba accessibility for management.
• Creating heterogeneous database link in Oracle database to integrate it with other applications.
• Configure and use Oracle Gateway for running Oracle queries in our application to get data from non Oracle database.

Confidential

Environment: Oracle E-Business Suite R11.5.10.2 over Oracle database 10gR2 RAC

• Oracle E-Business suite administration and post implementation complete support including Level1 support
• Administration of Oracle database 10gR2 RAC over Redhat Linux clusters
• Managing Oracle cluster ready service CRS for RAC (e.g. init.crs start/stop etc)
• Using srvctl utility for clustered database services management
• Changed backup policy and introduced incremental level1 backup due to 24*7 operation and high capacity 1.4 TB database
• Configuration of Oracle internet directory services (OID) and Single Sign On (SSO) feature for all supported Oracle products. Also integrated the oracle support in it.
• Dataguard physical standby configuration with dataguard broker for controlling switchover for Disaster recovery server at DR site. User dgmgrl utility for controlling broker
• Common APPL TOP shared on SAN for
• Cloning of production RAC database on test without RAC
• Patching ERP application which was divided on different application servers in term of shared application tops and RAC based database
• Performance Tuning specifically of data warehousing queries used by Oracle BI integration with E-Business suite