SQL SERVER DBA
al-watania
Total years of experience :4 years, 3 Months
• Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2000/2005/2008R2, 2012, .
• Experience in upgrading SQL Server from version 2000 to 2005, 2008, 2008R2, 2012.
• Have good experience with partitioned schemas, partitioned tables and indexes, creating Filegroups using SQL Server 20005/2008R2, 2012.
• Good experience with SQL Server 2008 online Indexing and Recoveries features.
• Good experience with implementing DR solution, High Availability of database servers using Database mirroring and replications and Log Shipping.
• Experience in Data Migration Management.
• Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Created maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics.