Sql Server
Resume:
Kalyan Vasu Gutta
Email: ******.*****@*****.***
SUMMARY
7+ years of Database Administration and Development experience working on MS SQL Server 2014/2012/2008 R2/2008/2005 Production, Development and Testing in Clustered and Stand-alone Server Environments.
Expertise in Database Administration activities that include Installation, Configuration, Backup & Recovery, Database Security, Database designing and Query optimization.
In depth hands on experience on Transactional Replication and database mirroring for Very Large Databases (VLDBs) and highly transactional systems.
Has worked on SQL Server AlwaysOn high availability feature and has a firm understanding of Contained Databases and Availability groups(HADR) of SQL Server 2012.
Implemented and maintained Log Shipping using Idera SQL Safe and Clustering as part of Disaster Recovery (DR) program.
Creating and Maintaining Database Maintenance Plans for the new server boxes.
Documented Disaster Recovery plans and participated in disaster recovery drills.
Expertise in setting up Active/Passive and Active/Active Clusters for High availability.
Good experience in resolving SQL Server blocking and Dead Lock Issues.
Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes.
Experience in configuring and managing Linked Servers. Data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
Upgraded databases from MS SQL Server 2008 to MS SQL Server 2012/2014, MS SQL Server 2005 to MS SQL Server 2008 and MS SQL Server 2000 to MS SQL Server 2005.
Extensive experience in Capacity Planning, Performance Tuning, Disaster Recovery, Troubleshooting, Backup and Restore Procedures.
Experience in SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services)
Overall database design that involves creating normalized databases, user authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types.
Experience in upgrading SQL Server software to new versions and applying Service packs and hot fixes.
Provide 24/7 production support for mission critical systems.
Experience in implementing various RAID 1, 5 and 10 technologies.
Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures.
Creation and maintenance of Databases, creating Roles and managing user permissions.
Experience in Troubleshooting and documenting root cause analysis.
Hands on experience in writing and debugging Stored Procedures, Triggers, Cursors, Complex queries using T-SQL Scripts and Batch files.
Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
Monitoring Dashboard Reports for Performance Tuning and finding bottleneck in database.
Expertise in using DBCC trace flags, handling blocking and deadlock situations.
Good at Data availability solutions like Online Restore, Online index operation, Database Snapshot and Fast Recovery.
Intensive experience in monitoring and tuning SQL Server database performance using SQL Profiler, DMV’s, Index Tuning Wizard and Windows Performance Monitor.
Had knowledge on NOSQL technologies like MongoDB, Cassandra.
Worked with Third Party Backup solutions like SQL Redgate, Litespeed and SQL Safe for MS SQL Server.
Flexible, Enthusiastic and project oriented team player with excellent communication skills and analytical skills to develop creative solution for challenging client needs.
Technical skills
Project Domain
Application Development, Administration of MS SQL Server 2014/2012/2008R2/2005/2000, Oracle, Sybase.
Programming
Languages
Transact-SQL, SQL, C/C++, Java and Visual Basic
RDBMS
MSSQLServer2000/2005/2008/2008R2/2012/2014, MySQL, PostGreSQL9.2.10, Oracle, MS Access.
Operating Systems
Windows Server 2000/2003/2008/2008R2/2012, Windows XP, 7 Pro, Linux, Unix.
Database Tools
SSMS, SQL Server Business Intelligence Studio, SQL Profiler, SQL Query Analyzer, Index Analyzer, Log Viewer, Database Tuning Advisor, and Upgrade Advisor.
ETL Tools
SSIS 2005/2008/2008 R2/2012, DTS
Contact this candidate