Lamri - DBA ORACLE 11G

Ref : 130416S002

06600 KHERRATA (Algérie)
DBA (42 ans)
Freelance

Compétences

C++

SQL SERVER

CRYSTAL REPORT

PL SQL

C SHARP

ITIL

DOTNET

BORLAND C++

ORACLE 11G

AWK

Expériences professionnelles

DBA (Database Administrator) / Project Manager
July 2007 – present
CEVITAL
Agro-alimentaire (Algeria)
Main tasks
We have oracle 10g/11g/SQL Server 2008 & 2005 & 2000 databases running on production. All of these databases should be running 7/24.
The databases are running under windows 2003/2008 server OS.
Our Administrations routines are:
• Installing and configuring the Oracle & SQL Server software.
• Creating and maintain all databases required for Production, Training and Test.
• Managing database objects.
• Creating backup and recovery strategy.
• Tuning oracle and SQL servers, Queries optimization.
• Troubleshooting with problems regarding the databases.
• Design & Develop reports using Crystal report and ReportOne tools.
• Design & implementation of Enterprise Datawarhouse.
• Planning data refresh using ReportOne ETL.
• Managing ReportOne Datawarhouse.
• ELT (ODI) & BI (OBIEE) developer
• Backup System Administration Symantec (Backup Exec 2010 for windows servers).
• Project Management & application support (Sage, Kelio, ..).

Application Specialist
September 2005 – June 2007
LACOM - Algerian telecommunication Consortium (Orascom Telecom and Egypt Telecom )
Telecom operator (Algeria)
Main tasks
• Design and develop new applications using visual studio .net (C#, ASP .net): LACOM complaints management (CRM), Customer automatic search for Call Center operators, SMS Sender, webCRM, Invoices Loader.
• Give training and support for end users.
• Develop reports, using SQL 2000 Reporting Services, for marketing, finance, commercial and technical departments (Billing, CRM, Oracle Application, Order management).
• Manage development environment including development database.
• Manage reporting server.
• Application Support level 2.

IT Consultant (Freelance)
January 2005 – August 2005
ITComp
IT Services Company and Oracle partner (Algeria)
Main tasks
• Design and develop new applications using C++.
• Give training and support for end users.

Études et formations

EDUCATIONS & DIPLOMAS
June 2008 Oracle Certified Associate 10g (OCA 10g) Exam : 1Z0-042

Nov. 2010 Doctorate (Post Graduation) in Computer science from University of BEJAIA, Algeria (in progress).

2004 – 2007 Magister (Post Graduation) in Computer science from INI Algiers, Algeria.

1999 – 2004 Computer science Engineer from INI Algiers, Algeria.

1996 – 1999 Bac Maths from kherrata school, Bejaia, Algeria.

TRAINING
2011 : LAVAL University (Canada) & ESG, Algiers
- Project Management (based on PMBok standard of PMI).

2010 : COSYSTRA France, Béjaia
- ITIL v2 Foundation.

2010 : OPTEAM France (Frédéric Fenoll), Béjaia
- IT project management.
- Cahier de charge informatique.

2009 : ITComp, Algiers
- Oracle 10g database administration: Workshop II
- Oracle 10g database administration: Tuning

2008 : HighTech center, Hydra Algiers
- Maintaining a Microsoft SQL Server 2005 database, Course 4742
- Designing a Microsoft SQL Server 2005 database, Course 4740

December 2007 : Oasys, Hydra Algiers
- Focus on Symantec Backup Exec 11d (BE 11d) and Backup Exec System Recovery (BESR).

September 2007 : CEVICO Group
- Crystal Report

September 2006 : HighTech center, Hydra Algiers
- Programming with C# in Microsoft.Net, course 2609
- Web Application Development with Microsoft Visual Studio.Net, course 2333

LANGUAGES
• Arabic: mother tongue.
• French: fluent.
• English: good

TECHNICAL KNOWLEDGE
Operating Systems
Linux Mandrack & Mandriva & Ubuntu, Windows 2003 Server, Windows 2003 Server, Windows 2000 Server, Windows XP.

Databases Administration
Oracle Server 9i, Oracle 10g, Oracle 11g, SQL Server 2008, SQL Server 2005, SQL Server 2000.

ETL & BI Tools
SQL Server Reporting Services, SQL Server Integration Services, Crystal Report, ReportOne, ODI, OBIEE

Languages
SQL, PL SQL, T-SQL, shell, C/C++, C#, ASP .net, JAVA, DELPHI, HTML, Lisp, Lex/Yacc, Tcl/Otcl, AWK, NS2

Development Environment
Visual Studio .net 2003/2005, Jbuilder X, C++ Builder 5.