senior database administrator interview questions shared by candidates
How would you work with a client that has a performance problem and it is impacting the production but you cannot see any query running long in database.
I had to specify some tools and answer the process as DBA uses to identify database or OS problems. Included variables, statuses values, Linux tools but I missed some small things that were OK at the point because I was able to explain other ways to reach the same information.
by using error-log we i can identify problem
We have data that gets loaded once a week. With that in mind we have an application that clients enter search data in to and then SQL has to dynamically build a statement that has 25 different data points/relationships. It works fine, but takes upwards of 30 seconds to return the data to the client. You can not change the existing schema, but you can however add to it. Indexes are already present and optimized on all the different tables. What could you do to make this process much faster??
See Interview Questions for Similar Jobs
- Database Administrator
- Software Engineer
- Senior Oracle Database Administrator
- Senior Software Engineer
- Oracle Database Administrator
- Project Manager
- Data Analyst
- Senior DBA
- Business Analyst
- Software Developer
- Vice President
- Senior Manager
- Principal Software Engineer
- Senior Consultant
- SQL Server Database Administrator