• Experience in evaluation of on-premises SQL database to Azure SQL to reduce the license cost• Assessed the existing database by running DMA and removing the migration blocking issue, cross-platform issues to get maximum performance improvement• Ran the Database Migration Assistant to upgrade the existing SQL server to Azure SQL Database• Configuring and maintaining High Availability solutions(AlwaysOn, log-shipping, and Clustering) on Premises /Cloud• Configuring Azure services PaaS/IaaS and migrated database from on premise to Azure • Setup the Service tier in each environment based on the usage and activities. The DTU is setup to give maximum throughput while accessing database from web application through VPN• Implemented the owner, database contributor, database reader permission to access Azure Web Portal to developers, DBAs and system admins• Configured and maintained Elastics DB Pools• Proficiency and expertise in SQL Server DB backup/Recovery, Disaster Recovery Planning & Security Management• Set up the Automatic Tuning on production database to create index based on the inheritance from Azure SQL. The improvement increases sharply to show the result in the few milliseconds• Run the Vulnerability Assessment Report to investigate, manage and resolved security issues• Managing /supporting and Very large Database (VLDBs) more than 2TB to 17TB• DB Maintenance activities using Ola Allergen and Brent Ozar owned Stored Procedures• Run Query Performance insight to have deeper insight in DTU consumption, top queries by CPU, Duration or execution • Scheduled Automatic refresh and scheduling refresh in power bi services.• Optimized DBs using Table Partitioning, Archiving, Data Retention Rules• Designed and automated reports for DB security and performance using XEvents & PowerShell• Managing a team of 14 DBAs and T SQL & Azure developers

• Worked with product owners to define with priorities of business critical and major projects• Expertise in reading and understanding execution plan and fixing the query to execute low cost.• Extensively worked on Locks, Deadlocks, handling Isolation level and concurrency effects, Defect CPU, I/O, Memory bottlenecks• Expert in monitoring, Optimization, performance tuning of SQL server database using DMVs, Activity monitor, SQL Profiler, DB Tuning Wizard and third party tools.• Expertise in implementation of security models, Database authentication modes, Creation of logins, granting permissions and assigning roles to users on databases• Created Stored Producers and performed index analysis for slow performing SSRS reports to bring down the report rendering time from 15mins to 2 seconds• Configured the Power BI • Involved in Design, analysis, Implementation, Testing and support of ETL process for Dev, Stage, Test and Production Servers.• Processed data from flat files and excel files to database tables using in-build tasks • Lead the Database Production Support for critical issues.• Scripting the Database Consistency Check (DBCC), Scheduling the scripts to run daily and weekly basis

* Creating, Updating and Fine Tunning the Procedures.* Data Migration Using SSIS.* DBA Activities.* Data base team managing.

• Installed & configured SQL Server 2008 R2/2008/2005 in standalone environments.• Managed privileges & roles for application/database security.• Rewrote and tuned long-running SQL queries for improved scalability.• Created a new database structured to define for client and communication types• Defined Domain integrity, referential integrity between database tables• Automated and maintained SQL administration tasks• Created a SQL Job in SQL Server Agent to send an automated email using database mail for unused campaign codes notifies user to take an action • Designed and implemented Disaster Recovery Procedures Like Log Shipping, Transactional Replication• Configured Recovery Time Objective(RTO) and Recovery Point Objective(RPO) of business critical servers Such as File Server & SQL Servers to minimize the downtime and data loss• Conducted Root Cause Analysis of application availability related to coding practices, database bottlenecks or network latency• System performance using System Monitor, SQL Profiler, and DBCC utilities.• Used linked server to perform distributed queries, joined with local server DB to update database records• Used Visual Source Safe to keep track of all modifications and enhancements of the tools• Created technical documentation of database applications including data structures and SQL stored procedures• Performed bulk data migration using DTS from flat text files• Created Adhoc SQL queries, Stored Procedures & Functions

and guide is a CRM application mainly used for customer supports and Online shopping (E-commerce) Module. Our applications support 10 lakhs customer’s records and frequently update, insert bulk and modifying the customer packages.; SQL Server 2005 & SQL Server 2008 R2Role : DBA, SQL server 2005, 2008 Developer and Production Server database support.Duration & Team Size: 3.6 years and 3 MembersResponsibilities Responsible for installation and configuration of SQL server 2005 & 2008 database on the servers.Developing SQL scripts for maintaining administration tasks.Based on the business needs created Transactional replication in database.Estimating of table sizes and record sizes. Trouble shooting problems by using SQL server Profiler.Solved critical production problems and performed point in time recovery plans.Implemented database standards and naming convention for the database objects.Data base objects like Tables, Stored Procedures, Views, Rules, Defaults, user defined data types and functions for this project.Experienced in resolving deadlock and blocking issues for concurrent users.Developed database backup scripts and automated this process – Maintenance PlanProvided 7 X 24 production supports for the database and application issues.Interacting with the users and troubleshooting the problems involved with the development of stored procedures.Created and maintained Users department, Users role and User groups.Focuses on Index tuning and fragmentation of the Index pages with the help of alter index script and finalize based on the average fragmentation >30 then doing “Rebuild” and < 30 then doing “Reorganize” and automated from the maintenance plan in sql server objects.Rewrote and tuned long running SQL queries to cut execution time, ease database load and improved scalability.Easy design system Pvt limited

CSS Logistics – Customer Support Service.Few months worked in ASP .Net coding with html pages for CSS (Repair centre and Call centre application)Then moved to create and alter stored procedure as well as do reports in Crystal Reports; ASP.Net, VB.Net, Crystal Reports 9.2, SQL Server 2000, Infragistics Controls; SQL server developer and Production server database support.Duration & Team Size: 3 years and 10 Members.ResponsibilitiesPartly involved install, configure and upgrade MS SQL Server with the help of Upgrade tool.Involved performance tuning.Used MS Visual Source Safe 6.0 as a version control system.Developed the Master Admin pages (ASP.Net) with third party control Infragistics grid.Generated Dynamic reports using Crystal reports.Responsible for developing GUI screens with the help of dream viewer.Defined relationship between tables and enforced the referential integrity constraints. Created clustered and non clustered Indexes.Monitored User accounts, User permissions user roles and user groups.Created and Monitored the Jobs which is failed then sent a mail thru sql server mail

* Create Master table .Net pages * Monitor and create the snapshot of the live server functions.* Using Crystal reports for Reports.* Created 200 odd html pages proto type design an intial stage of project.