Post Job Free

Resume

Sign in

Oracle & Sql Server

Location:
Ottawa, ON, Canada
Salary:
75K
Posted:
June 15, 2015

Contact this candidate

Resume:

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



Contact this candidate