老虎国际DBA工程师
社招全职3年以上互联网 / 电子 / 网游地点:北京状态:招聘
任职要求
必须项: - 3 年以上 MySQL 生产环境运维经验,精通 InnoDB 引擎机制(事务、锁、MVCC、日志、Buffer Pool); - 熟练掌握 MySQL 主从复制、GTID、MHA / Orchestrator / InnoDB Cluster 等高可用方案; - 能独立完成慢查询分析、执行计划解读、索引优化、参数调优; - 有 Redis 运维经验,理解持久化、淘汰策略、集群分片、缓存穿透/雪崩应对; - 熟悉至少一种消息队列(Kafka 或 RabbitMQ),了解其架构、运维要点与常见故障; - 熟练使用 Linux 系统,能排查 IO、内存、网络、进程等系统级问题; - 熟悉 Shell/Python 至少一种,能编写自动化运维脚本; - 强烈的问题驱动型人格 —— 看…
登录查看完整任职要求
微信扫码,1秒登录
工作职责
- 负责公司核心 MySQL 集群的部署、监控、备份、扩容、高可用架构设计与日常运维; - 快速定位并解决线上 MySQL 性能瓶颈、慢查询、锁冲突、主从延迟、复制异常等复杂问题; - 深度优化 SQL 与索引,参与数据库设计评审,推动开发写出“不炸库”的 SQL; - 运维 Redis 集群(主从、哨兵、Cluster),保障缓存高可用与数据一致性; - 熟悉 Kafka / RabbitMQ 等消息中间件,能排查消息积压、消费异常、集群故障等运维问题; - 编写自动化脚本(Shell/Python/Go),提升数据库部署、巡检、故障自愈效率; - 参与数据库容量规划、灾备演练、压测方案设计,保障业务 7x24 稳定运行; - 对线上突发数据库故障能快速响应、冷静处理、复盘改进,形成知识沉淀; - 保持对数据库新技术的好奇心,主动研究源码、内核机制、性能调优技巧,乐于分享。 我们希望你: - 不满足于“重启解决” —— 你渴望知道“为什么”; - 不止步于“能用就行” —— 你追求“最优解”; - 不害怕“半夜告警” —— 你享受“手起刀落修复问题”的快感; - 对数据库有“洁癖” —— 看到烂 SQL 会手痒,看到无索引查询会心痛; - 是个“技术侦探” —— 从一堆日志里抽丝剥茧,还原故障现场让你兴奋。 我们提供: - 与业内顶尖架构师、SRE、开发团队协作的机会; - 深度参与千万级/亿级用户规模数据库架构演进; - 鼓励技术钻研、源码阅读、参加行业会议、发表技术文章; - 有竞争力的薪酬 + 年终奖 + 股权激励(视职级); - 弹性工作制 + 不鼓励无效加班 + 故障复盘不甩锅文化;
包括英文材料
MySQL+
https://juejin.cn/post/7190306988939542585
这是一篇 MySQL 通关一篇过硬核经验学习路线,包括数据库相关知识,SQL语句的使用,数据库约束,设计等。
[英文] MySQL Tutorial
https://www.mysqltutorial.org/
your go-to resource for mastering MySQL in a fast, easy, and enjoyable way.
https://www.youtube.com/watch?v=5OdVJbNCSso
MySQL SQL tutorial for beginners
https://www.youtube.com/watch?v=7S_tz1z_5bA
This beginner-friendly course teaches you SQL from scratch.
MVCC+
https://15445.courses.cs.cmu.edu/spring2023/notes/18-multiversioning.pdf
Multi-Version Concurrency Control (MVCC) is a larger concept than just a concurrency control protocol.
https://celerdata.com/glossary/multiversion-concurrency-control
Multiversion Concurrency Control (MVCC) is a method used by databases to manage concurrent access to data.
https://www.postgresql.org/docs/current/mvcc-intro.html
PostgreSQL provides a rich set of tools for developers to manage concurrent access to data.
https://www.youtube.com/watch?v=iM71d2krbS4
it's actually a simple database management technique that allows users to read rows in a database table while the record is also being updated.
高可用+
https://redis.io/blog/high-availability-architecture/
A high available architecture is when there are a number of different components, modules, or services that work together to maintain optimal performance, irrespective of peak-time loads.
https://www.ibm.com/think/topics/high-availability
High availability (HA) is a term that refers to a system’s ability to be accessible and reliable close to 100% of the time.
Redis+
[英文] Developer Hub
https://redis.io/dev/
Get all the tutorials, learning paths, and more you need to start building—fast.
https://www.runoob.com/redis/redis-tutorial.html
REmote DIctionary Server(Redis) 是一个由 Salvatore Sanfilippo 写的 key-value 存储系统,是跨平台的非关系型数据库。
https://www.youtube.com/watch?v=jgpVdJB2sKQ
In this video I will be covering Redis in depth from how to install it, what commands you can use, all the way to how to use it in a real world project.
缓存+
https://hackernoon.com/the-system-design-cheat-sheet-cache
The cache is a layer that stores a subset of data, typically the most frequently accessed or essential information, in a location quicker to access than its primary storage location.
https://www.youtube.com/watch?v=bP4BeUjNkXc
Caching strategies, Distributed Caching, Eviction Policies, Write-Through Cache and Least Recently Used (LRU) cache are all important terms when it comes to designing an efficient system with a caching layer.
https://www.youtube.com/watch?v=dGAgxozNWFE
消息队列+
https://www.youtube.com/watch?v=xErwDaOc-Gs
Kafka+
https://developer.confluent.io/what-is-apache-kafka/
https://www.youtube.com/watch?v=CU44hKLMg7k
https://www.youtube.com/watch?v=j4bqyAMMb7o&list=PLa7VYi0yPIH0KbnJQcMv5N9iW8HkZHztH
In this Apache Kafka fundamentals course, we introduce you to the basic Apache Kafka elements and APIs, as well as the broader Kafka ecosystem.
RabbitMQ+
[英文] RabbitMQ Tutorials
https://www.rabbitmq.com/tutorials
These tutorials cover the basics of creating messaging applications using RabbitMQ.
https://www.youtube.com/watch?v=bfVddTJNiAw
RabbitMQ is a powerful message broker that can help you create resilient and scalable applications.
Linux+
https://ryanstutorials.net/linuxtutorial/
Ok, so you want to learn how to use the Bash command line interface (terminal) on Unix/Linux.
https://ubuntu.com/tutorials/command-line-for-beginners
The Linux command line is a text interface to your computer.
https://www.youtube.com/watch?v=6WatcfENsOU
In this Linux crash course, you will learn the fundamental skills and tools you need to become a proficient Linux system administrator.
https://www.youtube.com/watch?v=v392lEyM29A
Never fear the command line again, make it fear you.
https://www.youtube.com/watch?v=ZtqBQ68cfJc
Bash+
[英文] The Bash Guide
https://guide.bash.academy/
A quality-driven guide through the shell's many features.
https://www.youtube.com/watch?v=tK9Oc6AEnR4
Understanding how to use bash scripting will enhance your productivity by automating tasks, streamlining processes, and making your workflow more efficient.
还有更多 •••
相关职位
社招3年以上
岗位职责: 1.负责数据库系统部署、方案规划、设计和实施; 2.负责日常数据库管理、监控、问题分析、性能调优、故障诊断与排除等; 3.负责规划变更方案,主导和实施各类数据库变更; 4.负责数据库备份、恢复、灾备实施,保证数据安全; 5.负责提供开发、运维相关的数据库技术支持
更新于 2025-10-28深圳
社招1年以上A210207
1、保证业务对MySQL、Redis、ES等各类SQL、NoSQL数据库的正确使用和稳定可靠运行; 2、深入理解业务,系统性地进行数据库优化和风险治理; 3、进行数据库的故障发现、定位、止损能力建设,提升数据库异常恢复速度; 4、深入理解数据库的成本结构,优化数据库使用率和资源成本; 5、参与相关自动化工具平台的设计和开发。
更新于 2025-04-01北京

社招3年以上
1.维护数据库稳定运行(MySQL, Redis) 2.负责数据库自动化运维平台建设 3.现有数据库分库分表扩容改造、架构设计,提升业务数据库容量和容灾能力 4.负责数据库开发规范制定、落实 5.日常开发数据库支持,表结构设计优化,慢SQL优化等等
更新于 2024-02-22杭州