Database MS SQL Server 2008/2012/2014/2016O/S Windows Server 2008/2012/2016 Enterprise EditionResponsibility:As a team member, I was responsible for the 50 servers located in several locations where 15 servers act as the database production servers. • Designing the databases and making a backup strategy.• Monitoring and fixing any, issues with Replication, Log Shipping, and Mirroring.• Upgrading SQL Server to 2012 R2/2014/2016.• Coordinate with application and development teams while deploying the DB Builds.• Proactive monitoring using alerts to avoid major issues.• Analyzing Deadlocks and tuning the Queries to Prevent the Deadlocks/Blockings. • Responsible for the logical and physical design of SQL Server databases. • Configuring the DR Strategies and Involved in DR Tests.HighlightsMS SQL Server Database Development: • Experience in Creating and modifying Tables, Views, Triggers, Stored Procedures, User Defined Functions and other Transact-SQL (DDL, DML) statements for various modules. SSIS Development:• Experience in using SSIS tools like Import and Export Wizard, Experience in importing/exporting data between different sources like Flat File/SQL/Excel etc. using SSIS.DBA Activities experience:Setting up and configuring a New SQL Server DB environment based on Customers' requirements.Expertise in SQL Server Backup and Restoration of the database.Expertise in indexes and blob data movement to dedicated file groups.Worked on SQL Server Disaster Recovery, Log-shipping and Mirroring.Experience in tuning indexes to improve performance and query executions.