Yazid - DBA ORACLE

Studies
Computer Magister Diploma : Information systems
Institut National d'Informatique.Oued Smar. Algiers. Algeria
Development of a combinatorial approach data warehousing – Geographic Information Systems " GéoDatawarehouse" Will be finished in 2009

Computer engineer Diploma : Information systems
Institut National d'Informatique.Oued Smar. Algiers
Evaluation : Very Good 1995-2000

Summary of some realized projects
• Ministry of Justice (Algeria): Project manager and DBA for the project SGPC (integrated system with 6 modules, deployed in 128 sites
• GFI (France): Implementation of Oracle10g Real Application Cluster with ASM technology
• Ministry of Justice (Algeria): Oracle DBA support: Backup, recovery, troubleshooting, upgrade, patching, software install, Replication, ….
• Mobilink (Telecom operator): Implementation of Backup Strategy using Oracle Secure backup and supporting the solution.
• Sonelgaz (Electricity and Gaz Company ): Implementing E-learning Solution
• Design and development of an integrated system (Stock, production , …) for Aigle group (Industrial group Algeria)
• Very large training Projects:
o Orascom Telecom (Telecom Operator)
o Bank Of Algeria
o Ministry Of defense
o Sonatrach (Petroleum Company)
o Sonelgaz (Electricity and Gaz Company )
o El BarakaBank
o Natexis Bank
o Naftal (Petroleum Company)
o Ministry of Justice
o Mobilis Telecom (Telecom Operator)
o Coca cola
o Pepsi Cola
o Celtel (Telecom Operator , Kinshassa, Democratic Congo)
o SNPC ((Petroleum Company , Pointe Noire, Congo, Brazaville)
o ……..
• ……

Technical trainings
• Oracle Database 10g: Real Application Cluster for administrators : Oracle university Paris
• Oracle Database 10g: Grid Control: Oracle university Paris
• Oracle Database 11g: New features for Administrators : Oracle university Paris
• Training of trainers: Collège Saint Félicien Quebec, Canada
• Oracle Database Performance Tuning Palco. Amman. Jordan
• Oracle DBA Training (4 sessions) Algiers. Algeria
• Technical- Sales Training over Oracle 9i Oracle corporation. Oracle North Africa Marrakech. Morocco.
• Microsoft Windows 2000 Training (4 sessions) Algiers . Algeria
• Microsoft SQL Server Training (3 sessions) Algiers. Algeria

Certifications
• Oracle Database 10g Administrator Certified professional
• Oracle Database 10g Administrator Certified Associate
• Oracle Certified Instructor
• Oracle Database 9i Certified Associate DBA
• Microsoft Certified Trainer (2004,.., 2008)
• Microsoft Certified Database Administrator MCDBA
• Microsoft Certified Professional MCP

Courses delivered
• SQL , PL/SQL and iSQL Plus tool
• SQL For end users
• Advanced PL/SQL
• Oracle9i Database: DBA I
• Oracle9i Database: DBA II
• Oracle9i Database: Implement partitioning
• Oracle9i Database: Performance Tuning
• Oracle9i Database: Backup and recovery with Rman
• Oracle9i Database: Dba for developers.
• Oracle Database 10g: SQL and PL/SQL Fundamentals
• Oracle Database 10g: Administration Workshop I
• Oracle Database 10g: Administration Workshop II
• Oracle Database 10g: performance Tuning
• Oracle Database 10g: Real Application Cluster for administrators
• Oracle Database 10g: Grid control
• Oracle Database 11g: new features for administrators
• Oracle Application 10g: Discoverer For end users
• Oracle Application 10g: Discoverer For administrators
• Implement Microsoft SQL server 7.0 Database.
• Administer Microsoft SQL server 7.0 Database.
• Develop a Microsoft SQL server 2000 Database
• Microsoft SQL server 2000 Database administration
• Microsoft SQL server 2000 Database: Transact SQL
• Microsoft SQL server 2005 Database; maintenance and administration

Knowledges
Operating systems Linux Red Hat , Enterprise linux, Windows 2003/2000 server/NT, Windows Vista/XP/2000 pro/ 98
Databases Oracle 11g/10g/9i/8i, SQL Server 2005/2000/7.0
Languages Delphi, Visual Basic, Pascal, C, PL/SQL, Transact-SQL, SQL
Tools and soft wares TOAD, Power Amc, Microsoft Office, Microsoft Project, Mind Manager
Conception Methods Merise, UML, Outputs flows

Languages
English Studies and work language: Good level
French Studies and work language: Very good level
Arabic Maternal and studies language: Very good level

Skills
Oracle Database 10g, 9i Administrator (OCP10g, OCA 9i, OCI)
• Oracle Database 10g RAC (Real Application Cluster)
• Oracle Database 10g grid control
• Oracle Database 10g ASM Automatic Storage Management
• Oracle Database 10g DataGuard
• Oracle Database installation and upgrades versions 11g, 10g, 9i, 8i
• Oracle Database Security Management
• Backup and Recovery strategies with RMAN.
• Oracle Secure backup (10g)
• Oracle database 10g, 9i performance tuning., AWR , ASH, ADDM, Statspack
• Oracle database 11g new features.
• Oracle 10g DataPump
• Import/Export. Cloning. Replication
• Oracle Discoverer 10g (admin and develop)
• Oracle Enterprise Manager
• SQL and Database Partitinoning, tables clustering, IOT
• Shared Server
• Database, User and Object Security. Auditing, data encryptions
• SQL, PL/SQL.. SQL*Loader.
• Oracle Net.
• Oracle enterprise Linux
• Unix and Dos Scripting

Microsoft SQL Serevr Database Administrator (MCDBA, MCT)
• Software installation and upgrades (versions 7.0, 2000, 2005)
• Backup and Recovery.
• Database development
• Security management
• Database objects management
• Enterprise Manager
• Replication
• SQL, Transact SQL.
• Database performance tuning

Oracle and Micrososft Trainer (MCT, OCI)
• Oracle Database 9i, 10g and 11g Database track
• Oracle language track
• Oracle Database advanced Track
• SQL Server DBA track
• SQL Server developer track
• Windows Administration track