This post has already been read 2045 times!
Diving out from the previous article where in we had learnt that now really it is the right time to become a DBA. Had a thought on finding out the insights related to what a DBA must be actually doing . DBA’s jobs seems to go into a category where others don’t want to do the tasks or doesn’t have the ability to do. DBA’s get the enviable task of figuring out all of the things no one else can figure out. The DBA needs to have an understanding of networking, programming, scripting, data modelling, Operating System knowledge, Java, Storage, security and anything else that would touch a database. It can be referred to it as the centre of attention. This opens up many fields for an individual whilst going on in the path to become a DBA.
Historically and futuristically the DBA had and has total responsibility for the database and had the following job duties:
- Install, patch and maintain all Database software
- Tune all database instance components including SQL and PL/SQL
- Approve all production schema changes
- Approve changes to database design
- Control all migrations of database schema objects
- Design and implement a backup & recovery system
- Implement database failover technology
In the late 20th century DBA’s were still overlooked because DBAs said “It’s not my job,” or “I don’t have time.” Changing technology mandated that the 21st century DBA would have more overall responsibility for the whole operation of their database.
Here is a list of typical DBA responsibilities:
- Installation, configuration and upgrading of Oracle server software and related products.
- Evaluate features and related products.
- Establish and maintain sound backup and recovery policies and procedures .
- Take care of the Database design and implementation.
- Implement and maintain database security (create and maintain users and roles, assign privileges).
- Perform database tuning and performance monitoring.
- Perform application tuning and performance monitoring.
- Setup and maintain documentation and standards.
- Plan growth and changes (capacity planning).
- Work as part of a team and provide 7×24 support when required .
- Perform general technical trouble shooting and give consultation to development teams.
- Interface with technical support.
- And most of all…..Maintain 100% uptime!
With the advent of new technologies and the growth and importance of data ,the DBA job role became far more demanding, and many companies started to view the DBA as a technical management position, encompassing far more responsibility than the traditional DBA. DBAs were faced with a new requirement to have degrees in both computer science and business administration. The business administration allowed them to understand the working of internal systems and helped them to design the corporate database.
Summarizing as stated, becoming a DBA requires a lifetime commitment. Large corporations will not entrust their life-or-death data to just anyone, and most insist on hiring DBA’s who have demonstrated a commitment to the profession, constantly acquiring new certifications, degrees and knowledge. |