VARUN

SQL DBA

PROFESSIONAL SUMMARY:

Over * years of experience as SQL server 2012/2008R2/2005/2000 With Telecom, Banking and Health Care sectors.

Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.

Experience in writing Stored Procedures, User Defined Functions, Cursors and Triggers.

Experience in extracting and transforming data using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.

Experience in maintaining the security for databases (creating logins for users, roles, and assigning permissions to them).

Experience in Database Backup, Recovery and Disaster Recovery procedures.

Expert in performance tuning and handling blocking situation and dead lock situations.

Used third party Quest tools like spot light and fog light and Lite speed for backing up large databases.

Experience in Migrating SQL Server 2000 to SQL Server 2005 and 2008 to 2012.

Experience with concepts like data partitioning, online indexing, DDL triggers, DMV, DMF, DTA, SSIS and performance dash board.

Experience in creating jobs, alerts and automating them.

Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC utilities and Index Tuning Wizard.

Intensive experience in monitoring database performance using SQL Profiler and Windows Performance Monitor.

Expertise and Interest include Administration, Development, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.

Performed Log Shipping and implemented Transactional and Snapshot Replication as high availability techniques.

Experience in Database Mirroring as disaster recovery solution.

Good experience with Integration, Reporting and Analysis Services.

Experience in developing ASP.NET websites using VB.NET, C#.

Experience in Data Modeling (logical modeling and physical modeling) using Erwin.

Excellent communication, analytical and inter personal skills and ability to learn new concepts.

TECHNICAL SKILLS:

Languages

C# ASP. NET, T-SQL, My SQL, VB.NET, HTML, XML, C/C++, CSS, DHTML, Java Script

Operating Systems

Windows 95/2000/2003/2008/XP/VISTA/7, Sun Solaris 9, LINUX, VMware ESX servers

Databases

MS SQL Server 2008R2/2008/2005/2000, Oracle 10g/11g, MYSQL, MS Access

ETL & Reporting Tools

DTS, SSIS, SSRS, SSAS, Crystal Reports

DB Utilities

SQL Server Management Utility, Query Analyzer

Application Software

Visual Studio 2005/2008, Visual Source Safe, TFS, MS Office Suite

Tools

SQL DB Access, Performance Monitor, Backup Utility, SQL LiteSpeed, Visio 2000, Red Gate, Fog Lite.

PROFESSIONAL EXPERIENCE:

HPE, Conway, AR JULY’14-Present

ROLE: SQL Server DBA

Responsibilities:

Worked extensively on installation and configuration of MS SQL Server 2005 /2008 /2008 R2 / 2012 on standalone and clustered Environments.

Involved in migration of MS SQL Server 2005/2008 to MS SQL Server 2012.

Handled clustering between two Production Servers and performed daily backups and developed recovery procedures.

Experience in the field of Unit Testing, have tested codes of T-SQL and SSIS packages in the testing environment.

Configured DB mail for sending automatic mails to respective people when SSIS process fails.

Migrated DTS packages to SSIS 2005 packages.

Administered the MS SQL Server by creating User Logins with appropriate Roles, dropping and locking the logins, monitoring the User Accounts, granting and privileges to users.

Scheduled the Backups for Databases and performed Restoration operations.

Created, built and deployed successfully SSIS packages by using BIDS.

Created SSIS packages to validate, extract, transform and load data from Oracle into SQL Server database.

Implemented and Maintaining Replication.

Generate every day morning Replication reports from branch SQL Servers and Resolve Issues.

Created jobs and scheduled jobs according to Requirements.

Assisted in Deploying 2 NODE failover clustering.

Implemented Transactional Replication between Primary and Secondary Servers.

Created Databases, Tables, Indexes and Views.

Created Linked Server between SQL Servers.

Implemented SQL Server Clustering on VM Ware.

Configured Mirroring and Transactional Log Shipping between Primary and Secondary Servers depending on the business requirements.

Worked with SQL Server Profiler to Generate Traces.

Developed documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Continuous monitoring server health with Idera.

Environment: MS SQL Server 2008/2005/2000, Windows 2000/2003/2005/2008/2012, SSRS, SSIS, MS Access, MS Excel VMware, MS Access, SQL Server Reporting Services and Integration Services.

University of Pittsburg Medical Centre (UPMC), Pittsburg PA. JUNE’13-JULY’14

ROLE: SQL Server DBA

Responsibilities:

Installation and Maintenance of SQL Server 2008 R2 on Test, Development and Production Environments.

