Performs all Oracle Database Administration related activities
Experience in managing, maintaining, patching, upgrading and ensuring operational continuity of the Oracle Database and associated components using the following Oracle products:
Oracle Database and OS
Oracle Recovery Manager
Oracle Data Guard.
Oracle Cloud Control
Oracle Golden Gate and veridata
Oracle Automatic Storage Management
Oracle RAC & Rac Datagaurd
Oracle E-Business Suite
Oracle WebLogic Fusion Middleware
Oracle Discoverer configure with EBS R12
HMIS Customized Application 11g
Sql Server 2008-20012 install configure and backup recovery
MySQL Database (install, backup, recovery)
******************************************************
Hands on Experience
**********************************************
de Migration Support to Functional Consultants
Handling tickets raised by functional/technical/business users
Handling Alerts raised by alert monitoring system from Database and applications
Tablespace Reorg Activities to improve the performance/to reclaim the unused space
Schema Reorg Activities to improve the performance
Patch Analysis where there is a patch needs to be applied
Patch Application as per schedule
Cloning as per schedules
Backups and issues related to them
Query response time and other Performance Issues
Work with Oracle Support by raising SRs on several issues
Monitoring Standby Databases and resolve respective issues
Regular database maintenance activities (tablespace management, datapump, purging log files……)
Training L1 Apps DBAs to make them L2 Candidates.
Work on issues which L2 couldn’t fix
New Environments Build/Setups
Designing Backup/Recovery policies
Installing new Application environments
Post-Installation Tasks of New environments
Integrating E-Business Suite with other environments such as (SOA, OSB, OBIEE, OTM, IPM …)
Work on integration issues
Work on Cluster setups for both applications and databases
Work on DMZ setups to E-Business Suite
Work on Standby site setups for both applications and databases
Interact with Network/OS teams on network setups and load balancer setups.
Work on Parallel Concurrent Processing (PCP) Setups
Fail-over capabilities testing of E-Business Suite and database
Design Cloning strategies.
Work on design related issues.
Setting up E-Business Suite with Oracle Access Manager/OID to achieve Single Sign-On (SSO) Capabilities
Attend Client Meetings to understand their expectations.
Involve in Business User Meetings to understand their expectations.
Design E-Business Suite Architecture with failover/failback capabilities.
Design Clustering capabilities of E-Business Suite and databases.
Design High availability of E-Business Suite and databases.
Design hardware/capacity sizing.
Helping L3 Team to achieve their targets and in understanding technologies.
Conduct training sessions to the L3 team to get an understanding of system design.
Fix any architectural related issues.
Work on integration options of E-Business Suite with other environments such as (SOA, OSB, OBIEE, OTM, IPM …)
I have 10+ years of active experience in installation and configuration, system implementation and problem trouble shooting. Experience with Oracle 19c, 18c, 12c, 11g and 10g Installation, Administration, Data Guard, RMAN, ASM, and RAC Involved in different scenarios of OLTP and data warehouse farms.
Experience in creating development, test, stage, production, and RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts.
Expertise in installation and configuration of oracle 10g, 11g, 12c, 18c and 19c on various platforms like IBM-AIX, SUN SOLARIS, HP-UX, Red Hat Linux and Windows.
Having a sound knowledge of new features of Oracle 12c and 18c
Proficient in using 12c/ 13c Cloud Control, OEM to monitor and setup alerts.
Planning the backups using RMAN, logical (import/export, impdp/expdp), hot and cold backup.
Oracle Database capacity planning, Creating & Managing Database Structures, space management, storage allocation and different type of storage structure (SAN/NAS)
Performed RMAN backups (Full, Incremental and Cumulative) and recovery, incomplete recovery and disaster recovery using Standby database or Data Guard.
Expertise in database backup/recovery strategy (BCV mirroring, RMAN, Export/Import & Data Pump), Performance Tuning, Capacity Planning, Standby database (Logical, Physical), Oracle configuration management, database cloning, refresh, and patch management.
Worked with latest 10g/11g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, and Recycle Bin.
Performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Application Tuning and Database/Instance Tuning.
Experience in performance-tuning services like EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 10g/11g/12c OEM Grid Monitoring, custom scripts troubleshooting Oracle databases using SQL trace.
Proficient in maintaining 10g, 11g, 12c, 18c and 19c d