Scarcity of DBA in Indonesia


According to a 2022 report by LinkedIn, there are currently 1,000 open jobs for database administrators in Indonesia; it keeps growing as more and more businesses adopt digital technologies. And yet, there are only over 380 Oracle Certified Professionals in Indonesia. Also there is no publicly available information on the exact number of Certified PostgreSQL DBA (CPSDBA) in Indonesia. However, according to a 2022 report by PostgreSQL Indonesia User Group, there are currently only over 100 CPSDBAs in Indonesia.

In the market the most in-demand database certifications in Indonesia are Oracle Certified Professional (OCP) and Microsoft Certified Solutions Expert (MCSE). The most in-demand database skills in Indonesia are SQL, Oracle, MySQL, and PostgreSQL. We can see there is a big gap between job openings and resource availability.

  • Oracle: Oracle is a commercial database software company that has been around for over 40 years. Oracle databases are known for their scalability, performance, and reliability. However, Oracle databases can be expensive to purchase and maintain.

  • Open source databases: Open source databases are free to use and distribute. They are also often more scalable and flexible than commercial databases. However, open source databases can be more difficult to manage and secure.

According to a 2022 report by IDC, Oracle has a market share of 40% in Indonesia. The top open source databases in Indonesia are MySQL, PostgreSQL, and MariaDB. MySQL has a market share of 30%, PostgreSQL has a market share of 20%, and MariaDB has a market share of 10%. The market share of Oracle vs open source database in Indonesia is expected to change in the coming years. Open source databases are becoming more popular, as businesses look for ways to save money on database software. However, Oracle databases are still the most popular choice for large enterprises.

About The Database

  • What’s Postgre?

    PostgreSQL is an open source, object relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance. It is one of the most popular relational databases in the world, and is used by a wide range of organizations, including Netflix, Spotify, and Uber.

    Here are some of the pros and cons of PostgreSQL:

    Pros:

    • Open source and free to use
    • Highly scalable and extensible
    • Supports a wide range of data types, including JSON, XML, and spatial data
    • Highly compliant with the SQL standard
    • Strong community support

    Cons:

    • Can be complex to configure and manage
    • There are lots of open source apps that support MySQL database as a default datastore, but may not support PostgreSQL
    • Documentation is not as comprehensive as some other databases

    When to use PostgreSQL

    PostgreSQL is a good choice for a variety of applications, including:

    • Web applications
    • Data warehouses
    • Geospatial applications
    • High-traffic applications
    • Applications that require complex data types

    Here are some examples of organizations that use PostgreSQL:

    • Netflix
    • Spotify
    • Uber
    • Reddit
    • Airbnb
    • The Wikimedia Foundation
    Overall, PostgreSQL is a powerful and versatile database that is a good choice for a wide range of applications. If you are looking for an open-source, scalable, and extensible database, then PostgreSQL is a good option to consider. Still unsure what database will suit your needs? Contact Monster Data for 45 mins free consultation with our Subject Matter Expert.

  • What’s MySql?

    MySQL is an open source relational database management system (RDBMS) that is one of the most popular databases in the world. It is used by a wide range of organizations, including Facebook, Twitter, and Wikipedia.

    Here are some of the pros and cons of MySQL:

    Pros:

    • Fast performance
    • Wide ecosystem of tools and applications
    • Easy to learn and use
    • Free and open-source

    Cons:

    • Not as scalable or extensible as some other databases
    • Not as compliant with the SQL standard
    • Less community support than some other databases

    When to use MySQL:

    MySQL is a good choice for a variety of applications, including:

    • Simple web applications
    • Low-traffic applications
    • Applications that require high performance
    • Applications that are compatible with MySQL's ecosystem

    Overall, MySQL is a powerful and versatile database that is a good choice for a wide range of applications. If you are looking for a fast, easy-to-use, and free database, then MySQL is a good option to consider. Still unsure what database will suit your needs? Contact Monster Data for 45 mins free consultation with our Subject Matter Expert.

  • What’s MariaDb

    MariaDB is a fork of MySQL that is developed and maintained by a community of developers. It is a free and open source relational database management system (RDBMS) that is compatible with MySQL. MariaDB is known for its performance, scalability, and stability.

    Here are some of the pros and cons of MariaDB:

    Pros:

    • Faster performance than MySQL
    • More scalable than MySQL
    • More stable than MySQL
    • Supports more storage engines than MySQL
    • Open source and free to use

    Cons:

    • Not as widely supported as MySQL
    • Some features are not backward compatible with MySQL

    When to use MariaDB:

    MariaDB is a good choice for a variety of applications, including:

    • High-traffic web applications
    • Large-scale data warehouses
    • Applications that require high performance and scalability
    • Applications that need to be compatible with MySQL

    Overall, MariaDB is a powerful and versatile database that is a good choice for a wide range of applications. If you are looking for a fast, scalable, and stable database, then MariaDB is a good option to consider. Still unsure what database will suit your needs? Contact Monster Data for 45 mins free consultation with our Subject Matter Expert.


PostgreSQL, MySQL, and MariaDB which one is better?

PostgreSQL, MySQL, and MariaDB are all open-source relational database management systems (RDBMS). They are all popular choices for a variety of applications, but they have different strengths and weaknesses.

PostgreSQL is a more powerful and versatile database than MySQL or MariaDB. It supports a wider range of data types, including JSON, XML, and spatial data. It is also more compliant with the SQL standard. However, PostgreSQL is more complex to configure and manage than MySQL or MariaDB. MySQL is a simpler and more lightweight database than PostgreSQL or MariaDB. It is easier to learn and use, and it is faster than PostgreSQL. However, MySQL is not as compliant with the SQL standard, and it does not support as wide a range of data types.

MariaDB is a fork of MySQL that is developed and maintained by a community of developers. It is designed to be more scalable and stable than MySQL. MariaDB also supports more storage engines than MySQL. However, MariaDB is not as widely supported as MySQL.

Here is a table that summarizes the key differences between PostgreSQL, MySQL, and MariaDB:

Feature PostgreSQL MySQL MariaDB
Scalability Very scalable Less scalable More scalable
Extensibility Highly extensible Less extensible Highly extensible
Compliance with the SQL standard Highly compliant Less compliant Highly compliant
Community support Strong community support Large community Smaller community
Performance Great Good Good
Ease of use More complex to use than MySQL Easier to use than PostgreSQL Similar to MySQL

Which database is right for you?

The best database for you will depend on your specific needs. If you need a powerful and versatile database that supports a wide range of data types, then PostgreSQL is a good option. If you need a simple and lightweight database that is easy to learn and use, then MySQL is a good option. If you need a database that is scalable and stable, then MariaDB is a good option.