Resume

Sign in

Oracle and PostgreSQL Database Architect and Administrator

Location:
Da'an District, Taipei, Taiwan
Posted:
February 20, 2020

Contact this candidate

Resume:

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



Contact this candidate