How To Become a Database Administrator

July 24, 2021 By: Indeed Editorial Team

Translate:CodeSnake

Tips：如果你對(duì)數(shù)據(jù)處理工作有興趣，你可以考慮從事數(shù)據(jù)庫(kù)管理的職業(yè)。作為一名數(shù)據(jù)庫(kù)管理員，你可以管理數(shù)據(jù)的存儲(chǔ)、維護(hù)、訪問和安全。在這篇文章中，我們將討論如何成為一名數(shù)據(jù)庫(kù)管理員，并回顧關(guān)于這一職業(yè)的常見問題。

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?

數(shù)據(jù)庫(kù)管理員的工作是什么？

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.

數(shù)據(jù)庫(kù)管理員（DBA）管理和維護(hù)軟件數(shù)據(jù)庫(kù)，如客戶記錄、統(tǒng)計(jì)調(diào)查、人口普查信息、用戶賬戶和圖書館目錄。數(shù)據(jù)庫(kù)管理員提供對(duì)數(shù)據(jù)庫(kù)的安全訪問，并管理備份解決方案，以防止系統(tǒng)故障時(shí)的數(shù)據(jù)丟失。這些人也可以幫助開發(fā)數(shù)據(jù)庫(kù)系統(tǒng)的階段。

Additional responsibilities may include: 其他職責(zé)可能包括

• 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

  
  

• 創(chuàng)建新的用戶賬戶和權(quán)限

• 測(cè)試對(duì)數(shù)據(jù)庫(kù)結(jié)構(gòu)的修改

• 監(jiān)測(cè)數(shù)據(jù)庫(kù)系統(tǒng)，檢查反應(yīng)是否緩慢和可能的瓶頸問題

• 通過定期安裝更新和補(bǔ)丁來優(yōu)化數(shù)據(jù)庫(kù)系統(tǒng)

• 定期更新數(shù)據(jù)庫(kù)服務(wù)器上的防病毒程序

• 排除故障和診斷數(shù)據(jù)庫(kù)系統(tǒng)問題，并實(shí)施解決方案

• 合并舊的數(shù)據(jù)庫(kù)

• 進(jìn)行容量規(guī)劃

• 監(jiān)測(cè)數(shù)據(jù)庫(kù)服務(wù)器的硬件和操作系統(tǒng)

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

要成為一名數(shù)據(jù)庫(kù)管理員，請(qǐng)遵循以下六個(gè)步驟

（1）Earn a bachelor's degree（獲取學(xué)歷）.

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.

首先，獲得一個(gè)學(xué)士學(xué)位，打好計(jì)算機(jī)科學(xué)和技術(shù)的基礎(chǔ)。選擇計(jì)算機(jī)科學(xué)或信息技術(shù)等專業(yè)，為從事數(shù)據(jù)庫(kù)管理做好準(zhǔn)備。

（2）Get work experience （獲取實(shí)習(xí)）

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.

從大學(xué)畢業(yè)后，在IT領(lǐng)域?qū)で笕腴T級(jí)的工作經(jīng)驗(yàn)（數(shù)據(jù)庫(kù)運(yùn)維等）?？紤]找一份IT支持助理或系統(tǒng)管理助理的工作以獲得實(shí)際經(jīng)驗(yàn)。

（3）Learn key computer languages（學(xué)習(xí)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.

如果你在大學(xué)里沒有掌握像SQL這樣的程序語言，那么在申請(qǐng)數(shù)據(jù)庫(kù)管理工作之前要先學(xué)習(xí)這些語言。你可以參加在線課程（B站白嫖）來學(xué)習(xí)基礎(chǔ)知識(shí)。

（4）Master computer programs and platforms（熟練掌握操作系統(tǒng)與MYSQL等數(shù)據(jù)庫(kù)）.

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.

當(dāng)你獲得工作經(jīng)驗(yàn)時(shí)，利用一切機(jī)會(huì)使用和學(xué)習(xí)計(jì)算機(jī)程序和平臺(tái)，如Microsoft Access、Oracle、Linux和UNIX（up本身在深入學(xué)習(xí)Linux CentOS）。你可以參加各廠商的在線課程，學(xué)習(xí)特定的技能。

（5）Pursue software vendor certification.（爭(zhēng)取軟件供應(yīng)商的認(rèn)證）

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.

為了證明你對(duì)你工作的平臺(tái)的了解，從軟件供應(yīng)商那里獲得一個(gè)認(rèn)證。許多數(shù)據(jù)庫(kù)管理員擁有IBM認(rèn)證數(shù)據(jù)庫(kù)管理員、微軟認(rèn)證解決方案助理或Oracle數(shù)據(jù)庫(kù)管理員認(rèn)證助理的證書。

（6）Create a resume(安排簡(jiǎn)歷).

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.

在完成這個(gè)職業(yè)的所有基本要求后，創(chuàng)建一份簡(jiǎn)歷并開始申請(qǐng)工作。包括你的教育、證書、技術(shù)技能和相關(guān)工作經(jīng)驗(yàn)。