What does a database administrator do? Job description of a database administrator, job responsibilities of a database administrator, sample job description of a database administrator

Database Administrator Job Description Sample

The sample job description is compiled taking into account the professional standard

1. General Provisions

1.1. A database administrator (DB) is classified as a specialist.

1.2. The following person is hired for the position of database administrator:

1) having higher education (bachelor's degree);

2) who have mastered additional professional programs - advanced training programs, professional retraining programs;

3) having worked as a junior database administrator (or in similar positions) for two years.

1.3. The database administrator must know:

1) basic concepts of statistics;

2) methods of statistical studies of test results;

3) main criteria (indicators) of the database operation;

4) the architecture of information storage and processing systems and the possibility of their interaction with the database;

5) interface components for interaction of the database with data storage and processing systems;

6) models and data structures, physical database models;

7) features of the implementation of the data structure and data management in the installed database;

8) characteristics and features of operation of local computer networks of various types;

9) features of the implementation of interaction of the database with components of the computer network;

10) languages ​​and database programming systems;

11) basics of statistical analysis;

12) modern methods and means of managing data distribution in memory;

13) Internal labor regulations;

14) labor protection requirements and fire safety rules;

15) ………(other documents, materials, etc.).

1.4. The database administrator must be able to:

1) use automated means of monitoring the status of the database;

2) process statistical data, apply statistical calculation methods;

3) independently search for information necessary to perform professional tasks in database management;

4) choose a method of action in the changing conditions of a work situation; control, evaluate and adjust your actions;

5) work with information storage and processing systems;

6) localize the problem of working with resources that has arisen in the data storage and processing system;

7) apply methods for optimizing database performance and monitor the results obtained;

8) configure interaction between computer network components;

9) apply database programming languages ​​and systems to optimize query execution;

10) ……… (other skills and abilities).

1.5. The database administrator in his activities is guided by:

1) ……… (name of the constituent document)

2) Regulations on ……… (name of structural unit)

3) this job description;

4) ……… (names of local regulations regulating labor functions by position)

1.6. The database administrator reports directly to ……… (name of the manager’s position)

1.7. ……… (other general provisions).

2. Labor functions

2.1. Optimizing the functioning of the database:

1) monitoring the operation of the database, collecting statistical information about the operation of the database;

2) optimization of the distribution of computing resources interacting with the database;

3) optimization of database performance;

4) optimization of computer network components interacting with the database;

5) optimization of query execution to the database;

6) optimization of life cycle management of data stored in the database.

2.2. ……… (other functions)

3. Job responsibilities

3.1. The database administrator performs the following duties:

3.1.1. As part of the labor function, monitoring the work of the database, collecting statistical information about the work of the database:

1) monitors the operation of the database, including various automated means;

2) determines the main statistical indicators of the database;

3) analyzes the obtained statistical data and draws conclusions about the effectiveness of the database.

3.1.2. As part of the labor function, optimization of the distribution of computing resources interacting with the database:

1) analyzes the capabilities for managing computing resources interacting with the database;

2) manages computing resources interacting with the database;

3) monitors the results of the redistribution of computing resources interacting with the database.

3.1.3. As part of the labor function, optimizing database performance:

1) analyzes the possibilities for managing database performance optimization;

2) determines the criteria for optimizing database performance.

3.1.4. As part of the labor function, optimization of computer network components interacting with the database:

1) analyzes the components of the computer network and the capabilities to manage their configuration;

2) determines evaluation criteria when changing the configuration of computer network components interacting with the database;

3) optimizes computer network components that interact with the database and monitors changes that have occurred in the operation of the database.

3.1.5. As part of the labor function, optimizing the execution of database queries:

1) carries out statistical analysis of queries to the database, their classification according to various criteria;

2) determines criteria for optimizing the execution of queries to the database;

3) optimizes the execution of statistically significant queries to the database.

3.1.6. As part of the labor function in optimizing the management of the life cycle of data stored in the database:

1) controls the distribution of data in memory;

