I have a college degree in electronics and I have some knowledge of SQL
So, I want to become a Database Administrator (DBA).
Can you tell me what DBA is?
What are the sources I must refer to gain knowledge books or materials?
What certification should I take to be a DBA? Please help me.
How To Become A DBA
In today\'s technology-driven world, organizations need databases to manage their voluminous data and run them efficiently to stay ahead of competition because businesses are data-driven.
These companies use different types of databases including Oracle, Microsoft, IBM, MySQL and Sybase.
DBAs are professionals who organize data in an appropriate manner so that data can be maintained, accessed, and updated.
A Database Administrator is responsible for maintaining and overseeing databases in an organization.
The DBAs Roles & Responsibilities
- Maintaining and executing actions such as disaster recovery, backups of databases
- Conducting tests on backup data
- Analyzing the performance of networks and systems
- Ensuring user and data security
- Designing databases
- Working with developers and network administrators
The DBAs Required Skills
- Familiarity with the concepts such as Tables, Views, Queries, Primary Keys, Foreign Keys, Types of Indexes, Columns and the different data types
- Programming knowledge
- Query language knowledge (PL/SQL or MS-SQL)
- Visual Basic
- Excellent communication skills - both verbal and writing skills
- A degree in Business Administration or Computer Science
- Knowledge of technologies like Java and Oracle Server or Microsoft Server
- Analytical and problem-solving skills
Employers generally look for candidates with an IT degree such as BE, BTech, MCA, and BCA .
However, a degree alone wonâ€™t be enough to get a DBA job. There are so many certifications that aregeared towards DBAs. Of these. two database vendors, Microsoft and Oracle, offer widely accepted DBA certifications.
- Microsoft Certified Technology Specialist (MCTS)
- Oracle Certification Associate (OCA)
If you want to become a Microsoft SQL Server specialist, you must go for either MCDBA or MCTS.
OCA is meant for those who want to be specialized in Oracle technologies.
Oracle is the leading database vendor. However, many organizations use a combination of both technologies. Therefore, whichever certification you choose, you will be still in demand, provided you can meet the expectations of employers in terms of your skills. Hence, focus more on developing your skill sets.
Since you have already an engineering background and knowledge of SQL, please further your IT skills and SQL query skills. Learn as many program languages as possible.
The following resources will help you further your SQL skills:
- Sam\'s Teach Yourself SQL in 24 Hours - the contents of this book are available online for free
- Beginning SQL Server 2000 Programming
- Inside Microsoft SQL Server 2000
- SQL: A Beginner\'s Guide
- SQL in a Nutshell
- Oracle8 DBA Handbook
- Oracle Database 10g DBA â€“ DBA handbook
- Oracle DBA Automation â€“ Quick Reference
- Microsoft SQL Server 2000 DBA Survival Guide
I want to caution you by saying that although reading books is good, it is not enough. You also need to convert your knowledge into actual hands-on experience.
However, please try to take some internship with organizations that require free DBA services or freelance for DBA related jobs online.