Sr Database Administrator Interview Questions in Addison, TX

440

Sr Database Administrator interview questions shared by candidates

Top Interview Questions

Sort: Relevance|Popular|Date
Hitachi Vantara
Senior Database Administrator was asked...February 28, 2018

They will definitely ask you about your accomplishment in your previous organisation

2 Answers

You can share your experience and share what you learned form it

they will bluff about internal aspects. be careful

Moka (Indonesia)

What are you gonna do if you hired?

2 Answers

Saya akan bekerja dengan sungguh-sungguh

Fix up database management

Yodlee

Q1. What will be your approach when you are reported that someone has deleted a table from production?

2 Answers

Ans. I provided him two approach to handle this situation , but I guess he was not knowing about any of them and that was clear from his follow-on question . When I gave him more detail as how it works he became furious and asked me how will you be doing if Table is 6Tb , and this time it was my turn to give a pity smile . Less

When some non sense interviewer keep bombarding useless question we cannot expect any chance of hiring. If it's a telephonic interview its better to switch off the phone right there Less

StubHub

In a dataguard environment, say the primary database is having network issues and you failover to the standby database. Now the standby has become the new primary. Now if network issues were resolved on the old primary, how do you restore it and make it a physical standby ?

2 Answers

There seems to be a new Oracle 11g feature called RESUME which can achieve this. I also think that it can be done using flashback. Less

The key in these questions is to cover the fundamentals, and be ready for the back-and-forth with the interviewer. Might be worth doing a mock interview with one of the StubHub or ex-StubHub Senior Oracle Database Administrator experts on Prepfully? They give real-world practice and guidance, which is pretty helpful. prepfully.com/practice-interviews Less

Percona

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.

2 Answers

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. Less

by using error-log we i can identify problem

How would you start with SQL analyzing SQL performance issue

1 Answers

Checking the status of SQL instance with health check, disk drives, recent errors or warning on the server, locks and Blocks, wait stats, maintenance jobs status, backup job status, OS level warnings and errors. Less

Beltis IT Solutions

Reportar as minhas atuações de forma livre.

1 Answers

Explanei sobre minhas passagens com liberdade.

How do you handle pressure situations?

1 Answers

To stay calm and focus on multi-tasking while being patient

RenaissanceRe

HA concepts to be performed on their virtual sand box.

1 Answers

I finished that challenge

NinjaHoldings

Tell me about your day to day responsibilities and what you do.

1 Answers

I proceed to discuss my day to day activities, the skills (hard and soft) that I bring to the table, and what I can do to help (very fluff questions) Less

Viewing 1 - 10 of 440 interview questions

See Interview Questions for Similar Jobs

Glassdoor has 440 interview questions and reports from Sr database administrator interviews in Addison, TX. Prepare for your interview. Get hired. Love your job.