2) determines the strategy for managing the distribution of data in memory intended for storing the database;

3) monitors compliance with the strategy for managing the distribution of data in memory intended for storing the database.

3.1.7. As part of his job functions, he carries out instructions from his immediate supervisor.

3.1.8. ……… (other duties).

3.2. ……… (other provisions on job responsibilities).

4. Rights

4.1. The database administrator has the right:

4.1.1. Participate in the discussion of job assignments, in meetings on their preparation and implementation.

4.1.2. Request clarifications and clarifications from your immediate supervisor regarding these instructions and assigned tasks.

4.1.3. Request, on behalf of the immediate supervisor, and receive from other employees of the organization the necessary information and documents necessary to carry out the assignment.

4.1.4. Get acquainted with draft management decisions relating to the function he performs, with documents defining his rights and responsibilities for his position, and criteria for assessing the quality of performance of his labor functions.

4.1.5. Submit proposals for the organization of work within the framework of their labor functions for consideration by their immediate supervisor.

4.1.6. Participate in discussions of issues related to the duties performed.

4.1.7. ……… (other rights)

5. Responsibility

5.1. The database administrator is held accountable:

For improper performance or failure to fulfill one’s official duties provided for in this job description - in the manner established by the current labor legislation of the Russian Federation, legislation in the field of audit;

For offenses and crimes committed in the course of their activities - in the manner established by the current administrative, criminal and civil legislation of the Russian Federation;

For causing damage to the organization - in the manner established by the current labor legislation of the Russian Federation.

5.2. ……… (other liability provisions).

6. Final provisions

6.1. This job description has been developed on the basis of the Professional Standard "", approved by Order of the Ministry of Labor and Social Protection of the Russian Federation dated September 17, 2014 N 647n, taking into account ……… (details of local regulations of the organization)

6.2. The employee is familiarized with this job description upon hiring (before signing the employment contract).

The fact that the employee has familiarized himself with this job description is confirmed by ……… (by signature on the familiarization sheet, which is an integral part of this instruction (in the journal of familiarization with job descriptions); in a copy of the job description kept by the employer; in another way)

6.3. ……… (other final provisions).

Download job description
database administrator(.doc, 90KB)

I. General provisions

  1. A database administrator is classified as a specialist.
  2. A person with a higher mathematical, economic or technical education and experience working on personal computers for at least 3 years is appointed to the position of database administrator.
  3. Appointment to the position of database administrator and dismissal from it is made by order of the director of the enterprise upon presentation
  4. The database administrator must know:
    • 4.1. Resolutions, instructions, orders, other governing and regulatory documents of higher and other bodies concerning programming methods and the use of computer technology in information processing.
    • 4.2. Technical and operational characteristics, design features, purpose and operating modes of equipment, rules for its technical operation.
    • 4.3. Technology of mechanized information processing.
    • 4.4. Types of technical storage media.
    • 4.5. Methods of classification and coding of information.
    • 4.6. Normalized programming languages.
    • 4.7. Current standards, number systems, ciphers and codes.
    • 4.8. Programming methods.
    • 4.9. The procedure for preparing technical documentation.
    • 4.10. Advanced domestic and foreign experience in programming and using computer technology.
    • 4.11. Fundamentals of economics, labor organization and management.
    • 4.12. Legislation on labor and labor protection of the Russian Federation.
    • 4.13. Internal labor regulations.
    • 4.14. Rules and regulations of occupational health, safety, industrial sanitation and fire protection.
  5. The database administrator reports directly to the head of the information technology department.
  6. During the absence of the database administrator (vacation, illness, business trip, etc.), his duties are performed by a person appointed in the prescribed manner. This person acquires the corresponding rights and is responsible for the high-quality and timely performance of the duties assigned to him.

