Basic duties of database administrator 1
accountability
1, responsible for the operation and maintenance management of the database management system, completing basic work such as database installation, monitoring, backup, testing and recovery, and ensuring the stability, security and high performance of the database management system;
2. Monitor the early warning log of the database, and regularly review, archive and delete the backup;
3. Monitor the daily conversation of the database, discover the abnormal conversation process in time and actively take effective measures to solve it, so as not to affect the business operation;
4. Monitor the fragmentation and remaining table space of the database, grasp the expansion speed of table space and the distribution of remaining space in time, dynamically adjust the storage scheme of the database according to changes, and optimize the use of resources; If necessary, make a storage medium expansion plan and future storage demand plan in advance;
5. Pay attention to the SQL Server version upgrade information and SQL Server-related vulnerability patch information of the database management system, implement the SQL Server version upgrade and patch trap in the production environment without affecting the business operation in the test environment, and monitor and log review the whole upgrade trap process to confirm that the upgrade trap is really successful;
6. Make a database backup plan, make data recovery requirements in the disaster recovery plan, and conduct regular drills to ensure the effective recovery of database data in case of disaster;
7. We should change the backup strategy of the database according to the business needs and actual situation, monitor the daily backup operation of the database and confirm the status, verify the backup data of the database and maintain the media storage management, and keep in touch and communicate with the database design manufacturers;
8. Formulate database user management requirements, establish database bottom results and access models, and formulate database performance monitoring standards and indicators; Unified management of any changes to database objects through the database management system;
9. Use SQL statements to manage, maintain and optimize the database;
10. When it is found that different users' requirements conflict with each other, resulting in process deadlock, assist relevant personnel to coordinate user requirements and cooperate with database designers of application systems to rationally allocate system resources;
1 1, responsible for the approval of management users of the database management system and the corresponding management authority setting, and taking measures to prevent the database from being accessed and destroyed without authorization;
12. Assist relevant departments to complete U9 system project implementation and application upgrade and wood management software system project implementation and application upgrade with relevant posts;
13. Complete related tasks assigned by the manager of the information department and assist all departments of the company to complete related work;
job requirement
1, bachelor degree or above, major in computer, with professional computer application knowledge, regardless of age or sex, with SQL Server certification (MCSA) is preferred;
2. Familiar with data backup/data recovery under SQL Server database platform, understand database performance monitoring and optimization, master SQL coding, have a certain understanding of database security, understand database design, index design, index maintenance and query engine, and understand capacity monitoring and planning;
3. Clear thinking and excellent communication and understanding skills; Strong logical calculation and hands-on ability, independent working ability, able to work under great pressure;
Description of Basic Responsibilities of Database Administrator II
Responsibilities:
1. Responsible for the formulation and implementation of disaster recovery schemes such as database installation and configuration, performance monitoring and optimization, fault diagnosis and elimination, data migration, database backup, replication and mirroring, as well as database security management and account authority management;
2. Maintain the safe and stable operation of online business core database 7*24;
3. Be responsible for the planning, evaluation and implementation of database architecture, and realize a highly available and extensible architecture;
4. Familiar with the operating mechanism and architecture of MySQL, proficient in/familiar with SQL, and familiar with database design and optimization;
5. Analyze and mine the new contents in the database;
Requirements:
1. Familiar with database management tools, such as Navicat and other lightweight management tools;
2. Skillful use of database related tools such as MySql and Oracle;
3. Participate in the development and implementation of MYSQL script management, SQL Advisor, data quality management and other tools and platforms;
4. Be familiar with at least one development language in java or Python.
Description of Basic Responsibilities of Database Administrator 3
Responsibilities:
1, responsible for the daily operation monitoring, management and performance analysis of the company's database, as well as troubleshooting and optimization.
2. Quickly handle and solve the faults and problems in the operation of the database system to ensure the security and availability of business data;
3. Responsible for the daily operation and maintenance, backup and recovery, upgrade and optimization, extended migration and security management of Oracle database;
4. Provide technical support services related to Oracle database for the architecture/development team, including object design, SQL writing specification formulation, guidance, audit, etc.
5. Responsible for the planning and design of Oracle database platform architecture and high availability scheme, and make corresponding capacity planning by analyzing the business development trend;
6. Responsible for business data analysis and mining, performance analysis and system optimization, problem tracking and management of Oracle database;
7. Responsible for the deployment, monitoring and optimization of system software and hardware, including the optimization of JVM, middleware and underlying hardware devices;
8. Write and maintain database design documents related to work;
Requirements:
1, bachelor degree in computer or related major, more than 5 years experience in ORACLE database maintenance and optimization;
2. Experience in database planning, design and optimization of large-scale online trading systems and enterprise application systems (such as ERP, SRM and WMS);
3. Skillfully install and build database servers, cluster systems and dual-machine hot standby, including SQL Server and Oracle.
4. Proficient in the principle and operation mechanism of Oracle database, with rich experience in management and tuning;
5. Proficient in RAC, Data Guard, OGG configuration management and troubleshooting;
6. Familiar with database operation and maintenance in linux and AIX environment; Familiar with VERITAS SF file system;
7. Proficient in Oracle database 1 1g/ 12c sub-database, sub-table, SQL parsing, data routing, etc.
8. Integrity, strong sense of responsibility, good communication and interpersonal skills, and good team spirit;
9. Hold OCP certificate;
10, Ansible, python experience or OCM certificate is preferred.
Description of Basic Responsibilities of Database Administrator 4
Responsibilities:
1, responsible for the company's database architecture planning, capacity planning and system tuning;
2. Responsible for the daily operation and maintenance of the database, fault handling, backup and recovery, performance tuning and patch upgrade, etc.
3. Plan, design, review and optimize the database design scheme;
4. Cooperate with R&D to formulate database technical scheme, database and table sharing strategy and data migration scheme;
5. Guide developers to complete database modeling, database index optimization and database operation statement optimization;
Requirements:
1, bachelor degree or above in computer related major;
2. More than five years of DBA related experience;
3. Proficient in the installation and deployment, development and maintenance, management and performance tuning of MySQL database under Linux;
4. Familiar with MySQL storage engine InnoDB, able to optimize the analysis/design of SQL statements and separation of reading and writing, and have experience in maintaining separation of reading and writing under high concurrency. ;
5. Familiar with MySQL transactions and locks, able to analyze and optimize locks;
6. Familiar with at least two other relational databases SQL Server/Oracle/PostgreSQL;
7. Familiar with the concept and process of ETL, and have some experience in developing stored procedures or ETL;
8. Familiar with Linux, with experience in scripting and automation; Master at least one scripting language (Shell, Python, Perl);
9. Familiar with java developers is preferred.
10, familiar with NoSql is preferred.
Description of Basic Responsibilities of Database Administrator's Work 5
Responsibilities:
1, responsible for database planning, deployment, optimization and troubleshooting of system databases (mainly Oracle and Mysql); Daily operation, maintenance and management;
2. Responsible for the storage planning and management of the database, and assist the system planning and design, installation and debugging, troubleshooting, installation, configuration, upgrade and migration of network security equipment such as firewalls;
3. Responsible for the formulation and implementation of the company's project data backup strategy and other related information security work;
4, responsible for the formulation and implementation of database backup and recovery strategy;
5. Responsible for database monitoring, performance check and optimization;
6. Be responsible for diagnosing, detecting and solving any database-related problems, and cooperate with other database-related management and maintenance.
7. Cooperate with developers and other project teams to provide daily technical support, troubleshooting and system maintenance.
Qualifications:
1, familiar with database structure design, and have a good understanding of system architecture and database theory;
2. Familiar with Oracle or Mysql database architecture and performance optimization;
3. Familiar with the principle of SQL optimization and have good SQL optimization ability;
4. Familiar with one or more mainstream UNIX/LINUX systems;