NLEN
Technical support?

OptimaData is a full-service, multi-platform data(base) service provider

We connect knowledge, expertise, consultancy, training and staffing

Our database services

We are (open-source) database experts and provide you with optimal performance of your database environment and staffing
OptimaData Database Consultancy, services and support on PostgreSQL, MongoDB, MariaDB, MySQL, Orqcle and MS SQL Server

Database Consultancy

High availability? High performance, migration? We advise you in making the right decisions, up until setting up and taking over the daily management of your database.

Read more

Training in PostgreSQL, MongoDB, MariaDB, MySQL. Basic, DBA, Developer and Advanced.

Database administration

We try to take care of your database worries. We offer a solid database management and maintenance program and provide you with the right consultancy or administration resources. These resources are tailored to your specific needs, so you can focus on your business.

Read more

OptimaData Staffing Data(base) professionals like PostgreSQL, MongoDB, MariaDB, MySQL, Oracle and MS SQL Server

Staffing

We offer custom-fit recruitment solutions for temporary and permanent matters of capacity, and entry to challenging data(base) assignments and job offers for database professionals and freelancers.

Read more

Current job offers and assignments

A selection of our premium job offers
inNaarden
You are a technical expert available to support our clients at both operational and tactical levels with open source database issues, both in and outside the cloud, and play a prominent role in projects.
inNaarden
Werken met ervaren data experts en moderne technologieën om data inzichtelijk te maken? Mooie projecten, je skills optimaal inzetten en onderdeel zijn van ons team? Kijk dan snel verder!
inNaarden
Werken met ervaren database experts en moderne technologieën om databases te bouwen en nog beter te laten presteren? Mooie projecten, je skills optimaal inzetten en onderdeel zijn van ons team? Kijk dan snel verder!
inLandelijk
Ben jij al geruime tijd als DBA of Developer bezig met open source databases? En zou je je willen specialiseren als Open Source Database Specialist? Prachtige uitdaging om je in vast te bijten!
inNaarden
Heb jij passie voor databases? Op zoek naar "the next level" of de transformatie waar de markt om vraagt? Als Database Reliability Engineer bij OptimaData kun je je hart en hard ophalen!
inNaarden
Nog niet eerder gehoord van een Multiplatform DBA? Dat kan kloppen, want dat ga jij worden als je uit je comfortzone durft te stappen en de uitdaging aangaat om met ons te groeien! Nieuwsgierig? klik en lees verder!
inNaarden
Zie jij ook de toename in PostgreSQL platformen? Zou jij je willen omscholen of specialiseren op Postgres en willen investeren in een boost van je kennis?
inLandelijk
Ben jij al geruime tijd als DBA of Developer bezig met MySQL / MariaDB? En zou je je willen specialiseren als MySQL / MariaDB Specialist? Prachtige uitdaging om je in vast te bijten!
Why OptimaData

Professional and competent

Our consultants are very experienced and knowledgeable about multiple (open source) database platforms.

Expertise in Open Source

Expertise in advice, setting up, migrating, automated deployment and managing open-source, hybrid and cloud database platforms.

Full-service

All services connected to your database management under one roof: Architecture design, POC, database administration and maintenance, 24/7 standby and support. Remote DBA and onsite database consultancy
Expertise in setting up and managing open-source database platforms.

About us

Contact us

Fill in your telephone number and we wil call you back as soon as possible. Or you can contact us yourself.

Contact us yourself

Stay up to date?

Leave your emailadres and stay up to date with the latest open source database news, events and blogs.
Our partners
We are accredited and proud partner of:
OptimaData is Microsoft Gold Partner Dataplatform

Microsoft Gold Partner

OptimaData is Consultancy and support partner of Codership and reseller of Galera Cluster, clustering MySQL and MariaDB.

Galera Cluster

OptimaData is Consulting partner in the Benelux for SeveralNines and reseller of ClusterControl. a management tool for open source DBMS such as MariaDB, MySQL, PostgreSQL and MongoDB.

Severalnines

OptimaData is Consulting and training partner of MariaDB and reseller of MariaDB TX and AX

MariaDB

References
What others say about us

Marcel Oudmaijer

Kadant

The response of OptimaData was swift and with result. I am convinced that with their guidance and expertise the performance of our database environment has improved significantly. My experience with OptimaData is without any hesitation very positive.

Performance Tuning

Bas Roos

VoiceWorks

We are not going to provide better services by managing our databases ourselves. We can rather spend our time on those things that add value to our wholesale partners and customers. OptimaData offers both the expertise and flexibility we need.

Managed Services

Karin Valk - Managing Director of Valk Solutions

Karin Valk

Valk Solutions

We offer our applications hosted and the data(base) is the heart of our cloud platform. We work on this every day with a team of in-house specialists. OptimaData offers us a valuable addition by taking a critical look at it from the outside and making expert recommendations for next steps. 

Database Consultancy

Blogs about databases

Databaserecovery. Have you tested yet?

Harry Splinter

In the past, Harry Splinter, Database Reliability Engineer at OptimaData, wrote about SAP ASE backups under the title "Thoughts on backups," in which he also paid attention to recovery. During his career as a DBA, he encountered quite a few situations in which recovery was the last straw. This sometimes led to unpleasant surprises. In this blog he shares his experiences. To learn, but also to amuse.

Database Recovery

Database blogs about MySQL, PostgreSQL, MariaDB, MongoDB and more!
Blogs about databases

Databases in the Cloud, without downsides

Jasper Jonk

UpCloud is an European cloud provider based in Finland that focuses on companies that need reliable, fast cloud services. In addition to cloud servers, UpCloud also provides other services, such as object storage and managed databases for MySQL and PostgreSQL environments. Because UpCloud and OptimaData have joined forces, UpCloud can now also offer custom solutions to customers with complex database issues. Jasper Jonk, Business Development Manager, talks about the added value of our partnership in this blog.

More about Upcloud

Database blogs about MySQL, PostgreSQL, MariaDB, MongoDB, DBaaS, cloud databases and more!
Blogs about databases

How much processing power and memory does your database server need?

Dimitri Choustov

At OptimaData, we regularly receive requests to investigate disappointing database performance. Often the organization has already had the conversation with the software vendor. A common response from the vendor is: the database server has insufficient CPU or memory. But how much processing power and memory is actually sufficient? And what can still be done if the application still responds slowly, even if the database server has sufficient hardware capacity? In this blog, Dimitri Choustov explains where possible improvements can be found.

Database performance tuning

 

Database blogs about PostgreSQL, MySQL, MariaDB, DBaaS and cloud databases
Blogs about databases

Our database experts gladly share their knowledge

Thomas Brinkman

Pros and cons of Database-as-a-Service

For the past six months, Thomas Brinkman has been conducting a research assignment at OptimaData. During the assignment, he investigated how a company like OptimaData can deal with the development around databases in the cloud and how they can function efficiently. What are his conclusions?

More about DBaaS

Blogs about databases

Cloudspend: Optimize datamodeling

Gerard Zuidweg

In this third and final blog in the series, Gerard Zuidweg, co-owner of OptimaData, discusses the importance of optimizing data modeling to effectively manage and reduce cloud costs. As companies migrate to the cloud, closely monitoring and controlling cloud spend is essential. Gerard shares seven practical techniques for taking a smart look at your data model. That way, you can optimize your database usage and reduce your cloud costs.

Cloudspend optimize datamodeling

Blog about Postgres and other open source DBMS like MySQL and MariaDB
Blogs about databases

Our database experts gladly share their knowledge

Martijn Wallet

Native PostgreSQL or Supported PostgreSQL

One of the most popular open source databases is PostgreSQL, in 2018 even declared DBMS of the Year. In this blog Martijn Wallet shares the most important advantages of using Supported PostgreSQL such as EDB Postgres Platform as compared to native PostgreSQL.

read more

Blogs about databases, PostgreSQL, MySQL, MariaDB, SQL Server
Blogs about databases

Our database experts gladly share their knowledge

Edco Wallet

Profit from performance tuning