II. Job responsibilities

  1. The main task of a database administrator is to maintain the full amount of operational and accumulated information in an up-to-date working condition, as well as to protect information from unauthorized access.
  2. The database administrator, in accordance with the task assigned to him, performs the following responsibilities:
    • 2.1. Analyzes the information needs of the organization's structural units.
    • 2.2. Masters the software offered by the information technology department.
    • 2.3. Coordinates with the information department issues on improving the process of storing and processing information in order to ensure the required reliability of the results and minimize calculation time.
    • 2.4. Ensures the exchange of information with the information department in accordance with the established procedure (including using electronic telecommunications networks).
    • 2.5. At the request of interested departments of the organization, together with the informatization department, draws up technical specifications for the development of software for new tasks.
    • 2.6. Carries out a range of works on the implementation of software.
    • 2.7. Provides systematic training to employees of the organization in techniques and skills for working on computers, as well as working with implemented software.
    • 2.8. Monitors the operation of computers and promptly reports failures and malfunctions to the information technology department.
    • 2.9. Carries out accounting and storage of documents related to automated processing of information on computers.
    • 2.10. Summarizes and analyzes user comments based on the results of task operation and transmits information about noted shortcomings to the information technology department.
    • 2.11. Monitors the integrity, reliability and safety of data circulating in the automated information system.
    • 2.12. Maintains an archive of used software and regulatory and reference information.
    • 2.13. Issues to the management of the organization recommendations on the distribution of incoming computer equipment between structural units, taking into account the availability of software, trained specialists and analysis of the load of PCs in use.

III. Rights

The database administrator has the right:

  1. Get acquainted with draft decisions of the enterprise management concerning its activities.
  2. On issues within his competence, submit proposals for the consideration of his immediate superior to improve the activities of the enterprise and improve information processing methods; comments on the activities of employees of the enterprise (department); options for eliminating existing shortcomings in the activities of the enterprise (department).
  3. Request personally or on behalf of the management of the enterprise from departments of the organization and other specialists information and documents necessary to fulfill his official duties.
  4. Involve specialists from all (individual) structural divisions in solving the tasks assigned to him (if this is provided for by the regulations on structural divisions, if not, then with the permission of the heads of divisions).
  5. Require the management of the enterprise (department) to provide assistance in the performance of its official duties and rights.

IV. Responsibility

  1. The database administrator is responsible for:
    • 1.1 For improper performance or failure to fulfill one’s job duties as provided for in this job description - within the limits determined by the current labor legislation of the Russian Federation.
    • 1.2. For offenses committed in the course of carrying out their activities - within the limits determined by the current administrative, criminal and civil legislation of the Russian Federation.
    • 1.3. For causing material damage - within the limits determined by the current labor and civil legislation of the Russian Federation.
  2. The database administrator is also personally responsible for:
    • 2.1. Inadequate implementation of organizational and technical measures to ensure the safety of information in the event of failures and failures of the PC.
    • 2.2. Inadequate organization of information protection from unauthorized access.
    • 2.3. Failure to take measures to prevent PCs from becoming infected with computer viruses.
    • 2.4. Disclosure of information constituting state, official and commercial secrets.

1.1 This job description defines the functional duties, rights and responsibilities of the database administrator.

1.2 The database administrator belongs to the category of specialists.

1.3 The database administrator is appointed to the position and dismissed from the position in the manner established by the current labor legislation by order of the director of the enterprise upon the recommendation of the head of the information center.

1.4 Relationships by position:

1.4.1

Direct subordination

To the Head of the Information Computing Center

1.4.2.

Additional Subordination

To the director of the enterprise

1.4.3

Gives orders

−

1.4.4

The employee is replaced

person appointed by order of the director of the enterprise

1.4.5

The employee replaces

−

  1. Database Administrator Qualifications:

2.1

education

higher mathematical, economic or technical

2.2

experience

at least 3 years

2.3

knowledge

Resolutions, instructions, orders, other governing and regulatory documents of higher and other bodies concerning programming methods and the use of computer technology in information processing.

Technical and operational characteristics, design features, purpose and operating modes of equipment, rules for its technical operation.

Technology of mechanized information processing.

Types of technical storage media.

Methods of classification and coding of information.

Normalized programming languages.

Current standards, number systems, ciphers and codes.

