A person who wants to be a DBA has to follow a strenuous career path where he gains knowledge from his experience, by being a database developer at the beginning and later climbing the ladder to a DBA.
The core skill sets that a DBA should possesses are a complete understanding of the concepts of the database architecture like Tables, View, Queries, Primary and Foreign Keys concepts along with advanced knowledge of concepts like partitions, tablespaces, procedures and business objects, etc.
The DBA should have the ability to talk to the database through query languages like SQL and PL/SQL. To attain success a DBA should also have the knowledge of the complete Software Development Lifecycle (SDLC) along with some software programming skills.
The most popular database software out there are fairly well-known-Oracle, MS SQL Server, IBM DB2 from the commercial space, and MySQ and PostGreSQL from the Open Source arena. You must gain expertise in any of these databases.
Finally, an understanding of shell scripting in Windows NT and UNIX, and common scripting languages and Web skills (Java, HTML, etc.) are also additional skills that can help you land a lucrative position as a DBA.
Similarly, experienced DBA professionals, who already have expertise in handling database implementation projects, can further enhance their skill sets by learning the frameworks for SOA or by venturing into the ERP domain by learning application solutions like Oracle Apps.
No comments:
Post a Comment