• Installing SQL 2012/SQL 2008 R2/2008 on dedicated servers • Installing SQL 2008R2/2008/2005 on clustered servers with 10 instances. • Upgraded SQL Server 2008 R2 to SQL server 2012 and Migrated Databases and Logins. • Engaged in monthly maintenance activities for production servers including patching, reboot and balance of clustered servers.• Working on Service tickets for problems with database backup failures or space issues on servers.• Monitor databases for errors\ Alerts and perform problem determination when necessary• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.

• Configured Linked Servers.• Managed Security by creating logon/groups and assigning appropriate permissions.• Conducted the Performance tuning, indexes tuning and Checked Deadlock Issues.• Automated the routine Maintenance Tasks and Jobs.• Involved in capacity planning in estimating and sizing of tables.• Extraction, Transformation and Loading data from various data sources using OLE DB connection by various SSIS packages.• Responsible for designing schema and finalization of naming and coding standards throughout project life cycle.• Configured SQL Encryption on Production Servers with active monitoring• Diagnosed and tuned the server Optimal Performance using SQL Server 2012 Dynamic Management Views (DMV).• Tested and implemented the PowerShell scripts in SQL production servers to automate the Jobs and regular tasks.• Worked with different data sources like OLE-DB, flat files and Excel to source data in SSIS.