Select Page

DBA Roles & Responsibilities: Constantly Changing

Craig Mullins | | September 27, 2016

DBA Responsibilities

One of the biggest challenges I see these days for DBAs is the ongoing redefinition of their job roles and responsibilities. Oh, most people know the rudimentary aspects of the job, namely keeping your organization’s databases and applications running up to par. The DBA has to be the resident DBMS expert (whether that is DB2, Oracle, or SQL Server – most likely a combination of those). He or she has to be able to solve thorny performance problems, ensure backups are taken, recover and restore data when problems occur, design physical databases from logical models, make operational changes to database structures and, really, be able to tackle any issue that arises that is data-related.

All of these roles continue to be requirements of the job, but that is no longer sufficient for most organizations. The DBA is expected to take on numerous additional — mostly technical — roles. These can include application development, managing the application server, enterprise application integration, managing Web services, network administration, and more.

Who manages the application server at your shop? The transaction processor? Other middleware? Who do you go to with SAP and other packaged application issues? Usually the DBA, right?

But I would guess that if you compare the job description of DBAs across several organizations, no two of them would match exactly. This is both good and bad. It is good because it continually challenges the technically-minded employees who tend to become DBAs. But it can be bad, too; because the job differs so much from company to company, it becomes more difficult to replace a DBA who leaves or retires. And no one can deny that database administration is a full-time job with plenty of stress all on its own. But the stress level just keeps increasing as additional duties get tacked onto the DBA’s “to do” list.

For DBA Managers, it’s important to be aware of the demands already placed on their time before piling on additional responsibilities. Or, to add additional challenge and responsibility to the plate of a DBA who is performing, consider off-setting some of the more mundane tasks to a managed services company or contractor so they can take on some of the more complex projects. Either way you go about it, it’s important to communicate with DBAs about the demands on their time and the tasks they enjoy most so you can delegate accordingly. The variety of roles DBAs take on across the board doesn’t have to be a frustration; done right, it can benefit everyone.

This blog was originally published on Craig Mullins’ blog at https://datatechnologytoday.wordpress.com/2010/11/22/dba-roles-responsibilities-constantly-changing/

12c Upgrade Bug with SQL Tuning Advisor

This blog post outlines steps to take on Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018
code

Recover a Table from an RMAN Backup in an Oracle 12c

This blog post will is to show a table restore for one table in a container database

Megan Elphingstone | February 2, 2017

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS