Services

Courses

SQL SERVER DBA

one to one online -- Practical , interview QA
FREE
Popular
Video meeting . 30 mins
800
Popular
Video meeting . 30 mins
800
Priority DM . 3 days reply
99
Popular
Video meeting . 30 mins
800
Video meeting . 60 mins
1,300

About me

I have a total of 8+ years experience and as relevant as MSSQL DBA 3 years. Having 3 years of experience in information technology this includes database administration and maintenance under windows platform  Installation and Configuration of SQL server 2005/2008R2/2012/2014/2016/2017/2019. Applying SQL service packs on SQL server 2008R2/2005/2012/2014/2016/2017 instances.  Experience of SQL server database security management, granting permissions and managing security by creating logins at instance level, users at database level and assigning privileges, SQL server authentication modes.  Hands-on ability in performing Database Administration (DBA) activities like database creation, management of log file & data files, taking database backups and restoring, troubleshooting and security related issues.  Implementation of database maintenance plans, jobs and alerts.  Experienced in handling issues like system databases corruption and orphan users.  Having hands on experience in DR Process including Log shipping and Database Mirroring.  Identifying fragmentation level of the indexes and Rebuilding or reorganizing the indexes.  Checking the performance of SQL Server, knowledge in using DMV and DMF for finding out long running queries, Blocking  Experience of working on space issues like Log files full, Tempdb full.  Performing data file movement from one drive to another drive Work as part of a team and provide 24x7 supports. Experience SQL SERVER DBA (L1 & L2) Experience in MIS Reporting EXCEL and Enterprise Application Administrator. Advanced Excel Formulas such as, Pivot Table, Lookups, Conditional formatting, count IF, Sum IF Experience on Implementation ,Deployment and Managing the centralized Document Management Experience in production database server Knowledge of Azure Cloud Experience in Banking & Financial, Educational, and Telecom Sector Good Team player