Description
SUMMARY OF QUALIFICATIONS * Worked as SQL DBA in Avana Consulting Pvt Lmt. * Having around 2 years of work experience as MS SQL Server Developer and Administrator. * Experience in SQL Server database administration & Configuration. * Having very good experience in creating database objects like Tables, views and indexes. * Work experience with development of Business Logic at Back-End using Stored Procedures, Functions and Triggers. * Good experience in Query Tuning and Performance enhancement of database. * Good experience in Index Rebuilding and Re-organization. * Good experience in configuring high availability concepts like Replication and Log shipping. * Good Experience in TSQL programming * Good Knowledge of Configuring Always on Groups * Experience on backup and restore process * Work experience using Dynamic management views (DMV) and DBCC commands for troubleshooting and for better maintenance. * Restoring the Databases from Production to test environment and vice versa. * Experience in using Common table expressions (CTE's) * Good Experience in SSIS, SSAS and SSRS.