How To Become a Database Administrator

July 24, 2021 By: Indeed Editorial Team

Translate:CodeSnake

Tips：如果你对数据处理工作有兴趣，你可以考虑从事数据库管理的职业。作为一名数据库管理员，你可以管理数据的存储、维护、访问和安全。在这篇文章中，我们将讨论如何成为一名数据库管理员，并回顾关于这一职业的常见问题。

If you have an interest in working with data, you might consider pursuing a career in database administration. As a database administrator, you can manage the storage, maintenance, access and security of data. In this article, we discuss how to become a database administrator and review commonly asked questions about this career.

1. What does a database administrator do?

数据库管理员的工作是什么？

A database administrator (DBA) manages and maintains software databases, such as client records, statistical surveys, census information, user accounts and library catalogs. A database administrator provides secure access to databases and manages backup solutions to prevent loss of data in the event of system failure. These individuals may also help develop stages of a database system.

数据库管理员（DBA）管理和维护软件数据库，如客户记录、统计调查、人口普查信息、用户账户和图书馆目录。数据库管理员提供对数据库的安全访问，并管理备份解决方案，以防止系统故障时的数据丢失。这些人也可以帮助开发数据库系统的阶段。

Additional responsibilities may include: 其他职责可能包括

• Creating new user accounts and permissions

• Testing modifications to database structures

• Monitoring database systems to check for slow responses and possible bottlenecks

• Optimizing database systems by regularly installing updates and patches

• Regularly updating anti-virus programs on database servers

• Troubleshooting and diagnosing database system problems and implementing solutions

• Merging old databases

• Performing capacity planning

• Monitoring the hardware and operating systems of database servers

  
  

• 创建新的用户账户和权限

• 测试对数据库结构的修改

• 监测数据库系统，检查反应是否缓慢和可能的瓶颈问题

• 通过定期安装更新和补丁来优化数据库系统

• 定期更新数据库服务器上的防病毒程序

• 排除故障和诊断数据库系统问题，并实施解决方案

• 合并旧的数据库

• 进行容量规划

• 监测数据库服务器的硬件和操作系统

2. To become a database administrator, follow these six steps

要成为一名数据库管理员，请遵循以下六个步骤

（1）Earn a bachelor's degree（获取学历）.

First, earn a bachelor's degree to develop a foundation in computer science and technology. Choose a major like computer science or information technology to prepare yourself to work in database administration.

首先，获得一个学士学位，打好计算机科学和技术的基础。选择计算机科学或信息技术等专业，为从事数据库管理做好准备。

（2）Get work experience （获取实习）

After graduating from college, seek entry-level work experience in the IT field. Consider getting a job as an IT support associate or a systems administration assistant to gain practical experience.

从大学毕业后，在IT领域寻求入门级的工作经验（数据库运维等）。考虑找一份IT支持助理或系统管理助理的工作以获得实际经验。

（3）Learn key computer languages（学习SQL语言）.

If you did not master computer languages like SQL in college, learn them before applying for database administration jobs. You can take online courses to learn the basics.

如果你在大学里没有掌握像SQL这样的程序语言，那么在申请数据库管理工作之前要先学习这些语言。你可以参加在线课程（B站白嫖）来学习基础知识。

（4）Master computer programs and platforms（熟练掌握操作系统与MYSQL等数据库）.

As you gain work experience, take every opportunity you have to use and learn computer programs and platforms like Microsoft Access, Oracle, Linux and UNIX. You can take online courses from each vendor to learn specific skills.

当你获得工作经验时，利用一切机会使用和学习计算机程序和平台，如Microsoft Access、Oracle、Linux和UNIX（up本身在深入学习Linux CentOS）。你可以参加各厂商的在线课程，学习特定的技能。

（5）Pursue software vendor certification.（争取软件供应商的认证）

To prove your knowledge of the platforms you work with, get a certification from the software vendor. Many database administrators have the IBM Certified Database Administrator, Microsoft Certified Solutions Associate or Oracle Database Administrator Certified Associate credential.

为了证明你对你工作的平台的了解，从软件供应商那里获得一个认证。许多数据库管理员拥有IBM认证数据库管理员、微软认证解决方案助理或Oracle数据库管理员认证助理的证书。

（6）Create a resume(安排简历).

After completing all of the essential requirements for this career, create a resume and start applying for jobs. Include your education, certifications, technical skills and relevant work experience.

在完成这个职业的所有基本要求后，创建一份简历并开始申请工作。包括你的教育、证书、技术技能和相关工作经验。