Description
Summary: Over 11+ years of IT experience of experience in Database Administration and Business Intelligence tools. Microsoft SQL Server (2005, 2008R2, 2012, 2014 & 2016) Database and in Microsoft Business Intelligence (MSBI) - SQL Server Integration Services (SSIS) and SQL Server Reporting Service (SSRS) and AWS (Amazon Web Services). * Experience with AWS components such as EC2, S3, EBS, and Security Groups. * Designed and Developed the Backup and Archiving, Disaster Recovery in AWS Cloud. * Experience in maintaining MS SQL Servers in Production, Development and Testing in Clustered and Stand-alone server Environment. * Expertise in Upgrade and Migration of MS SQL Server in clustered and non-clustered environments. * Automation of database refresh of lower environment from production using PowerShell scripts * Perform database administration activities including configuration, monitoring, space management, database backup & restore disaster recovery and database server maintenance for clustered database servers. * Developed and documented backup, recovery strategies, disaster recovery Plans and participated disaster recovery drills for various environment. Successfully implemented Mirroring for DR solutions. * Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic. Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases. * Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional. * Performed performance tuning using Dynamic Management Views (DMVs) and System Catalog Views, Profiler and Server-side Traces, Windows Performance Monitor, DBCC commands and in-built SQL tools like SQL Profiler, DTA (Database Engine Tuning Advisor) * Worked on database creation, refresh, decommission and instance or server decommissions and ensure maintains a repository * Experience in MS SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) * Transformed data from one server to other servers using SQL Server Integration Services (SSIS) * Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package. * Designer Experience in importing/exporting data between different sources like Oracle/Excel etc. using SSIS/DTS utility. * Expert in transforming complex business logic into Database design and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views and DTS. * Worked on failover cluster and load balancing and moving services & applications from one node to another.