Profil de M MO
M MO
600.00€ /j
DBA Oracle SQL
Consultant de l’ESN FreelanceDay
Disponible le :
09/01/2020
Localisation : France
Mobilité : Mobilité internationale
Localisation : France
Mobilité : Mobilité internationale
25 années d'expérience
0 missions réalisées
LinuxOracle
0 missions réalisées
M MO en quelques mots
Mehrad
Production & Development DBA
TECHNICAL SKILLS
Systems : Sun Solaris 10, 5.x. Linux: RedHat, Unbreakable, Debian. IBM AIX Power 7.x. HP-UX B.11x Microsoft: Windows Sever, Vista, XP, 2003 R2, 2000, NT4, Me, 98, 95, 3.1x, DOS
DBMS : Oracle Clusterware ASM RAC & Data Guard: 12cR1, 11g R2, 10g, 9i, 8i, 7
Microsoft SQL Server 2014, 2012, 2008, 2005, MySQL, Access
Application server : ORACLE 10gAS, Apache Tomcat
P.G.I : Oracle Applications 11i E-Business Suite
MIDDLEWARE: Oracle GoldenGate 11g
Corebanking: Flexcube , Siron Embatro-AML
Front Office applications : Intellect
Languages and Softwares: C, Pro*C, Pro*FORTRAN, Oracle SQL/PLSQL, PHP, JAVA, HTML, Shell (Sh & Ksh), Batchs, XML, Oracle Forms/Reports designer, Eclipse, Oracle RMAN, Oracle SQL Developer, Quest Toad, Analysis Services (OLAP), Oracle Datamodeler, PowerAMC
Business Intelligence : Oracle Data Integrator, Oracle Analytic Workspace Manager, Oracle BI EE, Excel, QlikView, Business Object, Cognos, Informatica
Networks : LAN et WAN, Protocoles TCP/IP, VOIP
Office support system: Word, Excel, PowerPoint
Virtualization software : Sun Virtual Box, Hyper V, VM ware
Methods : Merise, UML, ITIL
WORK EXPERIENCE
March 2016 to November 2019 – DAIMLER France : Architect DBA Oracle/SQL Server in Production and Studies environments
Maintenance charge and migration of Oracle and sqlserver databases
– Establish standards for Oracle database
– Establish standards for SQL server database
– instance naming standardization, services, tablespaces, schemas
– Establishment of the database and system security policy
– Creations and Implementation of scripts for 12c oracle databases
– Implement monitoring and audit tools for databases and their integration in One Automation
– Migration of Oracle Database 10g and 11g to 12c
– Database Migration SQL Server 2008 to 2014 and 2016
– Implementation of the backup policy and restore Oracle databases via Networker
– Oracle and SQL Server Referring to the outsourcing team in charge of maintaining N1, N2 and N3 of these bases and supervising changes and requests to be conform to the norms
– Implementation of Patching and Upgrade Policy and road maps
– Mercedes Benz France and Mercedes Benz Financial Service all servers, databases and flux mapping
– Reorganization of the architecture in accordance to the activities
– Implementation of the new architecture of databases on IBM Power Blade
– Implementation of Oracle High Availability Architecture with Oracle Dataguard
– Perform the migration of databases by using Oracle Dataguard
– Implementation of Home Made decisional tool collecting the system and databases related information on all servers and transform and load them into a datamart
– Implementation of Transactional Replication with Sql Server 2014
– Implementation of High Availability with Sql Server 2014 Always on Availability Groups
– Implementation of Encrypted Communication Channel with SSL/TLS database connection
– Implementation of Oracle Transparent Data Encryption and Oracle Data Redaction
– Implementation of the decision of a strategic application architecture (Creating ODS bases and DWH, Migrating and the sources and bases 12c Oracle SQL SERVER 2014, ODS Power and Transform / Load DWH with Informatica and return with Cognos / Message exchange with MQ Series )
Technical environment : Oracle 12cR1, Oracle 11gR2, Oracle 10g, Sql server 2014, sql server 2008, IBM AIX Power 7, RH Linux, Windows 2018 and 2012 Server, Networker, Informatica, Cognos, IBM MQ Series, One automation, Cognos, Microsoft Power BI
December 2015 to March 2016 – SG (Investment Bank) – Lille – France: DBA Oracle in Production environment
Maintenance of Oracle 11g databases in production environment and resolution of trouble tickets, and migration of Oracle databases 11G R2 to 12cR1 multitenant
– Maintenance of oracle database 11g and 12c
– Resolution of incidents of oracle 11g and 12c databases
– Resolution of incidents of GoldenGate 11g
– Tuning SQL codes and databases (ADDM, AWR)
– Migration of Oracle 11gR2 database to 12cR1
– Cloning of large volume databases (2TB)
– instance naming standardization, services, tablespaces, schemas
Technical environment: Oracle 12cR1, Oracle 11gR2, IBM AIX Power 7, RH Linux, Windows
January 2013 to date – Banking Industry: Production & Development DBA
– Database administration in Oracle & Sqlserver
– Installation & creation of databases in Oracle & Sqlserver
– Installation of client components
– Tablespace resizing, physical & logical storage, access concurrency
– Cloning & réplication of databases
– Oracle Dataguard Installation and administration ( Oracle 10 et 11g on HP-UX et Linux serveurs) in test and in production
– Tuning and performance management (AWR, ADDM) (AWR, ASH, ADDM …)
– Backup, restauration and clonage of oracle bases de données (RMAN, DATAPUMP, cold and hot backup)
– Backup, restauration and clonage of sqlserver databases
– Automatisation of databases maintenance procédures (backup et transfert, alertes …)
– Oracle database upgrading and patching
– Implementation of BI architecture with the establishment of an ODS and a DWH (star and snowflake patterns) designed to accommodate data from core-banking applications (Flexcube, Intellect, …) using DB-link, materialized views, PLSQL…
– Business Object Administration (CMC – Instances, calenderers, groups, users …)
– Business object Univers and Reports development
– Installation, configuration and maintenance of ODI 11g (Topologie, Sécurité …)
– Flexcube Administration
– Flexcube environment cloning
– Flexcube Setting (Modules Core, FX, FT, GL, BC, CIF, Customer Account, EOC, LC, LD, MM, Reconciliation, Queries, Security Maintenance et Settlement Maintenance)
– Oracle application server administration
– Swift Alliance administration
– Intellect Administration
– Administration of serveurs and applications Siron Embargo et Siron AML
– Migration of Siron Embargo/AML/PEP vers la version V13
– Datastage Développement (Oracle Schema) and interfaces (PL/SQL, shell Unix) destinated to alimente Siron AML
– Virtualization of Database servers on Linux (Virtual Box)
Technical environment : Oracle 11g, Oracle 10g, Unix (AIX, HP-UX), LINUX (Oracle Unbreakable), Windows Server 2003 & 2008, Oracle AS 10g, Business Object XI.3.1, Sqlserver 2005, Sqlserver 2008, Flexcube 7, Swift Alliance 7, Intellect, VirtualBox
March 2012 to January 2013 – Logica France : Oracle/Mysql DBA in Production environment
– Oracle database Audit
– Database administration in Oracle & Mysql (780 bases)
– Oracle & mysql administration
– Installation & création of database in Oracle & Mysql
– Installation of client components
– Tablespace resizing, physical & logical storage, access concurrency
– Cloning & réplication of database
– Tuning and performance management (AWR, ADDM)
– Backup & restore (RMAN, DATAPUMP, cold and hot backup)
– Oracle database upgrading and patching
– Oracle EBS (administration, Cloning and patching)
Technical environment: Oracle 11g, Oracle 10g, Oracle 9i, Unix (AIX, SUN), LINUX, OeBS11i, Dataguard, Cluster AIX & Linux
From July 2011 to March 2012 : Production & Development DBA in Oracle
• Support service delivery for CanalCE :
– Administration and maintenance of Oracle database in production and development
– Optimizing Performance of Oracle database in production and development
– Establishment of a security strategy for Oracle database
– Establishment and use of statistical tools to monitor the performance of Oracle database
– Installation and configuration of new database in development and production
– Safeguard (RMAN, DATAPUMP)
– Tuning and performance management (AWR, ADDM)
– Optimizing SQL queries developed by developers to improve the performance of database
Technical environment: Oracle 11g R2, Oracle 9i, Toad, Windows Server 2003 and 2008
from July 2010 to July 2011 : Oracle Consultant – Development DBA
• Support Service delivery for APEC :
– Maintenance and administration of Oracle 10g Database in Development and receipts
– Creation of Oracle 10g Database in Development
– Maintenance of PL / SQL, Forms and Report 6i applications
– Development and maintenance of synchronization application of flows with the ESB (Mule)
– Administration and maintenance of the CVS server for batch delivery
– Maintenance of Java applications
– Technical support
Technical environnement: Oracle 10g, Oracle 9i, Oracle Designer, Oracle Forms 6i, Oracle Report 6i, PLSQL, Shell, Toad , JAVA, MAVEN, SVN, CVS, HIBERNATE, Eclipse, Java, CVS, Mule, UNIX, Windows
From January 2010 to June 2010: BI consultant / DBA Oracle
• Support Service delivery for Direct Energie:
– Domain analysis.
– Datawarehouse modeling and creation of fact and dimension tables.
– Creation of the data model of the Storage Area Sources (ODS) from databases, or sequential files.
– Flow control and interfaces.
– Unit tests, receipt tests and integration tests.
– Return data and reporting with QlikView.
• Setting up a test environment with installation and configuration of the entire chain of BI in the context of a Package:
– Installation and configuration of Oracle 11g Database and Teradata
– Import Oracle data with import tool
– Import of Teradata structure to create Teradata tables
– Installation and configuration of ODI
– Test the performance of Flux from Oracle to Teradata
– Change KMs
– Creation of reporting in case of OK et KO
– Send file by email and backup files to a backup directory monthly
– Reporting with BO Designer
• Conducting training on Oracle Reports Builder to group of students (client NSIT)
• Writing technical documentation.
Technical environment:: Oracle 10g et 11g, Teradata, Toad, ODI, Qlikview, BO Designer, Serveurs Unix/Linux, Windows
From march 2000 to january 2010 : Development Engineer (Food-processing industry – Paris)
• Analysis, design and implementation of BI application :
– Analysis of business requirements in collaboration with the project ownership
– Dataware modeling and création of fact and dimension tables
Staging area (ODS) creation to store data from various sources (distributed databases, batch files …)
– Supply staging area from distributed Oracle 7 databases / sequential files (PLSQL/FORMS/Pro*Fortran)
– Transformation and integration of data from staging area to a dataware ( FORMS / PLSQL ).
– Design and implementation of a tool (FORMS / PLSQL), to allow customers to perform data Extraction -Transformation-Loading procedure periodically (fortnight, monthly, annually)
– Development of the reporting application in VBA/EXCEL
– Maintenance of the BI application.
– Administration and maintenance of the BI databases.
– Analysis and study of decision-making tools (ODI, BO and Qlikview) in order to perform the migration of the BI.
• Development and maintenance of the storage / Ordering / Billing / Accounting / raw materials market applications.
• Upgrade, rewriting and data recovery of the des applications
• Participation in the installation and configuration of UNIX and Oracle 9iAS.
• Participation in Oracle database and UNIX servers administration .
• requirements definition, preparation of specifications, time estimation, planning of work packages and deliverables, organization of meetings, resource planning, technical coordination in order of validation of deliverables , periodic reporting of the technical progresses.
• Test planning, unit testing, integration testing, according to the recommendations of ISTQB/CFTL.
• Drafting technical documents.
Technical environment : ORACLE v7/9i/10g, serveur d’application ORACLE 9iAS/Unix (Sun)/ OpenVMS/WinNT/Pro*Fortran/JAVA/JDBC/PLSQL/SQL/FORMS/REPORTS/UTPLSQL/Toad/CVS
From September 1998 to march 2000: Analyst Programmer
• Support Service delivery for Europcar
– Maintenance of GreenWay application, impact analysis and module and interface development
– Implementation of Makefiles and preparation of libraries for program compilations
– Development of stored procedures, Packages, Triggers
– Participation in the design of Database
– Realization and implementation of unit and integration tests
– Drafting technical documents (in English)
Technical environment : ORACLE V7, UNIX, WinNT, ProC, PLSQL, Forms 3, Perl
1997 : Master validation stage – Transoft International – Epinay sur Seine (6 months)
– Design and development of a computer code for the simulation of atmospheric dispersion around airports (Fluidyn Panache project)
Information gathering, bibliographic analysis, establishment of contact with European, American and Japanese airports to collect their works about pollutants dispersion modeling
– Case study of chronic and accidental dispersion of pollutants by numerical simulation
Technical environment : UNIX, C
From 1984 to 1995
– Research & development – CNRS Marie Lannelongue Hospital (6 months) : Study of NOS expression in pulmonary arterial hypertension by different pharmacological and molecular biology methods.
– Research & development – Institut Pasteur Paris (3 months) : study of the serotonin receptor by molecular biology methods (PCR)
– Research & development – CNRS-IRSC Villejuif (6 months) : Study of metalloprotease and thrombospondin (Herpes Virus) by cellular and molecular biology methods
– Research & development – INSERM Bichat Hospital – Paris (6 months) : Study of CCKB receptors using experimental surgery on animal model
– Hostel receptionist in Paris (6 years) : Reception of customers. Distribute tasks to personal cleaning. Mailing and reservations. Preparation of planning…
– – Veterinary Assistant in Dr Montharon clinic- Paris (1 year) : Preparation of the operating room. Consulting and surgery assistance. Install infusions, , blood tests, injections
QUALIFICATION & TRAINING
March 2019 – Oracle University
– Oracle 12c Database RAC administration
November 2016 – IB-CEGOS Formation
– SQL Server 2012/2014 database administration
– Designe database solutions with SQL Server 2012/2014
June 2012 – ALTER WAY FORMATION
– Mysql : Administration
2007-2018 – Information Technology & BI engineering – eiCNAM in Paris (Time off work)
– Big Data
– BI engineering – Project : ETL with ODI and reporting with QlikView
– Communication for engineers
– ITIL
– reverse engineering
– Software designing in Java : Patterns and Canevas
– The software testing and validation
– Software architecture in Java (J2EE)
– Advanced methodology of information technology – UML
– Technological infrastructures for e-commerce – PHP/MYSQL
– Software production – Project management process
– computer modeling
– Urbanization and architecture of information systems
– Management and organization of companies for engineers
– Social Management of the company for engineers
– Project management for engineers
Juillet 2010 – ItSMF France
– ITIL Certification : Services Passeport
Mai 2010 – Management Informatique
– ODI Advanced features .
2007 – Oracle University
– Oracle 10g Froms Developer
– Oracle 10g Reports Developer
2005 – Oracle University
– Oracle 9i Froms Developer
– Oracle 9i Reports Developer
2003 – Oracle University
– Oracle 9iAS advanced Administration
– Optimisation and tuning
– Developing applications with XML
2002 – Oracle University
– Based procedural objects in Oracle
2001 – Compuware
– UNIFACE Case training
2001 – Sun Microsystem
– Installation and Administration of Solaris
1999 – INFOSPHERE
– DBA ORACLE V7 training
1997-1998 – DESU Information Technology – Université of Paris 10
– Master of Information Technology, option System, network and object oriented programming
1996-1997 – DESS QCBA – Université of Paris 7
– Master of Chemical and Biological Quality of Atmospheres, Option Modeling of atmospheric flows.
1995 – CCI Versailles
– C/UNIX programmer training
1989 – Université of Paris 7
– Master of Biochemistry
LANGUAGES
– French Fluent
– English Fluent
– Italian Fluent
– Turkish Fluent
– Persian Mother language
