We are independent & ad-supported. We may earn a commission for purchases made through our links.
Advertiser Disclosure
Our website is an independent, advertising-supported platform. We provide our content free of charge to our readers, and to keep it that way, we rely on revenue generated through advertisements and affiliate partnerships. This means that when you click on certain links on our site and make a purchase, we may earn a commission. Learn more.
How We Make Money
We sustain our operations through affiliate commissions and advertising. If you click on an affiliate link and make a purchase, we may receive a commission from the merchant at no additional cost to you. We also display advertisements on our website, which help generate revenue to support our work and keep our content free for readers. Our editorial team operates independently of our advertising and affiliate partnerships to ensure that our content remains unbiased and focused on providing you with the best information and recommendations based on thorough research and honest evaluations. To remain transparent, we’ve provided a list of our current affiliate partners here.
Roles

Our Promise to you

Founded in 2002, our company has been a trusted resource for readers seeking informative and engaging content. Our dedication to quality remains unwavering—and will never change. We follow a strict editorial policy, ensuring that our content is authored by highly qualified professionals and edited by subject matter experts. This guarantees that everything we publish is objective, accurate, and trustworthy.

Over the years, we've refined our approach to cover a wide range of topics, providing readers with reliable and practical advice to enhance their knowledge and skills. That's why millions of readers turn to us each year. Join us in celebrating the joy of learning, guided by standards you can trust.

What Does a Data Administrator Do?

Helen Akers
By
Updated: Mar 03, 2024
Views: 17,116
Share

A data administrator is an information technology professional who may design and maintain computerized databases. The duties of a data administrator primarily involve managing software, including access authorization. Database software often needs to be examined and tweaked in order to store information according to an organization's needs. Monitoring and ensuring the functionality of the software is a crucial part of a data administrator's job.

Generally, data administrators determine how a database program should be setup and organized. They are often in charge of selecting server and storage applications that will display information in a specific manner. For example, the information regarding the different schools in a district may be searchable by name and address. The administrator determines what information is stored in the program and how it is categorized.

Besides applying their knowledge to configure and customize various database software programs, administrators must also be aware of how that software interacts with computer hardware. A good number of database programs provide users access to information through a local area network (LAN) or the Internet. One of the common duties of a data administrator is to make sure that database programs are accessible over a company's network. An administrator may work with a network engineer to increase and decrease network capacity as necessary.

At times, databases and software experience functionality errors. It is up to a data administrator to troubleshoot the system and discover the root cause of the error. Besides reactively fixing software programming errors, data administrators also routinely update and maintain the systems. This may involve temporarily disabling the functionality of the program in order to apply upgrades and transfer the stored data securely.

A major concern of any administrator is the security of the information contained in the database. Data administrators also partner with network system engineers to protect against possible intrusions. They may actively investigate and recommend potential firewall and intrusion detection software, in addition to encryption technology. Administrators are in charge of granting access to the database by creating user names, passwords and permissions.

When a data administrator sets up a user name, he will typically grant certain permission levels. Depending upon the user's job function or status, he may be able to modify programs on certain computers within an organization. Permission levels can also be used to restrict certain users from being able to access information or software components. For example, in an educational setting, student users may be restricted from changing any of the software on a computer.

Share
Practical Adult Insights is dedicated to providing accurate and trustworthy information. We carefully select reputable sources and employ a rigorous fact-checking process to maintain the highest standards. To learn more about our commitment to accuracy, read our editorial process.
Helen Akers
By Helen Akers
Helen Akers, a talented writer with a passion for making a difference, brings a unique perspective to her work. With a background in creative writing, she crafts compelling stories and content to inspire and challenge readers, showcasing her commitment to qualitative impact and service to others.
Discussion Comments
By nony — On Dec 26, 2011

@hamje32 - I have a lot of respect for the work that our database administrator does. At least where I work, it’s not an 8 to 5 job. He often has to do stuff on weekends too.

That’s because that’s when he chooses to do the upgrades on the database software. He doesn’t have to do it then, but he chooses to do so in order not to disrupt our work.

Of course if there is an emergency – the network is down or something like that – he has to come in as well, regardless of the hour. That’s something to consider if you plan to go into this line of work.

By hamje32 — On Dec 26, 2011

@everetra - We run reports against a database in our company, and I have to admit it can be somewhat of a hassle to get access to the data.

What the administrator does is that he limits certain kinds of permissions, like the ability to create tables and stuff like that. If we need tables built he does that.

Also, he limits the amount of data loaded into the server. Supposedly this is to make reporting easier. I guess I understand the security constraints but it would be nice if we had access to all the data at once.

By everetra — On Dec 25, 2011

The database administrator at our workplace is responsible for setting up our Oracle server on our network. We actually have a dedicated server that hosts the Oracle database. He sets us up with permissions and stuff.

The biggest problem that we run into is space requirements. As developers we often have the need to build larger databases. Our software is meant to be scalable.

Building larger databases means that we wind up eating up the hard drive space that is on the server. So we get emails from the database administrator asking us if we need all the databases that are on the server, or if there are some that we can take down.

I think eventually we’re going to need a terabyte or even a multiple terabyte drive for that server, to accommodate all of our projects.

Helen Akers
Helen Akers
Helen Akers, a talented writer with a passion for making a difference, brings a unique perspective to her work. With a...
Learn more
Share
https://www.practicaladultinsights.com/what-does-a-data-administrator-do.htm
Copy this link
Practical Adult Insights, in your inbox

Our latest articles, guides, and more, delivered daily.

Practical Adult Insights, in your inbox

Our latest articles, guides, and more, delivered daily.