We provide IT Staff Augmentation Services!

Sr. Oracle Apps Database - Consultant Resume

0/5 (Submit Your Rating)

Orlando, FL

SUMMARY

  • Oracle database Architect with 12+ years of professional experience, 10+ years as Oracle database, Oracle E - Business Suite (EBS) application DBA supporting 24x7 production instances, Project Management and 2 years in networking, linux/unix, Windows systems administration.
  • Extensive experience in managing large number of multi-terabyte RAC/Non-RAC with/without ASM Oracle 9i/10g/11g databases, DR, DMZ, SSO, SSL, Oracle E-Business suite 11i and R12.x.x. applications.
  • Installation/configuration/Maintenance of multi-terabyte RAC/Non-RAC Oracle 9i/10g/11g/12c, Grid/Cloud OEM 10g/11g /12c databases and Oracle E-Business Suite 11i and R12.x.x (single node and Multi-node) on Linux, Unix, OEL, AIX, HP-UX, Solaris SPARC, Windows systems, Oracle VM and VMWare.
  • Data masking and Test Data Management for Oracle E-Business Suite/PeopleSoft/custom applications using Oracle Enterprise Manager 12c including Data sub-setting.
  • Expertise in upgrade of multi terabyte E-Business Suite databases (9i, 10g, 11gR1/R2) and Oracle EBS applications 11i through R12.1.1 to R12.1.3 and 11i to R12.2.3
  • Proficiency in Database, Server/platform migration of Oracle E-Business suite databases (3-10TB) and applications.
  • Familiar with 3rd Party tools like Kofax/Mark View, Noetix, Readsoft, Vertex, Kintana, GLWand, More4apps
  • Migration of Oracle 9i, 10g databases to DB2 LUW 9.7 databases.
  • Extensively worked on Maintenance of Oracle E-Business suite applications using Oracle AD utilities/tools, patching, cloning, backup, administering concurrent manager, PCP, SSO, SSL, printer configurations, sysadmin responsibilities, troubleshooting database and EBS application related issues.
  • Experience with AP, AR, GL, PO, CE, IBY, SLA, ZX, FA, PER, PAY, SSHR, OAB, Workflow, INV, Projects, Federal financials, self-service applications iReceivables, iProcurement, iSupplier Portal, Oracle EBS modules.
  • Experience in Installation/Configuration and administration of Fusion Middleware products (Oracle Enterprise Repository, RCU, weblogic server, JRockit, Discoverer, Tuxedo)
  • Capacity planning, storage analysis, monitoring, best practices for database and oracle EBS environments.
  • Installation, configuration, Maintenance of Oracle Application server, Fusion Middleware Web logic server (WLS), discoverer 4i/10g, FMW Discoverer 11g, Oracle workflow, Forms, Reports.
  • Knowledge and Maintenance of 2 Node RAC with or without ASM.
  • Failover and Disaster Recovery solutions (Data Guard), implementation of backup strategies using RMAN export/import, VM, snapshot backup using Veritas/EMC SAN.
  • Good experience with project management activities including project planning, scheduling, phasing, coordinating, presentations and workshop sessions.
  • Performance tuning of Oracle database-SQL tuning, instance tuning, TRACE, TKPROF, SQLT, EXPLAIN PLAN, STASPACK, AWR, ASH, ADDM and security.
  • Experience of working in 24x7 Production and 16x5 Development environments and on call support for mission critical databases and Oracle EBS Applications.
  • Installation, configuration, troubleshooting and Maintenance of VMware tools, different flavors of Linux, windows 2003 servers/Microsoft Exchange Server/Desktops, Sugar CRM, Bug/Issue tracing tools like Bugzilla, JIRA, Content Management/Versioning Systems like Sharepoint, CVS NT, remote administration of Microsoft windows and Linux desktops using RDP, VNC, and secure Shell.

TECHNICAL SKILLS

