Resume

Sign in

Manager Oracle

Location:
Riyadh, Riyadh, Saudi Arabia
Posted:
November 12, 2018

Contact this candidate

Resume:

Samir Boussoussa

Riyadh, Saudi Arabia

Mobile: +966-********* Email: ac7n3g@r.postjobfree.com

Executive Profile

A seasoned computer science professional with 17+ years of rich experience in spearheading IT operations & database management, providing innovative IT infrastructure solutions/ services, aligning business goals with cutting-edge technology solutions to drive process improvements, competitive advantage and bottom-line gains.

Leveraging Oracle Core Database Administration and Oracle Applications EBusiness Suite 10,11i and 12 excellences whilst providing strategic consultancy - creative, innovative IT solutions to help companies achieve business, technology, and operational goals and objectives.

Mastering cutting-edge technologies and Certified Oracle Database and Applications Administration (Oracle Certified Professional OCP 9i and OCP 12C, and Oracle E-Business Suite R12 Applications Database Administrator Certified Professional. Hands-On Installation, Maintenance and enhancement of the EBS infrastructure architecture to the most advanced topology (RAC, Multinode, Shared ApplTop, load balancing) and Upgrading to latest software versions 12C, R12 and migrating to the newest Engineered Systems, combining highly optimized Exadata end Exalogic functionality.

Carried beyond myself by the inspiring force of urgent trend to commoditize IT. Involved in the corporate Business processes to innovate and improve the Business to get better value form IT Data and Apps. IT Service Management ITIL Certified.

Championed providing high performant Oracle code capable of addressing key business process. Owning cross-sector experience in international environments including Banking, Manufacturing and distribution, Governmental and education.

Core Skills

IT Strategy & Architecture Technology Roadmap Project Management Quality Assurance Financial Acumen Budgeting Process Optimization/Best Practices Training and Development Negotiation Skills Passionate Leadership.

Technical Skills

Database Administration Applications Development System Administration Technical Support Entreprise Resource Planning (ERP) Oracle 9i To 12C Database Oracle E-Business Suite EBS 11i, R12 Unix (HPUX 11i, IBM AX platform and Linux Server RedHat 6.5, Oracle Linux 7 Oracle Virtual machine Advanced and High availability Architecture: Cloud, RAC, Data Guard, Golden Gate Engineered Systems : Exadata, Exalogique, SuperCluster SQL/PLSQL Coding Shell Scripting.

Executive Synopsis

Proffered end to end support of suite of mission critical Oracle databases, SQL performance & tuning analysis, database design and best practice implementation.

Trainer and Oracle Consultant with Oracle University Education Partners.

Recognized for excellent project management, ITIL Certified (IT Service Management), technology leadership, communication, interpersonal and people management skills.

Professional Experience

IT Operations & Database Manager Feb 2010 – Present

Innovation Center, Riyadh, Saudi Arabia

Accomplishments:

Commanded the IT, infrastructure and operations of the Innovation Center (IC) and its Partners and customers including staff, material and software.

Instrumental in designing, developing and maintaining Database Management Solutions, delivering better performance, availability, security and management.

Drove improvement across the database estate covering all aspects of the Oracle Database Technology stack.

Pioneered development of a national database of inventors and innovate ideas, a knowledge base linked to intellectual property program, investors, universities and industrials. The system covers the submission, disclosure, and evaluation, registration as patent, to fabrication and marketing.

- facilitated effectiveness and functionalities of the organization`s database, related to integration with client`s websites and other systems, and reporting.

Assessment and Audit of large scale IT infrastructure at Ministry of Health. EBS 12, with DMZ and Mobile access.

Technical and financial Proposal toward making purchasing decision and migration to SuperCluster T5-8 and M6- 32 and MiniCluster Engineered Systems for our clients, Ministry and Banking fields.

Negotiate on behalf of sovereign Governmental institutions with mission critical Database the deployment of Exadata machine.

Migrate to Exadata on premises for private Database Cloud.

Configure Entreprise manager Cloud Control 12C (OMS, Repository, Agents Plugins), and Express Manager.

Heading project of Migration to 12C, Real application Cluster, Standby and Golden Gate in Bank of Agriculture Development.

Key Responsibilities:

Patching: apply regularly Release Update Pack RUP, and Family RUP for the EBS, bug fixes. High recommended patches. Using Online patching feature (adop utility). On Pre-Installation, Pathing the OS (Aix, HPUX, Linux) and update kernel parameters.

Cloning the production environment for test/Development purposes (Rapid Clone).

Maintaining the ERP database objects (validate, rebuild indexes, gather stats) and file system using (Adadmin).

Manage Discoverer implemented on oracle 11gAS.

Installation of ORACLE software products and Upgrades.

Monitor of the hole Oracle infrastructure (Dbs, Apps, Fusion Middleware, Agents Plugins) using Oracle Enterprise Cloud Control Manager (ECCM).

Performance Tuning Support Performance Tuning & day-to-day user support related to Oracle using best practice benchmarks and tools (ADDM, AWR, Top SQL/User consumers, EM Advisors). Performing applicative tuning (Data Modeling and SQL).

Periodic DBA tasks like Re-org of database, Rebuild of indexes, analyzing statistics etc.

Troubleshoot the Applications issues and performance problems, addressee immediately raising issues with respect to SLA timelines.

Work efficiently with Oracle support for any service requests.

Database disk storage Management.

Manage database logical structure i.e. tables, views, indexes, stored procedures, functions.

Maintain Database Security.

Import Export SQL*Loader.

Virtualization using Vmware, OVM on implementer request.

Support RAC environment.

Support during normal business hours and outside of business hours whenever required.

Provide DBA services to development work and Application team with deployment activities.

Co-ordination of database administration tasks among team, Development, and test (Data Modeling, UML, E/A models), Manage User Communication for database related issues.

Support planned and ad hoc request for backups and cloning of Database and Applications.

Design Backup and restoration strategy using RMAN (Hot backup), Back up and clearing the directory containing the archive log files to a different location. Automate Backup through Shell scripts and OS Scheduling.

Designing and managing database architectures at large scale, high availability, and high transaction rates, including ORACLE RAC Databases on HP platform Storage Eva 8000 4TB, rp8420 servers. Dataguard, ASM Storage, HPUX 11i v3. Hp DataProtectore for the backups and Rman scripts.

Proffering application development support including the ERP, CRM application management and web sites development/enhancement initiatives, ensuring maintaining the integrity & quality of operating environment.

Providing on-demand day to day support to various stakeholders in database setup, cloning patching, data migration, and bug- fixing.

Conducting analytics and ad hoc queries and reports on databases in response to managements and decision makers.

Configuring and managing the Oracle Ebusiness Suite Technology Stack (Oracle AS 10.2.1 known as Development Tools) and Ebusiness Suite Technology Layer comprising mainly the Application DBA (AD), Oracle Workflow (WF), Oracle Alert (ALR), Oracle BI Publisher (XDO)

Dealing with Oracle Support by configuring OCM (Oracle Configuration Manager) to upload up-to-date data to Oracle Support.

Partnering with management team to update the corporate websites, content management and other social media portals.

Manager and organizer of International Exhibitions Events with regards to new inventions and technology.

Leveraging multi-lingual and communication skills, managed international events: right from the online enrollment to the payments and negotiating the contracts with foreign partners and host. Supervised booth conception, and travel arrangements for the delegation team.

Among the most prestigious International exhibition successfully participated in:

-Kuala Lumpur, Malaysia, February 2011, 2012: The 10th and 11th Malaysia Technology Expo (MTE).

-London, UK October 2012: The 12nd British Invention Show (BIS).

-Geneva, Switzerland, April 2011, 2012, 2013, 2014 (current): The 39th, 40th, 41st, and 42nd International Exhibition on Inventions.

freelance / Oracle 12c Trainer and consultant Apr 2012/Present

Accomplishments:

Oracle 12c Trainer and Consultant, mentoring, teaching and cultivating the technical capabilities of End Users

Provided thought leadership, prudent consultancy, strategic advice for advanced architectures on high availability, Real Application Cluster (RAC), Virtualization.

Successfully implemented Disaster Recovery infrastructure, DataGuard for a RAC 11g2 database for the Agriculture Development Fund bank.

Key Responsibilities:

Providing clients with pragmatic and reliable advice, services and solutions to enable them to maximize their investment in new technologies on Oracle 12c Multitenant database and OEM Cloud Control.

Aiding in installation of EBS 12, Multitenant Database 12c.

Senior Oracle Apps DBA, ERP and System Administrator Mar 2005 - Jan 2010

Toyota Algeria, Algiers, Algeria

Accomplishments:

Served as technical expert for portfolio of Oracle databases, headed the Applications and Database IT team, trained key users in different business line modules: financial, sales and post sales service and spare parts as well as administration and human resources.

Trained and supported the development team (SQL, PL/SQL, Developer Suite, Discoverer) and end users.

Managed all phases of business ERP implementation and decision making related to the support and business and technical orientations.

Defined system architecture, technical design, planning, implementation and responsible for the highest level of performance tuning and recovery procedures for mission critical computer systems.

Installation and management of Real Application Cluster RAC (9i Upgraded to 10G) on Windows System for Custom-developed applications.

Architecting RAC with Oracle E-Business Suite (adding DB node) and Shared APPL_TOP, with two application Tiers load with balanced Web, Forms and Concurrent processing Services (formerly called Servers).

Installing and configuring BI APPS and SOA, Discoverer and XML Publisher.

Key Responsibilities:

Effectively managed the Entreprise Resource Planning (ERP) Oracle eBusiness Suite EBS 11i (11.5.10.2) along with the Unix HP platform and Linux systems (mainly HPUX 11 v2, AIX5.2L and Redhat).

Achieved Multinode installation of the production environment (four Servers HP rp4440 with shared APPL_TOP on SAN EVA 5000 shared disk); Cloning from/to different platforms (Aix, HpUnix, Linux).

Conducted upgrade operation, EBS 11.5.9 to 10, EBS DB 9i to 10G and RAC, Installing EBS 12.

Applied pre- and post-requisite patches. Backup and recovery (RMAN) using HP DataProtector Hardware/Software to perform daily backup of the whole system (OS+ERP).

Installed and configured RDA (Remote Diagnostic Agent) and operated closely Oracle Advanced Customer Support partnership.

Concomitantly served as System Administrator, designed and implemented solutions to keep IT environments resilient. Administered Concurrent processing, User Management, Profile Management, Workflow Configuration & Administration, register customized applications and menus.

Endeavored to optimize system performance using oracle tuning techniques, standards, Best Practices, gathering baselines statistics. Generated MIS reports, KPI reports and any customized customer report.

Performed database and application cloning of Production database on TEST environment to provide users the live data for testing purpose.

Provided 24h/7day on-call support via VPN. Including unplanned backups and restoration, patching, cloning, interaction with Service Request with urgent severity. Responsible of 1, 2 and 3 level of Supports.

Followed-up the implementation project with the functional consultants according to the Oracle AIM methodology.

Facilitated migrations from legacy systems (SAGE, Excel) to Oracle Applications: uploaded master data and opened balances.

Previous Professional Experiences:

Jan 2005 - March 2005: Junior Oracle Applications DBA, Toyota Morroco, Casablanca, Morroco

Nov 2004 - Jan 2005: Oracle Consultant, Entreprise Nationale des Systèmes Informatiques [ENSI], Algeria

Mar 2004 - Nov 2004: Trainer, Oracle University Education Partners, High Tech Center, Algiers, Algeria

March 2001- Feb 2004: Trainer, Oracle University Education Partners, ITCOMP, Algiers, Algeria.

Academics

Master degree in Computer Science, National Institute of Computer Sciences (I.N.I), Algiers, Algeria, 2003

Thesis: Data Mining Techniques and Design using Multi-Agents Approach

Engineer degree in Computer Sciences, specialized in Information Systems, 2001.

trainings & Certifications

Oracle E-Business Suite R12 Applications Database Administrator Certified Professional, Mar 18.

ITIL Foundation Certificate in IT Service Management, Dec 17

Oracle Database 12c Administrator Certified Professional, Jun 16.

Oracle Database 9i Administrator Certified Professional, Jul 13.

Oracle Database 9i Administrator Certified Associate, Apr 03.

Project Management Professional (PMI accredited 35 contact hours of formal project management education).

Personal Dossier

Nationality : Algerian

Date of Birth : Feb 03, 1978

Languages Known : Fluent in Arabic, French and English



Contact this candidate