Would you know what to do if your database administrator disappeared? Whether it’s because of an accident or on purpose, is your business prepared for such an event? How can you prepare for a DBA Departure?
Here are 6 Lessons from the Ntirety DBA Departure Survival Guide:
1: DON’T PANIC
You have options. There are resources available to help you take control over your database environment. At Ntirety, we have teams of US-based database administrators who are equipped to deal with any emergency. Our team members are ready at any hour to help you handle a DBA departure.
2: ASSESS SECURITY
The DBA holds the keys to the database kingdom—passwords. It is well worth your while to have full knowledge of the passwords (Database and O/S level) that impact your business. As a business owner or manager, you must have a contingency plan in place in case of a DBA departure. It could be as simple as putting the passwords in a sealed envelope in a safe once a month. This is a simple step that can prevent what could become a very costly mistake.
When a DBA is leaving your company, it is also important that you change the passwords. This is a clear, unambiguous industry best practice. It helps to protect your company, as well as the DBA who is leaving.
Another crucial step is to get the contact details of the DBA. Simply ask for a phone number and email address where they can be reached, just in case you have any questions after the DBA departure. Once you have these, only reach out when absolutely necessary.
3: GET A HANDLE ON KEY DAILY/NIGHTLY PROCESSING
Ask your DBA to share with you any and all documentation on key processing that your business relies on. Information needs to remain ready for action.
4: UNDERSTAND YOUR DATABASE BACKUPS
Ask your DBA for any and all documentation on database backup protocols and procedures. Also find out what are the most common problems that occur. You could find out that the DBA spends many nights troubleshooting backup issues which you will need to contend with after the DBA departure.
5: LEARN ABOUT PROACTIVE MONITORING & MAINTENANCE
Many times DBAs set up some basic jobs to monitor the health of the database. It is crucial that you have some level of proactive monitoring in place, even if it is just some code your DBA put together. Ask the DBA if he has any monitoring in place, and how it alerts users when there is a problem.
Also ask your DBA for the location of the maintenance jobs and the corresponding schedule.
6: ASK ABOUT ANY OUTSTANDING PROBLEMS OR CONCERNS
A database is a very complex set of software. Ask the DBA about any pressing issues or concerns that could prove problematic in the near-term. Your current DBA has an intimate knowledge of the operating environment. It is important that you capture whatever information you can to help make the transition smoother, before the DBA departure.
You and your database environment are not alone. Ntirety is always here to help. In case of database emergency during office hours please call (781) 474-7700, or contact our 24/7 Database Emergency Hotline at 877-684-7389.
To download the full DBA Departure Survival Guide, click here.