Over a million developers have joined DZone.

How DBAs Should Be Evolving With Database Automation

As DBAs are saddled with more duties and responsibilities, it can be a strain to handle them manually. See where automation can make your life easier.

· Database Zone

Build fast, scale big with MongoDB Atlas, a hosted service for the leading NoSQL database. Try it now! Brought to you in partnership with MongoDB.

The job of the DBA has always been a quite complex one that includes many responsibilities. However, as organizations evolve with the times, the role of DBA is becoming more and more challenging — and including an increasing number of tasks. It is clear that DBAs must do whatever they can in order to simplify their ever-growing workload.

In a recent Dell survey, by Research Analyst, Elliot King, and produced by Unisphere Research, DBAs were asked a number of questions pertaining to database administration and the importance of database automation. Check out the graph below to see what they considered to be the most important responsibilities for DBAs.

Based on this survey, it is clear that maintenance, performance, and configuration are key aspects of being a DBA. But large percentages also included other tasks, like change management and security counting among the most important responsibilities. Because the truth is that the role of a DBA holds many responsibilities.

For this reason, as DBA, it is important to simplify whatever you can in order to better be able to perform all your essential tasks. One of the ways DBAs are doing this is by using database automation.

As you can see, many of the basic administrative tasks of an organization are now automated. When it comes to verifying that all the database instances are up and running, over 80% of the people who responded to this survey disclosed that they use automation. Likewise, over 70% of DBAs use automation for verifying that scheduled jobs ran successfully, for verifying that database backups were successful, and to monitor disk space.

On the other hand, some tasks are clearly more commonly performed manually, like performance tuning, which 78.85% of DBAs perform manually, and provisioning or cloning databases, which 67.98% DBAs perform manually. This makes sense according to earlier studies that have shown that these tasks are more difficult and require more attention from DBAs.

When discussing the most pressing matters for the coming year, many DBAs mentioned that they would like to automate more tasks associated with database administration. The survey did not glean which specific project or project areas DBAs would like to automate, but that is likely due to the fact that one of the most challenging aspects of database administration is that each setting is unique.

In terms of data management infrastructure, DBAs were also asked to say what they thought the top challenges facing DBAs will be over the next few years, to which 38.86% picked the automation of more tasks associated with database management.

DBAs are responsible for so much and are continuously being asked to manage more database instances and DBMSs from different platforms, all while the amount of data under management continues to grow at a steady pace. Yet, while some routine administrative tasks have been automated, many tasks, like performance tuning and provisioning, are still generally done manually. For this reason, it is crucial for DBAs to continue to learn new technologies and continue to find ways to automate as much as possible.

Now it's easier than ever to get started with MongoDB, the database that allows startups and enterprises alike to rapidly build planet-scale apps. Introducing MongoDB Atlas, the official hosted service for the database on AWS. Try it now! Brought to you in partnership with MongoDB.

automation ,performance tuning ,dba

Published at DZone with permission of Yaniv Yehuda, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

The best of DZone straight to your inbox.

Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}