Programming methods.

The procedure for preparing technical documentation.

Advanced domestic and foreign experience in programming and using computer technology.

Fundamentals of economics, labor organization and management.

Legislation on labor and labor protection of Ukraine.

Internal labor regulations.

Rules and regulations of occupational health, safety, industrial sanitation and fire protection.

2.4

skills

−

2.5

Additional requirements

practice of working on personal computers
  1. Documents regulating the activities of the database administrator

3.1 External documents:

Legislative and regulatory acts relating to the work performed.

3.2 Internal documents:

Charter of the enterprise, Orders and instructions of the director of the enterprise (head of the computer center); Regulations on the information and computing center, Job description of the database administrator, Internal labor regulations.

  1. Database Administrator Responsibilities

4.1. The main task of a database administrator is to maintain the full amount of operational and accumulated information in an up-to-date working condition, as well as to protect information from unauthorized access.

4.2. The database administrator, in accordance with the task assigned to him, performs the following responsibilities:

4.2.1. Analyzes the information needs of the organization's structural units.

4.2.2. Masters the software offered by the information technology department.

4.2.3. Coordinates with the information department issues on improving the process of storing and processing information in order to ensure the required reliability of the results and minimize calculation time.

4.2.4. Ensures the exchange of information with the information department in accordance with the established procedure (including using electronic telecommunications networks).

4.2.5. At the request of interested departments of the organization, together with the informatization department, draws up technical specifications for the development of software for new tasks.

4.2.6. Carries out a range of works on the implementation of software.

4.2.7. Provides systematic training to employees of the organization in techniques and skills for working on computers, as well as working with implemented software.

4.2.8. Monitors the operation of computers and promptly reports failures and malfunctions to the information technology department.

4.2.9. Carries out accounting and storage of documents related to automated processing of information on computers.

4.2.10. Summarizes and analyzes user comments based on the results of task operation and transmits information about noted shortcomings to the information technology department.

4.2.11. Monitors the integrity, reliability and safety of data circulating in the automated information system.

4.2.12. Maintains an archive of used software and regulatory and reference information.

4.2.13. Issues to the management of the organization recommendations on the distribution of incoming computer equipment between structural units, taking into account the availability of software, trained specialists and analysis of the load of PCs in use.

  1. Database Administrator Rights

The database administrator has the right:

5.1. Get acquainted with draft decisions of the enterprise management concerning its activities.

5.2. On issues within his competence, submit proposals for the consideration of his immediate superior to improve the activities of the enterprise and improve information processing methods; comments on the activities of employees of the enterprise (department); options for eliminating existing shortcomings in the activities of the enterprise (department).

5.3. Request personally or on behalf of the management of the enterprise from departments of the organization and other specialists information and documents necessary to fulfill his official duties.

5.4. Involve specialists from all (individual) structural divisions in solving the tasks assigned to him (if this is provided for by the regulations on structural divisions, if not, then with the permission of the heads of divisions).

5.5. Require the management of the enterprise (department) to provide assistance in the performance of its official duties and rights.

  1. Database Administrator Responsibilities

6.1. The database administrator is responsible for:

6.1.1. For improper performance or failure to fulfill one’s job duties as provided for in this job description - within the limits determined by the current labor legislation of Ukraine.

6.1.2. For offenses committed in the course of carrying out their activities - within the limits determined by the current administrative, criminal and civil legislation of Ukraine.

6.1.3. For causing material damage - within the limits determined by the current labor and civil legislation of Ukraine.

6.2. The database administrator is also personally responsible for:

6.2.1. Inadequate implementation of organizational and technical measures to ensure the safety of information in the event of failures and failures of the PC.

6.2.2. Inadequate organization of information protection from unauthorized access.

6.2.3. Failure to take measures to prevent PCs from becoming infected with computer viruses.

6.2.4. Disclosure of information constituting state, official and commercial secrets.

  1. Working Conditions for a Database Administrator

7.1. The operating mode of the database administrator is determined in accordance with
Internal labor regulations established at the enterprise.

  1. Terms of payment

