TARUN BHEEMA

TARUN

205-***-****

acoq09@r.postjobfree.com

Professional Summary

Over 7+ years of IT Experience in SQL Server database admin, System Analysis, Design and

Development and Support of Microsoft SQL Server2012/2008 R2 / 2008 / 2005 / 2000 in Development,

Test and Production Environments on various business domains like State government, Product based,

Emergency Services and Manufacturing.

• Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and

Migrating SQL Server 2012/2008/2005/2000 on Clustered and Standby Environments.

• Migration from SQL server 2000 to 2005 and 2000/2005 to 2008 by using In-Place upgrade process

and as well as side-by-side upgrade process, And documented the Upgrade Process and also expert in

migrating DTS packages to SSIS Packages

• Expert in .NET 3.5, C#, ASP.NET, MVC 3, AJAX,WPF[XAML], WCF,SQL Server 2005-

2008.IIS 6.0 and 7.0,Visual Studio 2005 and 2008 and 2010,Team foundation Server (TFS).

• Efficiently worked on db2 implementation in JAVA Application

• Experience in implementing and Monitored different types HA and DR scenarios like Replication, log

shipping and Configure Database Mirroring in Cluster Environment on Production, QA and Dev

environments.

• Configured the servers on 32 bit and 64 bit clustered and standalone server environments.

• Experience in supporting Very Large Database (VLDB) more than 2TB and troubleshooting problems

• Expertise in Database Backup and Recovery procedures by using Native, TDP/TSM and LiteSpeed

to/from Disk /Legato server (Tape).

• Very Good Experience working with SCOM Monitoring

• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor

for monitoring and tuning MS SQL Server performance.

• Experience in using Performance Monitor/Profiler to resolve Dead locks/Long running queries. And

also good experience in data (table) partitioning.

• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database

Consistency Checks using DBCC Utilities and DMV’s and DMF’s, Re-indexing, Updating Statistics

and online indexing.

• Experience in Data operations for transaction Processing

• Experience in data modeling like physical data modeling and logical data modeling by using ERWIN

tool

• Expert in data warehouse modeling (designing Star Schema, snowflake schemas with identifying Facts

and Dimensions).

• Expertise in writing Stored Procedures, Functions and Triggers using T-SQL and also expert in tuning

Complex Queries.

• Good experience on physical storage configuration and optimization of SAN/NAS/DASD with different

RAID levels.

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

errors.

1

• Checking the threshold values and baselines and monitoring in perfmon and SCOM

• Created linked servers between SQL Server 2000 & Oracle 9i, 10g & 11g and Teradata and DB2.

• Expertise on Business Intelligence Tools to Create SSRS Reports, SSIS Packages and SSAS with

OLAP.

• Expertise in implementation of security models; Database authentication modes, creation of users,

configuring permissions and assigning roles to users.

• Expertise in performing data transformations between servers using BCP, DTS, SSIS and bulk insert.

And also Expert in using DMV’s, DMF’s.

• Good understanding in database and data warehousing concepts ( OLTP & OLAP). Experience with

logical and physical data modeling and database design using Erwin.

• Experience in managing Alerts, Operators and Jobs through SQL Server Agent.

• 24 X 7 Production Database on Call Support.

• Strong Technical background with excellent problem solving and communication skills. Strong time

management skills and excellent team player with reputation of integrity and an ability to work on

multiple technologies.

Education:

• Bachelor of Technology in Jawaharlal Nehru Technological University, Ananthpur, India

Technical Skills:

Languages C, C++, DDL, DML, T-SQL.

RDBMS MS SQL Server 2012,2008R2, 2008, 2005, 2000, SQL Server

Management Studio(SSMS), SQL Server Analysis Services 2005,

MS SQL Server Integration Services 2005, MS Access.

Front End MS Visual Basics 6.0.

Web Technologies ASP.Net, WCF Web Forms, XML Web Services, HTML,

Middle Tier MSMQ, Microsoft .Net Technology.

Tools SQL DB Access, Performance Monitor, Backup Utility, TDP/TSM,

LiteSpeed, RedGate, FogLite Crystal Reports, SSRS, VSS

VMware : ESX/ESXi Server 4.1/3.5/3.0/2.5