Databases: Oracle RAC/Non RAC 11g/10g/9i, OEM Grid 10g/11g/OEM Cloud 12c, Oracle Apex, DB2 UDB LUW 9.7 FP3/9.7/9.5, Sybase ASE 12.x, Mysql and Postgre SQL.

ERP Applications: Oracle E-Business Suite R12.2, R12.1.3, R12.1.2, R12.1.1, R11.5.10.2, R11.5.10

DBA Tools: HTML DB, RMAN, Dataguard, AD Utilities, TOAD, Putty, RDA, OS WATCHER, OEM Grid /Cloud DB12c/11g/10g, RCU, Autosys, SQL Developer, SQLT, Visio 2k.

Middleware: Fusion Middleware 11g, Oracle Application Server 11g AS/10gAS/9iAS, SSO, SSL, OID, Weblogic 10g/FMW Weblogic 11g (WLS), JDeveloper, OBIEE, IDM.

Web Technologies: Web Sphere, OC4J, JDBC, Oracle iAS, Oracle Forms and Reports Server

Utilities: Sqlplus, SQL*Loader, Import & Export, ODBC, Expdp/Impdp, SQL Developer, DB Analyzer.

Operating System: Confidential AIX, Solaris SPARC, RHEL AS/ES, OEL, CentOS, HP-UX, Unix, Windows server, Windows OS, Mac, Oracle VM, VMWare

Business Intelligence: Discoverer 4i/10g, Fusion Middleware Discoverer 11g, OBIEE 10g, Reports 6i, Crystal Reports

3rd Party Tools: Kofax/Mark View, Noetix, Readsoft, Vertex, Kintana, GL Wand, More4apps.

Oracle EBS Modules: AP, AR, GL, PO, CE, IBY, SLA, ZX, FA, CoreHR (PER), PAY, SSHR, OAB, INV, BOM, ONT, Federal financials, iProcurement, iSupplier, iReceivables, MDM, PIM, WIP, MRPLanguages SQL, PL/SQL

Virtualization: VMware tools, Oracle VM.

Ticketing/Bug Tracking: JIRA, GSM/Maximo, Remedy, Bugzilla

EDM/ILM Tool: OPTIM 7.3/7.1/6.5/6.4 Optim EBS Workbench 5.6/6.0, ODM, Optim Connect, Solix, Outerbay

Tools: and Utilities CVS NT, NIS, Sugar CRM, Sharepoint.

Microsoft: MS-EXCHANGE, Outlook.

Methodology: Oracle AIM.

Domain: Finance, Payroll & HR, Travel, Health Care, Center of Excellence, Government

PROFESSIONAL EXPERIENCE

Confidential, O’Fallon, MO

Lead Oracle APPS Database - Consultant

Responsibilities:

  • Propose best possible approach for Oracle EBS 11i upgrade, plan CRPs in consultation with key stake holders in project and implementing them.
  • Address all the challenges involved in upgrading a highly complex 5 TB single Global EBS 11i Instance to R12, Performance tuning the upgrade at Operating system/Database/Application/Storage/Network level to de-risk the overall upgrade process.
  • Configuring a DR site to address any Natural/human/Hardware challenges. configured DMZ for the supplier or business partners to access the Application, Used OEM Cloud 12c for Monitoring the 11i and R12 upgrade instances, Test data management, Data Masking, identify and fixing performance issues.
  • Production support: Doing Architectural review, proposing future Architecture Roadmap for EBS in terms of Technology/Stability/future growth/load/security, Involved in Strategic & Infrastructure capacity planning in terms of Hardware/Storage sub system/support infrastructure, PCI Audit compliance, DR Contingency.
  • Confidential extensively used Oracle Application Financials (FIN), family, applying PSU/CPU/Family and module specific patches for AP, AR, GL, FA, PO, MRP, ZX, IBY, CE, XLA, PER, SLA modules.
  • Configuring iProcurement, iReceivables for authorized external users on the DMZ to accessing the application.
  • Confidential has a 5TB Oracle EBS Database footprint which is growing at a faster pace, using Solix archival solution to move the legacy data to Archive DB to improve the overall database and upgrade performance.
  • Managing Self-service applications, Supporting customizations, technical/development and Functional teams with their issues, document the upgrade process end to end for the CRP’s and Production rollout was done successfully
  • Working on the Production performance issues and supporting day to day production related activities, backup, recovery, Maintaining 5 non prod environment, helping development and testing team with their issue resolution