The terms of remuneration for the database administrator are determined in accordance with the Regulations on remuneration of personnel.

9 Final provisions

9.1 This Job Description is drawn up in two copies, one of which is kept by the Company, the other by the employee.

9.2 Tasks, Responsibilities, Rights and Responsibilities can be clarified in accordance with changes in the Structure, Tasks and Functions of the structural unit and workplace.

9.3 Changes and additions to this Job Description are made by order of the general director of the enterprise.

Head of structural unit

(signature)

(last name, initials)
AGREED:

Head of the legal department

(signature)

(last name, initials)

00.00.0000

I have read the instructions:

(signature)

(last name, initials)

00.00.00


Approximate form I approve ___________________________________ (initials, surname) (name of the organization, __________________________ enterprise, etc., its (director or other legal form) official authorized to approve the job description) " " ____________ 20__ m.p.

Job Description for Database Administrator

_____________________________________________ (name of organization, enterprise, etc.) " " ______________ 20__ N____ This job description has been developed and approved on the basis of an employment contract with __________________________________________ (name of the position of the person for whom _______________________________________________________ and in accordance with this job description) the provisions of the Labor Code of the Russian Federation and other regulations governing labor relations in the Russian Federation. I. General provisions 1.1. A database administrator is classified as a specialist. 1.2. A person with a higher mathematical, economic or technical education and experience working on personal computers for at least ________ years is appointed to the position of database administrator. 1.3. Appointment to the position of database administrator and dismissal from it is made by order of the head of the enterprise upon submission of __________________________________________________________. (head of the information department, head of another structural unit) 1.4. The main task of a database administrator is to maintain the full amount of operational and accumulated information in an up-to-date working condition, as well as to protect information from unauthorized access. 1.5. The database administrator must know: - regulations, instructions, orders, other governing and regulatory documents of higher and other bodies concerning programming methods and the use of computer technology in information processing; - technical and operational characteristics, design features, purpose and operating modes of equipment, rules for its technical operation; - technology of mechanized information processing; - types of technical storage media; - methods of classification and coding of information; - normalized programming languages; - current standards, number systems, ciphers and codes; - programming methods; - procedure for preparing technical documentation; - advanced domestic and foreign experience in programming and using computer technology; - basics of economics, labor organization and management; - fundamentals of labor and labor protection legislation of the Russian Federation; - internal labor regulations; - rules and regulations of labor protection, safety precautions, industrial sanitation and fire protection; - _________________________________________________________________. 1.6. The database administrator reports directly to the head of the information technology department. 1.7. During the absence of the database administrator (vacation, illness, business trip, etc.), his duties are performed by a person appointed in the prescribed manner. This person acquires the corresponding rights and is responsible for the high-quality and timely performance of the duties assigned to him. 1.8. ______________________________________________________________. II. Job responsibilities The database administrator, in accordance with the task assigned to him, performs the following responsibilities: 2.1. Analyzes the information needs of the structural divisions of the enterprise. 2.2. Masters the software offered by the information technology department. 2.3. Coordinates with the information department issues on improving the process of storing and processing information in order to ensure the required reliability of the results and minimize calculation time. 2.4. Ensures the exchange of information with the information department in accordance with the established procedure (including using electronic telecommunications networks). 2.5. At the request of interested departments of the organization, together with the informatization department, draws up technical specifications for the development of software for new tasks. 2.6. Carries out a range of works on the implementation of software. 2.7. Provides systematic training to enterprise employees in the techniques and skills of working with computers, as well as working with implemented software. 2.8. Monitors the operation of computers and promptly reports failures and malfunctions to the information technology department. 2.9. Carries out accounting and storage of documents related to automated processing of information on computers. 2.10. Summarizes and analyzes user comments based on the results of task operation and transmits information about noted shortcomings to the information technology department. 2.11. Monitors the integrity, reliability and safety of data circulating in the automated information system. 2.12. Maintains an archive of used software and regulatory and reference information. 2.13. Issues to the management of the enterprise recommendations on the distribution of incoming computer equipment between structural units, taking into account the availability of software, trained specialists and analysis of the load of PCs in operation. 2.14. ______________________________________________________________. III. Rights The database administrator has the right: 3.1. Get acquainted with the draft decisions of the enterprise management concerning its activities. 3.2. On issues within his competence, submit proposals for the consideration of his immediate superior to improve the activities of the enterprise and improve information processing methods; comments on the activities of employees of the enterprise (department); options for eliminating existing shortcomings in the activities of the enterprise (department). 3.3. Request personally or on behalf of the enterprise management from departments and specialists information and documents necessary to perform their job duties. 3.4. Involve specialists from all (individual) structural divisions of the enterprise in solving the tasks assigned to it (if this is provided for by the regulations on structural divisions, if not, with the permission of the head of the enterprise). 3.5. Require the management of the enterprise (department) to provide assistance in the performance of their official duties and rights. 3.6. ______________________________________________________________. IV. Responsibility The Database Administrator is responsible for: 4.1. For improper performance or failure to fulfill one’s job duties as provided for in this job description, within the limits determined by the labor legislation of the Russian Federation. 4.2. For offenses committed in the course of carrying out their activities - within the limits determined by the administrative, criminal and civil legislation of the Russian Federation. 4.3. For causing material damage - within the limits determined by the labor and civil legislation of the Russian Federation. The job description was developed in accordance with ________________ (name, _____________________________, document number and date) Head of the structural unit (initials, surname) _________________________ (signature) " " _____________ 20__ Agreed by: Head of the Legal Department (initials, surname) _____________________________ (signature) " " ________________ 20__ I have read the instructions: (initials, surname) _________________________ (signature) " " _____________ 20__

