Senior Oracle Database Administrator
EFG-Hermes
مجموع سنوات الخبرة :19 years, 7 أشهر
• Installing, upgrading and managing Oracle RAC databases with ASM as required on Linux Operating systems.
• Providing Production support of large Oracle & SQL database supporting active online applications.
• Troubleshooting Production problems and working effectively with team members to identify and address problems
• Scripting for database monitoring and to automate routine tasks
• Performing data analysis to provide management with timely and accurate information
• Performing data management tasks as required loading, editing, restoring data at the requests of our clients.
• Researching, testing and coordinating Oracle patches/upgrades
• Tuning of SQL code and assisting developers in writing and tuning SQL queries
• Testing of new features using 3rd party tools (Toad, SQL Developer, Enterprise Manager, etc.)
• Interacting with Oracle support to resolve issues.
• Designing and managing logs, back-up using RMAN
• Write clear documentation of operating procedures, and ability to write specifications for applications to be developed.
• Troubleshoot and resolve RAC issues
• Monitor current DBMS performance and capacity and develop procedures, where necessary, to improve the DBMS environment as required.
• Maintain backup and recovery both manual and integrated with EMC networker.
• Design SQL queries and PL/SQL program units to fit direct business requirements and to integrate with other applications.
• Designing and developing Oracle reports & Oracle discoverer reports.
• Designing and developing Oracle Forms.
• TradeNet products Administration and integration.
• Integrate Oracle and MS SQL databases and other systems with DR system using EMC Recovery Point.
• Managing Clustered Oracle Application Servers hosting websites and web services.
• Responsible for Customizing and deploying online trading web site.
• Participated in project intended to extend our online trading website using java web technology.
• Follow up and deliver ERP system based on oracle technologies have been developed by Third Party Company.
• Responsible for maintaining and support the ERP system.
• Installing, configuring and deployment oracle application server.
• Develop PL/SQL and Java Portlets.
• Develop Web Services based on PL/SQL.
• Consultation for different teams in diagnosing and tuning PL/SQL program units and SQL scripts in production environments to act with best performance.
• Oracle Developer for Containers Group which had main responsibility to automate Containers Handling Company operations (Charge and discharge containers from vessels and containers yard operations) and integrate it with other parties like customs and the unified port authority system.
• Sharing in business analysis in many areas (Vessels operations and containers Operations).
• Develop and Maintain Vessel Stow Entry Loader Module.
• Develop and Maintain automatic vessels berthing Module.
• EDI messages Integration for containers handling operations.
• Develop new reports to cover all business cycles.
• Implement Vessel Operations Module.
• Implementation and customization of Billing Modules for vessels.
• Implement Containers Gate Module.
• Implement Containers Handling Module.
• Integrate with customs to make integrity in reference data and transactions.
Comprehensive Course last for six months, covered most aspects concerning oracle developing
B.Sc. in Electronics and Communications Engineering.