你对数据库管理员的定义是什么?

你对数据库管理员的定义是什么?

By Ben Kubicek, 2017/09/05

今天恰好Steve旅游到了英国,我们将邀请他作为客串社评员。

好的,我知道最简单的答案是数据库管理员(DBA),但是到底这是一个什么角色呢?如果必须要你把DBA描述给一个不懂技术的人,你会怎么描述?数据库管理员可以有很多不同的角色或者作用。在这些角色或作用中我曾经看到过或者做过的包括:安装SQL Server,管理服务器性能,包括磁盘空间利用率,管理备份,控制权限和用户的权利或角色,管理复制和不间断的在多个故障转移群集以及性能调优/索引,sql的工作,警报,数据库邮件,释放数据库脚本等。我认为这些可以被称为是数据库管理员的核心职责。

取决于你工作的公司规模,我也看到部分数据库管理员有一些额外的责任。这些可能被归为更多数据库开发人员的工作,例如创建表,视图,函数和存储过程。或者数据架构领域的更多内容,如数据库设计,模式,表格,键和索引的归一化。有的时候,一个数据库管理员可能管理将数据导入或导出数据库的SSIS包。其他时候,他们可能使用SSRS或者其它报告工具来做一些报告。随着更多的进入BI领域,你可能需要数据仓库和ETL包来进行管理。还有其它一些数据库管理员的职责我肯定漏掉了。

在我以前的工作中,我曾被雇作为一名.net开发人员同时做着数据库开发工作。那是一间很小的商店,而我是一个拥有丰富数据库经验的员工。在我知道之前,我正在做安装sql server,设置备份和管理sql server性能之类的工作,我花了9年做这项工作,其中大约2/3的工作是为公司或他们的客户做数据库管理员,数据库架构师或数据库开发人员工作。没有人真正要求我去做,我只是看到需要就跳进去做了。

现在有些人在那里想要把工作最小化。他们只是试图在雷达下滑冰而已。当这些人是数据库管理员时,他们可能在做一个充分的工作,如数据库服务器正在运行等等。但是这不是我想要的对数据库管理员的定义。我认为一个好的数据库管理员的定义是他乐意并且准备好了跳进这个“工作坑”,并能做超过工作本身要求做的事情。他们不仅能掌握好自身的核心职责,而且乐意去借助别人的帮助去做一些我在上面提到的其它方面的数据库管理员的工作。他们不害怕去学习或者尝试新的东西。他们是团队成员,在实现项目的过程中乐意卷起袖子、不怕脏累希望看到项目成功。

那么你会怎么定义一个数据库管理员呢?在你目前的工作中,你是一个怎么样的角色又承担了哪些责任?


What is your definition of a DBA?

By Ben Kubicek, 2017/09/05 Today we have a guest editorial as Steve is traveling to the UK. OK, I know the easy answer is a Database Administrator, but what role is that? If you had to describe it to a non-technical person what would you say? There are many different roles and functions a DBA can have. Some of the roles or functions I have seen / done are: installing SQL Server, managing server performance including disk space utilization, managing backups, controlling access and user’s rights/roles, managing replication and always-on / multiple failover clusters and performance tuning/indexes, sql jobs, alerts, database mail, releasing db scripts. I think these could be described as core DBA responsibilities. I have also seen, depending on the size of the company you work for, some DBA’s have some additional responsibilities. Things that might be described as more database developer such as creating tables, views, functions and stored procs. Or things that are more in the data architect realm, such as database design, schema, normalization of tables, keys and indexes. Sometimes, a DBA might manage the SSIS packages that bring data in and/or out of the database. Other times they might need to do some reporting perhaps using SSRS or other reporting tools. As you move more into the BI landscape, there may be data warehousing and ETL packages to manage. I am sure there are other aspects of being a DBA that I have missed. In my previous job I was hired as a .net developer that also did database development. It was a very small shop and I was the one with the most database experience. Before I knew it I was installing sql server, setting up backups and managing sql server performance and more. I spent nine years at that job, where about two thirds of my job was doing DBA, database architect or database developer work either for the company I worked for or for their clients. No one really asked me to do it, I just jumped in as I saw the need. Now there are some people out there that aim to do the minimum at work. They are just skating by trying to stay under the radar. These people, when they are DBAs, are probably doing an adequate job. The database servers are running etc., but this is not how I would want to define a DBA. I think one thing that defines a good DBA, is someone who is willing and ready to jump in and go above and beyond their job description. They are managing their core responsibilities, but are also willing to lend a hand at some of the other aspects mentioned above that could be considered DBA work. They are not afraid of learning / trying something new. They are team players that want to see a project succeed and they are willing roll up their sleeves and get their hands dirty in the process. How would you define a DBA? What roles and responsibilities do you currently have at your job?


本文参与腾讯云自媒体分享计划,欢迎正在阅读的你也加入,一起分享。

发表于

我来说两句

0 条评论
登录 后参与评论

相关文章

来自专栏idba

数据库系统中的“黑天鹅”

一 前言 纳西姆.尼古拉斯.塔勒布的经典著作《黑天鹅》中对“黑天鹅现象”的定义是

963
来自专栏PHP在线

8 个不得不说的 MySQL 陷阱

Mysql安装简单,速度较快,功能丰富。另外它还是开源运动的标杆,它的伟大成就向我们展示了一个成功的公司是可以建立在开源代码之上的。 然而用过mysql的人都曾...

3645
来自专栏数据和云

拨云见日 - 深入解析Oracle TX行锁(下)

优化的核心思想:Balance is the ONLY key to Optimizer. 上期回顾:拨云见日—深入解析Oracle TX 行锁(上) 前文中我...

3329
来自专栏木东居士的专栏

拉链表是什么

3895
来自专栏java架构学习交流

java 面试,java 后端面试,数据库方面对初级和高级程序员的要求

本内容摘自 java web轻量级开发面试教程 对于合格的程序员,需要有基本的数据库操作技能,具体体现在以下三个方面。 l  第一,针对一类数据库(比如MySQ...

2277
来自专栏带你撸出一手好代码

到底该不该使用存储过程

看到《阿里巴巴java编码规范》有这样一条 ? 关于这条规范,我说说我个人的看法 我觉得用不用存储过程要视所使用的数据库和业务场景而定的,不能因为阿里巴巴的技术...

4149
来自专栏数据库新发现

数据库性能和数据库安全:面试题上以小见大

友情链接:http://enmotech.com/web/classify/43.html

870
来自专栏飞总聊IT

大数据时代的NoSQL

NoSQL这个词语伴随着云计算和大数据的出现也有一些时日,对于NoSQL和SQL的区别到底是什么,NoSQL自己又是什么,往往很多人还有一些困惑。这篇文章主要阐...

3446
来自专栏牛客网

猫眼测开一二三面面经,给口头offer

一面: 计算机网络: 面试官:浏览器输入URL地址到呈现页面给用户,中间到底发生了什么?用到了什么协议。 我:balabala,扯到了DNS 面试官:DNS的查...

6569
来自专栏沈唁志

2018年韩创科技旗下我图网PHP工程师面试题分享

4. 一张采用Innodb的User表,其中id为主键,name为普通索引,试从索引的数据结构角度分析,以下两条语句(均返回一条记录)在检索过程中有哪些区别

1322

扫码关注云+社区