What to do when you join a company as a new DBA
When we take up a new job and join a company as a new DBA, what should we do immediately? Unless your manager has specific task or expectations for you, this is what I recommend. Start documenting or looking through all the database you will be managing. This should include important database information like the following:
1. Database architecture diagram (Is this RAC, DataGuard or GoldenGate?)
2. Database parameters (AMM or ASMM, Archive logging, DB block size, DBID?)
3. Understand the application using the database (OLTP, DWH, Hybrid?)
4. Read and understand existing documentations available. (DR, Failover, Backup procedures)
The reason is simple, understand the environment you will be managing throughly. Every database environment is different. By documenting the environment, you will be able to understand it fully. It will help when you are troubleshooting issues.