
@Sudheep.Grandhe Sir,
SQL DBA task is not limited but spans to
- DB installation
- Adding users in SQL Server
- Detach and attach the database in order to move it from one location to another
- Moving bulks of data from one database to another, or make a copy of the data.
- Index maintenance for performance improvement
- Scheduling jobs
- Preparing a maintenance plan
- Backup and Recovery
- SQL Profiler for performance bottlenecks/other monitoring tasks
- Learning SQL Server Transaction Log will be an indespensible asset in case of system failure
- DB auditing
- Central Management of Servers for distributed systems
- Proper planning for better hardware resources
- DB clustering
- Database Configurations including dbmail configuration
- Knowledge of Powershell will be helpful
- Disaster recovery
- Good amount of knowledge about locking abd blocking
- Log shipping
- How to restore master db in case it crash
- Sufficient amount of knowledge about Temporary db and how to keep an optimal one
- Deployment in the Cloud Environment (Azure platform)
- Extensive amount of knowledge about query optimization (Please read the answers presented here
http://www.dotnetfunda.com/forums/show/20833/how-do-you-improve-the-performance-of-a-stored-procedure )
- Internals of SQL Server
- Data security
- Excellent trouble shooting skill
-
Knowledge of ETL Process (SSIS/SSAS/SSRS) - Good amount of knowledge about Data Warehousing
-
An effective communication skill(written/verbal), presentation skill and initiatives -Training to the fellow members
And also
NOSQL knowledge(theory and Practical) with optimization of the same will be a great asset.
Also it is
good to know about other databases like GreenPlume(Parallel DB), Oracle, PostgreSQL, MySQL, EyeDB (OODB) etc. and it's functionality.
And a proper certification
( a.
https://www.microsoft.com/en-in/learning/mcsd-azure-architect-certification.aspx b.
https://www.microsoft.com/en-in/learning/mcsa-sql-certification.aspx )
Books recommended - DBA Survivor: Become a Rock Star DBA, by Thomas LaRock
- Microsoft SQL Server 2012 Internals, by Kalen Delaney
- SQL Server Hardware, by Glenn Berry
- Inside the SQL Server Query Optimizer, by Benjamin Nevarez
- Troubleshooting SQL Server—A Guide for the Accidental DBA, by Jonathan Kehayias and Ted Krueger
A reference link :
https://www.mssqltips.com/sql-server-dba-resources/ Writing blogs for sharing the knowledge and open to learn new technologies help always.
Having said all the above,
nothing can beat hard work/dedication/patience/an eye for detail/inquisitiveness and above all a
smile under high work pressure makes a lot of difference - everywhere and anywhere.
To conclude, we must quote Sir Isaac Newton -
"
I do not know what I may appear to the world, but to myself I seem to have been only like a boy playing on the seashore, and diverting myself in now and then finding a smoother pebble or a prettier shell than ordinary, whilst the great ocean of truth lay all undiscovered before me ."
Hope this will be helpful.
--
Thanks & Regards,
RNA Team
Sudheep.Grandhe, if this helps please login to Mark As Answer. | Alert Moderator