Interview Help

[BhagyaSiri]

One of my friend referred this, when I asked for interview help..

I am working in testing for 1 year, billing is very low.
Recent gaa.. SQL Server admin nerchukunna... interviews kosam .. prepare avuthunnaa..

can some one help me in interviews.. thanks ..

[STRAWBERRY]

[Rockstar_me]

I can help you.... What are you Looking for?

[ILAQAT_MUFLIYA]

LTT

[BhagyaSiri]

I haven't get any interviews, so far, I will try to attend the interviews.. first, after couple of interviews.. I will know, If I can attend or not..

[Rockstar_me]

all the best.. prepare all main concepts first..

[BhagyaSiri]

thanks

[ghazni]

[b] SQL Server DBA Phone Interview Questions[/b]
[color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3]
Although no two phone interviews are the same, below outlines some potential questions to keep in mind as you prepare for a SQL Server DBA phone interview:[/size][/font][/color][list]
[*]Can you explain your skill set?
[list]
[*]Employers look for the following:
[list]
[*]DBA (Maintenance, Security, Upgrades, Performance Tuning, etc.)
[*]Database developer (T-SQL, SSIS, Analysis Services, Reporting Services, Crystal Reports, Service Broker, etc.)
[*]Communication skills (oral and written)
[/list][*]DBA's opportunity
[list]
[*]This is your 30 second elevator pitch outlining your technical expertise and how you can benefit the organization
[/list]
[/list]
[/list]
[list]
[*]Can you explain the environments you have worked in related to the following items:
[list]
[*]SQL Server versions
[*]SQL Server technologies
[list]
[*]Relational engine, Reporting Services, Analysis Services, Integration Services
[/list][*]Number of SQL Servers
[*]Number of instances
[*]Number of databases
[*]Range of size of databases
[*]Number of DBAs
[*]Number of Developers
[*]Hardware specs (CPU’s, memory, 64 bit, SANs)
[/list]
[/list]
[list]
[*]What are the tasks that you perform on a daily basis and how have you automated them?
[list]
[*]For example, daily checks could include:
[list]
[*]Check for failed processes
[*]Research errors
[*]Validate disk space is not low
[*]Validate none of the databases are offline or corrupt
[*]Perform database maintenance as available to do so
[/list][*]For example, automation could include:
[list]
[*]Setup custom scripts to query for particular issues and email the team
[*]Write error messages centrally in the application and review that data
[*]Setup Operators and Alerts on SQL Server Agent Jobs for automated job notification
[/list]
[/list]
[/list]
[list]
[*]How do you re-architect a process?
[list]
[*]Review the current process to understand what is occurring
[*]Backup the current code for rollback purposes
[*]Determine what the business and technical problems are with the process
[*]Document the requirements for the new process
[*]Research options to address the overall business and technology needs
[list]
[*]For example, these could include:
[list]
[*]Views
[*]Synonyms
[*]Service Broker
[*]SSIS
[*]Migrate to a new platform
[*]Upgrade in place
[/list]
[/list][*]Design and develop a new solution
[*]Conduct testing (functional, load, regression, unit, etc.)
[*]Run the systems in parallel
[*]Sunset the existing system
[*]Promote the new system
[*]Additional information - [url="http://www.mssqltips.com/sqlservertip/1403/checklist-to-re-architect-a-sql-server-database/"]Checklist to Re-Architect a SQL Server Database[/url]
[/list]
[/list]
[list]
[*]What is your experience with third party applications and why would you use them?
[list]
[*]Experience
[list]
[*]Backup tools
[*]Performance tools
[*]Code or data synchronization
[*]Disaster recovery\high availability
[/list][*]Why
[list]
[*]Need to improve upon the functionality that SQL Server offers natively
[*]Save time, save money, better information or notification
[/list]
[/list]
[/list]
[list]
[*]How do you identify and correct a SQL Server performance issue?
[list]
[*]Identification - Use native tools like Profiler, Perfmon, system stored procedures, dynamic management views, custom stored procedures or third party tools
[*]Analysis - Analyze the data to determine the core problems
[*]Testing - Test the various options to ensure they perform better and do not cause worse performance in other portions of the application
[*]Knowledge sharing - Share your experience with the team to ensure they understand the problem and solution, so the issue does not occur again
[*]Additional information - MSSQLTips.com Category: [url="http://www.mssqltips.com/category.asp?catid=9"]Performance Tuning[/url] and [url="http://www.mssqltips.com/category.asp?catid=37"]Query Optimization[/url]
[/list]
[/list]
[list]
[*]What are the dynamic management views and what value do they offer?
[list]
[*]The DMV's are a set of system views new to SQL Server 2005 and beyond to gain insights into particular portions of the engine
[*]Here are some of the DMV's and the associated value:
[list]
[*]sys.dm_exec_query_stats and sys.dm_exec_sql_text - Buffered code in SQL Server
[list]
[*]Additional Information: [url="http://www.mssqltips.com/sqlservertip/1363/identifying-the-input-buffer-in-sql-server-2000-vs-sql-server-2005/"]Identifying the input buffer in SQL Server 2000 vs SQL Server 2005[/url]
[/list][*]sys.dm_os_buffer_descriptors
[list]
[*]Additional Information: [url="http://www.mssqltips.com/sqlservertip/1187/buffer-pool-space-in-sql-server-2005/"]Buffer Pool Space in SQL Server 2005[/url]
[/list][*]sys.dm_tran_locks - Locking and blocking
[list]
[*]Additional Information: [url="http://www.mssqltips.com/sqlservertip/1359/locking-and-blocking-scripts-in-sql-server-2000-vs-sql-server-2005/"]Locking and Blocking Scripts in SQL Server 2000 vs SQL Server 2005[/url]
[/list][*]sys.dm_os_wait_stats - Wait stats
[list]
[*]Additional Information: [url="http://www.mssqltips.com/sqlservertip/1031/waitstats-performance-metrics-in-sql-2000-vs-sql-server-2005/"]Waitstats performance metrics in SQL Server 2000 vs SQL Server 2005[/url]
[/list][*]sys.dm_exec_requests and sys.dm_exec_sessions - Percentage complete for a process
[list]
[*]Additional Information: [url="http://www.mssqltips.com/sqlservertip/1338/finding-a-sql-server-process-percentage-complete-with-dmvs/"]Finding a SQL Server process percentage complete with dynamic management views[/url]
[/list]
[/list]
[/list]
[/list]
[list]
[*]What is the process to upgrade from DTS to SSIS packages?
[list]
[*]You can follow the steps of the migration wizard but you may need to manually upgrade portions of the package that were not upgraded by the wizard
[list]
[*]Additional Information: [url="http://www.mssqltips.com/sqlservertip/1224/upgrade-sql-server-dts-packages-to-integration-services-packages/"]Upgrade SQL Server DTS Packages to Integration Services Packages[/url]
[/list][*]For script related tasks, these should be upgraded to new native components or VB.NET code
[/list]
[/list]
[list]
[*]What are some of the features of SQL Server 2012 that you are looking into and why are they of interest?
[list]
[*]AlwaysON
[*]Contained Databases
[/list][list]
[*]User Defined Server Roles
[*]New date and time functions
[*]New FORMAT and CONCAT functions
[*]New IIF and CHOOSE functions
[*]New paging features with OFFSET and FETCH
[*]NOTE - Many more new features do exist, this is an abbreviated list.
[/list]
[/list]

[BhagyaSiri]

thanks for the link.. ghazni..

[ghazni]

[quote name='BhagyaSiri' timestamp='1382042670' post='1304430927']
thanks for the link.. ghazni..
[/quote]
aina avi google chestey dorukayi.... urike help andam enduku ani adi vesa real time lo kuda evarana telistey cheptarani...

[BhagyaSiri]

[quote name='ghazni' timestamp='1382042896' post='1304430941']
aina avi google chestey dorukayi.... urike help andam enduku ani adi vesa real time lo kuda evarana telistey cheptarani...
[/quote]

online lovi .. nenu prepare avuthunnaa... my main intention.. is to collect the information.. and have it ready.. when the interview is there..

thanq for ur suggestion..