Maziar GHAZALI

16 rue du petit Montesson

78110 - Le Vésinet-France

 : +33 (0) 1 83 58 71 40

 : +33 (0) 6 03 06 21 47

:

Oracle Infrastructure Architect Expert

–Freelance, 17years’ experience –

EDUCATION

2016Master’s degree in Computer Science and Information Systems

Ecole d’Ingénieur du Conservatoire National des Arts et Métiers - Paris

2000Analyst-DeveloperDiploma - Rouen

1996Baccalaureate General Science Series - Orléans

PROFESSIONAL TRAINING

2015Oracle Database 12c: Advanced Security Options (TDE, DatabaseVault) - Oracle PS - Noisiel

2015Oracle Database 12c: ManagingIncrementalStatistics - Oracle ACS - Noisiel

2015Oracle Database 12c: Multitenant Administration - Oracle PS - Noisiel

2013Oracle Database 11g: Data Guard Administration Ed 3 - Oracle University - Colombes

2012Oracle Database 11g: RAC Administration Release 2 -Oracle University - Colombes

2012Oracle Grid Infrastructure 11g: Cluster management ASM 2 - Oracle University - Colombes

2012BMC Control-M/Enterprise Manager: Scheduler - BMC - Nanterre

2012Moody's Analytics Enterprise Risk Software (Fermat) - Moody's Analytics - Saint-Cloud

2009Oracle Database 10g - Performance Tuning - Oracle University - Colombes

2009Oracle Database 10g - Workshop 2 - Oracle University - Colombes

2009ApplicationStarWeb (Craft:Pharmaceutical and health) - IFOSUP/Steria - Paris

2008Sybase ASE 15 Administration - Sybase - Issy-les-Moulineaux

2007InfoSphereDataStage Server - IBM - Noisy-le-Grand

2005Oracle Database 9i - Workshop 1 - Oracle University - Paris

2005Oracle Applications 11iAdministration - Oracle University - Paris

2002Architecture & development: Microsoft ASP & VB .NET - Microsoft - Tehran

TECHNICAL KNOWLEDGE

E.R.P.Oracle Applications 11i E-Business Suite

D.B.M.S.Oracle 12c, 11g, 10g, 9i, 8i M.A.A. (Grid Infrastructure: ASM, RAC & Data Guard)

SAP Sybase ASE 15 & 12, Microsoft SQL Server 2008, 2005, 2000, Access, XML

SYSTEMSOracle ZDLRA, Oracle/Sun Solaris 10, 5.x. Linux: RedHat AS3 à AS7, CentOS, Debian. IBM AIX 5.x. HP-UX B.11x, Microsoft: Windows 8.1 au 3.1x, DOS

LANGUAGESOracle PL/SQL, SQL, DML, Shell (ShKsh), Batchs, XML, XPath, XSL, XQuery

Oracle Java EE, C++, C, CGI, ASP.NET, VB.NET, ASP (VBS), VB, JavaScript, DHTML

SOFTWARESOracle SQL+, Oracle DBA Studio, RMAN, Oracle SQL Developer, Eclipse, Quest Toad, Analysis Services (OLAP), ARS (Action Request System), PowerAMC, IBM WebSphere: DataStage & Base/ND, DreamWeaver, Front Page, SAM, Visual Studio 6 et .NET, WebExpert

MIDDLEWAREIBM InfoSphereDataStage Server

DECISIONNALMoody's Analytics Enterprise Risk Software (Fermat)

METHODESUML, SADT, PERT, GANTT

P.E. TOOLSOracle Enterprise Manager (Cloud Grid Control), IBM Tivoli TSM, BMC Control-M, $U

LANGUAGES

TrilingualFrench (fluent)

Persian (mother tongue)

WORK EXPERIENCE

01/15 - 01/17BANQUE DE FRANCE - EUROSYSTEME(French Central Bank) - Noisiel

Oracle Technical Infrastructure Architect(OI/DIT/INFRA/SGBD/ORACLE)

ProductionOracle DBA last level support

