Sql Server Manager

Gurbir Singh

SQL Server DBA

____________________________________________________________________________

_______________

Summary of Experience:

o Microsoft Certified SQL Server DBA with around Eight Years of

experience in MS SQL SERVER 2008/2005/2000 Database Administration in

Production, Test and Development environment.

o Experienced in designing and implementing complete Software

Development Life Cycle (SDLC) for client servers and database

applications.

o Designed and documented Logical and Physical Data Models.

o Experience in relational database modeling using tools like CA Erwin

and Microsoft Visio.

o Expert in installation and configuration of MS SQL Server 2008, 2005 &

2000 in different 32/64 bit environments.

o Expertise in Installing and configuring SQL Server 2008/2005

Active/Active and Active/Passive clusters on 32/64 bit Window Server

2003 and Window Server 2008 .

o Expertise in migration of SQL Server 2000 to SQL Server

2005/2008,SQL Server 2005 to SQL Server 2008, 32/64 bit in cluster

and non-cluster environments.

o Implemented Database Mirroring as High Availability in SQL server 2005

& 2008.

o Expertise in implementing Log Shipping as backup solution for MS SQL

Server 2000/2005/2008 databases.

o Highly experienced in implementing Replication Models such as

Transactional, Snapshot and Merge in SQL Server 2000, 2005 and 2008 in

OLTP environments.

o Excellent skills in developing Backup & Recovery procedures and

Database Security procedures to maintain Data Integrity.

o Expert in developing and documenting the backup and disaster recovery

plan.

o Highly experienced in Developing DTS/SSIS Packages for data

extraction, transformation, and loading from various heterogeneous

sources.

o Experienced in developing and deploying complex reports using SSRS

(Reporting Services)

o Experienced with Data Warehousing (OLAP) methodologies such as star

schema, snowflake schema and Dimensional Modeling using Analysis

services SSAS

o Hands on experience in building SSAS data cubes and populating data

marts

o Highly Experienced in SQL Server performance tuning, query

optimization, Database Maintenance plans, Database Consistency Checks

using DBCC and DMV'S

o Expertise in monitoring the production server with native tools like

SQL Profiler, Window System monitor.

o Expertise in identifying, troubleshooting issues and documenting root

cause analysis.

o Experienced in configuring and managing Linked Server, Data transfer

between SQL Server and other Databases

o Experience in contacting Microsoft and other vendors for product and

technical support.

o Experience in providing 24X7 support.

o Experience in using the third party tools like Idera 's Diagnostic

Manager, SQL Nexus, Quest 's Spotlight, Foglight & Lite Speed.

o Experience in working with quality assurance and version controlling

tools

o Superior communication, presentation, documentation, analytical and

problem solving skills.

Certificate of Excellence from Microsoft:

o MCITP Database Administrator SQL 2008

o MCTS SQL Server 2008 & SQL 2005

o Microsoft SQL Server 2008 -Designing, Optimizing and Maintaining a

Database Administrative Solution ( 070-450)

o Microsoft SQL Server 2008 - Implementation and Maintenance (070-432)

o Microsoft SQL Server 2005 - Implementation and Maintenance (070-431)

BrainBench Certifications:

o Microsoft SQL Server 2008 - Administration

o Microsoft SQL Server 2005 - Administration

o RDBMS concepts

Technical Skills:

RDBMS MS SQL Server 2008, 2005, 2000, 7.0

Operating Systems Windows 2008, 2003, Windows 2000, Windows NT

4.0, Windows 95/98/ XP

Cluster Solution Microsoft cluster

Technologies RAID, SAN

Version Control Tools Visual Source Safe, Source Gear Vault

Other Tools Erwin Data Modeler, MS Visio, BMC Remedy, DeskPro

Languages C, C++, T-SQL, XML, HTML Script, Java script

Third Party Tools Lite Speed, Spotlight, Foglight, Idera's

SQL Diagnostic Manager, SQL Nexus, Lumigent's

Explorer, MOM, SQLIOSIM

Application Areas:

o Database Security

o Backups and Recovery

o Clustering (Active/Active and Active/Passive Environments)

o Database Mirroring

