![]() ![]() Strong communication, presentation, documentation, analytical and problem solving skills.Experience working in 24X7-production support.Expertise in identifying, troubleshooting issues and documenting root cause analysis.Expertise in monitoring the production server with SQL Profiler, SiteScope Monitoring, Idera Diagnostic Tool, Solarwinds DPA.Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.Experienced in SQL Server performance tuning, query optimization, Database Maintenance plans, Database Consistency Checks using DBCC and DMV’S.Expertise in deployment and scheduling of SSIS packages.Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).Expert in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.Expert in creating and using Stored Procedures, Views, User Defined Functions.Proficient in SQL Server and T - SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.Excellent skills in developing Backup & Recovery procedures and Database Security procedures to maintain Data Integrity.Handled multiple SQL Instances on Cluster environments for Server Consolidation projects built on SAN using RAID levels. ![]() Experienced in implementing Replication Models such as Transactional and Snapshot in SQL Server 20 R2 in OLTP environments.Experience on migrating the physical servers to Azuredatabases.Experience running a SQL Server environment in Amazon Web Services (AWS).Expertise in implementing Log Shipping as backup solution for MS SQL Server 2005/2008 R2 databases.Expertise in migration of SQL Server 2005 to SQL Server 2008 R2/2012, 2008 R2 to 2014. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |