DevOps Engineer (DBA)
运维工程师(数据库管理)
Main Responsibility主要工作职责
· Administration of server database cluster. Ensure the service is available 7 x 24h.
管理各业务数据库服务器高可用集群,保障服务稳定7×24可用。
· Establish and maintain database high availability cluster monitoring and backup recover mechanism. Improve operation quality.
建立和维护数据库高可用集群监控和备份恢复机制,提高服务运行质量。
· Responsible for database system's stability, high efficiency and security. Support information architecture design together with system architect.
负责维护数据库系统的稳定、高效、安全运行,参与数据架构规划设计。
· Responsible for finding the root cause of database error on time and keeping improving current database system performance.
负责及时排除数据库故障,并对数据库进行持续性能优化。
· Support database development and auditing.
支撑数据库开发支持和审计
Qualification任职要求
· At least 3 years of working experience as MySQL Database Administrator. Familiar with Innodb, MyISAM engine and related optimization strategy.
三年以上MySQL DBA实际工作经验,熟悉Innodb、MyISAM引擎以及相关优化策略
· Familiar with MySQL master/slave copy, master/master copy, MySQL Cluster, master-a/b, multiple master with multiple slaves and etc.
熟悉MySQL主从复制、主主复制,MySQL Cluster,两主一从,多主多从等
· Familiar with No-SQL, such as Hbase, Memcached, Redis and etc., and other high availability technical solutions.
熟悉No-SQL技术(Hbase、Memcached或Redis等)了解相关高可用技术方案
· Familiar with Linux/Unix. Have at least one coding language ability:
Perl/PHP/Python/Shell.
熟悉Linux/Unix操作系统,有以上系统Perl/PHP/Python/Shell一种或多种脚本语言编程能力
· Familiar with Oracle operation mechanism and daily management (including backup and recover, error handling, performance improvement) will be a plus.
熟悉Oracle运行机制及日常管理维护优先(包括备份与恢复、故障处理、性能优化等)
· Have experience in database auditing.
有数据库审计经验