Web Server Technologies IIS 5.1/6.0.

Data Modeling Tool ERWIN 4.0, Visio 2003, Office Visio 2007

Operating System Windows 2008, 2003, 2000 Advanced Server, Windows 2000 data

center, Windows NT, Windows 95/98/2000 XP.

Professional Experience

State of Wisconsin, Madison, WI Apr’14 –

Till date

SQL Server DBA

2

Responsibilities:

• Installed and Upgraded from SQL server 2005, 2008 and 2008 R2, 2012 and Some servers upgrades

Standard to Enterprise edition

• Migrated Databases from SQL Server 2000 to SQL server 2005 and 2008, 2012.

• Worked in Active-Passive, Active-Active Cluster and DB Mirroring environment as a High availability

solution And Always on.

• Worked with the table partitioning (Sql Server 2008) mechanism to allow the SQL Server engine to

escalate locks to the partition level before the table level.

• Worked with Transparent Encryption, table compression, database compression and merge

statements using SQL server 2008.

• Used Policy Based Administration feature (SQL Server 2008).

• Worked with SCOM Monitoring

• Created Table Valued Parameters (SQL Server 2008) of a table value data type and be able to pass this

variable into a stored procedure.

• Rendered Reports to Microsoft Word using SQL Server 2008.

• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in

Development and Production environments.

• Performing Backup/Restore to/from Legato server (Tape) and Disk

• Tuning queries which are running slow using Profiler and Statistics IO by using different Methods in

terms of evaluating joins, indexes, updating Statistics and code modifications.

• Designed the functional and technical documents, report templates and reporting standards for the

developers to work on the report development

• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for

Applications by using T-SQL.

• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in

terms of evaluating joins, indexes, updating Statistics and code modifications

• Expert to write the auditing scripts for SQL server

• Expert in Performance Tuning of the Stored Procedures.

• Efficiently Carried out DBA Responsibilities in planning DB2 version migration activities, in migration

phases and in performing post migration tasks

• Monitored and managed DB2 thread and locking issues

3

• Produced and analyzed DB2 performance reports

• Checking Database Health by using DBCC Commands and DMVS

• Monitored and modified Performance using execution plans and Index tuning.

• Experience in Database security and integrity planning

• Prepared Documentation for the Disaster Recovery plan

• Designed Data Integrator jobs with Error Handling and email notifications.

• Managing Databases spread across multiple servers in Production, Development, staging & testing

environments.

• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-

Production Servers and handling maintenance Jobs.

• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.

• Routine DBA jobs like Backups and Restores

• Good experience in data modeling and metadata services.

Environment: MS SQL Server 20012,2008 R2, 2008, 2005 and 2000, T-SQL, Erwin, ASP.Net 3.0, SSAS,

SSIS (ETL), SSRS, z/OS, DB2 (Version 9) SharePoint Server 2007 and 2010, Windows 2003 and 2008

Servers,DNS/DHCP/IIS Server

Panasonic Automotives, Peachtree City, GA Dec ’12 –

Mar’14

SQL Server DBA

Description:

Panasonic Automotives serves giant automobile producers like General Motors, Toyota, Hyundai, Daimler or

Mercedes and Tesla. Panasonic is the supplier of Infotainment Head Unit in low end vehicles of GM and high

end vehicles of Daimler and Ford. It has eco-friendly mechanisms, Driver distraction indicator and Driver

Caution features and data analytics systems to process information for automobile producers for efficient

design.

Responsibilities:

• Installed and Upgraded from SQL Server 2005 to SQL server 2008 on Various Production Servers.

• Implemented SQL Data Compression Using Sql server 2008 For Compressing Data and Log Files,

Back Up Level.

4

• Migrating Databases from SQL Server 2005 to SQL Server 2008 by using REDGATE.

• Worked with the table partitioning (Sql Server 2008) mechanism to allow the SQL Server engine to

escalate locks to the partition level before the table level.

• Worked with Transparent Encryption, table compression, database compression and merge

statements using SQL server 2008.

• Used Policy Based Administration feature (SQL Server 2008).

• Created Table Valued Parameters (Sql Server 2008) of a table value data type and be able to pass this

variable into a stored procedure.