Performance tuning is a much-discussed topic. In many cases it is the first issue brought up by new customers. The question or complaint is usually about the speed of the database. It would be a logical step to take action. In order to achieve visible improvement ad hoc and on a short-term basis, expanding resources is often seen as the solution. And, with databases in the cloud and auto-scale, or “fully managed”, these resources are scaled up for you entirely automatically. The only thing that is not managed are the costs. Because that is, after all, the revenue model of today's popular DBaaS solutions. All the more reason to take a pro-active look at database performance.

Performance tuning in DBaaS

Database blogs about PostgreSQL, MySQL, MariaDB, SQL Server
Blogs about databases

Our database experts gladly share their knowledge

Edco Wallet

Full throttle with MySQL - part 2

In part 1 of this blog - Help! MySQL is spinning out of control - we wrote about performance challenges you may face when your database grows and which pitfalls you should take into account if you want to be well prepared. In short: what you need to think about beforehand to be able to grow flexibly along with your database. In this blog we want to give you the 6 most important parts you can pay attention to and which parameters are of influence.

Performance tuning MySQL

Blog about DBaaS, DBA skills, tuning, troubleshooting, PostgreSQL, RDS, Azure, MySQL and MS SQL
Blogs about databases

Our database experts gladly share their knowledge

Thomas Spoelstra

DBA - Old but Gold vs DbaaS

We wrote earlier that there is nothing wrong with managing databases in a somewhat older environment. But there is also nothing wrong with more mature database administrators. Thomas Spoelstra - yes, the guy from the man cave - is one of those. He knows better than anyone how to set up a database as efficiently as possible, because 'before' there simply wasn't any more disk space or memory. Now that we are massively switching to the cloud, with all its space and possibilities for scaling up, those efficiency skills no longer seem that important. Until the costs get out of hand. Then you need someone who can assess and fine-tune the content of the data model to reduce your cloud costs. So someone like Thomas...

More about DBaaS

Blogs about databases

Our database experts gladly share their knowledge

Martijn Wallet

The benefits of database maintenance

If a red light on your dashboard turns on, most people call the garage - or the roadside assistance - with lightning speed. But if an application suddenly slows down, few people are inclined to do anything about it. That’s a missed opportunity. In this blog Martijn Wallet explains the benefits of having your database regularly serviced.

More about database maintenance

Blogs about databases

Our database experts gladly share their knowledge

Edco Wallet

When you grow from your strength and passion, it's real and lasting

What is the result when you put a banker, a techie and an aerospace engineer together with the right dose of inspiration? Right, you get OptimaData, the full-service multi-platform data(base) service provider. In this article, Gerard Zuidweg, Edco Wallet and Martijn Wallet reflect on five years of OptimaData.

More about 5 years OptimaData

Database blogs about PostgreSQL, MySQL, MariaDB, SQL Server
Blogs about databases

Our database experts gladly share their knowledge

Edco Wallet

Surfing the open source waves

IT develops at the speed of light. Innovations and updates follow each other in rapid succession and one new tooling is presented after another. There is also a lot of movement in the field of open source databases. Staying abreast of all these developments is therefore quite a challenge. In this blog we will give you some tips and valuable resources.

more about open source resources

Database blogs about PostgreSQL, MySQL, MariaDB, SQL Server
Blogs about databases

Our database experts gladly share their knowledge

Tino Dudink

Cloning and Cleansing: Master or Disaster

Copying data seems to have become almost a daily requirement. And, I'll admit it, when asked to automate this, I'm happy to work with you. Automating data and database copies to exits for development, test and acceptance environments is a daily occurrence and often has a valid business case. The simplicity and power of an automated procedure immediately presents a major pitfall. Storage is expensive, especially flash storage in an enterprise computing environment, such as HyperConverged Infrastructure (HCI). Our data usage keeps growing and sometimes seems to become unmanageable. In this blog Tino Dudink, DBA Consultant and Senior Database Reliability Engineer, talks about his vision on data usage.

More about data usage

Blogs about databases, PostgreSQL, MySQL, MariaDB, SQL Server
Blogs about databases

Our database experts gladly share their knowledge

Edco Wallet

A closer look at DBaaS

There is a growing interest in Database-as-a-Service (DBaaS). At the same time we only seem to be at the forefront with regard to quality and possibilities. Countless variations are now available from different cloud providers. Databases can be deployed in the cloud with seeming simplicity. If you believe the marketing stories, you no longer need a database administrator. Developers with ready-to-use building blocks - containers - can get started right away. But did they really take a good look at DBaaS?

