首页 > Oracle DBA > Oracle DBA工作内容

Oracle DBA工作内容

砖石国际_[官网首页]Oracle DBA做什么的?通过真实的招聘信息了解Oracle DBA工作内容,掌握企业对Oracle DBA的要求。同时该职位有254条工资、44条面试,更全面了解Oracle DBA工作职责。

254条工资 |44条面试

Oracle DBA工作职责

1.负责项目生产数据库巡检,故障处理、安全管理与日常维护,保障可用性; 2.负责线上业务数据库进行监控、管理和维护,具有良好的排查问题的能力; 3.配合开发部门查询统计数据、优化审核SQL、规范代码编写; 4.负责项目数据库备份和恢复的执行、有限性检查与测试; 5.负责跟踪、支持及数据库变更管理、对业务运行状态、性能进行监控; 6.熟练HP-UX/Linux系统平台上数据库的维护管理; 7.具有良好的客户沟通能力,良好的技术方案报告汇总能力。

查看全文

企业对Oracle DBA要求

以下内容来自看准网企业对Oracle DBA的职责要求

要求A

任职资格:
1.熟悉Oracle数据库软件的安装配置,升级.
2.熟悉Oracle体系架构和内部原理.
3.熟悉编写SQL和存储过程、触发器、视图等.
4.熟悉Oracle数据库日常监控.
5.熟悉管理维护Oracle表空间及数据库文件.
6.熟悉数据库备份、恢复和故障处理.
7.熟悉SQL优化,对索引、执行计划有深入理解.
8.严格遵守变更流程,确保不因变更操作而导致数据库停机或异常.
岗位职责:
1.要求有全面运维工作经验.
2.实施Oracle 数据库方案策划.
3.配合部门查询统计数据.
4.优化审核SQL,规范代码编写
5.监控数据库,维护数据一致性.
6.数据库扩容,架构调整.
7.各操作系统基本服务搭建维护.
8.有Oracle RAC集群、SQL优化经验者优先.

要求B

岗位职责:
1) 负责数据库的规划、安装、配置与运维,保证数据库稳定高效运行;
2)负责日常数据库管理、监控、分析、性能调优、故障诊断与排除等;
3) 制定数据库升级、补丁、迁移以及优化方案并实施;
4)支持开发和测试,提供必要的咨询建议。


任职要求:
1) 三年以上oracle数据库管理经验,熟练数据库体系结构;
2) 熟练oracle RAC、DG的安装、维护和故障排除;
3)能够熟练使用性能分析工具优化数据库;
4)可独立编写脚本、制定数据库备份、迁移策略,实现对数据库日常维护的自动化;
5) 熟悉各种Unix/Linux平台的使用。

要求C

Has a minimum of 2 years of experience in Oracle Database management. Will manage and perform standard maintenance, monitoring, and tuning of numerous Oracle production database instance. Has worked with 10g, and 11g.

  • Support existing databases while assuring optimized performance, stability and uptime.
  • Demonstrated experience in working on Root Cause Analysis for oracle database issues.
  • Tune and trouble-shoot Oracle 10g and 11g databases.
  • Assess databases to assist in troubleshooting and performance tuning
  • Understanding of database internals.
  • Database and SQL tuning skills with hands-on experience in large and busy environments.
  • Demonstrated problem solving abilities and initiative.
  • Support 10g/11g installations.
  • Support 10g/11g upgrades.
  • Unix skills required, preferably Solaris and Linux flavors. Proven experience with command-line database tools (SQL*Plus, PL/SQL) and UNIX (Perl, Shell) required.
  • Ability to provide reliable technical support and guidance on site issues in a high velocity and dynamic environment.
  • Flexible, adaptable and able to manage multiple tasks in a dynamic environment.
  • Ability to communicate complex technical concepts clearly to peers and management.
  • Expected to work well within a team and take ownership of on-going responsibilities and RCAs.
  • Present DDL/DML changes successfully to high concurrency databases while preserving uptime and efficiency.

Skills Required:

  • Minimum 2 years’ experience as Oracle DBA
  • Minimum of 2 years’ experience with administering and supporting databases on 11g on Solaris Platform.
  • Knowledge of database performance tuning and troubleshooting.
  • Knowledge of database internals and data structures.
  • Knowledge of SQL and PL/SQL
  • Knowledge of Unix Shell and Perl languages. Working experience on Solaris and Linux is required.
  • Excellent verbal and written communication skills.
  • Oracle installation, patching, Oracle troubleshooting and communication with oracle support.
  • Experience with oracle Standby databases/Data Guard.
  • Experience with OLTP and Batch processing database setup.
  • Knowledge of data replication strategies and their effect on uptime, network and other infrastructure.
  • Knowledge of Golden Gate Replication is a plus.

查看全文

Oracle DBA热门招聘

查看全部
Oracle DBA工资概况
平均¥10150

工资分布图(k)

数据来源于看准用户,取自该职位最近一年内员工发布的工资信息。

Oracle DBA就业前景

月平均7829(个)

职位需求分布(个)

数据来源于看准用户,取自该职位最近一年内员工发布的工资信息。

Oracle DBA热门公司工资

 

Oracle DBA热门公司面试

APP
看准官方APP

下载看准官方APP

返回顶部
老鸟

输入手机号,下载看准APP

二维码

扫码下载看准APP
或各大应用商店搜索:看准

想知道你的同行每个月都拿多少薪水吗?登录/注册

页面底部区域 foot.htm