• Compare and synchronize your database schemas or data by using REDGATE

• Rendered Reports to Microsoft Word using SQL Server 2008.

• Experience with Virtualization technologies like Installing, Configuring, and Administering VMware

ESX/ESXi. Created and managed VMs (Virtual Server) and also involved in the maintenance of Virtual

Servers

• Worked With 'upsert' commands to programmatically INSERT data if it does not exist or UPDATE the

data if it does all in 1 set of logic (SQL Server 2008).

• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in

Development and Production environment for SQL Server 2005.

• Setting up and Monitored transactional replication, Database mirroring on Production and QA

servers.

• Used DTSXchange tool for migrating DTS packages to SSIS

• Worked in Active Active Cluster environment as a High availability solution.

• Recovered the System and User databases from suspect mode

• Performing Backup/Restore to/from Legato server (Tape) and Disk

• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in

terms of evaluating joins, indexes, updating Statistics and code modifications.

• Extensively used Litespeed backups

• Expert in configuring Tempdb.

• Expertise and Interest include Administration, Database Design, Performance Analysis, and

Production Support for Large (VLDB) and Complex Databases up to 300 TB.

• Designed the functional and technical documents, report templates and reporting standards for the

developers to work on the report development

• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for

Applications by using T-SQL.

• Expert in Performance Tuning of the Stored Procedures.

• Checking Database Health by using DBCC Commands and DMVS

• Monitored and modified Performance using execution plans and Index tuning.

• Experience in Database security and integrity planning

• Used log shipping for synchronization of databases.

• Prepared Documentation for the Disaster Recovery plan

5

• Designed Data Integrator jobs with Error Handling and email notifications.

• Managing Databases spread across multiple servers in Production, Development, staging & testing

environments.

• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting

Services (SSRS).

• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-

Production Servers and handling maintenance Jobs.

• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and

Build.

• Routine DBA jobs like Backups and Restores

• Good experience in data modeling and metadata services.

Environment: MSSQL Server 2008 and 2005, T-SQL, Erwin, ASP.Net 3.0, SSAS, SSIS (ETL), SSRS,

SharePoint Server 2007, Windows 2003 Server, IIS 6.0, IBM DOORS, DNS/DHCP/TCP-IP/IIS Servers .

General Motors -OnStar Emergency Services, Detroit, MI Oct’11 –

Nov’12

SQL Server DBA

Description: OnStar is a product of General Motors provides emergency services during vehicle failures with

press of a button enabling Vehicle voice control protocol for subscribers of low to high end vehicles (GEN 9

and GEN 10) . We also provide a full array of Claims and Loss Control services to support this business,

handled by our knowledgeable and seasoned network of professionals. Our expertise and entrepreneurial

approach allow us to be one of the leaders in the industry.

Responsibilities:

• SQL Server 2005 Database Administration.

• Installed and configured more than 2GB RAM in SQL Server 2005.

• Performed the migration of SQL Server 2000 to SQL Server 2005.

• Configured the servers on 32 bit and 64 bitclustered and standalone server environments

• Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.

• Responsibleto Monitor and troubleshooting Log Shipping.

• Involved in Source Data Analysis, analysis and designing mappings for data extraction also

responsible for Design and Development of SSIS Packages to load the Data from various Databases

and Files.

• Implemented and maintained Database mirroring as a Disaster Recovery Solution.

• Setting up and Monitored transactional replication, Database mirroring on Production and QA

servers.

• Installed, authored, and managed reports using SQL Server 2005 Reporting Services

• Experience in trouble shooting Client connections, viewing error logs and application logs.

• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server

Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

6

• Responsible for monitoring and making recommendations for performance improvement in hosted

databases. This involved index creation, index removal, index modification, file groupmodifications,

and adding scheduled jobs to re-index and update statistics in databases.

• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL

triggers and user-defined functions.

• Experience in implementing and maintaining new T-SQL features added in SQL Server 2005 that are

Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression

(CTE).

• Transferred data (ETL) to Data ware house Environment using SSIS.

• Used Data Partitioning, Snapshot Isolation in SQL Server 2005.

• Expertise and Interest include Administration, Database Design, Performance Analysis, and

