IT Operations & Maintenance Engineer- DBA

1. Responsible for performing local database management and promotion

1. Responsible for building relevant systems and database high availability platforms according to business needs

1. Responsible for daily monitoring and management of various business system databases

1. Responsible for performing database troubleshooting and performance optimization

1. Responsible for performing database migration, upgrade, and vulnerability repair

6.Responsible for local disaster recovery platform construction, backup resource management, information systems data backup and recovery

1. Responsible for local information systems disaster recovery drills

1. Responsible for local information system security audit coordination and support.

Qualifications: Bachelor’s degree or higher in Computer Science, Information Technology, or related fields. Minimum of 3 years of hands-on experience in database administration (PostgreSQL, GaussDB, MySQL, or similar), Experience managing TB-level databases is preferred. Familiar with common database principles and kernels, proficient in single machine, primary and backup, cluster installation and deployment of common databases Familiar with the syntax rules of common databases and able to perform basic SQL statement optimization Able to perform database related operations such as general tables, indexes, foreign keys, triggers, custom functions, etc Proficient in backing up, restoring, patching, upgrading, read-write separation and other related operations for databases such as PostgreSQL, GaussDB, MySQL, etc Familiar with Linux operating system and server/storage management Capable of writing basic operation and maintenance scripts Familiar with backup and disaster recovery systems and services, proficient in at least one mainstream backup software/system, familiar with common backup software/system, and have relevant management and maintenance experience Have good team spirit, cross departmental communication and coordination skills, can think independently, and has the ability to quickly absorb new knowledge