Sql Server Management

Siba P. Panda

Sr. SQL Server Administrator/Architect

408-***-**** ; ********@*****.***

Professional Summary

Microsoft Certified SQL Server DBA with 10+ yrs of Experience. Done my

masters in Database management Systems.

SKILLS

SQL Server Database Services

Integration Services - SSIS

Reporting Services - SSRS

Analysis Services - SSAS

Service Description

As a Database administrator/Architect performed various activities not

limited to:

Database Services

- SQL Server DBA and Production Support

- Implementing and Managing of Replication, Log Shipping, Clustering,

Mirroring, Always-on Availability Groups on HADR

- Install, manage, and troubleshoot multi node SQL Server Clusters

- Hands-on-experience in Always On availability configuration and

administration.

- SQL Server Virtualization and Consolidation

- SQL Server setup, installation, version upgrades/migration and

architect setup

- SQL Server Hardening and best practice implementation

- Capacity Planning, Load Balancing and Scaling out SQL Server

- Design and implement database Backup Restore and Disaster Recovery

strategy

- Database Archiving, Partitioning (Horizontal/Vertical)

- Database Performance Tuning, and Disaster Recovery

- Setting up base lining and capacity planning

- SQL Server Hardware sizing and bottleneck tuning

- Auditing SQL Server Security

- Plan, Design and Scheduled database Maintenance and Administrative

tasks including re-indexing, statistic update, and backup/recovery

strategies

- Configuring Replication (Transactional), Data Synchronization

- SQL Server Performance Tuning using internal and external tools like

Perfmon, Profiler, Index Tuning

- Troubleshoots and resolves database performance issues

- Implements and maintains multiple database environments

Database Development

- Creating Database Schemas, Snapshots for OLTP and OLAP applications

- Planning, creating and optimizing Indexes for databases

- Implementing Data Integrity by using Constraints, Triggers

- Creating and implementing XML Schemas

- Creating, managing and optimizing Performance for Views, Stored

Procedures, Triggers, Functions

- Query Performance Optimization, Execution Plans, Exception Handling

- Optimize database locks

- Worked in AGILE methodology. Good knowledge about Scrum Planning

Data Warehouse Management

- Installing and Configuring Integration Services on Clustered

Environment for High Availability

- Troubleshooting and Optimizing SSIS package performance

- Deployed and Scheduled DTS SSIS Packages

- Experience in design and developing ETL (Extract, Transform, Load) of

large scale enterprise projects

- Installing and Configuring Reporting Services

- Created Reports to meet Ad hoc business requirement

- Publishing / Deploying Report on multiple Report Servers

- Managing Shared Data sources and permissions

- Configured Reports Snapshots, Report Caching for reporting performance

- Created and managed subscriptions for Reports (Email, table driven,

share folder)

- Assigning report level permissions to Secure business information

- Upgraded / Migrated SQL Server Reporting Services

- Configure Backups for Reporting Services

- Installing & Configuring SQL Server Analysis Services

- Memory Management for SQL Server Analysis Services

- Backing Up and Restoring an Analysis Services Database (OLAP)

SQL AZURE / Microsoft Cloud Database Services

- Subscribe SQL Server Azure Cloud Services

- Create Database(s) on SQL AZURE

- Setting up SQL Azure Firewall

- Create, manage SQL Server AZURE Databases

- Setting up Connection Strings and connecting SQL Server AZURE

Databases from locally Installed SQL Server Management Studio(SSMS)

for Developers

Technical Skills

Programming T-SQL, ASP .Net

Languages

RDBMS Microsoft SQL Server 2000/2005/2008 R2/2012/2014

Reporting Tools SSRS, SSIS, SSAS

Design/CASE Tools MS Project, MS Visio

Operating Systems Windows Server 2008 R2/2012 R2

Scripting Language PowerShell 3.0, Windows Scripting, VBScript

Database VMWare VSphere 5.1, vCenter, Microsoft SQL Server

Virtualization Azure, IAAS, PAAS

Tools Microsoft SCOM, Litespeed, HP Sitescope, Siebel

CRM Analytics, Alertra Monitoring

Professional Work Experience

01. Company: City of Eugene, OR Mar 2012 - Till date

Role: Sr. Database Administrator

Currently working at City of Eugene's Information Services Division (ISD)

as Sr. Database Administrator. Handling various projects related to Public

Works, Public Safety, Library & Re-creation, HR & Finance etc.

