Services
Courses
SQL SERVER DBA
one to one online -- Practical , interview QA
Video meeting . 30 mins
Video meeting . 30 mins
Priority DM . 3 days reply
Video meeting . 30 mins
Video meeting . 60 mins
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