Abdeslam MIHFAD
Phone : 514-***-****
**** ******* ******, ********, *** 3H9
acp8gx@r.postjobfree.com
Databases Administrator
(analyst programmer)
Professional Profile
8+ years of experience as DBA of ORACLE and MS SQL server,
2+ years of experience as programmer Analyst.
Education
Master of Software Engineer Concordia University, Montreal 2010-2012
Bachelor of applied computer science: Network System EMSI University, Casablanca 1997-2001
Bachelor of Science in Applied Mathematics Science University HASSAN II, Casablanca 1995-1999
Certification
Oracle Database 11g Administrator Certified Professional (OCP), 2014
DBA Oracle 11g training, 2008
MS SQL Server training. 2005
Professional Skills
Installation, configuration and administration of Oracle GoldenGate,
Installation, configuration and administration of Oracle Weblogic,
Installation, configuration and administration of Oracle RAC and DATA Guard,
Administration of databases ORACLE and SQL Server: Analyse, backup, restoration and recovery,
Tools: OEM 12C, RMAN, Toad, SQL*plus, Oracle Reports, Oracle Forms.
Technical Skills
Databases
Languages
Oracle 12c/11g/10g/9i, MS SQL Server, MySQL,
Java J2EE: JSP, Servlet, Web services,
JavaScript, PL/SQL.
Operating Systems
UNIX: AIX 7.1, Solaris
Linux: RHEL, Ubuntu, Oracle Linux
MS Windows :( Active Directory, DNS, DHCP, WINS, RRAS) TCP/IP, Configuration RAID,
VMware, VM VirtualBox,
Language
English, French, Arabic.
References
On request.
Professional Experiences
Consultant / Databases Administrator (19 months) Feb/2013-Sept/2014
Momentum Technologies, Quebec City
Mandates
Client :
Internal Mandate
Mandate :
Environnent 12c
Period :
July 2014 To September 2014 (4 months)
Function :
DBA
Tasks and responsibilities:
Installation, configuration and administration of oracle GoldenGate,
Installation, configuration and administration databases ORACLE 12c,
Installation, configuration and administration of OFM / WebLogic,
Installation, configuration and administration the environment OEM12c,
Cloning oracle databases for the environment of development, teste and training (RMAN),
Creation and teste STANDBY database for assuring the high availability (RMAN),
Restoration and recuperation of a database after a disaster (RMAN),
Installation, configuration and administration of MYSQL databases.
Environment :
Linux, 11G, GoldenGate, OEM 12c, RMAN, TOAD, SQL DEVELOPER, PL/SQL, SQL*LOADER, MYSQL
Client :
AGENCE DU REVENU DU QUÉBEC
Mandate :
Evolution and Maintaining databases
Period :
November 2013 - June 2014 (8 months)
Function :
Databases administrator
Tasks and responsibilities:
Participate in configuring, testing and implementing Oracle GoldenGate,
Review and update the conceptual/physical models,
Review the data access with the system analysts,
Generate script for creating the database objects (DDL),
Broadcast source code into the different environments (unit, Acceptation, training…) using adequate tools,
Participate in the jobs of the databases optimization.
Environment:
UNIX AIX7, GoldenGate, ORACLE 10G, 11G, ORACLE RAC 11G, IBM AIX, SQL SERVER 2008R2, ORACLE DESIGNER, SYSTEM ARCHITECT 2001, OEM 11G, 12C, ORACLE VPD (VIRTUAL PRIVATE DATABASE), ORACLE FGA (FINE GRAIN AUDITING), RMAN, TOAD, SQL, PL/SQL, SQL*LOADER.
Client :
CSST
Mandate :
Migration from 10g to 11g
Period :
February 2013 To October 2013 (9 months)
Function :
Databases Administrator
Tasks and responsibilities:
Creation and configuration Oracle databases,
Configuration the system ASM,
Administration of Oracle databases on RAC environnent,
Control and optimization of oracle databases,
Identify and Apply the oracle patches (OEM / OPatch),
Configuration and control the processes of the databases backup (RMAN),
Support and recovery databases for testing disaster scenarios,
Installation and configuration Oracle Enterprise Manager 11g grid control,
Assisting developers and application DBAs,
Cloning oracle databases for the environment of development, teste and training (RMAN),
Configuring Oracle Data Guard for the high availability.
Environment:
ORACLE 10G, 11G, ORACLE RAC 10G, OEM 11G, ORACLE GRID CONTROL 11G, RMAN, IBM TSM, SIEBEL, UCM, WINDOWS 2003, 2008 R2, ZLINUX.
Database Administrator August/2008- Feb/2010
High-Tech Software Services. Morocco
Tasks and responsibilities:
Administration of ORACLE databases
Supporting developers
Supporting the testing and application validation
Environment:
ORACLE 10G, Linux, Windows 2003, Java, SQL/PL/SQL (oracle Forms, oracle reports).
Database Administrator Feb/2006-July/2008
SECURIMAG, Morocco
Tasks and responsibilities:
Install and parameter of the access control system,
Developing scripts of exporting data from the access control system,
Administration of the databases ORACLE, SQL SERVER and SAGE LIGNE500.
Environment:
Windows 2003, XP, Vista, 7, APPOLO (APACS), Oracle, SQL SERVER, /PL/SQL (Forms, reports)
Database Administrator Oct /2001 - Jan/2006
GSM AL MAGHRIB, Morocco
Tasks and responsibilities:
Install and parameter of the system “Sage ligne 100/ ligne 100 SQL”,
Parameter and deploy of the databases of SAGE,
Administration of databases SAGE : backup, restoration and recovery,
Support the users of the SAGE databases.
Environment:
Windows 2000, 2003, XP, SQL server, Java, C++, Crystal report