Usage of new compression Techniques in SQL Server 2008 R2 for backup and restore jobs.

Implemented Database Mirroring and Transactional Replication as a part of DR plan.

Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.

Creating Logins and Roles with appropriate permissions.

Creating and Maintaining Database Maintenance Plans.

Modify Stored Procedures and complex T-SQL Queries to improve query execution process.

Write T-SQL Scripts for database backup jobs and daily/weekly jobs.

Tune slow running queries using SQL Server Profiler.

Import data across multiple instances using BULK INSERT and BCP Utility.

Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.

Plan, analyze and develop Ad-hoc Reports using SQL Server Reporting Services (SSRS) and Report Manager to support various user requirements.

Create and manage database objects that include Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers to implement Business Logic.

Create Clustered and Non-Clustered Indexes to improve the performance of database access.

Create and manage databases across Development and Production instances using SQL Server Management Studio.

Involved in Capacity Planning, Database Normalization and De-normalization process.

Involved in Logical and Physical Data Modeling process using MS Visio.

Use MS Visual Source Safe as a Version Control System.

Involved in Change Data Capture process.

Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.

Environment: TSQL,MS SQL SERVER 2000/2005/2008,SSRS, QUERY ANALYSER, VISUAL STUDIO 2005, VB.NET, C#, WINOWS SERVER 2008, IIS, SSAS.

PNC Bank, Pittsburg, PA. JUNE’12-MAY’13

ROLE: SQL Server DBA

Responsibilities:

Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers.

Installation of SQL Server 2008/05 on Windows Server Clustered environment.

Migrated SQL Server 2000 databases to SQL Server 2005 databases including DTS to SSIS packages.

Extensively worked on Profiler, Perfmon, DMVs, DMFs and DTA to tune the databases, servers and query tuning.

Managed Security using SQL Logins, Roles and Security Modes for various users.

Rebuilding the indexes on regular intervals and placing the huge table/non-clustered index on the separate file group to improve the performance.

Optimized the query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.

Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.

Analyze execution plans and generate suggestions for improvement.

To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.

Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance.

Used Change-data-capture (CDC) for capture changes on a daily basis.

Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas

Supported 24 X 7 Production environment

Environment: MS SQL Server 2008R2/2008/05/00, Windows 2008/2003 Server, C#.net, VB and ASP.NET, MS Visio, Microsoft Visual Studio 2008/2005, MS Business Intelligence Development Studio 2008, MS Access.

I Flex Solutions, Hyderabad, India. JUNE’09 –MAY’12

SQL Server DBA

Responsibilities:

Installation of SQL Server 2005, service packs, hot fixes, security patches.

Worked on the migration of SQL Server 2000 to SQL Server 2005.

Used Data Partitioning, Snapshot Isolation in SQL Server 2005.

Update statistics, database integrity check and Backup operations

Generated reports from Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS, SSRS Packages.

Designed and implemented comprehensive Backup plan and disaster recovery model.

Worked extensively in Query Analyzer and Profiler for tuning queries using variable for characteristics and query costs.

Created and modified Stored Procedures and Functions to generate reports.

Used log shipping for synchronization of database.

Configuring Perfmon, blocking analysis, enabling of AWE and PAE, Max degree Parallelism.

Practical experience in managing the internal and external MS SQL database security.

Environment: SQL Server 2005/2000 with Clustering, Replication, T-SQL, Windows Server 2003 64-bit, Profiler, TFS.

HDFC Bank ltd, Hyderabad, India. SEPT’07-JUNE’09

ROLE: SQL Server DBA/Developer.

Responsibilities:

Created Database tables with constraints and relationships between multiple tables.

Created Views, User Defined Functions and Triggers.

Extensively used the VB coding and HTML usage.

Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.

Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Responsible for creating Stored Procedures and Scheduled to run them by creating SQL Agent Jobs.

Performed various data transfers between various servers using BCP and DTS.

Supported team in resolving in DTS and T-SQL related issues.

Involved in performance tuning and query optimization.

Performed Database and Performance testing for the database objects.

Created backup/restore and disaster recovery plans for production servers.

Backing and Restoring of Databases on Scheduled basis.

Involved in documenting the entire technical process.

Supported technical teams involved with MS SQL issues and operations.

Involved in the maintenance of the database.

Environment: SQL Server 2000, Oracle 8i, VB 6.0, Windows 2000, Erwin, IIS 5.0, Crystal Reports 9.0 and Microsoft Reporting services 2.0.

Education: Bachelor’s of Information Technology, Jawaharlal Nehru Technological University, India.

Contact this candidate