Flux rss

Database administrator

Database administrator

A database administrator (or DBA for short) is in charge of maintaining and operating the databases which form a company's information system.

Skills

Given the critical nature of the data he/she is in charge of, the database administrator must be well versed in IT, with a particularly good knowledge of DBMSs (database management systems) and the query language SQL, as well as knowing several programming languages, in order to be able to automate certain tasks.

His/her duties involve ensuring the integrity of the company's information system. What's more, a keen understanding of DBMSs may be necessary for optimising queries, adjusting DBMS settings, or fine-tuning database access monitoring tools.

The database administrator may be called upon to act as technical support for client application users or development teams in order to fix their problems, advise them, or help them carry out complicated queries.

Working with the security manager, the database administrator will need to develop data backup and restoration plans and procedures, in order to preserve the data which he/she is responsible for.

Besides these technical skills, the database administrator must have a good understanding of the company's applications and be in a position to listen to users' needs when developing or editing a database. Ideally, he/she has experience with designing information systems and UML models.

Salary

A database administrator's salary may vary between $40k and $70k (£20k-£35k) per year, depending on how large and complex the information system is, and which duties he/she is given.

This document entitled « Database administrator » from Kioskea (en.kioskea.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the licence, as this note appears clearly.

Résultats pour Database administrator

Databases - DBMS models Databases appeared in the late 1960s, at a time when the need for a flexible information management system had arisen. There are five models of DBMS, which are distinguished based on how they represent the data contained: The hierarchical model: The... en.kioskea.net/bdd/bddtypes.php3
Databases - ODBC (Open Database Connectivity) ODBC stands for Open Database Connectivity. This is a Microsoft-defined format for communicating between Windows database clients and consumer DBMSs. The ODBC managier can be found in Windows 3.1 and 9x. In Windows 95 and 98, it is available in the... en.kioskea.net/bdd/odbc.php3
Databases - Data levels The ANSI/SPARC architecture, which dates from 1975, defines abstraction levels for a database management system: Internal (or physical) level: defines how data is stored, and how it is accessed. Conceptual level: also called the DRM (data... en.kioskea.net/bdd/bddansi.php3

Résultats pour Database administrator

Access the hidden Administrator Account in Windows VistaAccess the hidden Administrator Account in Windows Vista Why has the Administrator account been disabled in Vista? How to activate the Administrator Account Solution 1: Through User Account Control Solution 2: With Command Prompt Solution... en.kioskea.net/faq/sujet-300-access-the-hidden-administrator-account-in-windows-vista
No Windows Update with Windows XP SP3After installing Windows XP Service Pack 3, Windows Update won't work. Windows XP Service Pack 3 installs a new version of Windows Update, but it forgets to register it. try the following: Log on as an administrator, and run cmd.exe, and... en.kioskea.net/faq/sujet-255-no-windows-update-with-windows-xp-sp3
Graphical interfaces for SQLiteGraphical interfaces for SQLite SQLite is a powerful database management engine found in a relatively small C programming library; it requires no monitoring and can be used with most programming languages (C, C++, Java, Python). Unlike... en.kioskea.net/faq/sujet-629-graphical-interfaces-for-sqlite
1 2 3 Next

Résultats pour Database administrator

Regedit is disabled by the administrator (Solved)Hello, When i run Regedit it displays " Regedit is disabled by the administrator" what to do en.kioskea.net/forum/affich-8895-regedit-is-disabled-by-the-administrator
MySQL Help, PHP and Database help (Solved)Hello, I am building a form/blog/personal site for a small company. I was wondering if someone could help me in setting up my database. i have thought of a few options but i am not quite sure what one is the best. each user have a person page, they... en.kioskea.net/forum/affich-21728-mysql-help-php-and-database-help
How to merge an excel file to database? (Solved)Could someone please instruct me how to merge an excel file to database (MS Access/FoxPro/Oracle)? en.kioskea.net/forum/affich-19483-how-to-merge-an-excel-file-to-database
1 2 3 Next

Résultats pour Database administrator

Download Database Designer Platinum EditionDatabase Designer is a program for creating databases. It requires no programming knowledge. The application offers many tools: additions of fields, images, checks bugs correction syntactic and much more. It also allows the export of basic HTML, text... en.kioskea.net/telecharger/telecharger-1077-database-designer-platinum-edition
Download OpenOfficeOpenOffice is a free office application suite, including a word processor, spreadsheet, presentation tool, drawing package and database, compatible with all other major office suites like Microsoft Office (97-2007... en.kioskea.net/telecharger/telecharger-56-openoffice
Download DB Designer Allows you to handle your databases the most efficient way. DBDesigner 4 is a visual database design system that integrates database design, modeling, creation and maintenance into a single, seamless environment. It combines a simple and clear... en.kioskea.net/telecharger/telecharger-273-db-designer
1 2 3 Next

Résultats pour Database administrator

Databases - Introduction A database (abbreviated DB) is an entity in which data can be stored in a structured manner, with as little redundancy as possible. Different programs and different users must be able to use this data. Therefore, the concept of a database is... en.kioskea.net/bdd/bddintro.php3
IT professions - Network administrator A network administrator (also called a network manager) is in charge of maintaining and developing a business's network infrastructure. Today, network infrastructure is such an integral part of most businesses that network unavailability may... en.kioskea.net/metiers-informatique/administrateur-reseau.php3
Databases - Using forms In order to use databases, the user must be provided with an interface that allows him or her to view data based on certain criteria. There is a tool for this: forms. A form is an interface with components for displaying, entering, or selecting data.... en.kioskea.net/bdd/bddform.php3
1 2 3 Next