Sql Server Data
Resume:
TARUN BHEEMA
TARUN
*****************@*****.***
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