Senior Oracle Apps (ebs) Dba/oracle Dba Resume
CaliforniA
SUMMARY
- Extensive experience as Oracle DBA/Oracle Apps (EBS) DBA in 11i/12.1/12.2 versions in OLTP Production environments supporting over 12000 users.
- Extensive experience in Implementation/Upgrade/Support of Oracle Applications Release 12 (12.0.3/12.0.6/12.1.3/12.2.4 )/11i(/ 11.5.10/11.5.9/11.5.8/11.5.4 )/Oracle8i/9i/10g/11g databases with over 40 Applications Modules, High Availability, Multi Node Middle Tier, RAC(Real Application Cluster) Standby Databases, OSSWA, RMAN, Replication, Performance Tuning, Backup and Recovery, Capacity Planning.
- Installation, upgrade. Platform Migration and Configuration of Oracle E - Business Suite Release 12/11i with forms server, Web Server, Concurrent Processing Server with very strong knowledge of Oracle Applications R12/11i Architecture.
- Usage of ad Utilities like adop, adadmin, adcfgclone, adpatch for, cloning, administering and patching Oracle Applications releases.(R 12.2/12.1/12.0//11 i).
- Good team player, good learner, has superior Organizational, administrative and Problem-solving skills with teh ability to work in fast paced environments.
- Good understanding of Oracle Cloud Infrastructure(OCI)/Oracle DBaas/Oracle Autonomous database
- Trained, Mentored Applications Users.
- Possess strong interpersonal and communication skills.
TECHNICAL SKILLS
Hardware: Solaris SUN SPARC, IBM X-Series and P-Series Servers, HP-9000 Servers.
O/S: Linux 2/3/6,7, AIX 5.1, 5.2, 5.3,7.1 SunSolaris 2.5/2.6/8/9/10/11 , HP-UX10/11.X, Windows NT, Windows 95
Software: Oracle 19c/12c/11g/10g/9i/8i/7, Oracle Applications Release 12.2/12.1/12.0/11 i(11.5.9)(GL, AP, AR, PA, CE, iTime, iExpense, Management Reporting, OFA(Oracle Financials Analyzer), ADI(Applications Desktop Integrator), Workflow, Oracle Self Service Applications(OSSWA), Oracle HRMS, Oracle Manufacturing, Oracle iprocurement, Oracle ), Forms Server, Reports Server, and Concurrent Processing Server, admin server, Oracle iAS, adaimgr, adadmin, adpatch, adclone Oracle Real Application Cluster(RAC), TOAD, ENTERPRISE MANAGER GRID CONTROL, DBARTISAN,DATA LOADER, C, SQL, PL/SQL, Developer 2000, Forms 4.5 (Triggers, Procedures, Functions), Reports 2.5, Power Builder 4.0, Utilities like SQL*PLUS, SQL*Loader, RMAN (Recovery Manager), ANALYZE, EXPLAIN PLAN, SQL TRACE, TKPROF, SQL*Net 2.0, Net8
PROFESSIONAL EXPERIENCE
Senior Oracle Apps (EBS) DBA/Oracle DBA
Confidential
Responsibilities:
- Upgrade of teh Oracle EBS from Rel. 12.1.3 to 12.2.4
- Performed Applications Cloning using Rapid Clone/manual cloning procedures.
- Performed patching of EBS 12.2 environments
- Administered Oracle EBS Release 12.2 environments
- Responsible for promotion of CEMLI (Configurations/Customization, Extension, Modification, Localization, and Integration).
- Performed Oracle Applications (E-Business Suite) System Administration duties like creating Applications Users, Creating/Managing Applications responsibilities, Menus, Functions, Application Object library (AOL) tasks etc...
- Perform troubleshooting, incident and problem management (including root cause analysis) for incidents.
- Performed Oracle Transparent Data Encryption (TDE)
- Performed integration of environments using SOA Suite.
- Configured various SOA adapters for interfaces across various environments.
- Responsible for promotion of SOA composites across various environments.
- Installed/configured Oracle grid infrastructure and ASM for databases.
- Performed database administration, growth monitoring, reorganization (Export and Import), and capacity planning.
- Performed storage allocations, Unix Shell scripting and development/Production support.
- Performed database sizing, tablespace management, security.
- Trained, Mentored Users.
- Performed database backup and recovery.
- Administered Concurrent Managers and Concurrent Programs.
- Registered new custom Applications.
- Monitored Performance using Oracle 11g/12c Grid Control, troubleshooting.
- Did Applications/Database Performance Tuning.
- Knowledge of TOAD, SQL, PLSQL.
- Contacted Oracle Support and filed TARs online.
Environment: Solaris 11/10, Oracle 19c/12c/11g/10g, Oracle Applications 12.2.4 business streams such as Oracle Financials(GL,AP,AR,Cash Management, Oracle Self Service Web Applications(OSSWA), Management Reporting, Workflow, Oracle Financial Analyzer, ADI, Forms Server, Reports Server, Concurrent Processing Server, Utilities like SQL*PLUS, TOAD, SQL*Loader, OEM Grid Control(Oracle Enterprise Manager), RMAN, SQL Net, Unix Shell/Perl Scripting, Oracle ASM, Oracle grid infrastructure, Oracle Exadata, Oracle Access Manager, Oracle fusion middleware, Weblogic, Oracle Transparent Data Encryption (TDE), Oracle data gaurd
Senior Oracle Apps (EBS) DBA / Oracle DBA
Confidential
Responsibilities:
- Migrated and Upgraded Oracle EBS from Solaris to AIX.
- Upgrade and migration of teh Oracle EBS from 11.5.10.2 to R12
- Migrated and upgraded teh FDR (Financial Data Reporting) environment from Solaris to AIX.
- Migration and Upgrade of Oracle Fusion Middleware 11g /Weblogic server 10.3 from Solaris to AIX.
- Upgrade and cross platform migration of Oracle Database from 11.2.0.2 to 11.2.0.4
- 24x7 Administration of Production Oracle Applications R12 with 100 Concurrent users with teh database of 600+GB size.
- Using ad utilities like adadmin, adclone, adpatch for administering and patching Oracle Applications Release 12.
- Responsible for promotion of Code (Reports, Interfaces, Conversions, Extensions) from various environments like development, testing, Pre-Production (QA) and Production.
- Performed Oracle Applications (E-Business Suite) System Administration duties like creating Applications Users, Creating/Managing Applications responsibilities, Menus, Functions, Application Object library (AOL) tasks etc...
- Administered and maintained on-going production and Non-Prod database environments.
- Performed code migration, patching, patch impact analysis across different pre-production and production environments.
- Perform troubleshooting, incident and problem management (including root cause analysis) for incidents.
- Performed database growth monitoring, reorganization (Export and Import), and capacity planning.
- Performed storage allocations, Unix Shell scripting and development/Production support.
- Performed database sizing, tablespace management, security.
- Trained, Mentored Users.
- Performed database backup and recovery.
- Administered Concurrent Managers and Concurrent Programs.
- Registered new custom Applications.
- Performed Applications Cloning using Rapid Clone/manual cloning procedures.
- Monitored Performance using Oracle 11g/12 Grid Control, troubleshooting.
- Did Applications/Database Performance Tuning.
- Knowledge of TOAD, SQL, PLSQL.
- Contacted Oracle Support and filed TARs online.
Environment: Solaris 10, HP-UX 11.3, AIX 7.1, SQL Server 2005/2008/2012 Oracle 11g/10g, Oracle Applications 12.1.3 business streams such as Oracle Financials(GL, AP, AR, Cash Management, Web ADI, Oracle Self Service Web Applications(OSSWA),, Management Reporting, Workflow, Oracle Financial Analyzer, ADI, Forms Server, Reports Server, Concurrent Processing Server, Utilities like SQL*PLUS, TOAD, SQL*Loader, OEM Grid Control(Oracle Enterprise Manager), RMAN, SQL Net, Unix Shell/Perl Scripting
Senior Oracle Apps (EBS) DBA/ Oracle DBA
Confidential
Responsibilities:
- Implementation of Oracle Applications Release 12 (E-Business Suite) with Oracle iAS (Forms Server, Reports Server, Oracle HTTP Server (Apache), Concurrent Processing Server, Admin server) and Oracle 10g Server with Oracle Financials/Applications 12.0.6 business streams such as Oracle Financials, Oracle Self Service Web Applications(OSSWA), Management Reporting, Workflow, WebADI, etc.
- Involved in planning phase of Oracle E-Business Suite upgrade from 12.0.6 to 12.1.3
- Upgrade of Oracle Database from 10g to 11g.
- 24x7 Administration of Production Oracle Applications R12 with 100 Concurrent users with teh database of 600+GB size.
- Using ad utilities like adadmin, adclone, adpatch for administering and patching Oracle Applications Release 12.
- Responsible for promotion of Code (Reports, Interfaces, Conversions, Extensions) from various environments like development, testing, Pre-Production (QA) and Production.
- Performed Oracle Applications 12.0.6(E-Business Suite) System Administration duties like creating Applications Users, Creating/Managing Applications responsibilities, Menus, Functions, Application Object library (AOL) tasks etc...
- Administered and maintained on-going production and Non-Prod database environments.
- Performed code migration, patching, patch impact analysis across different pre-production and production environments.
- Perform troubleshooting, incident and problem management (including root cause analysis) for incidents.
- Installed, Configured Oracle10g/11g, Oracle EBusiness Suite 12.0.6 Server and related products.
- Performed database growth monitoring, reorganization (Export and Import), and capacity planning.
- Performed storage allocations, Unix Shell scripting and development/Production support.
- Performed database sizing, tablespace management, security.
- Trained, Mentored Users.
- Performed database backup and recovery.
- Administered Concurrent Managers and Concurrent Programs.
- Registered new custom Applications.
- Performed Applications Cloning using Rapid Clone/manual cloning procedures.
- Installed grid control 11g/Monitored Performance using Oracle 11g Grid Control, troubleshooting.
- Did Applications/Database Performance Tuning.
- Knowledge of TOAD, SQL, PLSQL.
- Contacted Oracle Support and filed TARs online.
Environment: HP-UX 11.3, Solaris 10, Linux, SQL Server 2005/2008/2012 Oracle 11g/10g, Oracle Applications 12.0.6 business streams such as Oracle Financials(GL,AP,AR,Cash Management, Web ADI, Oracle Self Service Web Applications(OSSWA),, Management Reporting, Workflow, Oracle Financial Analyzer, ADI, Forms Server, Reports Server, Concurrent Processing Server, Utilities like SQL*PLUS, TOAD, SQL*Loader, OEM Grid Control(Oracle Enterprise Manager), RMAN, SQL Net, Unix Shell/Perl Scripting
Senior Oracle Oracle Apps (EBS) DBA/Senior Oracle DBA
Confidential
Responsibilities:
- Upgrade (11.5.8 to R12.0.3)/Implementation/Production Support of Oracle Applications Release 12 (E-Business Suite) with Oracle iAS (Forms Server, Reports Server, Oracle HTTP Server (Apache), Concurrent Processing Server, Admin server) and Oracle 9i/10g Server with Oracle Financials/Applications 12.0.3 business streams such as Oracle Financials, HRMS, CDS(Claims Distribution System), Oracle Self Service Web Applications(OSSWA), Management Reporting, Workflow, WebADI, etc.
- 24x7 Administration of Production Oracle Applications R12 with 2600 Concurrent users across teh world with 100 on-site Applications end users with teh database of 300+GB size.
- Using ad utilities like adadmin and adpatch for administering and patching Oracle Applications Release 12.
- Responsible for promotion of Code(Reports, Interfaces, Conversions, Extensions) from various environments like development, testing, Pre-Production(QA) and Production .
- Performed Oracle Applications 12.0.3(E-Business Suite) System Administration duties like creating i Applications Users, Creating/Managing Applications responsibilities, Menus, Functions, Application Object library (AOL) tasks
- Administered and maintained on-going production and test database environments.
- Installed, Configured Oracle9i/10g/Oracle EBusiness Suite 12.0.3 Server and related products.
- Performed upgrade of RMAN server.
- Performed migration of RMAN from one server to another.
- Performed database growth monitoring, reorganization (Export and Import), and capacity planning.
- Performed storage allocations, Unix Shell scripting and development/Production support.
- Performed database sizing, tablespace management, security.
- Trained, Mentored Users.
- Performed database backup and recovery.
- Administered Concurrent Managers and Concurrent Programs.
- Registered new custom Applications/rapid cloning/performance tuning.
Environment: AIX 5.3L, Solaris 9, Windows NT, Oracle 10g/9i, Oracle Applications 11.5.8/12.0.3 business streams such as Oracle Financials(GL,AP,AR,Cash Management, Web ADI,, Human Resources(HRMS), Oracle Self Service Web Applications(OSSWA), High available multi node middle tier architecture with Standby database, Management Reporting, Workflow, Oracle Financial Analyzer, ADI, Discoverer, Forms Server, Reports Server, Concurrent Processing Server, Utilities like SQL*PLUS, TOAD, SQL*Loader, OEM Grid Control(Oracle Enterprise Manager), RMAN, Net 8, Unix Shell/Perl Scripting
Oracle Applications11i DBA/Oracle 9i/10g DBA
Confidential
Responsibilities:
- Implementation/Production Support of Oracle Applications 11i(E-Business Suite) with Oracle iAS (Forms Server, Reports Server, Oracle HTTP Server (Apache), Concurrent Processing Server, Admin server) and Oracle 9i/10g Server with Oracle Financials/Applications 11i business streams such as Manage teh Business(MTB), Quote to Cash(Q2C), Demand to Available(D2A), Contract Management(CM), Human Resources(HRMS), Req to Pay(R2P), Oracle Self Service Web Applications(OSSWA), Management Reporting, Workflow, Oracle Financial Analyzer, ADI, Discoverer etc.
- 24x7 Administration of Production Oracle Applications 11i with 12000 Concurrent users across teh world with 300 on-site Applications end users with teh database of 500+GB size.
- Using ad utilities like adadmin and adpatch for administering and patching Oracle Applications 11i.
- Responsible for promotion of RICE Code(Reports, Interfaces, Conversions, Extensions) from various environments like development, testing, UAT and Production with managing of teh change control process documents, seeking approvals from managers etc.
- Performed Oracle Applications 11i(E-Business Suite) System Administration duties like creating 11i Applications Users, Creating/Managing Applications responsibilities, Menus, Functions, Application Object library (AOL) tasks etc...
- Installed and configured ADI, Discoverer Client, Oracle JInitiator, Oracle Network administration and troubleshooting.
- Administered and maintained on-going production and test database environments.
- Maintained Oracle RDBMS 9i/10g high availability solutions like Oracle RAC, Oracle Data Guard, Oracle Replication in AIX Environment.
- Installed, Configured Oracle9i/10g Server and related products.
- Performed database growth monitoring, reorganization (Export and Import), and capacity planning.
- Performed storage allocations, Unix Shell scripting and development/Production support.
- Performed database sizing, tablespace management, security.
- Trained, Mentored Users.
- Performed database backup and recovery.
- Administered Concurrent Managers and Concurrent Programs.
- Registered new custom Applications.
- Performed Applications Patching, Applications Cloning, Monitoring, troubleshooting.
Environment: AIX 5.1/5.2, Linux 2/3, Sun Solaris 9, Windows NT, Oracle 9i, Oracle Applications 11i business streams such as Manage teh Business(MTB), Quote to Cash(Q2C), Demand to Available(D2A), Contract Management(CM), Human Resources(HRMS), Req to Pay(R2P), Oracle Self Service Web Applications(OSSWA), High available multi node middle tier with Parallel Concurrent Processing and RAC architecture with Standby database, Management Reporting, Workflow, Oracle Financial Analyzer, ADI, Discoverer, Forms Server, Reports Server, Concurrent Processing Server, Utilities like SQL*PLUS, TOAD, SQL*Loader, OEM Grid Control(Oracle Enterprise Manager), RMAN, Net 8, Unix Shell/Perl Scripting, IBM HACMP, GPFS
Senior Oracle Financials/Applications11i DBA/Senior Oracle DBA
Confidential
Responsibilities:
- Implementation/Administration of Oracle Applications 11i with Oracle iAS (Forms Server, Reports Server, Oracle HTTP Server (Apache), Concurrent Processing Server, Admin server) and Oracle 8i Server with Oracle Financials/Applications 11i modules General Ledger, Accounts Payables, Accounts Receivables, Cash Management, Project Accounting, Oracle Self Service Web Applications(OSSWA), Oracle Portal, iTime, iExpense, Management Reporting, Workflow,
- Oracle Financial Analyzer, ADI, Discoverer and HRMS.
- 24X7 Administration of Oracle Applications 11i with 6000 Concurrent field users/150 on-site Applications end users.
- Using ad utilities like adadmin and adpatch for administering and patching Oracle Applications 11i.
- Responsible for Code Migration (Custom Code, Custom Interfaces, and Conversions) from environments like development, testing, UAT and Production with managing of teh change control processes, seeking approvals from managers etc using EARS (Extended Action Request System).
- Involved in 11i upgrade from 11.5.4 to 11.5.9.
- Performed Oracle Applications System Administration duties like creating 11i Applications Users, Managing Applications responsibilities, Application Object library (AOL) tasks etc...
- Installed and configured ADI, Discoverer Client, Oracle JInitiator, Oracle Network administration and troubleshooting.
- Trained, Mentored Users of Oracle Applications.
- Administered Concurrent Managers and Concurrent Programs.
- Registered new custom Applications.
- Performed Applications Patching, Applications Cloning.
- Maintained Production Systems uptime, monitored applications performance, troubleshooting.
- Installed, Configured Oracle8i/9i Server and related products on HP/UX 11.0, Solaris 8, and Windows NT.
- Performed database growth monitoring, reorganization (Export and Import), and capacity planning.
- Performed storage allocations, Unix Shell scripting and development/Production support.
- Performed database sizing, tablespace management, security administration (Managing Responsibilities, roles, access control etc.)
- Did Applications/Database Performance Tuning.
- Contacted Oracle Support and filed TAR online.
Environment: HP-9000, HP/UX 11, Windows NT, Sun Solaris 2.5/2.6/8/9, Oracle 8i, Oracle Applications 11i with Oracle Financials (AP, AR, GL, CE, MR, ITIME, IEXPENSE, OFA, WORKFLOW, ADI, DISCOVERER), HRMS. Forms Server, Reports Server, Concurrent Processing Server, Utilities like SQL*PLUS, SQL*Loader, OEM (Oracle Enterprise Manager), DB Artisan, RMAN, Net 8, Unix Shell/Perl Scripting.
SENIOR ORACLE DBA/ORACLE APPLICATIONS DBA
Confidential, California
Responsibilities:
- Confidential is an Application Service Provider for Call Center Management. Its various clients include Exodus, HP etc.
- Involved in installation, upgrading and configuration Oracle Applications 11i Financials/Applications 11i modules (General Ledger, Accounts Payables, and Accounts Receivables.
- Using ad utilities like adadmin and adpatch for administering and patching/applying maintenance pack for Oracle Applications 11i upgrade from 11.5.2 to 11.5.4.
- Created Snapshots for implementing Replication.
- Designed, implemented Backup, Recovery Strategies and Procedures using RMAN (Recovery Manager)
- Integrated and configured HP OPENVIEW OMNIBACK II with Oracle and RMAN for Media Manager based Backup and Recovery.
- Designed, Created and maintained databases, created Tablespaces, Tables, Indexes etc. in development, test and production environments with 500 concurrent users.
- Created users (database accounts), roles and granted appropriate privileges to them.
- Performed hot/cold backups and database recovery in case of failures.
Environment: HP-9000, HP/UX, Windows NT, Sun Solaris 8, Oracle 8i, Oracle Applications 11i with Oracle Financials (AP, AR, GL, CE, MR, ITIME, IEXPENSE, OFA, WORKFLOW, ADI, DISCOVERER), HRMS. Forms Server, Reports Server, Concurrent Processing Server, Utilities like SQL*PLUS, SQL*Loader, OEM (Oracle Enterprise Manager), DB Artisan, RMAN, Net 8, Unix Shell/Perl Scripting.