sql server 2012 sql server management studio 17

Languages: T-SQL, PowerShell, ASP.NET, C#. SQL Server Tools: Management Studio, SQL Server Data Tools, Business Intelligence Development Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Performance Monitor, Database Tuning Advisor, Availability Groups.Ĭluster Solution: Microsoft Windows Cluster, AlwaysON availability groups 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.

Experience in installation and configuration of MS SQL Server 2016, 2014, 2012, 2008 R2 instances in Production/QA/Development environments.

Eight years of experience as a SQL Server DBA in IT, Banking, Technology provider firms.

Sql server 2012 sql server management studio 17