Responsibilities:

. Provides 24 x 7 Tier-3 Production support of Production Servers and On-

Call 24\7 support

. Installation, configuration and maintenance of SQL Server

2005/2008/2008R2/2012 in a Clustered environment as per standard best

practice

. Planned and completed several database migration/up gradation projects

from SQL Server 2008/2008R2/2005/2000 to SQL Server 2014/2012/2008R2/

across different data centers with minimal downtime.

. Configured and supported SQL Server 2012 Always On Availability Groups

as per HA\DR Solutions.

. Setting up high availability/Failover technologies of Database Servers

using Clustering, Replication, Log Shipping and Database Mirroring

. Migrated all SQL Server objects (e.g. Databases, logins, Agent jobs,

Alerts, Linked Servers, Operators etc.) with the help of scripts

. Created Maintenance plans for SQL Server for index, Statistics

maintenance and backup/recovery strategies Rebuilding or reorganizing

an index is based on the fragmentation percentage which is determined

using DMVs

. Trouble shooting various SQL server 2012/2008/2005/2000 Database

connectivity issues from the web applications.

. Installing SQL Server security patches regular updates.

. Performs physical implementation of databases, storage structures,

high-availability solutions,

. Perform a variety of complex professional work in the analysis,

design, implementation, maintenance, problem resolution, and technical

optimization of system databases and database management software in

client-server, and Internet/Intranet environments

. Design and development of ETL package for multiple Business

Intelligence projects using SSIS and SSRS. Creating SSIS packages and

scheduling the SQL agent jobs to automat execution of SSIS packages.

. Designed, Developed and Deployed reports in MS SQL Server environment

using SSRS. Generated Sub-Reports, Drill down reports, Drill through

reports and Parameterized reports using SSRS.

Environment: SQL Server 2005/2008/2008R2/2012/2014 SSIS, SSRS, Windows

Service 2008 R2/2012, ArcGIS 10, Microsoft SharePoint 2013, Lync 2013,

System Center, VMWare VSphere 5.1

02. Company: Wipro Technologies Aug 2011 - Dec 2011

Client: NBC Universal

Role: Database Architect

NBC Universal is one of the world's leading media and entertainment

companies in the development, production, and marketing of entertainment,

news, and information to a global audience.

The project involves analysis and design of a Private Cloud solution for

NBC Universal using VMWare VSphere 5.0 & vBlock virtualization technology.

Design a plan to migrate existing SQL & Oracle database servers to Virtual

Machines. There are around 500 physical servers that needed to migrate.

Client's Platform Technology team has envisioned building dynamic database

and web platforms to cater to technological changes and to also fulfill the

growing needs of the application platforms themselves.

Responsibilities:

. Architecture design of new virtualization environment (private cloud)

using VMWare VSphere 5.0 & SQL Server 2008 R2

. Provide blue print of the entire solution architecture

. Certify SQL Server 2008 R2 performance and scalability on a VMWare 5.0

platform

. Provide database migration plan from physical to virtual environment

with minimal downtime

. Provided best practice sharing on VMWare with SQL Server 2008R2 (i.e.

Storage, Network, OS, SQL Server etc.)

. Implemented VMWare advanced features like vMotion, DRS (Distributed

Resource Scheduler), VMWare HA, Hot addition of CPU & Memory, Fault

Tolerance, VM Provisioning etc.

. Installation and configuration of SQL Server 2008R2 on respective VM's

(both stand-alone and Cluster)

. Provide overall VBlock architecture with best practice on Storage, OS

& SQL Server configurations

. Implement VMWare advanced features like vMotion, Distributed Resource

Scheduler (DRS), Site Recovery Manager (SRM) on the SQL Server Virtual

Machine's

Environment: VMWare 5.0, SQL Server 2005/2008 R2, Windows Server 2008 R2

03. Company: Wipro Technologies Jul 2010 - Jul 2011

Client: Cisco Systems Inc.

Role: Lead DBA

Linksys, a division of Cisco Systems, Inc., is the recognized leader in

Camera, VoIP, Wireless and Ethernet networking for the home, SOHO (Small

Office, Home Office) and small business users.

This project involves providing maintenance and Support of Client's

Consumer website. The site is being accessed by users across the Globe with

one million users at a peak load and 50% of the websites make database

calls. The objective of the project is to manage scalability, failover and

redundancy. Migration of all physical servers from the existing data center

