Mehrad - Chef de projet ORACLE SQL

March 2016 to date – 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
- Implement the creations 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
- 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 the 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 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 Informatica and return with Cognos)
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, One automation

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