Pierre Marcenac
Paris, France – Bangkok, Thailand
adbvs1@r.postjobfree.com (+33)6-10-72-09-06
+66 (0-92-634-****
http://www.linkedin.com/in/pierremarcenac/en
Senior Database Administrator Consultant
Oracle DBA Expert Oracle-AWS Migration SQLSERVER, PostgreSQL Data Architect
Multi-faceted results-oriented Oracle Consultant with proven track record of managing end-to-end multimillion dollar initiatives for customers across industries. Analytical, highly adaptable professional with a keen understanding of customer requirements and exceptional problem solving skills. Extensive experience developing, deploying and evaluating systems aimed at improving quality and efficiency. Talent for managing high-performance, high-capacity databases in a critical production environment. Excellent communicator fluent in French and English, able to forge solid relationships with strategic global partners and build consensus across multiple organizational levels.
Highlights of Expertise
Strategic & Tactical Planning
Project Management
Data Warehouse Architecture
Entrepreneurial Leadership
Customer Relationship Management
Business-driven Technology Organizations
Oracle Applications / Migrations
Business Intelligence
Exceeding Service-level Agreements
Troubleshooting & 24/7 Support
Selected Technical Accomplishments
Large capabilities to support and innovate all aspects of architecture, design and implementation for the Data Warehouse employing Oracle including using and implementing Materialized Views, Partitioning, parallelism.
Managed tuning aspects of Oracle databases including single SQL statement, Concurrency, Batch and Oracle kernel parameters.
Set up and implemented backup and recovery policies in all possible scenarios. Designed, discussed and Implemented replication to a recovery site with streaming or Dataguard.
Provided 24 * 7 global support to customers as required.
Installed, configured and upgraded database from Oracle 9i/10G/11G/12c/18c.
Migration from oracle to MS SQLSERVER and PostgreSQL clusters
Ensured alignment of database engineering initiatives with business imperatives.
Also written 2 books on Oracle databases, Eyrolles publishers Paris – France (1991 and 1993).
Career Experience
Consult-Ora.com, Paris, France
In an entrepreneurial capacity, provide strategic Oracle consulting expertise as a full-time DBA to prestigious CAC40 groups, banks, Governments, hospitals, and various specialized distribution groups.
FOUNDER / CONSULTANT (2000 to Present)
Founded the company to offer high-end consulting services in multiple roles within Oracle environment. Collaborate with the customer to determine, design and model high impacting solutions. Execute and deliver solutions designed in agreement with the overall Oracle architecture and business needs. Launch and administer enterprise database infrastructures. As the Data warehouse/ Infra Architect, manage high traffic and volume systems. Design and build Data warehouse, oversee general administration, troubleshoot (Break/Fix) and resolve tuning issues. Manage Oracle-AWS Migration, RDS / EC2 and data architect BI projects. In the capacity of an Oracle DBA, provide DBMS upgrades, disaster recoveries, migrations, backups, optimizations. Also offer best Oracle development practices in a framework of ambitious business objectives. Conduct SQL and PL/SQL code review and mentor other database engineers. Evaluate the impact of decisions relating to databases and various database engineering initiatives. Act as a liaison between the technical and the business teams and work closely with C-level executives.
Capabilities in MS SQLSERVER and PostgreSQL as well.
Summary Projects:
Caisse épargne (bank), actual project: implement a streaming replication for Disaster recovery and high availability
Le Figaro Group, Press Publishing & Digital Media (2010-2019): As the Project Manager oversaw complete logical database design and data warehouse implementation, defined back up policy and maintained all Oracle Database. Technical skills used were - ETL: TALEND; Infra: Linux VMWare, SAN Oracle 11.2 EE and Oracle Database (Versions 7 to 12). MS SQLSERVER administration and cluster replication.
Veolia Water Systems (2007 – 2019): As the Oracle DBA, spearheaded the Oracle BI Foundation for water treatment solutions. Conducted data online patch update and migration in an Oracle 11g Enterprise Edition environment using Materialized Views Proactive performance review. Technical skills used were - ETL: Cognos Data Manager; Tool: Report Studio, ODS, Staging Area; Infra: Hosted physical server on Windows 2003/2008 R2.
Saint-Gobain, Avalant Bkk (2018-19): Trained and mentored PL/SQL and SQL developers. Migration to PostgresSQL.
Mayor of Cities (2010-2015): As Senior Oracle DBA, Provided specific interventions for Oracle server virtualization in a VMWare / NetApp Interaction with Oracle.
Learning Tree International, Paris, France
Design, develop and deliver training in various modules of Oracle.
ORACLE INSTRUCTOR / TRAINER (1998 – Present)
As the lead Oracle Instructor, conduct training in Oracle, covering Introduction to SQL, PL/SQL; Oracle Database Administration; Oracle backup and recovery; Oracle Tuning.
Key Achievements:
Constantly received student appreciation for delivering effective courses and training sessions.
Successfully designed future course curriculums for both existing and emerging database skills.
Education & Credentials
University of Sophia Antipolis, France
Doctor of Science (PhD), Oracle Database
University of Nice, France
Master’s Degree in Database