to a new data center and upgrade SQL Server 2005 to SQL Server 2012 in a

Windows Cluster environment.

Responsibilities:

. Architecture design of new environment running on SQL Server 2008, ASP

.Net

. Develop high-availability plan across Data Center and implementation

. Setting up high availability/Failover technologies of Database Servers

using Clustering, Replication, Log Shipping and Database Mirroring

. Setup new SQL Server 2008 on the new Data Center using standard best

practices

. Perform side-by-side upgrade of Production SQL Server databases with

minimal downtime

. Installation and configuration of SQL Server in a Windows Cluster

environment (Active-Active Cluster)

. Provide tier 3 production support of the database environments

. Perform Query Tuning and optimization of slow running queries

. Identify root cause and implement short & long term fixes for issues

(Problem Management)

. Managing a team of 4 DBA's

Environment: SQL Server 2005/2012, SSRS, SSIS, HP Sitescope, IIS 6.0, .NET

Framework (3.0/ 3.5), Windows Service 2003/2008 R2

04. Company: Wipro Technologies May 2008 - Jun

2010

Client: Microsoft Corporation.

Role: Project Manager (Tier 3 Production Support)

MSIT SQL Operations (SQLOPS) provides SQL Production Support to the entire

MSIT organization consisting of ~2500 Production SQL Server Instances.

Responsibilities:

. High Availability. Review and design high-availability solution based

on the available technologies in SQL Server (i.e. Log Shipping,

Mirroring, Replication, Clustering)

. Performance Tuning. Analyze current performance issues to determine

trends; provide solutions to increase performance, reliability and

connectivity

. Assist customers with deployment of newly developed MS technologies

including scheduling, oversight and other platform related activities.

Acting as liaison between MS product groups and customers involved in

the TAP program.

. Resolving issues escalated by L2 DBA team, maintaining SLAs

. On-Boarding Involved in Capacity Planning and security audits on the

Database Servers. Build up servers as per standards defined by

Microsoft

. Conducting process training, process knowledge tests and training to

bridge gaps and updating of new process requirements

. Root cause analysis for common / complex errors reported out in Major

Incidents Tickets

. Project management done for Onboarding MSO (Microsoft Sales) SQL

Servers into SQLOPS team

. Project management done for implementing ITIL (or Microsoft MOF)

standards for IT Service Management. This includes Incident

Management, Change Management, Problem Management, IT Service

Continuity Management

Environment: SQL Server 2005/2008/2008 R2, Windows 2003/2008, ASP .NET,

Litespeed, Siebel MSE (ticketing tool), VSS (version control tool),

Microsoft SCOM (monitoring tool), PowerShell scripting, Hyper-V

05. Company: Wipro Technologies Mar 2004 - Apr 2008

Client: Microsoft Corporation.

The project involves providing environmental platform support &

infrastructure management to Integrated Reporting project for Microsoft.

The primary purpose of the Integrated Reporting (IR) project is to provide

the ad-hoc operational reporting capability by exposing the data via MS

Cube technology.

Responsibilities:

. Installation and configuration based on best practices of MS SQL

Server 2000 & 2005 database servers, according to the standards and to

the specifications given by the clients

. Plans, defines and executes database maintenance activities including

re-indexing, statistic update, and backup/recovery strategies

. Performs physical implementation of databases, storage structures,

high-availability solutions, replication, and disaster recovery

solutions

. Monitors database efficiency and maintains database performance by

troubleshooting problems, fine tunes the database environments and

performs capacity planning

. Provides technical expertise and hands-on support in consolidation and

migration of databases to new hardware and platforms

. Movements of databases between environments - Migration of databases

between versions like SQL Server 2000 to SQL Server 2005

. Prepare automation scripts (using SQLCMD utility, Windows scripting

etc.) for Production Deployment

. Resolving incidents related to SQL jobs, Replication, Backups and

other SQL server performance related issues

. Audits user activity to ensure integrity and performance of the

database

. Troubleshoots and resolves database performance issues

. Manages, supports and maintains Microsoft SQL Server database

technology and infrastructure, adhering to the architectural

guidelines and policies

Environment: Windows Server 2003 EE x-64, IIS 6.0, SQL Server 2005 x-64,

SSIS, SSRS & SSAS, Informatica ETL 8.6

Educational Qualification

Master in Computer Management (MCM)

Master in Management Studies (MMS - Systems)

Contact this candidate