A database administrator is a specialist who is responsible for developing requirements for an organization's various databases. He is responsible for the design, effective use, integrity and maintenance of the storage facility. The administrator manages accounting-type records and organizes a system of protection against unauthorized use of information in the database. A detailed description of this specialty is established in the professional standard “Database Administrator”, approved by order of the Ministry of Labor and Social Protection of the Russian Federation No. 647n dated September 2014. Specialty code 40064.

Administrator tasks

Streams of transmitted information play an important role in the modern world. All data is systematized into certain groups - databases. An administrator is a person who provides qualified management of these databases, including their comprehensive protection. Due to the connection of any processes taking place in organizations, this profession is in great demand in the market.

The main tasks of a database administrator are to ensure the smooth operation of all equipment located in the organization (networks, servers and other electronics). The specialist’s activities include the implementation of certain algorithms for processing and distributing the entire volume of information in the enterprise (its maintenance and dispatching), which will allow the continuous retrieval and use, if necessary, of the necessary information.

A database administrator is a specialist who spends most of his working time maintaining a ready-made information system. But in some cases, he is given other tasks as part of the workflow:

  • design and development of flowcharts and databases;
  • development of necessary requirements;
  • standardization of data warehouse performance;
  • formulation of access rights and basic regulations;
  • copying databases in backup mode and restoring them;
  • defining the format of user accounts;
  • research on use cases for protecting databases from unauthorized intrusions into the system;
  • developing options for preventing hardware errors and software failures in order to maintain the integrity of the data volume;
  • providing the ability to quickly switch to an updated version of the database management system.

General Administrator Responsibilities

The job description for a database administrator provides for the implementation of a large number of activities related to the information system in the organization. Any instruction includes several general points that are typical for any type of information manager.

  1. Carrying out continuous copying of information databases in backup mode. In the case of permanent data storage, if problems arise with servers or networks, all data from the infobase can be easily restored (or most of it).
  2. Regular work on updating software. Information arrays are often processed not by one program, but by a whole complex of service software. Therefore, when constantly updating software, the database administrator is required to have knowledge about the features of various software services, protocols (network), as well as programming skills in different computer languages. In addition, each administrator must be able to independently write a utility that is required in his activities.

Groups of Specific Responsibilities

