Type sample
I approve
___________________________________ (initials, surname)
(name of company, __________________________
enterprise, etc., his (director or other
legal form) official,
authorized to approve
job description)
"" ____________ 20__
Job description
database administrator
______________________________________________
(name of organization, enterprise, etc.)
"" ______________ 20__ N_________
This job description has been developed and approved for
on the basis of an employment contract with __________________________________________
(name of the position of the person for whom
______________________________________________________ and in accordance with
this job description has been drawn up)
provisions of the Labor Code Russian Federation and other regulatory
acts regulating labor relations in the Russian Federation.
I. General provisions
1.1. The database administrator belongs to the category of specialists.
1.2. A person is appointed to the position of a database administrator,
having a higher mathematical, economic or technical education
and practice on personal computers at least _______ years.
1.3. Appointment as a database administrator and
exemption from it is made by order of the head of the enterprise according to
submission ________________________________________________________________.
(head of the information department, head of another
structural unit)
1.4. The main task of a database administrator is to maintain
in the current working condition of the full volume of operational and accumulated
information, as well as protecting information from unauthorized access.
1.5. The database administrator must know:
- resolutions, orders, orders, other guidelines and
normative documents of higher and other bodies concerning methods
programming and use of computer technology in processing
information;
- technical and operational characteristics, design
features, purpose and modes of operation of the equipment, its rules
technical operation;
- technology of mechanized information processing;
- types of technical information carriers;
- methods of classification and coding of information;
- normalized programming languages;
- current standards, number systems, ciphers and codes;
- programming methods;
- procedure for registration of technical documentation;
- advanced domestic and foreign experience in programming and
use of computer technology;
- fundamentals of economics, organization of labor and management;
- fundamentals of labor legislation and labor protection of the Russian
Federations;
- internal labor regulations;
- rules and regulations of labor protection, safety measures,
industrial sanitation and fire protection;
- _________________________________________________________________.
1.6. The database administrator reports directly to the chief
informatization department.
1.7. During the absence of the database administrator (vacation, illness,
business trip, etc.) his duties are performed by a person appointed in
in the prescribed manner. This person acquires the corresponding rights and
Responsible for quality and timely execution
the duties assigned to him.
1.8. ______________________________________________________________.
II. Job Responsibilities
Database administrator in accordance with the
task performs the following duties:
2.1. Analyzes the information needs of structural
departments of the enterprise.
2.2. Masters software tools offered by the department
informatization.
2.3. Coordinating with the information department on issues related to
improving the process of storing and processing information in order to
ensuring the required reliability of results and minimizing time
calculations.
2.4. Provides information exchange with the department of informatization in
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 department of informatization makes terms of reference on the
development software new tasks.
2.6. Carries out a complex of works on implementation software tools.
2.7. Carries out systematic training of employees of the enterprise
techniques and skills of working on computers, as well as working with embedded
software tools.
2.8. Monitors the operation of computers and timely
reports failures and malfunctions to the informatization department.
2.9. Maintains and maintains records related to
automated processing of information on computers.
2.10. Summarizes and analyzes user comments on the results
operation of tasks and transmits information about the noted shortcomings to
informatization department.
2.11. Monitors the integrity, reliability and
safety of circulating in the automated information system
data.
2.12. Maintains an archive of used software and
reference information.
2.13. Issues recommendations to the management of the enterprise on the distribution
between structural subdivisions of incoming computer technology with
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 company's management,
relating to his activities.
3.2. On issues within its competence, to submit to
consideration of their immediate supervisor proposals for
improvement of enterprise activity and improvement of processing methods
information; comments on the activities of employees of the enterprise (department);
options for eliminating existing in the activities of the enterprise (department)
shortcomings.
3.3. Request personally or on behalf of the management of the enterprise from
departments and specialists information and documents necessary for
performance of their official duties.
3.4. Engage specialists from all (individual) structural
departments of the enterprise to solve the tasks assigned to it (if it
provided for by the provisions on structural divisions, if not - with
permission of the head of the enterprise).
3.5. Require the management of the enterprise (department) to provide
assistance in the performance of their duties and rights.
3.6. ______________________________________________________________.
IV. A responsibility
The database administrator is responsible for:
4.1. For improper performance or non-performance of their official
duties set out 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 exercising their
activities - within the limits determined by administrative, criminal and
civil legislation of the Russian Federation.
4.3. For causing material damage - within the limits determined
labor and civil legislation of the Russian Federation.
The job description was developed in accordance with ________________
(Name,
_____________________________.
document number and date)
Head of structural unit (initials, surname)
_________________________
(signature)
"" _____________ 20__
Agreed:
Head of the legal department
(initials, surname)
_____________________________
(signature)
"" ________________ 20__
I am familiar with the instruction: (initials, surname)
_________________________
(signature)
Database Administrator Job Description Sample
A sample job description is drawn up taking into account the professional standard
1. General Provisions
1.1. The database administrator (DB) belongs to the category of specialists.
1.2. The following person is accepted for the position of a database administrator:
1) having a higher education (bachelor's degree);
2) mastered additional professional programs- advanced training programs, professional retraining programs;
3) who has worked as a junior database administrator (or in similar positions) for two years.
1.3. The DBA must know:
1) basic concepts of statistics;
2) methods of statistical research of test results;
3) the 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 of the database interaction with data storage and processing systems;
6) data models and structures, physical database models;
7) features of the implementation of the data structure and data management in the established database;
8) characteristics and features of the operation of local computer networks various types;
9) features of the implementation of the interaction of the database with the components computer network;
10) database programming languages and systems;
11) basics of statistical analysis;
12) modern methods and means of managing the distribution of data 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) apply automated means of monitoring the state of the database;
2) process statistical data, apply statistical calculation methods;
3) independently conduct a search for information necessary to perform professional tasks of database management;
4) choose a method of action in the changing conditions of the working situation; control, evaluate and correct their 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 database performance optimization methods and monitor the results;
8) adjust the interaction between the components of the computer network;
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 constituent document)
2) Regulations on ……… (name of the structural unit)
3) this job description;
4) ……… (names of local regulations governing labor functions by position)
1.6. The database administrator reports directly to ……… (title of the position of the head)
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) database performance optimization;
4) optimization of computer network components interacting with the database;
5) optimization of the execution of queries to the database;
6) control optimization life cycle data stored in the database.
2.2. ……… (other functions)
3. Job responsibilities
3.1. The database administrator has the following responsibilities:
3.1.1. As part of the labor function, monitoring the operation of the database, collecting statistical information about the operation of the database:
1) monitors the operation of the database, including various automated means;
2) determines the main statistical indicators of the database operation;
3) performs the analysis of the received statistical data, the formation of 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 possibilities 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 the optimization of database performance;
2) defines criteria for optimizing database performance.
3.1.4. As part of the labor function, optimization of computer network components that interact with the database:
1) analyzes the components of the computer network and the possibilities for managing their configuration;
2) determines the evaluation criteria when changing the configuration of the computer network components interacting with the database;
3) optimizes the components of the computer network that interact with the database, controls the changes that have occurred in the operation of the database.
3.1.5. As part of the labor function, optimization of the execution of queries to the database:
1) carries out statistical analysis queries to the database, their classification according to various criteria;
2) determines the 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 life cycle management of data stored in the database:
1) manages the distribution of data in memory;
2) determines the strategy for managing the distribution of data in memory intended for locating the database;
3) monitors the observance of the strategy for managing the distribution of data in memory intended for locating the database.
3.1.7. As part of the performance of his labor functions, he performs the instructions of his immediate supervisor.
3.1.8. ……… (other duties).
3.2. ……… (other provisions on official duties).
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. Ask the immediate supervisor for clarifications and clarifications on these instructions, issued assignments.
4.1.3. Request, on behalf of the immediate supervisor, and receive from other employees of the organization the necessary information, documents necessary for the execution of the assignment.
4.1.4. Get acquainted with the draft decisions of the management regarding the function performed by him, with documents defining his rights and obligations in his position, criteria for assessing the quality of the performance of his labor functions.
4.1.5. Submit proposals on the organization of labor within the framework of their labor functions for consideration by their immediate supervisor.
4.1.6. Participate in the discussion of issues related to the duties performed.
4.1.7. ……… (other rights)
5. Responsibility
5.1. The database administrator is responsible for:
For improper performance or non-performance of their official duties provided for by 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 prescribed by the current administrative, criminal and civil legislation of the Russian Federation;
For causing damage to the organization - in the manner prescribed by the current labor legislation of the Russian Federation.
5.2. ……… (other liability provisions).
6. Final provisions
6.1. This job description was developed on the basis of the Professional Standard "", approved by the Order of the Ministry of Labor and social protection Russian Federation dated September 17, 2014 N 647n, taking into account ...... ... (details of the organization's local regulations)
6.2. Familiarization of the employee with this job description is carried out upon employment (before signing the employment contract).
The fact that the employee is familiarized with this job description is confirmed 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; otherwise)
6.3. ……… (other final provisions).
When hiring an employee for the position of a database administrator, management expects to receive management systems maintenance services. The main task of a specialist is to ensure uninterrupted access of all users of the organization to the necessary information.
If a person is hired to create a base from scratch, then his duties include design, requirements development, implementation, performance testing and maintenance support. In addition, the creation of credentials, their protection from unauthorized penetration into the database, as well as maintaining the integrity of its structure.
Almost all the time the employee spends at the computer. More detailed information about what exactly are the duties, rights and responsibilities of a database administrator, in the job description developed in the organization, should be described in full.
Regulations
The employee hired for this position is a specialist who can be hired or fired only by the head of the company. Usually, the applicant is required to have a higher education in the profession, namely, that it relates to the mathematical, engineering or technical direction. In addition, to obtain this position, you must work in the field information technologies at least three years in relevant positions.
The database implies that in the process of performing his work he will be guided by regulatory and legislative documentation, methodological materials that directly affect his activities.
He must take into account the clauses of the organization's charter, orders from higher management, as well as other rules and procedures established at the enterprise and consistent with the labor laws of the country.
Knowledge
According to the DI of the database administrator, he is obliged to know all acts of a legal nature, methodological information and standards related to information technology, computer technology, design, and development of computer-type systems.
He is obliged to know how the equipment provided to him by the organization to perform work works, what characteristics it has, in what modes it operates, and all the rules for using its technical features.
An employee must be able to use in practice various operating systems and software that are aimed at managing data, protecting it and preventing access to information without access from higher management.
The role and responsibilities of a database administrator include knowledge of data processing technology in a mechanized way. He must learn everything modern types information carriers, methods by which data is encoded, information standards of codes and ciphers, system software, as well as its use in practice.
In addition, the employee is required to have knowledge of economics, labor legislation, management activities and other rules governing his normal work in the company. The specialist must also know how to properly draw up technical documentation.
Functions
The duties of the administrator include the performance of certain functions by him:
- maintaining the relevance of information stored on the company's servers;
- database management, organization;
- comprehensive protection;
- checking the system and preventing its infection with viruses.
Also, among the functions of an employee, it is worth noting maintenance of the database, conducting training events on their operation for company employees, creating and maintaining an archive in which all software and other reference Information. Also, the employee must ensure the confidential storage of data, which makes it possible to create official, commercial and state secrets.
Responsibilities
In order to properly perform the functions assigned to an employee, he must perform certain duties of a database administrator, including carrying out activities aimed at optimizing the use of company information technology resources. To do this, he must use the configurations operating systems installed on the equipment of the organization, and the main characteristics of the database.
The duties of a database administrator include the development and implementation of software that allows information to be preserved and remain intact even in the event of hardware failures.
He is also obliged to keep records of all failures and malfunctions in the operation of the equipment, promptly report them to employees specializing in the restoration and elimination of problems of a similar nature, and in some cases independently carry out repair and restoration work.
Other responsibilities
The job responsibilities of a database administrator include maintenance, creation and preservation, backup of information, introduction of logs. file system. If necessary, the employee restores data, analyzes various departments of the company, makes his own adjustments and suggestions to the work and development of the software.
He is also obliged to offer management the modernization of technological support, to improve the management and storage of data, conduct training activities to improve the knowledge of other employees so that they can fully use the databases used in the company, give advice on his competent authority.
Rights
An employee has the right to make suggestions regarding the improvement of the conditions for fulfilling his duties as a database administrator, to request information that is necessary for him to work and is within his competence.
In addition, the administrator has the right to improve his qualifications, to require assistance from his superiors in the performance of his duties, if necessary. He also has the right to an equipped workplace and receive all necessary technical support to carry out their functions.
A responsibility
The administrator is responsible for the performance of his duties and in case of their incorrect or complete failure to perform, he may be held liable in accordance with the legislation of the country. He is also responsible for any violations of the laws of the country that he committed during the performance of his work. He can be held liable for causing material damage to the company.
AT modern world meaning information flows hard to overestimate. Information, one way or another, is systematized in databases that require qualified dispatching. At the same time, the value of technologies that allow not only competently compiling and managing information arrays, but also protecting them from unauthorized changes and cyberattacks is growing. We are talking about competent IT-administration. Due to the relevance of this topic in modern information society, it seems reasonable to cover this topic in more detail.
Database Administrator Tasks
The work of a database administrator implies the implementation of algorithms for the maintenance and dispatching of information arrays, which are databases. In fact, the functions of a database administrator are to ensure the smooth operation of equipment (usually servers) and networks, so that a continuous process of using the required information is ensured.
Although maintenance takes up most of the time, however, the duties of the administrator are not limited to this. Sometimes specialists are engaged in full-fledged database design, which means:
- block diagram design;
- requirements development;
- formulating regulations and access rights;
- definition with the format of accounts;
- elaboration of options for implementing protection against unauthorized entry;
- development of ways to prevent hardware errors and software failures to maintain the safety of data arrays.
Database Administrator Duties
The job description of a database administrator involves huge amount a variety of activities. However, not all possible functionality is always used. As a rule, the tasks of an administrator boil down to the following:
- Implementation Reserve copy information bases.
Such a backup should be carried out in accordance with the established frequency, so that in the event of a "collapse" it would be possible to quickly restore the system's performance and provide access to most of the information databases.
- Requires regular software updates.
Now even editing and maintaining the integrity of information arrays are engaged in computer programs. Thus, the administrator must be able to competently "conduct" this complex of service programs. The profession of a database administrator implies the presence of programming skills in different languages, understanding of the features of software services and knowledge of network protocols. In fact, the administrator must have the competence to independently write the utilities required in his work.
DBA Requirements
The professional standard database administrator requires the applicant to have a higher technical (and lately, even cybernetic) education. Only such a qualification will allow a specialist to design database models with high quality, thinking through its structure. More broadly, the duties to be performed by a network and database administrator can be summarized as follows:
- conducting an analysis of the needs for information dispatching of various divisions (divisions) at the enterprise;
- testing software products developed by adjacent structural divisions;
- the administrator is required to show initiative in the process of developing methods and algorithms for storage and technologies for using database information in order to increase the productivity and productivity of the results obtained;
- ensuring the functioning of methods of user interaction with databases.
DBA training
The database administrator, whose education should be predominantly technical, should, among other things, have the following knowledge and skills:
- ability to design, and most importantly, optimize database structures;
- understanding the ideology of different types of database architectures;
- high qualification in the implementation of algorithms that provide both internal security and counter attacks from outside;
- knowledge of programming languages, markup languages (for example, XML), modeling languages (for example, UML) as well as database query languages (such as SQL and others).
Database administrator courses
Currently, there are quite a few advanced training courses based on well-respected academic institutions that provide additional knowledge and skills for successful database administration. Training and retraining are carried out in the following specialties:
- database architect;
- development of models of information arrays;
- database administrator 1s;
- administration of the data storage process;
- database administrator microsoft sql;
- network administration.
database administrator salary
The work of the administrator of information arrays implies exclusively full-time employment. Even despite the economic crisis, the need for qualified personnel in the country is only growing. At the request "database administrator vacancies Moscow" you can get at least 200 open official vacancies that exist permanently. Since 2010, their number has doubled. (The fall was observed only in the first half of 2015).
In the regions, the situation, of course, is calmer, but even there there is a lack of competent personnel. In this regard, attention is drawn to the levels of salaries in this profession in mid-autumn 2017:
- In Moscow - cf. the salary of a database administrator is 110 thousand rubles; the maximum offer is 160 thousand rubles.
- According to St. Petersburg - cf. indicator - 77.5 thousand rubles; max indicator - 100 thousand rubles.
- By region - cf. - 40 thousand rubles; max - 75 thousand rubles
And of course, the value of a qualified workforce is determined by its current competence. So you should never neglect the acquisition of additional knowledge and skills.