Responsible for technology monitoring, then qualification of new Oracle products. [Oracle Database 12.1.0.2 Standalone and MAA (Maximum Availability Architecture) qualification]. Responsible for design and implementation of new Oracle standards adaptedto 12c multitenant.

  • Oracle Grid Infrastructure,RAC 12.1.0.2 [2 nodes]RAC Data Guard(DG) [2 nodes]qualification
  • Oracle Grid Infrastructure,RAC 11.2.0.4 [2 nodes] RAC DG [2 nodes] qualification
  • Oracle (Container DB and Non-CDB architecture) 12.1.0.2 Standalone and with DG qualification
  • Audit and writing technical documents of database migration from 11gR2 to 12c
  • Writing architecture documents, installation and operational documents for several services
  • Implementation of automated procedures and databases monitoring
  • Solving production incidents, last level support, closely with Oracle Advanced Customer Service
  • Design and implementation of new Oracle standards and bests practices adapted to 12c multitenant
  • Auditand implementation of Center for Internet Security benchmarks on Oracle Database 11g & 12c and«Database Security for Oracle and Risk Management of European System of Central Banks / Single Supervisory Mechanism » to correlate new standards with security

Technicalenvironment: Oracle 11g & 12c MAA, RHEL 6.x & 7.x, HP-UX, IBM AIX, Solaris, Windows

11/14 - 01/15SOCIETE GENERALE(RESG/GTS/RET)- (Detail Bankand Insurance) - Tigery

Oracle Architecte

Responsible for auditingthe architecture of Information System orientedOracle database backups. Identification and quantification of alternative solutionsaround RMAN backups concerning critical databases with high volume for the respect of RTO/SLA. Establishment of the action plan.

Technical environment: Oracle 9i, 10g, 11g, Data Guard, Study of Zero Data Loss Recovery Appliance

08/13 - 07/14E-MERCHANT (PIXMANIA | DIXONS RETAIL / MUTARES)- Asnières sur Seine

ProductionOracle DBA Architect

Responsible for the maintenance of production Oracle databases and resolution of trouble tickets during the migration phase of the entire IT infrastructure to new platforms 3 RAC nodes in ASM 11g R2 Clusterware and Data Guard 11g R2 within a team of 9 Expert DBA.

  • Solving Clusterware ASM RAC, Data Guard, RMAN and database incidents
  • SQL Tuning and database using ADDM, AWR, Toad and Grid Control 11g
  • Creation / manipulation services managed by the database and Clusterware
  • Creating, cloning, migration, deleting databases large volume (2-5 TB)
  • Handling Schedule jobs refreshing materialized views in the refresh groups
  • Implementation of automated procedures via Shell and PL / SQL scripts for Nagios
  • Standardization of naming instance, services, tablespaces, schemas
  • Management planning / Minutes of meetings DBA

Technicalenvironment: Oracle 10g, 11gR2 RAC, ASM, DataGuard, GoldenGate, Linux RH, Windows

09/12 - 05/13VEOLIA WATER- (Collective services)- Nanterre

ProductionOracle DBA Architect, SQL Server & Sybase DBA

Responsible for the architecture of the new database cluster platforms Veritas Linux RedHat AS 5 and the migration of RAC and non-RAC databases from HP-UX. Implementation of operating procedures.

  • RDBMS Oracle 11g R2 and 10g RAC and no RAC databases installand configuration
  • Implementationof RMAN with catalogueand backup withscripts done for BMC Control-M
  • Backup / Restore / Replication / Migration via exp / imp, expdp / impdp and RMAN
  • Tuning / Optimization via Automatic Workload Repository (AWR) and Grid control 11g
  • Fixed critical error occurred during production
  • Expertise / advice on the architecture of the information system and the new infrastructure

Technicalenvironment: Oracle 8i, 10g and11gR2 RAC, SQL 2K to2K8R2, HP-UX, Linux RH, Windows

02/12 - 07/12BPCE- (Investment Bank) - Paris 13 and Paris 15

DBA Production Manager

Production Oracle DBAArchitect and SQL Server DBA

