职责描述：
1、精通主流关系型数据库（如 MySQL、Oracle、PostgreSQL）及 NoSQL（如 MongoDB、Redis）的安装、配置与优化。
Proficient in the installation, configuration, optimization of mainstream relational databases (such as MySQL,acle, PostgreSQL) NoSQL databases (such as MongoDB, Redis).
2、熟悉云数据库服务（如 AWS RDS、阿里云 PolarDB、腾讯云 TDSQL）的部署与运维。
2. Familiar with the deployment operation maintenance of cloud database services (such as AWS RDS, Alibaba Cloud PolarDB, Tencent Cloud TDSQL).
3、掌握容器化数据库（如 Docker、Kubernetes）的部署及云原生架构实践。
3. Master the deployment of containerized databases (such as Docker, Kubernetes) practices in cloud-native architecture.
4、能够通过慢查询日志、执行计划分析（EXPLAIN）优化 SQL 语句，合理设计索引与分表策略。
4. Capable of optimizing SQL statements through slow query logs execution plan analysis (EXPLAIN), reasonably designing indexing table sharding strategies.
5、熟练使用监控工具（如 Prometheus+Grafana、Zabbix、ELK）实时追踪数据库性能指标（CPU、内存、I/O、连接数）。
5. Skilled in using monitoring tools (such as Prometheus+Grafana, Zabbix, ELK) to track database performance indicators (CPU, memory, I/O, number of connections) in real-time.
6、熟悉参数调优（如 MySQL 的 InnoDB 缓冲池、Oracle 的 SGA/PGA 配置）。
6. Familiar with parameter tuning (such as InnoDB buffer pool in MySQL, SGA/PGA configuration inacle).
7、掌握主从复制（Master-Slave）、读写分离、集群方案（如 MySQL Cluster、Redis Sentinel）。
7. Master master-slave replication (Master-Slave), read-write separation, clustering solutions (such as MySQL Cluster, Redis Sentinel).
8、能设计跨可用区 / 跨云容灾方案，确保 RTO（恢复时间目标）和 RPO（恢复点目标）符合业务需求。
8. Able to design cross-availability zone /cross-cloud disaster recovery solutions to ensure that RTO (Recovery Time Objective) RPO (Recovery Point Objective) meet business requirements.
9、熟悉自动化故障切换工具（如 Keepalived、Pacemaker）。
9. Familiar with automated failover tools (such as Keepalived, Pacemaker).
10、能制定全量 / 增量备份策略，熟悉物理备份（如acle RMAN、MySQL 热备份）与逻辑备份（如 mysqldump、pg_dump）。
10. Able to formulate full /incremental backup strategies, familiar with physical backup (such asacle RMAN, MySQL hot backup) logical backup (such as mysqldump, pg_dump).
11、熟悉备份验证方法（如随机抽样恢复测试），确保数据可恢复性。
11. Familiar with backup verification methods (such as random sampling recovery tests) to ensure data recoverability.
12、精通 Linux（CentOS/Ubuntu）与 Windows Server 的安装、配置及优化，熟悉内核参数调优（如文件系统、网络协议栈）。
12. Proficient in the installation, configuration, optimization of Linux (CentOS/Ubuntu) Windows Server, familiar with kernel parameter tuning (such as file systems, network protocol stacks).
13、掌握 Shell/PowerShell 脚本编写，能自动化批量部署服务或修复系统问题。
13. Master the writing of Shell/PowerShell scripts, able to automatically deploy services in batches fix system issues.
14、熟练使用 VMware、KVM、Hyper-V 等虚拟化平台，具备资源调度与集群管理经验。
14. Skilled in using virtualization platforms such as VMware, KVM, Hyper-V, with experience in resource scheduling cluster management.
15、熟悉 Docker 容器编排（Kubernetes、Swarm），能配置防火墙（iptables、Windows Firewall）及负载均衡（HAProxy、Nginx）。
15. Familiar with Docker containerchestration (Kubernetes, Swarm), able to configure firewalls (iptables, Windows Firewall) load balancing (HAProxy, Nginx).
任职要求：
1、数据库安装与配置
Database Installation Configuration
1.1 安装数据库软件
1.1 Installing Database Software
选择适合的数据库系统，根据业务需求选择数据库类型
a suitable database system choose the database type according to business requirements
安装前的环境准备，系统资源评估，安全性设置预配置
Prepare the environment before installation, evaluate system resources, pre-configure security settings
执行安装程序，按照官方文档逐步安装
Execute the installation program install step by step in accordance with the official documentation
1.2 配置数据库参数
1.2 Configuring Database Parameters
内存与存储配置，根据数据量调整内存分配，设置存储路径与策略
Configure memory storage: adjust memory allocation according to data volume, set storage paths strategies
网络连接配置，配置数据库监听服务，设置防火墙规则
Configure network connections: set up database listening services configure firewall rules
1.3 用户权限配置
1.3 Configuring User Permissions
创建数据库用户，分配权限与角色
database users assign permissions roles
2、数据库维护与优化
2. Database Maintenance Optimization
2.1 日常备份与恢复
2.1 Daily Backup Recovery
制定备份策略，全量备份与增量备份结合，定期执行备份任务
Formulate backup strategies: combine full backup incremental backup, execute backup tasks regularly
备份文件存储与管理，备份文件命名与存储位置，备份文件有效期管理
Store manage backup files: manage the naming, storage location, validity period of backup files
数据恢复演练，模拟数据丢失场景，执行恢复操作并验证
Conduct data recovery drills: simulate data loss scenarios, perform recovery operations, verify the results
2.2 性能监控与优化
2.2 Performance Monitoring Optimization
监控数据库性能指标，CPU 与内存使用率，I/O 读写速率
Monitdatabase performance indicators: CPU memory usage, I/O read write rates
分析性能瓶颈，慢查询日志分析，索引使用情况评估
Analyze performance bottlenecks: analyze slow query logs evaluate index usage
执行优化措施，调整 SQL 语句，增加或优化索引
Implement optimization measures: adjust SQL statements, add optimize indexes
3、数据库安全管理
3. Database Security Management
3.1 用户访问控制
3.1 User Access Control
实施*小权限原则，仅授予必要权限，定期审查权限分配
Implement the principle of least privilege: only grant necessary permissions review permission assignments regularly
密码策略管理，强制密码复杂度，定期更换密码
Manage password policies: enforce password complexity require regular password changes
3.2 数据加密与审计
3.2 Data Encryption Auditing
敏感数据加密存储，使用透明数据加密技术，加密密钥管理
Encrypt sensitive data storage: use transparent data encryption technology manage encryption keys
数据库操作审计，记录所有数据库操作，定期审查审计日志
Audit database operations: record all database operations review audit logs regularly
3.3 防止 SQL 注入攻击
3.3 Prevention of SQL Injection Attacks
输入验证与过滤，对用户输入进行严格验证，使用预编译语句
Perform input validation filtering: strictly validate user input use prepared statements
定期安全扫描与漏洞修复，使用自动化工具扫描漏洞，及时修复已知漏洞
Conduct regular security scans vulnerability fixes: use automated tools to scan fvulnerabilities fix known vulnerabilities in a timely manner
4、数据库升级与迁移
4. Database Upgrade Migration
4.1 规划升级路径
4.1 Planning the Upgrade Path
评估新版本特性与兼容性，分析新版本功能改进，测试新版本与现有系统的兼容性
Evaluate new version features compatibility: analyze functional improvements of the new version test its compatibility with existing systems
制定升级计划与时间表，明确升级步骤与责任人，安排非业务高峰期进行升级
Formulate an upgrade plan schedule: clarify upgrade steps responsible persons, arrange upgrades during non-peak business hours
4.2 执行升级操作
4.2 Executing the Upgrade Operation
备份现有数据库，执行全量备份，验证备份文件完整性
Back up the existing database: perform a full backup verify the integrity of backup files
安装新版本软件，按照官方文档安装新版本
Install the new version software: install the new version according to the official documentation
迁移数据与配置，导入备份数据，调整新版本配置参数
Migrate data configurations: import backup data adjust configuration parameters fthe new version
4.3 升级后验证与测试
4.3 Post-Upgrade Verification Testing
功能验证，检查所有业务功能是否正常
Verify functions: check whether all business functions work normally
性能测试，对比升级前后性能指标
Conduct performance tests: compare performance indicators before after the upgrade
用户反馈收集与处理，收集用户反馈意见，处理用户遇到的问题
Collect handle user feedback: gather user opinions address problems encountered by users
5、兼任服务器管理
5. Concurrent Server Management
5.1 服务器硬件管理
5.1 Server Hardware Management
5.2 操作系统管理
5.2 Operating System Management
执行操作系统安全补丁更新
operating system security patches
维护用户账户权限
Maintain user account permissions
配置和管理 SSH/TLS 等安全协议
Configure manage security protocols such as SSH/TLS
5.3 虚拟化平台运维
5.3 Virtualization Platform Operation Maintenance
调整虚拟机资源分配
Adjust virtual machine resource allocation
部署和更新容器化应用
Deploy containerized applications
5.4 安全防护体系
5.4 Security Protection System
处理入侵检测告警
Handle intrusion detection alerts
执行漏洞扫描并修复
Perform vulnerability scans fixes
维护防火墙规则，管理安全组策略
Maintain firewall rules manage security group policies
5.5 机房基础设施维护
5.5 Computer Room Infrastructure Maintenance
机房巡检
Conduct computer room inspections
管理网络布线，维护配线架标识
Manage network cabling maintain patch panel labels
资产台账更新，记录设备变更情况
asset ledgers record equipment changes
More