Production Support for Large (VLDB) and Complex Databases up to 2.5 TB.

• Expertise in SQL Server Analysis Services.

• Expertise in creating and supporting in OLAP Cubes

• Managed VERITAS net backups and Litespeed backups.

• To analyze long running queries and tune the same to optimize application and system performance.

• Maintaining the database consistency with DBCC at regular intervals.

• Involved in creating and supporting in OLAP Cubes Involved in development activities included

hardware and network specification, installation and configuration, and participation in database

design, architecture and SQL scripting.

Environment: MS SQL Server 2005, ANSI SQL, SSAS, SSIS, BO XI, Informatica, MS SQL Server

Reporting Services 2005 (SSRS), COGNOS, DDL, Erwin, SharePoint Moss Server, ASP.Net, ETL, Erwin,

C#.Net, SAP, CSS, Java Script, XML, HTML.

Compuware - Covisint, Detroit, MI April ’09 –

Sep ‘11

Role : SQL Server DBA

Description: Covisint is a B2B product that provides the platform of choice for enterprises who need to

securely share, integrate and present trusted information to critical people and things across their extended

network of business partners and customers.

Responsibilities:

• Database Administrator, Database Programming.

• Relocation of Databases from one server to another server using attach and detach databases.

• Involved in Up gradationof Touch works Database.

• Touch works application was implemented in Active Passive clustered environment.

• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for

various categories of users.

• Rebuilding the indexes at regular intervals for better performance.

• Designed and implemented comprehensive Backup plan and disaster recovery strategies.

• Migrated DTS packages from Legacy system to SQL SERVER 2005.

• Using the Litespeed to take backups.

• Involved in Weekly Change Management, in which code developed by developers is being run on

production server.

• Implemented log shipping between two instances of servers using Database Maintenance Plan by

creating a Monitor server and a shared Folder.

• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

• Monitored and modified Performance using execution plans and Index tuning.

• Recovering the databases from backup in disasters.

7

• Maintaining the database consistency with DBCC at regular intervals.

• Used DTS packages to move logins and jobs from one server to another server.

• Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS

Designer by using Control Flow and Data Flow Tasks with ETL Tool.

• Transferred data (ETL) to Data ware house Environment using SSIS.

• To set up SQL Server configuration settings.

• Used Data Partitioning in SQL Server 2005.

• Using log shipping for synchronization of database.

• Good experience in data modeling and metadata services.

• Expertise in SQL Server Analysis Services (SSAS).

• Expertise in SQL Server Reporting Services (SSRS).

• Monitoring SQL server performance using profiler to find performance and dead locks.

• Maximum performance and uptime in production environment.

• To analyze long running slow queries and tune the same to optimize application and system

performance.

Environment: SQL Server 2005, SSIS, SSRS, DB2, ETL, Visual Studio.NET, Erwin, DB Artisan, Windows

NT/2003, UNIX.

Avitronics Private Limited, Bangalore, India May ’08

– Mar ‘09

SQL Server Developer/ SQL Server DBA

Description:

Avitronics offers Electronic Warfare Software Services for Bharat Electronics Limited – A Ministry of

Defense organization in India designs and develops Automatic Testing Equipment for Electronic Warfare

to India MIG flights. We administered database for various Radar Warning Receiver Components and

Support to Hindustan Aeronautics Limited which is our client for ATE software versions- MKI &MKII.

Responsibilities:

• Actively participated in gathering of User Requirement and System Specification.

• Created new database logical and physical design to fit new business requirements, and implemented new

design into SQL Server 2000.

• Succeeded migrating old data from legacy system into SQL Server 2000 using DTS and Backup and

Restore option.

• Filtered bad data from legacy system using complex T-SQL statements, and implemented various

constraint and triggers for data consistency.

• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensured database

optimization by using Index Tuning Wizard, SQL Profiler and Query Analyzer (execution Plan).

• Created Users and Roles, and managed security and permission of database.

• Created stored procedures for Automatic Scripting to backup transaction logs, log files, maintain archive

of objects.

• Actively participated in User Acceptance Testing, and debugging of the system.

Environment: SQL Server 2000 Enterprise Edition, .NET, VB, Crystal Reports.

8

9

Contact this candidate