Responsibilities:ac
Contract Duration - 12 months
- Responsible for Database(mysql) and Middleware(Redis/Kafka/ElasticSearch) management support and backup/restoration.
- Responsible for Database(mysql) and Middleware(Redis/Kafka/ElasticSearch) trouble shooting and optimization.
- Responsible for the password and permission management of Database(mysql) and Middleware(Redis/Kafka/ElasticSearch) .
- Responsible for data migration projects, infra enhancement and solution architecture.
- Responsible for designing and enforcing DBA procedures, standards and rules.
Requirements:
- Proficient in how MS SQL/Mariadb/Oracle Database works and familiar with the differences between different Database versions.
- Participate in the 24/7 rotational shift including weekends.
- Experience in developing and executing database security policies, procedures
- Must take initiatives to automate manual Database work
- Proficient in analyzing MSSQL statement performance, designing and implementing indexing and table sharding;
- Familiar with non-structural databases such as MongoDB and Elasticsearch and hands-on skills for performance tuning.
- Experience in operating Alibaba Cloud database products is preferred, and experience in using AWS database products is preferred.
- Familiar with Linux and scripting languages such as Shell or Python.
- Strong experience of backups, restores, recovery models, database shrink operations, DBCC commands
- Have security awareness of database operation and management.