a closer look at DBaaS

blogs about databases, cloud, postgreSQL, Microsoft, MySQL, Aurora, Azure, etc
Blogs about databases

Our database experts gladly share their knowledge

Edco Wallet

Can you still see the wood for the cloud trees?

Lately we've been writing regularly about cloud solutions and points of consideration of different variants of cloud solutions lately. But what exactly is the difference between all those variants? With which form are you the most carefree and with which model do you mainly have control over the performance? Can you still see the wood for the trees?

Cloud databases overview

blogs about postgres, MySQL, MariaDB, SQL Server, containers, cloud, AWS, Azure, etc.
Blogs about databases

Our database experts gladly share their knowledge

Martijn Wallet

The how, why and when of databases in containers

In this blog Martijn Wallet, our Manager Consultancy and Training, discusses what containerization is, what the pros and cons are and when it's better to stay away from it.

Databases in containers

Blogs about databases, PostgreSQL, MySQL, MariaDB, SQL Server
Blogs about databases

Our database experts gladly share their knowledge

Edco Wallet

What you need to know about PostgreSQL 13

PostgreSQL 13 has been released over a month ago. The most important changes and new features have already been announced in various ways and (online) stages, mostly by well-known contributors or influential Postgres community players. In this blog we take a look at those who have allready mentioned the new features, changes and handy facts about PostgreSQL 13. We give an overview of interesting articles, webinars and blogs about the important major but also perhaps neglected non-major changes.

More about Postgres 13 

Blogs about databases

Nieuw item

Blog about databases in the cloud, GCP, AWS, Azure Cloudreport 2020
Blogs about databases

Our database experts gladly share their knowledge

Edco Wallet

Database performance, CloudReport 2020

The transition to the cloud is in full swing. Private, public, hybrid, IaaS, PaaS, DbaaS; the cloud has countless forms and applications. But which cloud provider and which machines match best with your environment, and especially with your database? CockroachLabs - the company behind CockroachDB - recently published their annual Cloud Report. They have conducted an extensive and thorough benchmark with the three most well-known cloud providers: AWS, Azure and GCP. The benchmark is about a database instance on a cloud server and not DbaaS. In this blog Edco Wallet shares a summary of the Cloud Report 2020.

More about Cloudreport 2020

Blog about databases, administration, consultancy, PostgreSQL, MySQL, MongoDB, MS SQL Server
Blogs about databases

Our database experts gladly share their knowledge

Martijn Wallet

Determine better indexing and partitioning with hypopg

I ran into the challenge to determine the best partitioning key on an Amazon RDS Postgres database. Normal approach would be to start a project trying to implement this on a development environment. But in most cases, like during a QuickScan, the customer expects an educated guess in as little time as possible. It concerns running production environments where you would rather not release all kinds of scripts and analysis tooling to avoid disrupting the primary process. Which then also takes up unnecessary extra time.

More about HypoPG

Blog about open source, databases, healthchecks, administration, setup and tooling
Blogs about databases

Our database experts gladly share their knowledge

Dimitri Choustov

Get your database fit and healthy again

At OptimaData we are regularly asked to investigate disappointing performance of database environments (such as SQL Server, MySQL or PostgreSQL). Due to all possible variations and combinations in environments, there is not one specific or directly identifiable cause for such a performance issue. In this blog Dimitri Choustov explains how to get your database fit and healthy again.

Read more about HealthChecks

Blog about how to run Postgres on Docker, and many more open source subjects!
Blogs about databases

Our database experts gladly share their knowledge

Craig Healey

How to run Postgres on Docker part 3

In a previous post I deployed a PostgreSQL database in a container from a standard image. Now I’m going to look at deploying a PostgreSQL cluster. Well, kind of. PostgreSQL uses the term cluster to refer to “a collection of databases managed by a single PostgreSQL server instance”. I’m using it in the more general sense, to refer to High Availability.

read more

Blog about how to run Postgres on Docker understand the basics.
Blogs about databases

Our database experts gladly share their knowledge

Craig Healey

How to run Postgres on Docker (part 2)

In my previous blog post, I quickly ran through how to set up postgreSQL inside a Docker container, up to the point where you could administer the database with psql or pgAdmin. What I didn’t do was explain how any of it worked. If you’re trying to anything even slightly different, or if you encounter errors running it as I outlined, then you’re going to need to know what all of those commands actually do. In this blogpost i will explain some Docker basics.

Read more

Blogs about pen source databases. DBMS like PostgreSQL, MySQL, MariaDB, CockroachDB and general stuff about data and management.
Blogs about databases

Our database experts gladly share their knowledge

Via the link "read more database blogs" you will find our blog section. Blogs about databases, open source DBMS like PostgreSQL, MySQL, MariaDB, CochroachDB. Great stories how to and also general stuff about data and management.

read more database blogs

Blogs about open source databases. DBMS like PostgreSQL, MySQL, MariaDB, CockroachDB and general stuff about data and management.
Blogs about databases

Our database experts gladly share their knowledge

Via the link "read more database blogs" you will find our blog section. Blogs about databases, open source DBMS like PostgreSQL, MySQL, MariaDB, CochroachDB. Great stories how to and also general stuff about data and management.

read more database blogs

Blogs form OptimaData about open source DBMS like PostgreSQL, MySQL, MariaDB and technical reviews.
Blogs about databases

Our database experts gladly share their knowledge

Gerard Zuidweg

Open Source DBMS Feel free to choose but choose wisely

Open Source Database Management Systems are on the rise. Not only among newtech companies, but now also in banks, government departments and multinationals. Recent research among CIOs has shown that more than 60 percent want to drastically reduce licensing costs. Opting for more open source software helps, if well-considered choices are made. The most important points to consider are shown below.

Points to consider Open Source DBMS

Blogs about databases

Nieuw item

Blogs about databases

Nieuw item

Blogs about databases, open source DBMS like MySQL, PostgreSQL, MariaDB. Also general stuff about data and management.
Blogs about databases

Our database experts gladly share their knowledge

Roland van Veen

Nothing wrong with experienced databases

There is nothing wrong with the management of databases in somewhat older environments. On the contrary, these are applications that keep a lot of companies afloat. But there are a number of things you need to pay attention to. Roland van Veen, OptimaData DBA and Database Reliability Engineer, explains in this blog what those things are.

More about legacy databases

Database blogs about open source databases, cloud and DBaaS and PostgreSQL, MySQL and more
Blogs about databases

Our database experts gladly share their knowledge

Eric Gipon

How to centralize MySQL databases

When you're just starting out with your IT environment, everything is still very manageable. But once you're a few years down the road, you might find yourself with a tangle of databases. Centralizing can be the solution, Eric Gipon tells us how in this blog.

More about MySQL clustering

Blog about Docker, databases and Postgres in a container, blog 1 of 3.
Blogs about databases

Our database experts gladly share their knowledge

Craig Healey

How to run Postgres on Docker (part 1)

As a multi-platform DBA, I spend a lot of time learning about the latest features available on a variety of open-source and proprietary databases. I usually use VirtualBox images to create my sandbox databases, but they can take up quite a bit a disk space and resources. Especially if I’m playing around with things like database clustering solutions, when I need multiple databases running together. So the other day, I thought about using Docker containers.

read more

Nog
Events
PostgreSQL Usergroup NL New Year Meetup

We are happy to kick off the Newyear by inviting you to a meetup on January 18th! This time around we are welcome at Tilaa, an ambitous cloudhosting company in ‘s Hertogenbosch.

We have two great talks lined up for you.

Ellert van Koperen - DB architect and Perfomance tuner- will start the program with a talk about his journey with migrating big databases within the dynamic environment of VandeBron Energie.

The second talk is by Marc Linster  - Chief Customer Officer of EDB, who will share with us his vision on the future of PostgreSQL in a demanding and rapidly changing world of digital transformation, analytics and AI.

As usual we have some space in the program reserved for anyone who wants to to a lightning talk. Please contact us through a personal message on meetup.com

We are very grateful to Tilaa, for hosting the Meetup. Registration through Meetup.com is required.

More info and registration