DBA Manager and Responsible for the commissioning of the project (Budget live BanquePopulaire, Caissed'Epargne, Natixis, Credit Foncier and all other subsidiaries of the BPCE)

Oracle DBA:

  • RDBMS Oracle 11g R2 databases install and configuration
  • Creation / Manipulation / Reorganization database objects
  • Backup / Restore / Duplication via exp / imp, RMAN and Data Pump
  • Tuning / Optimization via StatsPackand Grid control 11g, reorganization / index creations
  • Correction / Optimization and implementation of running SQL scripts and PL / SQL, Shell
  • Oracle RAC database administration

Technicalenvironment: Oracle 9i RAC to 11gR2, Linux RedHat, Windows

SQL Server DBA:Level 1 and 2

  • RDBMS SQL Server 2008 R2 with multiples instances install
  • Development or test database refresh from production databases

Technicalenvironment: Microsoft SQL 2K to 2K8R2, Windows

07/10 - 02/12SEAFRANCEmaritime subsidiary of SNCF(Transport)- Paris 19

Production Oracle DBA Architect & APPS DBA EBS & SQL Server DBA

Technicalenvironment: Oracle 9i, 10g, EBS 11i, Linux RedHat AS4 and AS5, Windows 2000 server

Responsible for studying and improving the information system architecture based in Paris / France, Calais and Dover / England and administration of Production Oracle databases and MS SQL Server

Architecture:Redesign of the information system architecture oriented databases

  • Install / Migrate kernel and Oracle databases on system clusters and industrialization
  • Oracle Standby database Install and automatic transferring archive log implementation
  • Migration/cloning databases with multiplexing redologs and control files
  • Setting up automatic hot backup database with expdp and exp
  • Establishment of full and incremental backup RMAN
  • Installation of automatic warning systems for monitoring database
  • Implementation of Oracle Enterprise Manager 11g Grid Control

Oracle DBA: Production Oracle database administration level 1 to 3

  • Creation / Reorganization of objects in the database
  • Backup / Restore / Duplication via exp / imp, Data Pump and RMAN
  • Tuning / Optimization with StatsPack and Grid control 11g, reorganization / creation of indexes
  • SQL, PL/SQL and shell scripts optimization and implementation

Technicalenvironment: Oracle 9i and 10g, Linux RedHat AS4 and AS5

APPS DBA: Oracle Applications 11i.10 E-Business Suite administration

  • Install with Stage Area and clone of Oracle Applications 11i with adclone
  • Resolution of errors and incidents, install patches and family pack, merge
  • Creation and monitoring of Oracle Metalink TARS

Technicalenvironment: Oracle 9i and 10g, Oracle EBS 11i.10, Linux RedHat AS4 and AS5

SQL Server DBA: Production SQL Server database administration level 1 and 2

  • SQL Server 2K8 install + associate databases instances
  • Backup jobs implementation and purge transaction log
  • Developmentor test database refresh from production databases

Technicalenvironment: Microsoft SQL Server 2008, Windows 2000 Server

03/10 - 07/10ALMA CONSULTING GROUP(Business Services) - Gennevilliers

Production Architect Oracle, Sybase & SQL Server DBA

Responsible for studying and managing production and audit databases, migration of databases to shared and dedicated servers, advising and supporting operations management.

  • Creation of a process and implementation strategy
  • Design of new data model for all database servers (Multiplexage)
  • Automatic backups (expdp / impdp, RMAN with catalog)
  • Duplication of databases (expdp/impdp, RMAN), set up of development databases and pre-prod.
  • Oracle kernel Install + update patches - Installation of OEM Grid Control
  • Complete setup of databases including creation of schemas and users role and grant management
  • Management of tablespaces, redolog, controlfile tables and index
  • Hot and cold Backup / Restore (expdpimpdp, RMAN)
  • Automate maintenance of tnsnames.ora and listener.ora
  • Automatic monitoring of databases (Grid Control)
  • Production from pre-production, issues correction
  • Tuning of databases using StatsPack and Grid Control

Technicalenvironment: Oracle 10g, 9i, Sybase ASE 12.0.0.8, SQL Server 2K5 and 2K8, Windows 2K3

02/10ALLOCINE.com(Web Information Service film)- Paris 8

Production Oracle DBA

EPilotAlloCine project: Responsible for installing the database CSE application that allows AlloCine to manage the marketing of its spaces.5 days mission for the preparation and implementation of the required fields on the Oracle, Linux RedHat AS5, Installation of kernel Oracle 10g Release 2 + update patches, creation/configuration of production database and the test database then data import

Technicalenvironment: Oracle 10g, Linux RedHat AS5

09/09 - 01/10ADP (AUTOMATIC DATA PROCESSING) GSI France(HR Services)- Le Pecq

Production Oracle DBA (ITIL)

Responsible for clients (example: payrollCarrefour’semployees) databaseadministrating. Installation tasks, migration, backup / recovery and ongoing administration lev. 2.

Technicalenvironment: Oracle 11g, 10g, 9i, 8i, Linux Debian & Oracle Sun Solaris 10

06/09 - 07/09ASSISTANCE PUBLIQUE - HÔPITAUX DE PARIS(Health)- Paris 14

Engineer and development Oracle PL/SQL

Responsible for "data recovery": Test and validation of the start of production logistics and financial data from 9 hospitals in Paris.

Technicalenvironment: Oracle 10g andOracle SQL Loader, HP-UX B.11.23

06/08 - 12/08LA POSTE(Distribution) - Saint Quentin en Yvelines

Oracle & Sybase DBA, UNIX Administration

Responsible for Consolidation / Virtualization VPAR Servers

  • Installation of Oracle and Sybase kernel + update patches
  • Volumetric Study, Disk resource management, SAN disk allocation for VPAR
  • Creation of VG, LV, FS, creation of accounts, Rights management,system settings
  • Automation of tasks by the development of Shell and Korn Shell script
  • Creation of Oracle / Sybase databases
  • Unloading/loading applicative data : Oracle Export/import, dump/load Sybase
  • Technical validation and update the status
  • Purge environments (database)post migration
  • Implementation flow CFT (Cross File Transfer)
  • Implementation of Oracle backups

Technicalenvironment: Oracle 9.2.0.5 and Oracle 10g, Sybase ASE 12.0.0.4, 12.0.0.8, HP-UX 11.i

04/07 - 06/08TOTAL(Energy)-Paris La Défense

DBA Production Manager - Technical Responsible of DBAs in Paris

Production Oracle and SQL Server DBA (ITIL)

DBA Manager:

  • Training and support for new DBAs to the TOTAL environment
  • Management of shift work schedule and leave
  • Management and delegation production incidents oriented database
  • Monitor resolution of incidents dealt with the team and then closing
  • Establish procedures for production and validation of operational records databases
  • Minutes of meeting with the production manager and team meetings DBA

Oracle DBA:

  • Installation of Oracle kernel + update patches - Installation of OEM
  • Creation/Manipulation/Reorganization of objects (tables, tablespaces, index et redolog)
  • Creation of users, management rights and roles, assign roles to users
  • Hot and cold backup/restoration/duplication/cloningdatabases (exp & imp) and RMAN
  • Maintenance of tnsnames.ora and listener.ora files
  • Installation of automatic warning systems for monitoring database
  • Correction/Optimization and execution SQL and Shell scripts, executing plan
  • Tuning/Optimization with statspack and Oracle Grid control
  • Installation/Administration of Oracle TDE (Transparent Data Encryption) module
  • Oracle Data Guard manipulation

SQL Server DBA:

  • RDBMS SQL Server 2000 and K5 install + associate databases instances + updates
  • Backup / Restore of databases, tables and users
  • Creating job, stored procedures, implementation and execution of DTS packages
  • Copies of databases, tables, indexes, stored procedures, DTS, views between users and servers
  • Production from pre-production or qualification, issues correction

Technicalenvironment: Oracle 10g, 9i, 8i, MSSQL Server 2K&2K5, any Operating Systems

01/07 - 04/07CAISSE NATIONALE D'ASSURANCE VIEILLESSE(Insurance) - Paris 19

Production Oracle DBA, IBM InfoSphereDataStage Administrator

Responsible for white migration of the National system management services, of all the national funds

  • Administration of DataStage jobs via National Director, Administrator and Manager
  • Set up and planning of jobs update tool retirement
  • Cloning, database migration from Oracle 8i to Oracle 10g
  • Use: IBM Tivoli Storage Manager, Dollar Universe, Business Object

Technicalenvironment: Oracle 10g, Oracle 8i, IBM AIX 5.3,InfoSphereDataStage

06/06 - 01/07CALYON (CREDIT AGRICOLE) (Bank) - Saint Quentin en Yvelines then La Défense

Production Oracle and SQL Server DBA (ITIL)

Oracle DBA:

  • Installation of Oracle kernel + update patches
  • Creation/Configuration/Enlargement of databases, schemas creation
  • Creation/Manipulation/Reorganization of objects (tables, tablespaces, index et redolog)
  • Creation of users, management rights and roles, assign roles to users
  • Generating and updating statistics
  • Hot and cold backup/restoration/duplication/cloning databases (exp & imp) and RMAN
  • Implementation automatic backups, correction and run SQL and shell script
  • Maintenance of tnsnames.ora and listener.ora files
  • Cloning databases and activation archive log mode
  • Implementation ofautomatic alert systemsfor filling filesystems
  • Development of a monitoring program (ASP, Oracle) of all databases
  • Production from the servers of pre-production or qualification

Technicalenvironment: Oracle 9i, Sun Solaris 5.8, IBM AIX 5.3 (UNIX), HP-UX (B.11.03 ia64)

SQL Server DBA:

  • Serversand clusters installation, Analysis Services, Reporting Services + service pack
  • Cluster SQL configuration (Manipulating cluster administrator)
  • Creating / Configuration / Expansion of databases
  • Backup / Restore / Creating of databases, tables, usersand roles
  • Creating job, stored procedures, implementation and execution of DTS packages
  • Copies of databases, tables, indexes, stored procedures, DTS, views between users and servers
  • Production from pre-production or qualification, issues correction

Technicalenvironment: SQL Server 2000 & 2005 (Windows NT SP6, 2000, XP and 2003 Server)

11/05 - 03/06SAVELYS(Energy)subsidiary of GDF Suezgroup-Paris 18

Oracle & Oracle Applications DBA

  • Study the content of the monitoring report
  • Using OAM, then SQL and shell scripts to collect information from the report
  • Development of an automatic application of monitoring information collection
  • Oracle Applications 11i.9 mono node installation and Oracle 10g 10g on Windows XP Professional
  • Oracle Applications 11i.9 mono node cloning

Technicalenvironment:Oracle 9i, Oracle Applications 11i.9 RAC, Linux RH AS 3, Windows XP Pro

09/05(1 week)FRANCE TELECOM TERMINAUX(Telecommunication)-Gentilly

Oracle & Oracle Applications DBA

Responsible for patching on top SUPPLY CHAIN ​​TEST environments RECIPE, use the package "Diagnostics" OAM for solving technical problems on a technicalenvironment: Oracle Application 11i.9, Sun Solaris 5.9

05/05 - 11/05GAN EUROCOURTAGE(Insurance)subsidiary of GROUPAMA-La Défense

DBA Oracle & Oracle Applications

  • Installation of ADI Mini-pack 11i.BNE.D on Oracle Applications 11.5.10 on Aix 5.2
  • Installation of ADI 7.2 on client Windows NT4 and XP Professional
  • Applying patches and update Oracle and Oracle Applications
  • Automation of the Shell (internal bookkeeping modules GAN) scripts
  • Support the implementation of the injector SAP Oracle Applications 11.0.3
  • Installation and compilation procedures and packages in databases
  • Support development teams and integration
  • Creation and monitoring of TAR the resolution of technical problems Oracle and Oracle Applications

Technicalenvironment: Oracle Application 11i.10, IBM AIX 5.2, Windows NT4 & XP

10/03 - 10/04IMEXKA(Telecommunication) subsidiary of TELEMEDIAGroup- Paris 16

Engineer and development freelance

Design and development of a client application management for Telemedia. (Management: numbers, billing and accounting) and project collection premium numbers.

  • Analysis of existing: Handbook of functional and technical requirements
  • Design data models in SQL Server and SQL access
  • Development, unit testing and put into operation, authorization management and user support

Technicalenvironment: Windows XP, Windows 2003 Server, ASP, ASP.NET, JavaScript, SQL Server

10/01 - 08/03RASSADIRAN SURVEYING CO (GeographicInstitute GIS) - Tehran

Analyst director

Design and implementation of Internet and Intranet sites: Management Application Mapping (Urbanization, roads, trees, etc.).

  • Feasibility Study,
  • Creation of models
  • Analysis, design, development
  • Corrective and evolutionary Maintenances

Technicalenvironment: ASP, ASP.NET, JavaScript, SQL Server 2000, IIS, WindowsXP and 2K Server

06/00 - 09/01BRAINSTORMING INTERACTIVE (Web Agency) - Lyon

Multimedia developer

Design and development of Internet, Intranet and WAP sites: Intranet La Poste (i-mail), macbenmusic.com, interflora.fr...

  • Analysis of existing: Handbook of functional and technical requirements
  • Analysis, design and research of technical and functional solutions
  • Design and implementation of changes and bug fixes
  • Technical interface with banks, partner sites and hosting

Technicalenvironment: Windows 2000, ASP, JavaScript, SQL Server, WLM, HTML

02/00 - 05/00IDEONET (Web Agency) subsidiary of PUBLIC SYSTEMGroup - Paris 7 (stage)

Web Programmer Analyst, Wap & Palm

  • Festival of Cannes 2000 wapsite(WAPA Cannes)
  • Telego.com website, models and various applications (example : ASP and JS calendar)

Technicalenvironment: Windows NT4, ASP, JavaScript, SQL Server 2000, WLM, HTML

Short missions (under 3 days)to solve Oracle database problems in:

Mercedes-Benz(Automotive industryMontigny-le-Bretonneux) andLucheux (Insurance broker in Paris)

Maziar GHAZALIORACLEDBA, APPS DBA, SYB DBA, MS SQL DBA1/7