Sr Oracle Apps DBA/ Fusion Apps DBA/ SAP Basis Admin
Independent Contractor
Total years of experience :17 years, 9 Months
Remote Support Projects:
@Appslink
May 2016 to Oct 2016
=Senior Oracle Applications DBA- Senior Technology Consultant @ APPSLINK.
-Designing, Install, Administer Oracle Fusion Applications 11g Release 9 (11.1.9).
-Day-to-day support of multiple Production and non-production Oracle E-Business Suite, Fusion Applications environments.
Sr Oracle DBA 8i, 9i, 10g, 11g, 12c RAC, Data Guard
Sr Oracle Apps DBA 12.x, RAC, Data Guard, Load Balacing, Multi Nodes Apps
Oracle E-Business Suite Upgrade from R11.5.10.2 to 12.2.4 Database upgrade from 11g to 12c. Integration with SSO, OID. Up gradation on Oracle RAC on ASM. Day to day maintenance patching, cloning, error resolution, SR Handling. Designing implementing supporting Oracle EBS 12 solutions. Designing EBS HA Solutions/
Designing, Installing Oracle Fusion Applications 11g Release 8 (11.1.8)
Designing, Implementing and supporting Oracle EBS solutions on cloud as well as in local data center.
Leading Oracle Apps DBA department.
Designing Implementing High Availability Solutions for Oracle EBS 12.1.3.
Implemented Oracle EBS Availability solution including 3 Application nodes including (DMZ) Configurations and Database on Oracle RAC Database nodes. Providing 99% availability on Oracle EBS.
Implementing Supporting multiple EBS projects in multiple environments.
Helping sales team by giving different solutions in different hardware and putting some innovative ideas to give edge to sales bid. Edge on time saving solutions, Cost Saving solutions and depending on requirements.
Designing, Installing Oracle Fusion Applications 11g Release 8 (11.1.8)
Designing, Implementing and supporting Oracle EBS solutions on cloud as well as in local data center.
Leading Oracle Apps DBA department.
Designing Implementing High Availability Solutions for Oracle EBS 12.1.3.
Implemented Oracle EBS Availability solution including 3 Application nodes including (DMZ) Configurations and Database on Oracle RAC Database nodes. Providing 99% availability on Oracle EBS.
Implementing Supporting multiple EBS projects in multiple environments.
Helping sales team by giving different solutions in different hardware and putting some innovative ideas to give edge to sales bid. Edge on time saving solutions, Cost Saving solutions and depending on requirements.
Installation of Oracle EBS on network (NFS Share).
Cloning Oracle EBS R12 from Multi node to Single Node.
Completed following Projects.
o Data Guard Implementation in test environment with Oracle EBS R12. In case of any failure can move to new server in 17 min with 0 or 1% data loss.
Functional Tasks : Resolving Create Accounting issues.
Working on following projects:
Client : Orient Power Company (Private) Limited.
Project Desc: Installation, Configuration, Cloning, Patching Oracle EBS R12.
Dataguard implementation in test environment. Failover time 17 min.
Up gradation of Oracle EBS from 12.1.1 to 12.1.3 environment.
SAP Basis Administrator.
Installation of SAP Business Objects 4.0 on SUSE Linux 11.
Main Responsibilities involve following.
• Implementing Data Guard on 11.5.10.2 in test environment.
• Up gradation of Database of E-business Suite 11.5.10.2 upgraded its database from 9.2.0.6 to 9.2.0.7, 9.2.0.8 and 10.2.0.2. and 11.2.0.1 On Linux
• Appl ication of E-Business Intelligence Family Pack 11i.BIS_PF.G. (E-Business Intelligence Family Pack 11i.BIS_PF.G. )
• Database Administration / Oracle Applications R11i (Test and Prod Servers).
• Currently working on following 2 Projects.
o Implementation of BI in 11.5.10.2.
o Up gradation of Reliance Weaving Mills, Fazal Cloth Mills Production Servers from release 11i to 12i AND
• Single and multi user/Node Installations of E-Business Suite.
• Up gradation of AD administration ADi from ADi 2 ADi 7.
• Applying Minipack, Family packs.
• Removing Bugs.
• Troubleshooting E-Business Suite. (Login, Jinitiator, Concurrent manager).
• Resolving Concurrent Manager Problems.
• Increasing Performance of Concurrent Managers.
• Resolving Apache Server Problems.
• Backup and Recovery.
• Administration of E-Business Suite Through AD Administration Utilities tasks including Compilation of different Objects like Flexfiled, Apps schema.
• Performing intense patching activities.
• Applying patches with and without Maintenance mode.
• Keeping Financial, BI (Business Intelligence) Modules to its Latest Patch-Level.
• Cloning Oracle application
• Resolving X-server problems on LINUX
• Keeping track of workers during patching and managing workers, resolving worker problems.
• Troubleshooting of Different Modules of E-Business Suite self as well as with the support of Metalink Metalink/My Oracle Support ( https://support.oracle.com/CSP/ui/flash.html ) on OWCs and on Phone calls. For severity 1 and 2 SRs
• Resolving user problems related to R11i reports.
• Creating new reports and editing old reports, up loading reports.
• Assigning Responsibility to users.
Database Administration Of Oracle Application Versions 11.5.10 and 11.5.7.
24/7 Support of Live Databases, Oracle Applications.
Installation of Oracle Financials, HR, Payroll, Business Intelligence On E-Business Suite.
Single and multi user Installation of E-Business Suite.
Up gradation of AD administration ADi from ADi 2 to ADi 4 and ADi 5.
Applying Patches.
Removing Bugs.
Troubleshooting E-Business Suite.
Resolving Concurrent Manager Problems.
Increasing Performance of Concurrent Managers.
Resolving Apache Server Problems.
Administration of E-Business Suite Through AD dministration Utilities tasks including Compilation of different Objects like Flexfiled, Apps schema.
Relinking of AD and other modules executables.
Compiling and Creating executables of forms and reports.
Applying Patches Interactively and non interactively.
Applying patches with and withought Maintenece mode.
Applying merge patches.
Resolving X-server problems on SUN.
Keeping track of workers during patching and managing workers, resolving worker problems.
Troubleshooting of Different Modules of E-Business Suite self as well as with the support of Metalink on OWCs and on Phone calls. For severity 1 and 2 SRs
KEY AREAS OF E-BUSINESS SUITE EXPERTISE
Experienced Senior E-Business Suite Oracle Applications DBA Consultant professional specialized in the implementations of the Oracle ERP products in Different Telecom and Petroleum companies. Worked with several large Oracle applications accounts and primarily assisted them on technical issues. This role has involved:
•Installing (Single User, Multi user) and upgrading E-Business Suite(Versions:11.5.8, 11.5.9, 11.5.10), R12) . Monitor and troubleshot 11i remotely.
•Installing latest legislative patches for HR, Internal Control Manager, Oracle Financials, Business Intelligence modules.
•Administration through AD Administration utilities task including Compilation, relinking of executables administration of workers, administration of concurrent managers and requests & maintenance including applying patches (Interactively, Non Interactively, With and without maintenance mode) and cloning.
•Adding New Modules to E-Business Suite and registering and licensing it through AD Splice and Oracle Application Manager
•Managing security on OS level as well on Application and Database level.
•Supporting customers on technical issues.
•Planning & implementing backup, recovery strategies.
•Grid Control Installation and Setup.
•Delivering Oracle Trainings. (Installation, Patching Administration)
•Supporting different operating systems including Windows, Linux, Sun.
•Troubleshooting of Different Modules of E-Business Suite self as well as with the support of Metalink on OWCs and on Phone calls.
CORE DATABASE EXPERTISE
•Installation and configuration of Oracle Database 10g RAC on virtual SAN.
•Replication with materialized views, Streams Oracle Database 10g.
•Configured data guard on 10g.
•Up gradation of any previous version of Oracle database to Oracle database 10gRelease 2
•Development in PLSQL.
•RMAN for backup and recovery
•Oracle Database Patching.
Oracle Exadata Database Machine 2014 Sales Specialist
Oracle E-Business Suite R12 Applications Database Administrator Certified Professional
LOTUS DOMINO Administration. Installation Configuration and Maintenance.
Oracle Database 10g Administrator Certified Professional
Operating System Introduction (Linux)
MAXIMO Administration and report designing.
Information Technology (Databases and Data warehousing)
MCSE Track 4