Working as an administrator involves performing, in addition to general duties, one of five groups of specific functions:

  • ensuring uninterrupted functioning of data systems;
  • optimization of information databases;
  • preventing data loss damage;
  • supplying databases with various security measures;
  • management of expansion and development of information bases.

Operational support work includes the following responsibilities.

  1. Copying information from the database in backup mode.
  2. Recovering information from a database.
  3. Managing access options to information bases.
  4. database management software.
  5. Analysis of events that occur during database operation.
  6. Logging and recording of events that arise during the processing of information in databases.

Optimizing the operation of information bases includes the following responsibilities:

  • analysis of the work of databases, collection of statistical information about the work of information databases;
  • optimization of redistribution of computing data that interacts with databases;
  • standardization of information base performance;
  • optimization of computer network elements that interact with databases;
  • optimization of queries to information databases;
  • optimization of life cycle control, which is stored in information systems.

Preventing data damage and loss includes the following responsibilities.

  1. Development of provisions for copying information bases in backup mode.
  2. Monitoring compliance with backup provisions.
  3. Development of plans for backup of information bases.
  4. Development of procedures for creating information copies of data in automatic backup mode.
  5. Implementation of procedures for data recovery after information “collapses”.
  6. Analysis of failures occurring in the system, identifying the causes of violations.
  7. Development of instructions and methodological recommendations for database maintenance.
  8. Study of the functioning of software and hardware support for databases.
  9. Setting up the functioning and performance of information bases.
  10. Development of proposals for the modernization of supporting software and hardware.
  11. Assessment and analysis of risks of failures in the activities of information databases.
  12. Development of methods for automatic backup of information bases.
  13. Development of procedures for introducing data hot replacement modes.
  14. Drawing up reports on the operation of databases.
  15. Conducting consultations for users during the operation of information databases.
  16. Development of proposals in the field of advanced training of employees.

Providing databases with various security measures includes the following responsibilities:

  • development of a database information security strategy;
  • monitoring compliance with information security measures at a basic level;
  • optimization of system functioning in the field of security at the database level;
  • information system audit and database protection from external threats;
  • drawing up regulations to help ensure the security of information data systems;
  • improving the security system to reduce the load on the functioning of information systems;
  • preparation of reports and reports on the performance and status of security systems in information media and storage facilities.

Managing the expansion and development of data information bases includes the following responsibilities.

  1. Analysis of problems in the system for processing information in databases and development of proposals for the development of prospects in the work of databases.
  2. Drawing up regulations for updating system software in databases, information bases into new software options and their combination with new platforms.
  3. Studying and putting into practice new options and ways of working with information databases.
  4. Tracking updates to infobase options.
  5. Monitoring the implementation of information repositories and their compatibility with new platforms and new software versions.
  6. Development and creation of a structure of divisions, development of a personnel reserve.

Problem-oriented administrator

A problem-oriented database administrator is a specialist who solves problems that arise during the operation of an information database system. The sources of such problems can be different. This may be inaccuracy of data, lack of demand, unreliability of production processes, etc.

A problem-oriented administrator is concerned with identifying and structuring internal and external problems. Identified problems are analyzed, after which options for their solution are put forward.

Most often, a problem-solving-oriented administrator is brought in to work in emergency situations, when a quick, qualified analysis of the situation and a search for a solution is required.

In most cases, a problem-oriented administrator performs the duties of a network administrator during non-crisis times and works with databases and connecting network users in the organization.

When a crisis situation occurs, the administrator first analyzes the organization's resources to solve the problem from the inside, checks the possibility of using new technologies to overcome the crisis, and predicts how long the organization will need to solve the problem.

The algorithm for the activity of a problem-oriented network manager comes down to the following:

  • analysis of the current situation;
  • identifying specific problems that arose during the crisis;
  • determination of the entity authorized to solve such problems;
  • analysis of options for solving the problem with calculation of financial costs;
  • determining the projected time frame for restoring the pre-crisis situation;
  • actual problem solving if all the above actions and calculations are approved by management.

Performance Analyst