Environment: EBS 11i/11gR11gR2/EBS R12.1.1/R12.1.3 Dev/Test/Pilot/Clone/Patch env. SSO, OEM 12c, Solaris SPARC10(64 bit), RAC, VMWare VM, Oracle APEX, DISCOVERER, Solix, READSOFT, EMC/SAN Storage, DRDMZ, RMAN, ASM, Dataguard, NOETIX, GL Wand, FMW Weblogic 10g(WLS), Sharepoint, JIRA, GSM/ Maximo

Confidential, Orlando, FL

Sr. Oracle APPS Database - Consultant

Responsibilities:

  • Understand Tupperware Oracle EBS Environment, propose best approach for EBS 11i upgrade, Plan CRPs with their DBA Manager and implementing them.
  • Hardware Sizing, Capacity planning, Install RPM’s/software/patches/EBS R12 file system, Upgrade multi node EBS 11i to R12 and Validation.
  • Address all the upgrade challenges, performance tuning the upgrade at OS/Database/Application/Storage/ Network level to de-risk the overall upgrade process.
  • Tupperware uses Oracle Application Financials (FIN), Supply chain (SCM) and Manufacturing family of products and HRMS in shared mode, applied following module specific patches for AP, AR, GL, FA, PO, MRP, ZX, INV, IBY, CE, BOM, WIP, ONT, XLA, PER, SLA modules.
  • Working with Functional/development team to design an approach to implement iSupplier/iProcurement and iReceivables, applying security patches, configuring external users/anonymous logins on web tier of DMZ, addressing security challenges with respect to above setup and testing it in non-prod environments.
  • Reduced the 2.5 Terabyte EBS database footprint by 20% by archive/moving the legacy data, improve the overall database and upgrade performance.
  • Used OEM Cloud 12c for Pro-active Monitoring the 11i and R12 upgrade instances, identifying performance issues, Data Masking, Test data management and tuning them using tuning pack.
  • Support the Functional/technical/development teams with their issues, document the upgrade process for the future CRP’s and Production rollout, Knowledge Transfer to the DBA Team

Environment: Oracle EBS multi node 11i/11gR2 11gR2/EBS R12.1.1/R12.2 Stage/Dev/Perf environments, OEM 12c, RAC, RHEL ES 5.8/6.4 (64 bit), VMWare VM, Oracle APEX, SAN Storage, iProcurement, FMW Weblogic 10g (WLS), Vertex, Crystal Reports, RMAN, DMZ

Confidential, Salem, OR

Sr.Oracle Apps DBA

Responsibilities:

  • Responsible for the performance tuning of overall processes from platform migration to EBS upgrade to reduce the overall EBS migration/upgrade downtime drastically.
  • Understanding the Marion County EBS environment and recommend on Hardware/Memory/Storage front to power the upgrade load and reduce downtime.
  • Finalize platform migration and upgrade approaches, plan and implement the CRPs, implement database upgrade, platform migration, EBS 11i to R12 GO-LIVE and post Go-live system stabilization and support.
  • Install blank 11g database, export EBS 10g data using oracle expdp and import into 11g database using impdp thus completely eliminating the database upgrade process.
  • Apply pre upgrade/module specific and upgrade performance patches, Maintaining Oracle Financials modules including Financial Accounting Hub, Payroll and HRMS, complete the post upgrade steps.
  • Fixing the post GO-LIVE issues and performances, stabilizing the system and provide the production support.
  • Installation/Config/Upgrade of Fusion Middleware Weblogic (WLS), Discoverer 11g and configuring it with Oracle EBS R12.1.3.
  • Configuring the OEM 12c for monitoring all types/all targets using Monitoring Templates, Creating/enforcing Enterprise wise rules, setting up Alerts, Data Masking and sub-setting, Configuring patching Wizard.
  • Creation of R12.1.3 clones for the Test, QA and Dev environments.
  • Migrating the rman backup from Solaris to Linux environments

Environment: Oracle EBS 11i/10gR2 11gR2/EBS R12.1.1/R12.1.3 Dev/Stage/Test and PRODUCTION environments, OEM 12c, HP-UX, SOLARIS SPARC 10/RHEL ES 6.3(64 bit), Btrfs and ASM filesystem SAN Storage, NIS, Federal financials, Discoverer 10g/FMW Disco 11g, FMW Weblogic 10g (WLS), JIRA, Vertex, SharePoint, RMAN.

Confidential, San Francisco, CA

Lead Oracle Apps DBA

Responsibilities:

  • Responsible for end to end dba deliverables from finalizing the upgrade and platform migration approaches, planning the CRPs, implementing the plan, GO-LIVE for upgrade, platform migration to post Go-live system stabilization and support.
  • Understand the Confidential EBS environment; recommend hardware specs to power the upgrade load, finalize the approach and path for EBS upgrade/migration.
  • Apply pre upgrade, upgrade performance and EBS module specific patches (AP,AR, GL, ZX, SLA, Payroll, IBY)
  • Upgrade of 10gR2 (10.2.0.2) database to 11gR2 (11.2.0.3) database and EBS 11i to EBS R12.1.1 on Solaris SPARC 64 bit server, complete the post upgrade steps along with customizations.
  • Export/import of database using oracle expdp and impdp.
  • EBS R12.1.1 cloning, installing EBS R12.1 tech stack, platform migration of EBS R12.1.1 from Solaris SPARC 10 to RHEL 5.3.
  • Installation and configuration of discoverer 10gR2 and infrastructure (10.1.2.0.2 ) services.
  • Apply patch sets, update metadata repository, configuring SSO.
  • Upgrade of EBS R12.1.1 to R12.1.3.
  • Configuring the discoverer for the EBS R12.1.3.
  • Stabilizing the system after GO-LIVE, fixing the post go-live issues and performance issues.
  • Used OEM Grid 11g for Pro-active Monitoring, job scheduling, identifying performance issues, sql tuning and alerts.
  • Providing the production support.

Environment: Oracle 10gR2, 11gR2, Dev, Stage, Test and PRODUCTION environments, SOLARIS SPARC 10 (64 bit), RHEL ES 5.3 (64 bit), Discoverer 10gR2, 10gR3, Infrastructure 10g, EBS 11i, EBS R12.1.1 and EBS R12.1.3, SSO, OID, OEM Grid 11g

Confidential, Hillsdale, CA

Lead Oracle DBA

Responsibilities:

  • Creating Oracle DW databases for different environment like DEV, QA, UNITTEST
  • Maintaining DW databases, applying database patches CPU, upgrade patches, updating stats, locking/unlocking the stats on the schema/objects, tuning queries
  • Creating different sets of user for ETL, warehouse, user management, tablespace management, security administration, extracting schema ddl, supporting development team on database, auditing, profiling, and authentication.
  • Loading data to the historical environment (data warehouse) using online database aggregators (PL/SQL code), purging data, disabling constraints, disabling triggers for loading data both full load, incremental load.
  • Configuring RMAN backups both incremental and full.
  • Used OEM Grid for enterprise db and application monitoring. Configured threshold alert for the db, pushing agents to discover targets, Fine tuning or identifying performance issues using OEM, generating AWR reports and analyzing using OEM.

