Database administrator

Welcome to my “Database administrator.” 

The database administrator is the person responsible for developing database requirements, designing, implementing, efficiently using and maintaining it [1], including managing database user accounts and protecting against unauthorized access. An equally important function of the database administrator is to maintain the integrity of the database.https://www.blogger.com

The main tasks of the database administrator [edit | edit the code]

Database design.

Optimizing database performance.

Providing security in the database.

Backup and Restore the database.

Ensuring the integrity of databases.

Providing the transition to a new version of the DBMS.

According to the current standard, for the Database Administrator, tasks and job responsibilities are determined, depending on the skill level, from the following list.

Maintenance of functioning of a DB

Backing up the database

Database recovery

Controlling access to the database

Installation and configuration of software (software) to ensure the operation of users from the database

Installation and configuration of software for database administration

Monitoring of events that occur during the operation of the database

Logging of events that occur during the operation of the database

Optimizing the functioning of the database

Monitoring the operation of the database, collecting statistical information about the operation of the database

Optimization of the distribution of computing resources interacting with the database

Optimizing database performance

Optimization of the components of the computer network interacting with the database

Optimizing the execution of database queries

Optimization of life-cycle management of data stored in the database

Preventing data loss and corruption

Development of database backup rules

Monitoring the execution of the backup schedule

Development of a database backup strategy

Development of database recovery rules

Development of automatic procedures for creating backup copies of the database

Carrying out the procedure for data recovery after a failure

Control of compliance with the recovery schedule

Analysis of failures in the operation of the database and identification of their causes

Development of methodological instructions for database maintenance

Monitoring of the software and hardware of the database

Configuring the software and hardware of the database

Preparation of proposals for upgrading software and hardware database support

Forecasting and assessing the risks of database failures

Development of automatic procedures for hot backup of databases

Performing procedures for entering hot-swap resources in working mode

Preparation of reports on the functioning of the database

Advising users during the operation of the database

Preparation of proposals for staff development

Ensuring information security at the database level

Development of an information security policy at the database level

Monitoring compliance with regulations on security at the database level

Optimizing the performance of security systems to reduce the workload of the database

Development of regulations and audit of the data security system

Preparation of reports on the state and effectiveness of the security system at the database level

Development of automated procedures for detecting attempts of unauthorized access to data

Management of database development

Analysis of system problems of information processing at the database level, preparation of proposals for the future development of the database.

Development of regulations for updating software versions of the database.

Development of regulations for migration of databases to new platforms and new versions of the software.

Studying, mastering, and introduction in the practice of administration of new technologies for working with databases

Control of updating of versions of a DB

Monitoring database migration to new platforms and new versions of the software

Planning organizational structure of the unit and development of human resources.

Database Administrator

Mytishchi Machine-Building Plant, Moscow

By agreement

Official duties

Implementation of administration and support of database operation Mastering and implementing new information technologies, improving the quality of database operation Implementing a database backup and recovery strategy; Database management.

Requirements

Experience in administration and working with SQL Server 2005 \ 2008/2012 at least 5 years; The experience of the DB architect is no less than 4 years; Experience in optimizing someone else's code, identifying bottlenecks in the system; The experience of compiling and optimizing SQL queries. Skills in the application of analytical functions,

Oracle Database Administrator

MegaFon, Moscow

By agreement

Official duties

Operational and operational development of databases, oriented to real-time transactions; Ensuring the uninterrupted operation of databases in 24/7 mode; Analysis of the level of load on the system and the needs for hardware and software.

Requirements

Higher technical education (preferably in the field of computer technology); Work experience in the field of information technology is not less than three years; Expert knowledge of the principles of operation and organization of Oracle DBMS (knowledge of MS SQL will be a plus); Practical work experience.

SQL database administrator

World Trade Center, Moscow

By agreement

Official duties

Administration, technical support and finalization of the personnel accounting system "Boss-Kadyrov".

Requirements

Higher education (technical) Programming skills Knowledge of MS SQL, including writing SQL queries and relational theory without data Knowledge of the basics of OOP, VBScript, JScript (preferably) Skills for writing technical documentation and instructions for the user.

Information Technology Specialist (Database Administrator)

Crocus Group, Moscow

By agreement

Official duties

Administration of databases (MS SQL, Oracle) IT services (1C, ERMS, ERP); solving problems with locks, optimizing performance; Participation in projects for the implementation of new IT services; analysis of performance, increasing the speed of current databases.

Requirements

Higher education; experience of 3 years on a similar position (MS SQL, Oracle, 1C, ERMS, ERP, cluster solutions); experience in configuring and administering fault-tolerant systems (Always On); knowledge of tools for Oracle database administration, monitoring.