o Log Shipping

o Replication

o Performance Tuning

o DTS (Data Transformation Services)/SSIS

o SSRS

Professional Experience

Verizon Wireless, Alpharetta, GA Jan 09 to Till Date

SQL Server DBA

Description:

Verizon Wireless operates the nation's largest and most reliable wireless

voice and 3G network. Headquartered in Basking Ridge, N.J., Verizon

Wireless is a joint venture of Verizon Communications (NYSE, NASDAQ:VZ)

and Vodafone (NASDAQ and LSE: VOD. Verizon Communications Inc.,

headquartered in New York, is a global leader in delivering broadband and

other wireless Verizon Wireless operates America's most reliable wireless

network, serving nearly 93 million customers nationwide. SQL server /

Oracle / DB2 / Sybase are database platforms which are used to support IT

infrastructure.

Responsibilities:

o Install and configure SQL server 2008/2005.

o Migrating and upgrading SQL instances from SQL 2000 to SQL 2008/2005

in dev/test/production environments.

o Planned, installed, configured and maintained the SQL Server 2008 in

Environment of Active/Active Cluster with Multiple Instances.

o Project DBA for one of the applications. Activities -

Installing/configuring SQL server, patching, troubleshooting,

performance tuning.

o Primary DBA for various assigned servers in development/test/pre-

production/production environments. Activities - Keep a check on daily

infrastructure jobs, troubleshooting failed infrastructure jobs,

intermittent and periodic maintenance tasks, prepare

daily/weekly/monthly checklist.

o Optimization and Performance tuning using Idera's SQL Diagnostic

Manager, SQL Profiler, Performance Monitor and SQL Nexus. Also

involves stored proc optimization, query optimization, index

optimization.

o Tuning of SQL Server Memory structures and troubleshooting the

existing issues with Buffer Pool and Paging

o Support and set up environment with transactional replication

(configuring central publisher/distributor, managing publication,

managing subscription, implementing changes and troubleshooting).

o Supported and set up Database mirroring; a 'High Availability'

solution for critical operational databases.

o Configured and monitored the Database mirroring for the report

server for the creating the reports on the archived data

o Promoting new databases from one environment to another and make sure

that requirements and policies of team are met by application team;

using Red gate SQL compare and SQL Server Management Studio.

o Actively involved in capacity planning/requirement analysis and I/O

capacity using SQLIOSIM

o Troubleshoot production server issues (priority 3 and priority 4) on

day to day basis.

o Experience in load Testing in QA and implementing the changes to

Staging servers and Production servers.

o Providing 24 X 7 supports for production environment. Troubleshoot

priority 2 issues on production servers and also resolving priority 2

infrastructure alerts related to production servers.

Environment:

o Windows server 2000/2003/2008, MS SQL Server 2008/2005/2000, Idera's

SQL Diagnostic Manager, SQL Litespeed, SQL Nexus 3.0, SQLIOSIM, Red-

gate SQL Compare.

UnitedHealth Group, Minnesota

Dec 07 to Dec 08

SQL Server DBA

Description:

UnitedHealth group is one of the leading health care and health insurance

Company in the US. UHG has a huge IT infrastructure to support its wide

range of health care products and services. UnitedHealth Group is a

diversified health and well-being company dedicated to helping people live

healthier lives. UnitedHealth Group serves approximately 70 million

individuals worldwide, and operates in all 50 states and internationally.

Responsibilities:

o Involved in Migration of Databases from SQL Server 2000 to SQL Server

2005/2008

o Installed, Configured and maintained the SQL Server Cluster 2005 on

Windows Server 2003

o Configured and Monitored Database Mirroring for Application

Development environment

o Migration of DTS packages to SSIS packages

o Involved in Installation, configuration and maintenance of the

Reporting Services on Web Farm.

o Configured and maintained Database mirroring for transferring the

Archived Data to the Report Server.

o Involved in Deployment of Reports using SSRS with Scale-Out topology

o Involved in SQL Server Configuration, Administration, Implementation

and Trouble-shooting for Business work.

o Configured Transaction Replication on the Production server for the

internal reporting

o Controlled and coordinated the installations (Security Patches,

Service packs) and evaluated the performance before Pre-deployment.

o Involved in daily code drops and archives on the production databases

during maintenance windows.

o Performed Regular Database Maintenance process, checking the disk

Defrag procedures in different environments.

o Performed Database Refresh tasks from production to Development and

Staging Servers

o Performed Database consistency checks with DBCC, Defrag, Index tuning

and monitored error logs

o Database Performance of Index tuning with using Database Engine Tuning

Advisor to resolve Performance issues

o Used Idera's Diagnostic Manager and Performance monitor for monitoring

SQL Server Activities and keep a real time check on health,

availability and performance of SQL Server

o Created Users and Logins as per Standards

o Developed and optimized database structures, stored procedures,

Dynamic Management views, DDL triggers and user-defined functions.

o Work involvement in performance monitoring of Memory, Processor, Disk

I/O and fine tuning

o Handled Scheduled backups and restore operations with Litespeed 5.0

and monitored the tasks and Maintenance plan

o Involved in writing Stored Procedures and Functions, Cursors to handle

database automation tasks

o Preparation in Weekly, Monthly system maintenance report for Database

backups

o Actively involved in development of automated daily, weekly and

monthly maintenance tasks such as backups, verifying database

integrity etc.

o Provided 24x7 supports to SQL application developers in implementing

the applications on production server.

Environment

o Windows Server 2003, MS SQL Server 2000/2005, Quest 's Spotlight,

LiteSpeed5.0, CA Erwin 4.0

BroadRidge Financial Solutions Inc, NY

Dec 06 - Nov 07

SQL Server DBA/Developer

Description:

BroadRidge Financial Solutions Inc offers complete brokerage processing

services, from the industry's most widely trusted and deployed processing

platform to our robust wealth management solutions. BroadRidge Financial

Solutions, Inc., with over $2.2 billion in revenues in fiscal year 2009

and more than 40 years of experience, is a leading global provider of

technology-based outsourcing solutions to the financial services industry.

Responsibilities:

o Involved with maintenance of ACTIVE/PASSIVE Cluster Environments.

o Worked on SQL Server 2005 with latest Service Packs.

o Involved in moving SSIS packages between various environments

including Dev, QA, Staging and Production

o Maintaining Dev, QA, Staging and Production servers in sync.

o Connecting SQL servers remotely using Terminal services.

o Set up jobs to schedule SSIS packages using SQL Agent.

o Developed Ad-hoc and customized reports using SQL server reporting

services (SSRS)

o Created complex SSRS reports using complex expressions to calculate,

group, filter, parameterize and format the contents of a report

o Configured reporting services and managed reporting security by

creating groups and granting access to report folders and Ad-hoc

reports as required

o Involved in a team for implementing Data Warehousing (OLAP)

methodologies such as star schema, snowflake schema and Dimensional

Modeling using Analysis services SSAS.

o Build SSAS data cubes and populating data marts.

o Created Database Maintenance Planner for the Performance of SQL Server

which covered Database Integrity Checks, Update Database Statistics

and Re-indexing.

o Using SQL Server Integration Services (SSIS) tool of SQL Server to

populate data from various data sources, creating packages for

different data loading operations for application.

o Experience in creating and executing SQL Server Integration Services

(SSIS) packages.

o Managing schema objects such as tables, views, clusters, indexes,

procedures, triggers & maintaining Referential Integrity depending on

user requirements and converting them into technical specifications.

o Administering 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.

o Database and Transaction log backups & restoration, backup strategies,

scheduling the backups. Backing up system & user databases and

restoring them whenever necessary.

o Used BCP and Bulk Insert utilities.

Environment:

o Windows Server 2003, MS SQL-Server 2005/2000, SSIS, SSRS, Idera's SQL

Diagnostic Manager, Quest's Litespeed, Erwin

Ericsson India Private Limited, India

June 03 - Oct 06 SQL Server DBA/Developer

Description:

Ericsson is a world-leading provider of telecommunications equipment and

related services to mobile and fixed network operators globally. Over

1,000 networks in more than 175 countries utilize our network equipment

and 40 percent of all mobile calls are made through our systems. We are

one of the few companies worldwide that can offer end-to-end solutions for

all major mobile communication standards. Ericsson is a leading provider

of telecommunication and data communication systems, and related services

covering a range of technologies, including handset technology platforms.

Responsibilities:

o Installed, Configured and maintained the SQL Server 2005

o Review / test / apply all database changes to all environments

including QA, Development and Production Servers. Monitor SQL Error

Logs, Schedule Tasks, database activity, eliminate Blocking &

deadlocks, user counts and connections/locks etc.

o Worked with SQL server Profiler to generate traces.

o Actively participated in Logical design phase of new database.

o Worked on MS Visual Studio to draw data model.

o Solved issues related to server performance and disk space.

o Resolved issues related to query optimization, database optimization

and index tuning.

o Creating and managing schema objects such as tables, views, clusters,

indexes, procedures, triggers & maintaining Referential Integrity.

o Server & Application fine-tuning & trouble shooting.

o Monitoring MS SQL Server performance, identifying the issues and

resolving the issues.

o Monitored the SQL Server using the Microsoft Operation Manager.

o Administering 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.

o Configured Log shipping from one production server to the reporting

server.

o Configured the Database mirroring in the SQL Server 2005 instances as

High Availability.

o Implemented built in log shipping with SQL Server 2000 for disaster

recovery server.

o Designed, implemented and documented the Disaster Recovery Solution.

o Created and maintained the SQL Agents jobs and configured them to send

the alerts and email on failure to DBA group.

o Creating the jobs for running the packages automatically.

o Good in Implementing SQL Server security.

o Implemented and documented proactive monitoring scripts for production

databases.

o Monitored SQL Server Error Logs and Application Logs.

o Develop the reports for business users using Crystal Reports.

Environment:

o Windows 2000 server IIS 5.0, Window Server 2003 IIS 6.0, MS SQL

Server 2000/2005, Crystal Report, Microsoft Operation Manager (

MOM), Visual Source Safe

Patni Computers, India July 02

- May 03

SQL Server Developer

Description:

Patni Computers is a software services and consulting company based out of

India. It is one of India's oldest and Asia's largest and most prestigious

providers of information technology and business process outsourcing

services. As a SQL Server Developer, I was involved in the development of

Finance and Payroll databases and applications.

Responsibilities:

o Managing of database objects like Tables, views, indexes etc

o Created views for easier implementation on web pages, and wrote

triggers on those views to provide efficient data manipulation.

o Worked with BCP and DTS to load text files to SQL Server.

o Created stored procedures and functions to support efficient data

storage and manipulation.

o Optimized the performance of queries with modification in T-SQL

queries, removed unnecessary columns, eliminated redundant and

inconsistent data, normalized tables, established joins and created

indexes wherever necessary.

o Involved in various stages of Software Development Life Cycle like

Design (Logical & Physical), Development, Testing, Implementation and

Maintenance.

o Worked on Client/Server tools like SQL Server Enterprise Manager and

Query Analyzer to Administer SQL Server and develop Distributed

Queries.

o Worked on the implementations of an application that included security

module, database module, network module, report module using VB.

o Involved in writing queries and optimizing the performance of the

queries.

o Helped the front end application developers with their queries.

o Working on different environments like development, staging,

production

o Involved with optimization of Stored Procedures, Triggers, Views

o Worked on Server Native tools like SQL Server Enterprise Manager and

Query Analyzer to Administer SQL Server.

o Created reports using crystal reports as per the customer requirements

o Gave training session to the end users for the new product such as

using the product.

o Successfully resolved deadlock issues by creating traces on objects

using SQL Server Profiler.

o Worked to establish connectivity between VB Applications and MS SQL

Server by Using ODBC

o Maintained version control of database releases

o Application development using Visual Basic.

Environment:

o Windows 2000 Server IIS 5.0& Windows XP, SQL Server 2000, T-SQL,

Windows Server, HTML 4.0, VBScript, JavaScript, Access,, Crystal

Reports

[pic]

[pic] [pic]

[pic]

[pic][pic][pic]

Contact this candidate