Environment: Oracle 10gR2, 11gR1, 11gR2 DW databases on PRODUCTION, DEV, QA and TEST environments, RHEL ES 4.0, OEL 5.0, OEM Grid 11g

Confidential, Princeton, NJ

Lead Oracle Apps DBA

Responsibilities:

  • Initial requirement gathering, preparing project plan and plan sign off.
  • Responsible for complete solution from hardware sizing, system setup, download the required Application & database patches, upgrade, validation, functional testing and delivery of artifacts.
  • Finalize upgrade approach for database, application stack upgrade and processes on all environments.
  • Upgrade of EBS DB from 9iR2 to 10gR2 and subsequently to 11gR1 and EBS application stack from 11i to R12.1.1.
  • EBS application functional testing and validation.
  • OEM 11g was used to monitor the DB and Application, configured threshold alert for database, using OEM for AWR reports, sql analysis.
  • Documentation of all the 3 different upgrade stages, processes and handing over the artifacts to client.

Environment: Oracle EBS 11i and R12.1.1, RHEL ES 4.0, Oracle DB 9i/10gR2/11gR1, OEM 11g, RMAN

Confidential

Lead DBA and project management.

Responsibilities:

  • Requirement gathering, preparing project plan and plan sign off
  • Required setup for migrating 7 oracle (DW and reporting) databases to db2.
  • Installation and configuration of DB2 migration tool IDMT and migration of oracle databases to DB2 LUW 9.7 FP3, sanity check of migrated DB2 databases.
  • Migration, testing and validation of 400 DW pl/Sql oracle scripts to DB2.
  • Complete project management from sign off to successful migration for both Confidential and Confidential .

Environment: Oracle databases 9i, 10g, DB2 LUW 9.7 FP3, Confidential IDMT Migration Tool, Confidential MEET Knowledgebase version: 00.50, RHEL ES 4.0.

Confidential

Lead DBA

Responsibilities:

  • Understanding client application and 2 node RAC database environment.
  • Identifying the bottleneck by analyzing of the query code, the execution plan and AWR reports using OEM 10g for the reporting queries running against hugh tables having more than 10-20+ millions records.
  • Fixing RAC related global cache issues, analysis of the wait events, fine tuning the PCT free, doing batch execution, enabled caching on indexes to increase the performance.
  • Improved the execution time of the query from around 24 hrs to around 9.5 hrs.
  • Knowledge transfer and educating the customer about solution and process.
  • Maintaining Agrinova production 11g (Beta Stage) and 4 development related databases, db backup and daily database maintenance activities.

Environment: Oracle 11.2.X, Oracle 10.2.0.4, RAC, ASM, Toad, RHEL 4.7, OEM Grid 10g, PL/SQL

Confidential, Cupertino, CA

Responsibilities:

  • Initial requirement gathering, discussion with business, application owners and other member of team, preparing project plan and PoC plan sign off
  • Analyzing the application and data model for 13 CRM entities, modules/sub modules in Peoplesoft application.
  • Installation and configuration of Optim 7.3.1 and ODM Server on a 64 bit AIX 5.3 box and 7.3.1 client on Windows bit machine.
  • Creating and maintaining Optim directory on a Oracle 10g database and pointing dbalias to Peoplesoft TEST database, creating AD for 13 modules and archiving the data from them
  • Configuring ODM to access the data on the archive file using SQL query through JDeveloper.

Environment: Peoplesoft GCRM 8.49 Application, Oracle 64 bit 10gR2 database, Optim server and client 7.3.1, ODM 5.3 server and client, 64-bit AIX 5.3, 64-bit Windows 2003 SP2 server, JDeveloper.

Confidential

Lead Oracle Application DBA

Responsibilities:

  • Installing and configuring Oracle Database 11gR2/10gR2 and Oracle Enterprise Manager Grid control 11gR1/10gR2, Oracle Weblogic server 11g Release 1 (10.3.2) on OEL 5.3.
  • Installation and configuration of remote grid agents through agent push method to remote Oracle E-Business Suite (both 11i, R12) databases and application servers.
  • Applied CPU (Critical Patch Update) on grid repository database.
  • Involved in Linux kernel upgrade because of kernel Bug in RHEL 4.6. (from RHEL 2.6.9-78 to RHEL 2.6.9-89.0.28 )
  • Set threshold values for important metrics, configure alerts for pro active monitoring, fine tune the database, configure and schedule jobs, reports.

Environment: Oracle Weblogic Server 11g (WSL), DB 11gR2, OEM Grid 11gR1, OEL 5.3, OEM Grid 10.2.0.5, RHEL 2.6.9-89.0.28 .

Confidential, Princeton, NJ

Lead DBA and lead

Responsibilities:

  • Installation and Maintainence of new Oracle EBS 11i and R12 instances at both onsite and off-shore for Development, Test and client site simulation.
  • Cloning of instances for development and testing, remote maintenance, scheduling backup, applying patches for all the Oracle E-Business Suite 11i/R12 related Databases and servers.
  • Creating and maintaining Optim directory for the development and testing teams.
  • Lead for developing access definition for Oracle E-Business Suite 11i AP, SSHR modules and was a key member for a team involved in workflow access definition for the test data management solution.
  • Transferring knowledge to the US Confidential team for the modules developed.
  • Supporting US Confidential team for any implementation issues.

Environment: Oracle E-Business Suite 11i/R12.0.4/R12.1.1, Optim 7.1/7.2. RHEL AS4, PL/SQL

Confidential, Palo alto, CA

Responsibilities:

  • Understanding functioning of job scheduling in AutoSys and OEM.
  • Analysis of scripts and jobs running in AutoSys for job type & dependencies, time stamps and scheduling frequencies
  • Preparation of migration Plan, Convert around 3500 scheduled DBA maintenance jobs by mapping of existing jobs with the built in features of OEM using existing scripts
  • Documentation on migration process for each job

Environment: Oracle Enterprise Manager, Shell script, SQL/PLSQL, Linux, OEL 5.1

Confidential

Responsibilities:

  • Upgrade EBS 9i database to 10gR2, patch analysis for patches involving pre-requisites for upgrade ADI version, Developer 6i Version and 10g R2 interoperability patch for 11i.
  • Installation of oracle 10g (10.2.0.2) and Oracle E-Business suite application in a multi-node environment on Oracle Enterprise Linux 5.1, configuration Citrix access gateway client, and access neighborhood.
  • Administration, support and Maintenance of E-Business Suite 24*7 production, development and test databases.
  • Creating replica of production instance by importing the instance dump from production instance for testing.
  • Analyzing the execution plan and AWR reports for delete and purge query which was running against a table of 50 million records and deleting 10 million+ rows.
  • Tuning the query, improving execution time of the query from 11 hrs to 1.5 hrs.
  • Improved the disk access time by enabling asynchronous I/O and using separate disks for Log and datafiles.
  • Application user creation / responsibilities assignment, cloning, perform patch analysis for patches and pre-requisites, applying database (OPatch) and EBS application patches, performing AD activities and troubleshoot worker issues.
  • Monitor and diagnose database performance through monitoring of alert files, trace files.
  • Data migration/import data from different data sources like Excel, CSV, flat files, other database and loading into Oracle db using Sql loader, grouping, cleansing, validation and enriching leads data through internal and external resources to make it more useful to business.

Environment: Oracle 9i, 10gR2, Apex 3.0, Oracle PL/SQL, SQL developer, Apache HTTP server, Oracle E-business suite 11i, OEL5.1, 5.0, Linux 4, RHEL ES4, RMAN

We'd love your feedback!