Sql Server Data
Resume:
Sarath Chandra Vanga
************@*****.***
SUMMARY:
8+ years of experience with the 32bit, 64-bit Microsoft SQL SERVER in Production, Development and Testing in Clustered and Stand - alone Server Environment.
Expertise in installation of MS SQL Server 2014/2012/2008 R2/2008/2005/2000 and updating with latest service packs, hot fixes and security patches.
Very good T-SQL Programming skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
Extensively implemented the change management processes by using team foundation server (TFS) and Visual source safe (VSS).
Implemented and monitored different types of High Availability & Disaster Recovery scenarios like Always-on Availability Groups, Replication models (Snapshot, transactional), Log Shipping, Database Mirroring and Clustering (Local & Geo/Multi Site).
Good at SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
Handful of Experience on SQL server 2008 new features like Microsoft SQL multi server administration, resource governor, performance data collector.
Exquisite skills in Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling native Backup/Recovery of databases, Database Maintenance Planning.
Backup to or restore from Windows Azure Blob storage service.
Implemented the concepts like Data partitioning,Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-catch blocks, CTE, Online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and Dedicated Admin Connection.
Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
Experience in configuring and managing Linked Servers. Data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
Checking the threshold values and baselines and monitoring in perfmon and SCOM.
Worked extensively on Clustering and server consolidation. Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
Expertise in resolving locks, deadlocks, handling Isolation level and concurrency effects, detect CPU, I/O, Memory bottlenecks. Deployed and Debugged SSISpackages for import, export and bulk insert data with transformations from various datasources.
Extensively used the native tools like index tuning wizard or database tuning advisor, profiler, performance monitor, activity monitor, Event viewer for performance analysis.
Used third party tools like EMC Networker, Idera, Litespeed, Redgate, and Tivoli backup. Good knowledge on delivering predictable performance, scalability, business continuity, data protection using Microsoft Azure SQL Database.
Auditing of database for users transaction, login and database action and removing orphan users.
Worked with a team of business analysts, data architects, application developers, ETL developers and testers.
Data modeling Experience like Physical data modeling and logical by using ERWIN.
Excellent Problem Solving Skills, Communication, presentation and interpersonal skills. Strong troubleshooting and organizational skills.
Strong experience in mentoring with team members, documentation and 24/7 on call production support.
EDUCATION:
Bachelor’s Degree, Jawaharlal Nehru Technological University, Hyderabad.
TECHNICAL SKILLS:
Operating System
Windows 7/Vista/XP/2000/NT, Server 2012/2008R2/2003, Exchange 2003, Linux, UNIX
RDBMS:
MS-SQL Server 2005/ 2008/ 2008R2/ 2012/ 2014, MS Access
Languages
Transact-SQL, SQL, C/C++, Java, Mat lab, Lab view, and Visual Basic
Database Tools:
Enterprise Manager SQL Profiler, I-SQL, T-SQL, PL/SQL, SSRS, SSAS, ODBC, OLTP, ADO, SQL OLEDB, ERWIN, PSSDIAG, VISIO, IIS,HP SAN SCSI, LITE SPEED, RED GATE, VSS, BMC(MAGIC Help Desk),TFS, Double Take, SQLMON
ETL Tools:
SSIS 2005/2008/2008 R2/2012, DTS
OLAP Tools:
SSAS 2005/2008/2008 R2/2012
Reporting Tools:
SSRS 2005/2008/2012, Crystal Reports, MS-Excel(Pivot Tables, VBA, Macros)
Data Modeling Tools:
CA Erwin, MS-Visio, MS-Visual Studio
PROFESSIONAL EXPERIENCE:
CATHOLIC HEALTH INITIATIVES, Denver, CO. Mar’ 15 – Sep’ 15
Sr. SQL Server DBA
Responsibilities:
Installed and configured SQL Server 2005/2008R2/2012/2014 (Standard and Enterprise editions) in clustered and non-clustered environments.
Migrated SQL Server 2005 databases to SQL Server 2008 R2 databases including SSIS packages and from SQL Server 2008 to SQL Server 2012.
Performed in-place upgrade from SQL Server 2008 to 2008 R2
Implemented and maintained always-on, Database Mirroring, Log shipping and Transactional Replication as Disaster Recovery solution in SQL Server 2008 R2/2012.
Managed and administrated SQLServer2012/2008R2/2005 on production and non-production servers.
AlwaysOn Enhancements using 8 secondary replicas instead of 4 in SQL Server2014
Using Cluster Shared Volumes (CSVs) Failover cluster instances (FCIs) that was added on SQL Server2014.
Involved in supporting Multi node Cluster environment in production having databases of size 3 to 10TB.
Identify deadlock, blocking scenarios and Perform Re-indexing and Index defrag operations for the maintenance of large tables to resolve performance issues.
Implemented Policy Based Management on the servers and also wrote a Power Shell script which generates reports for monitoring space of the drives on the servers.
Used Idera SQL Safe tool for performance monitoring, backup and recovery, security, auditing and Power Shell scripting
Worked and provided production support to ETL based applications.
Deploying and promoting SSIS packages from TEST to Prod environment.
Developed a SSIS package to load data from SQL Base to SQL Server 2008 R2.
Creating SSIS Packages and maintaining them.
Recreating of DTS packages in 2008 SSIS.
Documentation of all the packages created.
Creating SSRS reports in between to test the data by managers, Worked on Data Staging and Cleansing.
Performed Failover drill tests to check the High Availability during disasters.
Worked and responsible for design, implementation and enhancement of ETL jobs.
Used Lite Speed for backups and maintenance jobs which includes updating statistics, database integrity checks
Worked in setting up the SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options
Developed and created the new database objects including tables, views, index, stored procedures, functions, triggers, advanced queries and also updated statistics
Modified Stored Procedures and complex T-SQL queries to improve query execution process
Used SQL Diag utility tool for troubleshooting some issues.
Worked on Hardware SAN and RAID levels configuration and placement of database files/file groups across different drives.
Hands on experience on Dump load and in place upgrade from 12.x to 15.x
Used third party tools like Quest lite speed for taking backups and restoring them, Spotlight and Confio Ignite tool for SQL performance monitoring.
Created Logins, Roles and Proxy accounts with appropriate permissions and maintaining Database Maintenance Plans.
Configured DB mail by creating accounts and profiles
Worked on extensively on Linked servers and also was part of Oracle 11g Upgrade.
Created and managed nightly Prod copy Jobs on the lower environments
Monitored alerts using Fog Light and Spotlight and also looked into Event Viewer, SQL Error logs and Log File Viewer for software and hardware related errors.
Worked on many Enhancement Projects and Upgrade Projects
Provided On call Production support
Environment: MS SQL Server 2008R2/2008/05,Windows 2008/2003 Server, C#.net, VB and ASP.NET, Lite Speed, MS Visio, Microsoft Visual Studio 2008/2005, MS Business Intelligence Development Studio 2008, Ignite, Spotlight, Radmin, Oracle 11g/10g, Double Take
ABC Supply, BELOIT, WI. Feb’ 13 –Feb’ 15
Sr. SQL Server DBA
For over 30 years, ABC Supply has been contractors’ partner in success. Headquartered in Beloit, Wis., it has more than 490 branches in 49 states and is the largest wholesale distributor of roofing in the United States and one of the nation’s largest distributors of siding, windows, and other select exterior building products.
Responsibilities:
Involved in Administration, Database Design, Performance Analysis, and 24X7 Production Support for Large (VLDB) and Complex Databases.
Managed over 250 SQL Servers including Production and Test servers.
Managed over 1500 databases and the largest database was around 5 TB.
Installed and configured SQL Server 2005/2008R2/2012/2014 (Standard and Enterprise editions) in clustered and non-clustered environments.
Experience configuring and working Microsoft SQL server on VMware Environment.
Implemented and monitored different types of High Availability &Disaster Recovery scenarios like Always on Availability Groups, Replication models (Snapshot, transactional), Database Mirroring and Clustering (Local & Geo\Multi Site).
Experience in Creating, managing SQL Server AZURE Databases and setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio (SSMS) for Developers.
Worked on Data Center Migration. Migrated SQL Server 2000/2005/2008 to SQL Server 2008 R2/2012/2014 respectively. Migrated DTS to SSIS packages .Documented the Migration process.
Worked on server consolidation. Migrated databases from physical servers to Virtual and cloud servers, which was cost effective.
Worked on capacity planning for existing production servers before consolidation and moving them to new data center
Upgraded SQL Server 2008R2 /2005/00 databases to SQL Server 2012/2014 databases.
Responsible for ensuring that company's databases are performing optimally through performance tuning, including: storage balancing, re-indexing, aggregation, partitioning, migration and maintenance plans.
Tested and implemented Backup to multiple files for faster and smaller SQL Server files.
Managed Security using SQL Logins, Roles and Security Modes for various users.
Developed scripts and tools used for Proactive monitoring of databases both from a performance and capacity management perspective
Good troubleshooting skills in production environment.
Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
Extensively worked with SQL Profiler, Execution Plan, Extended Events, PerfMon, Data-Collector Tool and DBCC Commands.
Worked with System Center Operations Manager (SCOM). Tested the threshold values and baselines and monitoring in PerfMon and SCOM.
Responsible for Application support for front-end feeds and Resolved Application connectivity issues like connection time-outs, connection pooling issues and memory leaks.
Created/altered/modified and tuned T-SQL Stored Procedures, Complex Queries, views, tables, and functions on OLTP and OLAP environments like Data warehouse and reporting.
Debugging complex and long stored procedures and workflow packages.
Administered windows server 2003/2008 R2/2012/2014 and managed server level security. Worked on Windows Active Directory (AD) for maintaining user information and authentication.
Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks. Created SSIS packages to load robust data from different Heterogeneous data sources like Oracle, SYBASE to SQL server.
Created, deployed and managed reports using SQL Server Reporting Services (SSRS)
Expertise in creating and supporting in OLAP Cubes
Work with vendors in evaluating and implementing new technologies.
Documented procedures\processes and Trouble-shooting guides for various issues.
Environment: SQL Server 2014/2012/2008R2/05/00, Windows Server 2012/2008R2/03 server, SCOM 2012/2007R2, VSPHERE 4.1/5, VSS, BIDS, TSM, TDP, SQL Profiler, Data Collector Tool, Perfmon, T-SQL, SSIS, SSRS, Share Point 2010/2013, Flexpod, NetApp, .NET4/3.5, MS- Excel, MS-DOS, Lotus Notes, HP Service Manager
ALCON, Irvine, California. Aug’ 11 – Dec’ 12
SQL Server DBA
Alcon is one of the pharmaceutical companies in the world. It is one of the largest pharmaceutical companies in the world both by market capitalization and revenue. Alcon discovers, develops, manufactures and markets a broad range of innovative products to improve human and animal health, directly and through its joint ventures.
Responsibilities:
Create and maintain various databases for Production, Development and TestingServers using MS SQL Server 2012. Planning the location of data, indexes, and Transaction log files on the disk.
Install and configure SQL Server 2012 on the server and client machines, provide connections and manage databases.
Use of DBCC Utilities to maintain the consistency and integrity of each database in the production server.
Conducted root cause analysis of application availability and narrow down the issues related to coding practices, database bottlenecks, or network latency.
Resolve locking and blocking issues.
Tuning the Production server to get the performance improvement.
Running Index Tuning wizard for optimal query performance.
Implemented Database Mirroring as part of disaster recovery plan.
Monitoring and Troubleshooting performance during peak periods with 600 to 800 concurrent connections.
Use of Microsoft Diagnostic utilities to take memory dumps and automated traces.
Implementing and Monitoring Transactional Replication and other SQL Server jobs using custom scripts.
Monitoring SQL Server LOGS, Application logs and analyzing the logs.
Connecting SQL Server remotely using Terminal services.
Providing 24*7 supports to SQL application developers in implementing the applications on production server.
Maintaining both DEV and PRODUCTION Servers in sync.
Creating users and assigning appropriate permissions.
Creating Backup strategies and scheduling them as a part of database maintenance plans.
Used NetIQ to improve the performance with the EMS.
Created the MS DTS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
Performed Logical Modeling, Physical Modeling, Forward and Reverse Engineering tasks in Data Modeling.
Involved in Performance Tuning for source databases, target databases, MS Analysis Server.
Environment: MS SQL Server 2012, IIS Server 5.0, Diagnostic Manager, Reporting Services, XML, Crystal Reports 10.
Falcon International Bank, Laredo, TX. Oct’ 09 – May’ 11
SQL Server DBA
Falcon International is Texas community bank founded in 1986. Its services include commercial banking, Finance and Insurance products and services. Falcon ranks among the top 100 of Hispanic business Magazine which list 500 largest Hispanic ownes business in U.S.
Responsibilities:
Administration and Maintenance of SQL Server 2005/2000 databases in Production, Staging, QA and development environments.
Responsibilities include the Production and Application Support for the Database and Application Servers.
Installing, Configuring and Maintaining SQLServer 2005/2000 on Active/Active Cluster with latest Service Packs, Hot Fixes.
Designed the Database Recovery plan and implemented the Database Mirroring in SQL Server 2005 and participated in Disaster Recovery Drill processes.
Provide and Monitor database "health" - availability, reliability, performance and capacityplanning using SQL Profiler, Database Tuning Wizards.
Provide Reliability using Transactional Replication.
Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.
Resolving performance issues using DMVs (Dynamic Management Views).
Performance Tuned Stored procedures using Index Tuning Wizard, Estimated Execution plan, Profiler and PerfMon.
Used the DMV’s to find the missing indexes on the tables for most appropriate used and missing indexes.
Setup, Installation and Configuration of SQL Server RDBMS. Evaluating and installing patches/Service Packs.
Optimization, performance tuning of SQL Server Systems and databases.
Setup Database Security and maintain accounts and access levels by creating suitable Logins, Roles and assigning object level permissions.
Analysis, development and maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.
Created Auditing procedure related Data using DDL/DMLTriggers to keep track all the changes to database and data in tables.
Environment: MS SQL Server 2005/ 2000, Windows server 2008/ 2003 Datacenter and Enterprise edition 32 bit/64 bit, Transact-SQL, SQL LiteSpeed, MS Visio for Enterprise Architect, ADO.net, VB.net, SSIS,SSRS, TFS(Team Foundation server).
United Healthcare, Hyderabad, India Jan’ 07 - Aug’ 09
SQL Server DBA\Developer
United Healthcare has a range of products and services that include medical imaging and information technologies, medical diagnostics, patient monitoring systems, drug discovery, and biopharmaceutical manufacturing technologies.
Responsibilities:
Actively participated in gathering User Requirements and System Specifications.
Filtered unnecessary data using complex T-SQL statements, implemented various Constraints and Triggers for data consistency.
Created Views to facilitate easy user interface implementation, and Triggers on them to facilitate consistency Data entry into the database.
Created Reports from database onto excel spread sheet using DTS.
Wrote complex stored procedures to process employee’s requirements and generating records between front end and back end.
Created various reports using Crystal Reports after performing Data Analysis
on the various Views of Business Intelligence.
Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure optimal performance of the server.
Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity.
Involved in fine Tuning Performance and Query optimization of the Database as required by the application.
Created Users and Roles, managed security and permissions of the databases.
Maintained SQL Scripts for creation of Database Objects.
Environment: SQL Server 2000, EXCEL, Erwin 3.x, Crystal Reports 9.
Contact this candidate