Senior Oracle Apps Database Administrator Resume
4.00/5 (Submit Your Rating)
OBJECTIVE
- Seeking Senior Oracle Database position in an aggressive organization which effectively utilizes acquired expertise and experience.
TECHNICAL SKILLS
- Oracle EBS R12 11i installation.
- Oracle EBS R12 11i patching over UNIX and LINUX environments.
- Oracle backup recovery and cloning for Oracle EBS R12 11i.
- Backup recovery using HP “data protector “.
- Oracle Real Application Cluster “RAC”.
- Oracle development including oracle forms and reports.
- Oracle sql and pl/sql.
- Oracle database installation (dedicated / shared server) configuration.
- Oracle database backup solutions (hot and cold backups).
- Citrix Client/Server with installation and configuration for application to be published over web.
- VPN connections.
- UNIX
- Linux.
PROFESSIONAL EXPERIENCE
Confidential
Senior Oracle Apps Database Administrator
Responsibilities:
- Working and support different Oracle ERP projects.
- Migrating Oracle EBS 11i from HP - UX to Linux (Syrian Telecom).
- Upgrading oracle EBS from 11i (11.5.10) to R12 (12.1.3) SabaFon - Yemen.
- Migrate oracle database from 32bit to 64 bit (PMIS - Yemen)
- Production/Test environments installation for HBTF (The Housing Bank For Trade And Finance)
- Upgrading oracle database 11gR1 to 11gr2.
- Upgrading oracle E-Business suite from 11i to R12 (12.1.x and 12.2.x)
- Adding and configure the custom application top.
- Workflow configuration for inbound / outbound notifications.
- Applying Opatches such as fixes and CPU patches to the database, application and weblogic servers.
- Concurrent manager administration and tuning.
- SSO (oracle single sign on 10g) installation and configuration.
- Weblogic 11g installation and administration.
- SOA suite installation and administration.
- OBIEE / BI installation and administration.
- IDM (identity management installation and administration).
- Oracle Hyperion installation (9 and 11).
- Oracle 12.2.x installation as multimode using cluster on weblogic.
- Linux 4, 5 and 6 installation.
- RPM packages installation for Linux and setting the kernel/limits parameters).
- Packages installation for IBM (AIX) and setting the kernel/limits parameters)
- Installation of Fusion applications (11.1.4, 11.1.5, 11.1.7, 11.1.8)
- Giving courses for DB fundamental I and II, weblogic, SOA, system administrator (sysadmin), RAC, Hyperion.
- Patching all releases of Oracle E-Business suite using adpatch and adop (online patching for 12.2.x).
- Creating oracle EBS users, responsibilities, menus.
- PASTA configuration and adding Arabic fonts to EBS.
- Adding and installing printer to EBS to print directly from EBS.
- Cloning Oracle EBS 11i, 12.1.x and 12.2.x
- Debugging and solving issues occurred or reported by the functional teams.
- Networker installation and configuration (EMC) and writing RMAN scripts for backup and recovery.
- Designing the architecture of EBS according to the number of concurrent users, self-service users high availability and security.
- Support oracle EBS for:
Confidential
Oracle APPS DBA/System Administrator
Responsibilities:
- Working on ERP Project for GAM with Deloitte, CCS and Optimiza
- Application Installation and upgrading, Oracle E-Business Suite 12.1.1 Installation (Fresh and Vision Instance) on HP-UX 11.31, HP-UX 11.23, Linux Redhat, on single-tier and multi-tier,
- Converting Oracle E-Business suite from single database to ASM (cluster) and application to multimode and connecting them on F5 Load balancer.
- Oracle Database 11.1.0.7 administration.
- Backup, Restore and recover databases using RMAN.
- Patch management and version control.
- Backup, Recovery and Cloning procedures.
- Real Application Cluster 11.1.0.7 (RAC) installation and configuration .
- Cloning from RAC to Single node and vice versa.
- Managing Production, Test, Development and training environments.
- Managing six servers “two for database as “RAC”, two for application tier and two for concurrent manager.
- Performance Tuning for Oracle Database and oracle applications.
- Weblogic installation 11g.
- SOA (Service Oriented Architecture 11g) suite installation and administration.
- Unix installation (Mission Critical).
- Unix network configuration.
- Unix patches and packages installation.
- UNIX disks and tapes management.
- Creating Users, Responsibilities, Menus, functions and flexfields.
- Managing profiles on all levels.
- Solving Arabic font's problem on UNIX platform.
- Supervising four employees (database and networks) administrators in the department which serves over 150 employees and 14 branches in the company.
- Testing oracle reports and forms for accuracy and speed.
- Design POS system (Point of sale) with accounting and inventory systems.
- Setting the annual budget and generating the semi-annual and the annual report for the department.
- Checking database integration and backup procedures.
- Development and modification for oracle forms and reports including Oracle Matrix Reports as needed.
- Provide quarterly report for the consistent of the hardware and the software used.
Confidential
Database administrator/oracle developer
Responsibilities:
- Oracle forms and reports development for loan tracking, accounting and payroll systems.
- Development of incentives system using oracle forms to calculate target for loan officers which includes disbursement, collection, transportation and mobile according to his/her portfolio.
- Development of E-POINT system
- Remote access to sites to provide technical support.
- Creating oracle tables, synonyms, functions, procedures, indexes and triggers.
- UPS (Uninterruptible power supply system) checking and reporting in case of failure.
- Development of performance reports to generate the operational, financial sustainability, portfolio at risk and other ratios reports.
- Oracle forms and reports development for loan tracking, accounting and payroll systems.
- Oracle 8i Database installation and maintenance.
- Backup, restore and recover database using RMAN and EXP/IMP.