OPPO高级SRE工程师
社招全职2-8年SOFTWARE地点：成都状态：招聘
任职要求
1.5年以上数据库运维工作经验，熟悉MySQL、PostgreSQL、MongoDB、Redis等至少两种数据库核心原理（如InnoDB存储引擎、主从复制、WAL日志、MVCC、B+树索引等） 2.熟悉常见的数据库高可用方案及工具，如MHA、Orchestrator、Patroni、Innodb Cluster等 3.有大规模、高并发环境…
登录查看完整任职要求
微信扫码，1秒登录
工作职责
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.
还有更多 •••
相关职位
社招其他
1、负责支撑网易集团旗下云音乐、Loft、支付等互联网产品的运维工作（涵盖操作系统运维、系统运维、容器运维等多个层面的工作），帮助业务持续提升产品稳定性； 2、负责相关运维工具和平台研发，通过工具和平台将运维能力赋能给外部其他团队，帮助其他团队提升效率； 3、关注业界前沿技术动态，通过新的运维技术和方法解决线上问题，提升团队运维质量； 4、持续优化运维操作和流程，保障海量用户的互联网产品稳定运行。
更新于 2025-04-14杭州
社招3年以上A91599A
1、负责Sdwan网络的日常运维、监控和故障排除，及时响应并解决网络故障和性能问题； 2、构建和维护Sdwan网络的监控和告警系统，实现对网络状态的全面监控和预警； 3、开发和维护自动化运维工具和脚本，提高运维效率，减少人为错误，并负责编写和维护Sdwan网络相关的文档和知识库； 4、参与容量规划和性能测试，确保Sd-wan网络能够满足业务需求。
更新于 2025-01-08北京
社招3年以上技术类-开发
1、负责核心业务系统的Java开发工作，确保系统的稳定性和高性能。 2、参与需求分析，设计并实现高效、可扩展的代码结构，优化系统性能。 3、与团队协作，解决复杂的技术问题，推动项目进度。 4、对现有系统进行维护和优化，提升系统质量和用户体验。 5、参与技术分享，提升团队技术水平，推动技术栈的持续升级。
更新于 2025-04-18杭州
社招2年以上诚云科技
1、云产品稳定性保障，风险巡检 客户云产品稳定性、体验相关事项治理，产品风险巡检，故障的应急跟进与处理 2、客户技术专项处置与支持 复杂、疑难问题/技术方案/活动护航保障/产研共建专项主导与管理工作 3、排查问题，管控体验 高效排查解决产品技术售后问题，在服务过程中关注客户体验提升、有效管控客情 4、专精客户行业，技术沉淀 提炼客户行业技术服务方案，沉淀内部技术文档，持续提高公共云/混合云各行业最佳实践能力
更新于 2025-10-10西安|北京|杭州