The DBA's role in performance analytics is to analyze the performance of the database and develop new solutions to problems identified during the analysis. The responsibilities of a Performance Analyst include the following:

  • carrying out an analysis of errors in the structure of the system and its constituent parts;
  • searching for weaknesses in the reliability and performance of programs at each level, including problems with hardware in network interaction and the logic of system operation;
  • development of scripts that process various heterogeneous data about the operation of programs and computers (flow of search queries, information on equipment debugging, network traffic, etc.);
  • selection of the most important information, presentation of data in a form suitable for analysis;
  • developing new approaches to collection and system performance;
  • increasing the degree of automation, autonomy and reliability of analytical tools, their improvement;
  • creating readable and development-friendly code;
  • creating new ways to solve performance problems, developing architectural concepts, participating in improving the reliability of data systems;
  • programming network applications.

System Data Warehouse Administrator

The data warehouse administrator performs more practical work, which is related to setting up database systems and debugging breakdowns that occur when using it.

The responsibilities of the data warehouse administrator are as follows:

  • administration of automatic telephone exchange;
  • maintenance of remote and local servers, networks and storage;
  • setting up local servers, Internet restrictions, servers with remote access, creating a network common to all users;
  • server management;
  • maintaining equipment in working order;
  • setting up terminal access for users (if necessary);
  • organization of network loading of computers;
  • setting up a workplace for employees;
  • providing assistance in installing low current systems;
  • minor repairs of office equipment and computers;
  • technical and software support for users.

Requirements for administrators

The general requirements of the professional standard under code 40064 include the presence of a technical higher education. Some employers also require a cyber education. This is due to the fact that the work of an administrator involves constructing a structured database model, as well as writing corresponding programs.

In addition to having the appropriate education, the following are important requirements:

  • ability to analyze the needs for information management of various departments in the organization;
  • availability of skills in testing new program products that are developed by departments and divisions of the organization;
  • the ability to take initiative in developing new algorithms and data storage techniques, in developing technologies for using information to increase productivity and the performance of the predicted result;
  • having experience in developing techniques that allow interaction with the user of information databases.

Learning outcomes

Despite the average salary, there are serious requirements for a database administrator to graduate. These include the following:

  • understanding the essence and purposes of various types of information base architectures;
  • the ability not only to design, but also to optimize the structure of information systems;
  • a high level of qualifications in the application of algorithms that ensure security within the system and its protection from external threats;
  • knowledge of programming, modeling and markup languages, ability to use them;
  • ability to use query languages ​​for information databases.

Advanced training courses

For people who have the profession of administrator in the field of information databases, there are many types of courses to improve their skills in this area. Such courses are conducted at scientific or educational institutions that provide a large amount of additional knowledge and skills in the field of information database administration.

Specialties in which you can improve your database administrator qualifications are:

  • development of models of information arrays;
  • architect of information network databases;
  • database administrator for the 1C program in various areas;
  • character;
  • database administrator using Microsoft SQL software;
  • management of information storage processes.

Administrator salary

The job of an information database administrator does not involve part-time work due to the specifics of the job. The complete computerization of society has led to the fact that even during the crisis, the demand for qualified personnel in the field of network administration did not fall. Administrators are needed most in capital cities.

According to the analysis of the situation, the average level of wages for specialists in the field of information administration was identified in the country.

Based on the results of 2017, it was found that the salary of a database administrator is expressed in the following figures:

  • Moscow - from one hundred ten to one hundred sixty thousand rubles;
  • St. Petersburg - from seventy-seven to one hundred thousand rubles;
  • in the regions - from forty to seventy-five thousand rubles.

In some regions, wages are set below the average, but after the employee improves their skill level, they increase. The administrator's profession is different in that any increase in the level of knowledge and acquisition of new skills most often has a positive effect on wages.

Working as a database operator has many benefits. First of all, the informatization of society provokes a constant increase in demand for specialists in the information sphere. In addition, network work provides the opportunity for constant self-development without the involvement of outsiders.

mob_info