What every DBA should know?
8 Things Every Beginner Oracle DBA Should Know
- Installing and configuring Oracle.
- Basic monitoring and tuning.
- Backing up and recovering databases.
- Basic understanding of database security issues.
- Database design.
- Good knowledge of DBMS series of packages.
- Command over SQL and PL/SQL.
- Wizards & GUI vs. command line.
What is DBA interview questions?
Questions about DBA experience and background
- Why did you choose database administration?
- Tell me about your experience as a DBA.
- Why did you leave your last DBA job?
- What are your top technical skills?
- Describe your workflow without direct supervision.
- How do you learn new applications?
What do you need to know to become a SQL Server DBA?
Just browse any one of the many job sites advertising SQL Server DBA job vacancies and you will quickly come to realise that almost all Junior positions list a number of years of SQL Server experience as a necessary requirement.
What do you need to know to be a database developer?
The necessary skills for the particular database can still be obtained on the job. In more specific situations (Big Data, high scalability), the developer should bring tuning knowledge about the particular database in use.
Which is the best way to learn SQL?
Blog your way to becoming a better DBA – Blogging is one of the most powerful and rewarding ways that you can learn the DBA art. Top 5 SQL Forums – Forums are one of the best places to learn about SQL Server because they enable you to not only find answers to your own questions but to also see what others are asking.
Can a SQL Server DBA be an accidental DBA?
The truth is that a significant proportion of SQL Server Database Administrators (DBA’s) start out in an alternative discipline, that is to say they are Accidental DBA’s.