Breaking in as an Accidental Database Administrator

It is a typical Wednesday afternoon. A call with your manager is scheduled around this time to discuss updates. As you enter the conference call, you don’t see anyone from your team, yet you see a familiar face in one of the window screens. “Isn’t that the Database Administrator who tendered his resignation letter a week ago?” you say to yourself.


And it dawned upon you. This call is not your typical meeting but a reception to your new role. You, my friend, are now a DBA.


As an accidental DBA, your first instinct would be to google “How to be a Smarter DBA”. Google will provide you an extensive list of searches: from SQL guides in SQL guides in database management, database security, and database monitoring to MySQL guides on the same topic.

As you open article by article to know more about your role, you must have realized something – “what system am I administering”? Sure, these SQL guides and MySQL guides are helpful, but if your company uses Oracle, you’re off on a bad start.


It is also common to scour the internet for resources on basic SQL and advance SQL topics. Although that is a part of the skillset a DBA needs, therefore, you will still need to understand the core components of how databases work and function.

Moreover, you might find yourself browsing through tutorials. If you are using SQL Server, Documentation on SQL server management studio might be a good starting point. Exploring the IDE will provide a better understanding once you begin Database Monitoring and Database Management.


For non-SQL Server DBAs, there are free IDEs available online, and they’re much more robust and reliable than the recommended IDE of a vendor. In essence, you can choose to settle with SQL server management studio or find an IDE that will be much more familiar to you.

What can you do?

As a DBA, your role is to maintain and optimize the database. You need to understand database management, database monitoring, and database reporting. Sure, backend development and setting up servers and clusters will also be under your responsibility. But as an accidental DBA, the management will not expect you to handle those tasks at once. So, rest assured that you will not need to dive into those topics yet.


The more critical aspect of being a DBA is to know more about performance tuning. In any database server, High-Performance MySQL databases or high-performing database servers will be your end goal. The speed of database read and write is not just the sole measurement for performance; it encompasses database server uptime and disaster recovery.


With an established system, your job is to maintain it. You want the system to work efficiently. Hence, you will focus your energy on focusing on things you can control and handle. Even if you are an accidental DBA, chances are database backups and recovery will be a task you will do.


Understanding backups, for one, is a good one to begin your DBA journey. You need to understand how each type of backup is aligned with your company’s guidelines on disaster recovery. A good tandem with database backups is learning recovery models. Restoring backups is the ideal next step in your journey.


Testing your backups is an absolute must. Untold numbers of DBAs have been left in the cold when it turns out their meticulously executed and stored backups fail to restore. So check – and check again.


Testing backups requires you to save a backup file and restore it in point in time. A secondary server for testing will be required if your database is currently being utilized in production. Use dbcc checkdb after restoring the backup to verify no corruption or issues were encountered.


Next, familiarize yourself with indexes and how they will affect your search queries. Indexes can have an enormous impact on your database’s performance when adequately implemented. During searches, this lessens the fetch time of queries reducing the overall load in the process.


Finally, learn how to optimize SQL queries. Structuring how your write queries is another way to unburden the database resources. The correct use of LEFT and INNER JOIN can impact the speed of returning data, especially when indexes are involved. Always remember not to bloat your data upon return.


There is a lot to talk about when you want to be a DBA. Entry to this role requires learning and experience before you can properly call yourself a bona fide DBA. Plus, you need to always keep in mind database performance. As much as possible, you want to avoid database performance degradation.


But, there is a much easier route rather than overwhelming yourself with these concepts.

Tools can make a difference

Even an accidental DBA, such as yourself, will be depending on database monitoring tools. Nowadays, Professional DBAs use tools for their daily operations. They prefer a working script rather than build it from scratch. Procedures from Brent Ozar or Ola Hallegren gives a much more holistic approach to database monitoring, making monitoring an entire instance much easier.


These solutions are excellent. But won’t you prefer to use a tool that has a pre-built feature of analytics, automated monitoring, and user interface? Yes, there exists such a product; that’s dbWatch Control Center. dbWatch Control Center is a monitoring and management solution that can monitor different databases anytime, anywhere.

dbWatch Control Center has three significant features: Database Monitoring, Database Management, and Database Reporting.


Under the monitoring module, you can monitor hundreds of databases heterogeneously or cross-platform. Whether your organization uses MySQL Server, MS SQL Server, Oracle, or Postgres, Control Center will be able to connect to it, be it in the cloud or on-premises.


In the same module, you will see different dbWatch jobs installed to an instance. Each job is specifically tailored to the monitoring needs of a DBA per each platform. For example, in MS SQL Server, a job called SQL Server Agent status checks if the SQL Server Agent is running or not. You can check more about the different job status by going to our online documentation for Control Center.


Another positive for jobs are they are agentless, meaning dbWatch schedules and triggers those dbWatch jobs. Last, jobs can be categorized as with alert status and without alert status.


Jobs with alert statuses provide alarms and warnings. Once those dbWatch jobs are finished running. They will provide a status color-coded as (see the image above for more details):

By default, they are set by the dbWatch team’s DBAs. If you feel confident in modifying the jobs or your organization has stricter rooms for error, you can set the parameters for each monitoring job. If not, you can leave it as it is.


As a DBA, you want to configure or manage your database instance directly. The management module acts as an IDE to your database server.

The management module also sports a variety of features like history and logs. For example, deadlocks. You can kill sessions using dbWatch Control Center. On top of that, you can see the blocking history of the sessions. These are one of the helpful ways dbWatch’s history and logs are.


You have different options like access control for database security, disk memory management, and backup management. As a matter of fact, managing indexes becomes easier with dbWatch Control Center.

When opening Maintenance Overview, you can see all instances that need your attention, marked with an orange checkmark. With just a click of a button, you can reorganize or rebuild indexes, perform dbcc checks, and remove database fragmentation. Imagine doing that without writing a single line of SQL code.


With this view, you can perform preventative or proactive maintenance. Various jobs in dbWatch will check fragmentation and statistics. This will provide you with the needed indicator that your indexes needs your immediate action.

For example, the image above shows you two different color coding. In the severity column, it shows I need to perform a dbcc check on always1. While SQLKND_16 needs its indexes to be reorganize. Luckily, with dbWatch, you can perform those tasks automatically outside office hours. Furthermore, what’s great about those jobs is that it prevents anyone from executing them carelessly during office hours unless its parameters allow it to be executed during those hours.


Finally, you can generate a database report for your managers and colleagues. With the option to provide a comprehensive one on all registered instances, dbWatch will email it directly to your team or access it in a server environment.


It might be overwhelming to submerge yourself in the tasks and responsibilities of a DBA. But don’t fret; you are now well equipped with the knowledge to go forth and be the best DBA out there. Always remember a tool does not make you any less of a DBA. A tool like dbWatch Control Center will leverage you into fitting in that role as soon as possible.

Database Admin’s role in the modern age of DevOps

A DBA working on Devops

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. When a business chooses the modern DevOps approach the can 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.  

A DBA working on Devops

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. 

Are you 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 track
  • Automate your daily maintenance tasks 


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 

Try Control Center today, download a trial version of dbWatch that can monitor up to 5 instances for 6 months.