Database Administration summary : ? Very good experience in Installation, configuration and maintenance of SQL Server. ? Experience in MS SQL Server upgrades/migration from 2005 to MS SQL Server 2008R2, from 2008 R2 to MS SQL server 2012 and from SQL 2012 to MS SQL server 2016. ? Implementation of Resource Governor for production environment. ? Implementation of TDE (Transparent Data Encryption). ? Has Knowledge of Analysis Services & Reporting Services, SQL Server Clustering and Log Shipping. ? Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands. ? Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO) ? Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO) ? Configure SQL Server monitoring utilities to minimize false alarms. ? Install and configure new SQL Servers. ? Verify the database change scripts provided by Development team. ? When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes ? Ensuring that storage, archiving, daily data backup as well as data log size-testing activities ? Trouble shooting any database and server related problem and creating customized reports for the management and users. ? Created SSIS Packages for Data Migration and Transformation. Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2008/2005 ? Daily support of system wide replication tasks including monitoring, alerting, and problem resolution. ? Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system. ? Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, dat