OPPO高级SRE工程师
社招全职2-8年SOFTWARE地点：成都状态：招聘
任职要求
1.5年以上数据库运维工作经验，熟悉MySQL、PostgreSQL、MongoDB、Redis等至少两种数据库核心原理（如InnoDB存储引擎、主从复制、WAL日志、MVCC、B+树索引等） 2.熟悉常见的数据库高可用方案及工具，如MHA、Orchestrator、Patroni、Innodb Cluster等 3.有大规模、高并发环境下数据库架构设计及运维经验, 熟悉MySQL分库分表工具及原理，能针对业务场景设计合理的水平拆分策略，并解决跨库事务、分布式ID生成、全局一致性查询等核心问题 4.掌握shell、python、golang等编程语言，能通过编程提升运维工作效率 5.熟悉Linux操作系统、K8s及容器化技术，有云数据库（AWS/Azure/阿里云/腾讯云）运维经验更佳
工作职责
1.负责公司MySQL、Redis、MongoDB、PostgreSQL等数据库运维工作，保证系统7*24小时稳定运行 2.负责公司业务线数据库稳定高效运行，协助业务解决潜在的数据库风险，保障SLA达成 3.数据库架构设计：负责公司数据库高可用（HA）及容灾、读写分离、分库分表、分布式数据库等架构设计，确保系统稳定性和可扩展性 4.数据安全：实施数据库权限管理、审计、加密、防注入、备份恢复等安全策略，确保数据安全合规 5.性能优化：监控并优化SQL查询、索引、存储引擎配置，解决慢查询、死锁、高负载等问题，提升数据库响应速度 6.自动化运维：运用DevOPS/AIOPS技术提升运维效率，不断提升数据库运维工程化水平 7.新技术研究：跟踪云数据领域关键核心技术及行业动态，推动数据库架构升级
包括英文材料
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.
PostgreSQL+
[英文] PostgreSQL Tutorial
https://neon.com/postgresql/tutorial
This PostgreSQL tutorial helps you quickly understand PostgreSQL.
[英文] PostgreSQL Tutorial
https://www.pgtutorial.com/
This PostgreSQL tutorial will teach you about PostgreSQL from beginner to advanced.
https://www.youtube.com/watch?v=qw--VYLpxG4
It is the most advanced open source database system widely used to build back-end systems.
https://www.youtube.com/watch?v=SpfIwlAYaKk
Learn PostgreSQL, one of the world's most advanced and robust open-source relational database systems.
MongoDB+
https://learnxinyminutes.com/mongodb/
MongoDB is a NoSQL document database for high volume data storage.
https://studio3t.com/academy/#courses
The fastest way to learn MongoDB
https://www.youtube.com/watch?v=c2M-rlkkT5o
This video will give you and introduction to MongoDB in 1 Hour. Afterwards I recommend exploring aggregation, replication, and sharding.
https://www.youtube.com/watch?v=ExcRbA7fy_A&list=PL4cUxeGkcC9h77dJ-QJlwGlZlTd4ecZOA
You'll learn how to use MongoDB (a NoSQL database) from scratch. You'll also learn how to integrate it into a simple Node.js API.
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.
WAL+
https://adambcomer.com/blog/simple-database/wal/
To recover our data after the database restarts, we need our first layer of on-disk persistence, the WAL.
[英文] Write-Ahead Logging
https://sqlite.org/wal.html
The default method by which SQLite implements atomic commit and rollback is a rollback journal.
[英文] The Write-Ahead Log: The underrated Reliability Foundation for Databases and Distributed systems
https://www.architecture-weekly.com/p/the-write-ahead-log-a-foundation
I want to talk with you today about the Write-Ahead Log concept.
https://www.postgresql.org/docs/current/wal-intro.html
Write-Ahead Logging (WAL) is a standard method for ensuring data integrity.
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.
B+树+
[英文] B+ Trees
https://cs186berkeley.net/sp20/static/notes/n3-BTrees.pdf
An index is a data structure that helps speed up reads on a specific key.
https://planetscale.com/learn/courses/mysql-for-developers/indexes/b-trees?autoplay=1
B+ trees are the underlying data structure of most indexes in MySQL.
https://www.youtube.com/watch?v=CYKRMz8yzVU
This lecture introduces B+ tress, and is a topic of a course in database design and database management systems.
https://www.youtube.com/watch?v=K1a2Bk8NrYQ
B-trees are a popular data structure for storing large amounts of data, frequently seen in databases and file systems.
高可用+
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.
高并发+
https://www.baeldung.com/concurrency-principles-patterns
In this tutorial, we’ll discuss some of the design principles and patterns that have been established over time to build highly concurrent applications.
https://www.baeldung.com/java-concurrency
Handling concurrency in an application can be a tricky process with many potential pitfalls. A solid grasp of the fundamentals will go a long way to help minimize these issues.
https://www.oreilly.com/library/view/concurrency-in-go/9781491941294/
You’ll understand how Go chooses to model concurrency, what issues arise from this model, and how you can compose primitives within this model to solve problems.
https://www.oreilly.com/library/view/modern-concurrency-in/9781098165406/
With this book, you'll explore the transformative world of Java 21's key feature: virtual threads.
https://www.youtube.com/watch?v=qyM8Pi1KiiM
https://www.youtube.com/watch?v=wEsPL50Uiyo
系统设计+
https://roadmap.sh/system-design
Everything you need to know about designing large scale systems.
https://www.youtube.com/watch?v=F2FmTdLtb_4
This complete system design tutorial covers scalability, reliability, data handling, and high-level architecture with clear explanations, real-world examples, and practical strategies.
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.
Python+
https://liaoxuefeng.com/books/python/introduction/index.html
中文，免费，零起点，完整示例，基于最新的Python 3版本。
https://www.learnpython.org/
a free interactive Python tutorial for people who want to learn Python, fast.
https://www.youtube.com/watch?v=K5KVEU3aaeQ
Master Python from scratch 🚀 No fluff—just clear, practical coding skills to kickstart your journey!
https://www.youtube.com/watch?v=rfscVS0vtbw
This course will give you a full introduction into all of the core concepts in python.
Go+
https://www.youtube.com/watch?v=8uiZC0l4Ajw
学习Golang的完整教程！从开始到结束不到一个小时，包括如何在Go中构建API的完整演示。没有多余的内容，只有你需要知道的知识。
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
Kubernetes+
https://kubernetes.io/docs/tutorials/kubernetes-basics/
This tutorial provides a walkthrough of the basics of the Kubernetes cluster orchestration system.
https://kubernetes.io/zh-cn/docs/tutorials/kubernetes-basics/
本教程介绍 Kubernetes 集群编排系统的基础知识。每个模块包含关于 Kubernetes 主要特性和概念的一些背景信息，还包括一个在线教程供你学习。
https://www.youtube.com/watch?v=s_o8dwzRlu4
Hands-On Kubernetes Tutorial | Learn Kubernetes in 1 Hour - Kubernetes Course for Beginners
https://www.youtube.com/watch?v=X48VuDVv0do
Full Kubernetes Tutorial | Kubernetes Course | Hands-on course with a lot of demos
AWS+
https://aws.amazon.com/
Amazon Web Services offers reliable, scalable, and inexpensive cloud computing services. Free to join, pay only for what you use.
Azure+
https://azure.microsoft.com/
Invent with purpose, realize cost savings, and make your organization more efficient with Microsoft Azure’s open and flexible cloud computing platform.
相关职位
社招3-5年网易游戏（互娱）
1. 负责GitLab、SVN、Perforce等版本管理工具的日常维护，参与相关工具的二次开发和定制化功能开发。 2. 负责持续集成（CI）、持续交付（CD）流水线的设计、优化和自动化管理，推动DevOps最佳实践落地。 3. 参与并推动公司各类开发、测试工具链的集成与自动化流程建设，提升研发效率和交付质量。 4. 参与应用日志采集、监控与报警系统的搭建、维护和优化，保障系统稳定性与安全性。 5. 协助开发团队解决代码管理、分支合并、冲突解决等相关问题，提升团队协作效率。 6. 编写和维护相关技术文档，制定运维和开发流程规范，协助团队成员培训与技术支持。 7. 关注并评估业界新技术，推动运维体系的持续改进和创新。
更新于 2025-08-18
社招5年以上核心本地商业-基
系统可靠性设计与实施：设计和实施可靠、可扩展和高性能的系统架构，确保全球用户的无缝体验。 故障排除与应急响应：主导重大故障的指挥，组织各方有序处理，制定并实施应急预案，确保快速响应和问题解决。 跨团队协作：与开发、产品和运营团队紧密合作，持续提升交付效率和质量。 容量规划：进行容量规划和管理，优化资源利用率，降低成本。 国际化部署方案支持：规划和实施全球化的部署方案，确保各地区的系统一致性和高效运行。针对不同地域的网络环境和法规要求，优化系统架构和数据传输策略。
更新于 2025-06-10
社招5年以上TPG
-负责业务稳定性建设和可用性保障 -负责分布式平台性能和架构优化 -负责设计和实现运维自动化相关系统或工具 -负责业务架构向容器化迁移，提升业务变更和故障自愈能力 -研究与产品发展匹配的运维技术，不断提升资源和交付效率
更新于 2025-05-08
社招智能与信息技术
1. 负责理想汽车AI平台RDMA网络下大规模GPU集群和并行高速存储的运维工作，为业务平台的可用性负责 2. 调查解决大规模GPU集群管理和大规模AI训练情况下遇到的各种系统/稳定性问题，打造自动化，稳定，易于运维的高速网络和超算集群 3. 深入理解业务,推动AI平台在K8S多集群架构、监控平台、日志等方向的云原生架构演进并落地解决方案 4. 持续建设AI平台运维体系、在稳定性建设、故障定位、资源运营等方向，推动运维工作自动化、工程化