Description
SUMMARY * Over 13+ years of experience on SQL Server focusing on business information systems as a 24/7 Production DBA, /Lead using SQL Server 7.0,2000,2005, 2008 2012 & 2014, SQL Server cloud (Azure) Oracle 9i, PostgreSQL for Energy & utility Industries. * Keeping High Availability of the Servers as well as its Application Suite with a minimal downtime. * Involved directly with the Project Team, Engineering Team to help and steer them on their new requirements and provided Solutions for the upcoming Change Release to the Project Team. * Provided assistance to Project Team with application-related issues or problems. * Monitoring all the Environmental SQL Servers / IIS Servers / Windows Servers using the Monitoring Tool - Scom. * Excellent troubleshooting and debugging abilities. Possess excellent analytical, communication, and interpersonal skills. * Excellent knowledge on Visual Studio Team Foundation. * Hands on experience with database backup and recovery * Extensive experience in SQL Enterprise Manager - creating and scheduling jobs, alert and operators with SQL Server Agent, SQL Profiler, restoring database using full, differential, and log backups. * Solid experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping, Replication and SQL Server Failover Clustering. * Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks. * Creation and maintenance of Databases, creating Roles and managing user permissions. * Extensive experience in Capacity planning, Performance Tuning, Disaster Recovery, troubleshooting, backup and restore procedures. * Extensively worked on DTS, SSIS, Bulk insert, BCP, T-SQL, VB for data transformation and SSRS for Reporting Services * Ability to manage and troubleshooting IIS problems/Issues. * Expertise in monitoring and resolving blocking issues using SQL profiler and DBCC commands. * Strong analytical, technical, interpersonal and communication skills. * Self-motivated, creative team player with effective communication and leadership qualities. * Hand on experience in automation using PowerShell. * Expert in creating stored procedures, views, triggers, functions, tables, partitions, MDX queries * Hands on experience with configuring CPU, memory, and storage capacity requirements with RAID, table size calculation and capacity planning * Hands on experience in managing OLTP and data warehouse databases sizes up to 6 Terabytes in dedicated and shared environments. * Expert in managing the space on OLTP server through Physical database design using file group placements to manage the space and improve the performance. * Proven experience in archiving Huge volume of data (more than 3 Billion) from OLTP to reporting environment with no downtime and without causing any impact to OLTP * Well versed with the incident management Change management, release management processes * Project & Vendor Management
Accomplishments
Highlights:
Keywords
