<img height="1" width="1" style="display:none;" alt="" src="https://dc.ads.linkedin.com/collect/?pid=204641&amp;fmt=gif">

A Database Admin's role in the modern age of DevOps

Posted by Chad Pabalan on Oct 20, 2021 9:08:00 AM

As a traditional database administrator working in an enterprise that supports multiple clients across the globe, it is critical in the business to meet the increase in customer demands through embracing the modern DevOps approach. Which focus on continuous delivery/integration and automation.  

For business decision makers, it is a major aspect in retaining and acquiring new clients as the business could easily deliver the needs of the clients which they support.  

 

5-Sep-28-2021-07-09-39-42-AM

  •  
  • A shift to the DevOps principles, from a traditional DBA to a modern DBA 

    Applying the DevOps principles means businesses can adapt to the growing needs of their clients; they can quickly expand and add new features requested by their customers. DevOps aims to achieve the following: version control, automation, testing, continuous deployment/integration, monitoring, and continuous operations; it combines the development and operations into one.  

    DevOps streamlines business operations, increased automation and maximizes productivity, better communication, and efficiency across teams. 

    A company that practices DevOps grows faster, delivers quality software, and obtains a high level of customer trust and satisfaction. 

  •  

How do database administrators fit in this modern age of DevOps? 

The increase in demand for professionals with DevOps backgrounds has been exponential to support development practices within a business. 

As a traditional database administrator – in the DevOps era, you need to shift your attention from manually doing your tasks, shifting to a modern DBA by automating your tasks as much as possible. A few examples such as the manual deployment of code changes, manual creation of test database servers, and reactive monitoring of your databases.  

Automate deployment of database changes: In a small development team, a SQL developer requests you to deploy their changes from the test sql server environment to the stage sql server environment. Developers will provide the list of the objects that have been amended and you will extract it from the source and manually execute it to the destination. But when working in a huge enterprise with plenty of databases, this cannot be done manually as it is prone to human errors. If you are starting to lean on a DevOps principle, as a DBA you should be choosing tools that the team will use for source control. You are also involved in deciding how the team would effectively build an automated process in deploying code in different database environments. 

Building and disposing of test servers: A managed service provider company caters to different business applications that they support. Multiple projects require different requirements based on the service level agreement agreed upon by the client. Some applications being supported are deployed in the Cloud, to have the flexibility and to save costs in maintaining servers. As a DBA in a DevOps team, you might receive requests from the management or development team to create an exact replica of a test server and dispose of it after the developers/QA have finished their testing. As a DBA you should be knowledgeable about using infrastructure as a code tool, for you to be able to automate the creation/disposing of servers once the need for those servers has been fulfilled. 

Reactive Monitoring versus Proactive Monitoring: A database administrator in a DevOps team must have the right set of tools or solutions to proactively monitor the environment that they manage. Instead of the manual and reactive way of monitoring your environment, like manually logging in each server and executing your customized monitoring scripts. You must properly set tools to help you proactively monitor your database environments’ health. A solution that will inform you of the real-time event status of your databases. Helping you to act upon an alert/database activity before it causes a huge performance impact on your production systems. 

 

Choosing the right solution to integrate with DevOps? 

A DBA such as you should be the evangelist in advocating the use of different technologies to integrate within the business process to improve efficiency, automation, and reliability. 

A proper database monitoring solution such as dbWatch Control Center would help you achieve the following: 

  • - Proactive monitoring provides easy access views for you to have a full overview of what is happening in your database farm
  •  
  • - Complete information of your database farm overall utilization, which is crucial in capacity and resource planning
  •  
  • - Delivers real time alerts of the different performance metrics you wish to keep track of  
  •  
  • - Automate your daily maintenance tasks 

 

Summary

Being a DBA in a DevOps team, it is critical to be able to adapt to different toolsets that are needed to automate various database administrator tasks across your database environment. As a database administrator, you need to embrace change from a traditional/manual approach into a DevOps way of thinking. You, as a database administrator, are the gatekeeper of data, your databases should always be intact and secure, you need to have the right tools to give you full overview and control of your database environment. 

With dbWatch Control Center as your partner in monitoring and managing your databases helps you achieve the following:  

- Proactive monitoring dashboards display a health overview of all databases within your data center. Provides you with the necessary information for you to take proactive action against issues 

 - Complete information of your growing databases in your data centers, such as your total allocated hardware resources and resource utilization like your CPU, memory, and disk usage 

 - Allow customization and tailored services depending on your business needs and requirements   

 - Maintains proactive monitoring and ensures high availability of your servers 

 - Delivers real-time alerts for performance metrics and identify which databases are having performance problems 

 

You can try Control Center today. Use this link to download a version of dbWatch that can monitor up to 5 instances for 6 months for free:  dbWatch Control Center free license   

If you have any questions or you would like to know more on how dbWatch can assist you in your current enterprise database monitoring and management situation, feel free to contact me directly:  chadwick@dbwatch.com    

 

For more information, visit www.dbWatch.comor the dbWatch wiki pages 

#DevOps #DBA #DatabaseManagement #verticalscaling #horizontalscaling #scalability #databasemonitoring #sqlserver #oracle #mysql #databasemonitor #sqlmonitor #mariadb #microsoft sql server 

 

----------------------------------------------

 
About the Author: 

Chad Pabalan is a Pre-Sales Engineer for dbWatch and a DBA specializing in SQLServer high availability setups and disaster recovery planning and configurations. He is an AWS Certified Solutions Architect Professional, a cloud enthusiast specializing in architecture and designing scalable, high available, and fault-tolerant systems on AWS Cloud. 

Topics: database monitoring, sqlmonitor, sqlperformance, sqlmonitoring, indexmaintenance