Apps DBA team leader
Saad Group
Total years of experience :25 years, 1 Months
- Integration between Oracle EBS, OAM and SMS
- Migration from Linux server to Unix servers
- Migration from single node architecture to multi node architecture
- Upgrade from 12.0.1 to 12.1.3
- Deploy Oracle Discoverer over Weblogic server
- Integration between Oracle EBS and Oracle Discoverer 11g
- Linux upgrade from 5.4 to 6.4
- Database upgrade from 10g to 11gR2
- RAC Database upgrade from 11gR2 11.2.0.3 to 11gR2 11.2.0.4
- Updating the full Disaster recovery plan according to the new changes
- Mass patching (Application patches like RUPs, Database patches like CPU, PSU patches)
- Structural reconfiguration (From single node to mutli-nodes and vice versa)
- Supporting multiple Production, Test and Development instances running Oracle DB, AS, Discoverer and Oracle Applications R12.
- Autoconfig stabilization
- Planning the capacity of the databases, Sizing the hardware, Installing and administering and Configuring Oracle DBs “9i and 10g”
- Schedule backup and export tasks.
- Stand by for emergency calls and troubleshoot Critical problems occurs during non- business hours.
- Modify the database structure, as necessary.
- Move data among different databases through Export/Import utilities.
- Administer User Security settings and monitor it.
- Administer the replication environment.
- Oracle Database:
- Installing (9i/10g/11g) Non-RAC/RAC environments, managing node configurations, adding/removing nodes to/from the RAC cluster.
- Creating and managing DR configurations (Oracle data guard).
- Release Management tasks including:
. Database upgrades and Grid upgrades,
. Technology stack upgrades, Periodic Maintenance Plans
. PSU patches, Critical Patch Updates (CPU patches) and point release upgrades.
. RUP patches.
- DB performance tuning, SQL tuning.
- Ensuring accessibility and recoverability of the database (disaster recovery of database pertain various types of database Failures).
- Strong experience in using RMAN, RMAN configuration (creating RMAN backup scripts for incremental & full database backup and run these scripts regularly).
- Strong experience in using SQL/PLSQL.
- Strong experience in using and configuring Oracle Enterprise Manager OEM.
- Taking Logical (dupms), Physical (Hot and Cold) backups for the database.
- Upgrading databases to the newest releases.
- Proactive Maintenance using dynamic views and metadata views.
- Audit trails on DB and EBS.
- Oracle Applications:
- Integrated Oracle applications R12 with Exchange gateway, - Strong hands on technical experience with Oracle EBS R12, Database (9i, 10g and 11g), Discoverer 11g, Workflow, Linux, Windows and AIX.
- Oracle Apps 11i and R12 Installation, Patching, Patch analysis, Cloning, Maintenance, Migration, Upgrade, Maintenance Pack application, JInitiator, Java upgrade.
- Responsible for implementing all technical tasks requested by the functional teams to complete the ERP implementation.
- Using Autoconfig to configure the EBS environment while preserving the existing customizations.
- Managing Concurrent Managers, Forms/Report Servers and Web Servers.
- Using the production backups to create test environments (cloning), without affecting the Production instance.
- Changing the EBS architecture from single node to multi nodes, from non-RAC to RAC as per the business needs.
- Proactive monitoring and maintenance for the EBS components (DB, Concurrent managers, Forms, Apache).
- Change Management tasks including (Applying Database patches “using Opatch”, Oracle Applications Patches, managing Technology stack configurations and control services).
- Strong experience in using all AD utilities.
- Design, implement and monitor the Backup and Recovery plans to ensure recoverability in case of any failures.
- Applying customizations sent by the development team on test instances and promote it to Prod.
Education B.Sc. Degree in Computer Science Applied Science University Year: 1999/2000