Infrastructure at your Service

All posts by Hervé Schweitzer

Hervé Schweitzer
Chief Technology Officer (CTO) and Principal Consultant

Hervé Schweitzer has more than ten years of experience in database and infrastructure management, engineering, and optimization. He is specialized in Oracle technologies such as standardisation, Backup and Recovery, Tuning, and in High Availability solutions such as Oracle Data Guard, Oracle Grid Infrastructure, Oracle Real Application Clusters (RAC), Oracle GoldenGate, and Oracle Failsafe. Hervé Schweitzer is "Oracle Certified Master 11g (OCM 11g)". Prior to joining dbi services, Hervé Schweitzer was Senior Consultant at Trivadis in Basel. He also worked as an IT Administrator and Oracle DBA at Crossair in Basel. Hervé Schweitzer holds a BTS degree in Information Systems from France. His branch-related experience covers Pharma, Transport and Logistics, Banking, Energy, Automotive etc.

Event “Logical Replication Insight”

By | Events | No Comments

Event “Logical Replication Insight”

Lausanne – 31.05.2016 / Olten – 01.06.2016

 

Ensuring data integration and system migration with minimal downtimes has become a crucial factor for the companies’ performance.
To meet this challenge, dbi services’ specialists are proposing this technical event dedicated to logical replication of data bases, giving you the opportunity to access expert’s knowledge regarding 3 replication solutions: Oracle GoldenGate, Dbvisit Replicate and Attunity Replicate. Starting from an Oracle database, we will present different types of implementation of logical replication and show factually the strengths of each solution from our partners Oracle, Dbvisit and Microsoft. Last but not least, we will enjoy a friendly apéro together after having shared experiences during a final open discussion. The experts of dbi services are looking forward to sharing their knowledge with you during this event. Come and join us!

Event program
Welcome coffee 08:30-09:00
Welcome speech & partner presentation 09:00-09:30
Session: Logical Replication with Oracle GoldenGate 09:30-10:15
Session: Dbvisit Replicate for logical replication 10:15-11:00
Coffee break 11:00-11:15
Session: Attunity Replicate – High-Performance Replication 11:15-12:00
Open discussion 12:00-12:30
Apero 12:30-13:30
The sessions

1st session: Logical Replication in the Disaster Recovery environment with Oracle GoldenGate
Hervé Schweitzer, Chief Technology Officer (CTO) and Principal Consultant

GoldenGate is an Oracle product which allows the replication of database applications (logical replication). However, the related databases must be consistent, at anytime. Otherwise the replication stops. Nowadays more and more companies have disaster recovery data centers and thus want to protect everything, including databases. Oracle Data Guard is usually used for the replication of Oracle environments in a Data Center (physical replication). But what happens when the replicated databases (standby) intentionally or unintentionally gets active? And is it possible to automate the GoldenGate replication in the DR Data Center too? This presentation provides an insight into these questions and proposes possible solutions.

2nd session: Dbvisit Replicate – logical replication made easy
Franck Pachot, Technology Leader and Senior Consultant   (presentation in French)

Clemens Bleile, Senior Consultant   (presentations in German)

Logical replication brings multiple concerns in a feasibility study: are datatypes compatible? Are there some conflict rules to set-up? What rate of redo can be processed? The best way to answer is to try. Dbvisit comes with a setup wizard which makes it possible to configure and run a replication on 30 minutes, what  is perfect for a PoC. Let’s do it live, from setup to running, and test common cases of conflict resolution, table re-synchronization, etc.

3rd session: Attunity Replicate – High-Performance Replication of Oracle Data to SQL Server

David Barbarin, Senior Consultant  & Vincent Matthey, Consultant   (presentation in French)
Stéphane Haby, Delivery Manager and Senior Consultant
   (presentation in German)

The replication between two different databases can be very complex. Attunity replicate is a powerfully simple data replication software. This tool is easy to configure and replace the need for complex and costly custom development projects. Through different scenarios, we will test all possibilities of the replication between Oracle and SQL Server such as different datatypes, DDL and DML commands.

Details for registration

Lausanne

Olten

May 31st

June 1st

 

Oracle Certified Master Java SE – Congrats to Philippe Schweitzer

By | Media releases & news | No Comments

OCM Java SE

Congratulations to Philippe Schweitzer for having passed the prestigious Oracle Certified Master Java SE certification (OCM Java SE) that validates advanced proficiency in the Java programming language using Java SE. Already known for its OCM consultants specialized in Oracle databases, dbi services becomes one of the few Swiss companies employing more than 2 consultants holding the OCM certification.

The main knowledge and skills validated by this certification are:

  • Algorithmic efficiency
  • Networking in several ways
  • Graphical user interface demonstrating good principles of design
  • Multi-threaded programming
  • Concurrency, locking, life cycle and priority of threads
  • Understanding of Java Virtual Machine

Discover the professional career of Philippe Schweitzer, Senior Consultant and Lead of Development & Integration. Read more