S wapna

Mobile: +1-818-***-****

Email: acd4sy@r.postjobfree.com

E xperience Summary:

I am an IT professional with 8+ years of experience working in enterprise environment

as a M icrosoft SQL Database Administrator. My main area of expertise is M icrosoft SQL

database administrator, T-SQL Developer, IT management and Service delivery.

Area of Expertise:

• Extensive experience in Production support with customer interactions during the

p roduction service analysis.

Worked extensively in MS-SQL Server 2000/2005/2008 and currently

working with SQL 2012 upgraded environment (Production DBA).

More than one year experience in SQL Azure environment.

Having experience as a developer of SSIS Packages and developing reports

using SSRS.

Having more than 5 years’ experience in M icrosoft I IS technology as

administrator and developer.

Gained experience on several tools for technical functionalities and ticketing

tools.

H ighly experienced in monthly patching and application deployments and

I nstallations on production SQL and Web servers.

Good at Win 2003, 2008 and 2012 operating systems under H LB/NLB

environments and supported terminal servers.

Having experience in wri ting T-SQL queries on production databases on

d ifferent requirements.

Experience in maintaining hundreds of production servers along with test

and development servers.

An effective communication with excellent relationship building &

i nterpersonal skills. Strong analytical, problem solving & organizational

abilities. Possess a f lexible & detail oriented atti tude.

Adding value by leveraging Ideas & Best practices, Designing & Providing

relevant Reporting & Status Updates to the higher management.

Good understanding of Onshore and Offshore Model and coordination

experience.

Having good understanding of Microsoft Amalga which helps to get

i nformation in real time, to see any view of data and creating new views of

data.

Leading the Service improvement projects to provide the customer with

better IT environment and minimizing the r isk of service downtime.

Leading and mentoring team technically and functionally.

Good understanding in communicating with end customers to

u nderstanding the requirements and set up the relationships.

Skill Sets:

Technical Functional

RDBMS: M S-SQL Server 2000 / I nf rastructure Skills: W ins mapping.

2005 / 2008 and 2012, SQL with I nstalling and maintaining HP SIM in

W indows Azure. P rod and PPE environments, monitoring

and working on alerts. Working on

Development Skills: T-SQL, SSIS

deployments for Dev/Prod/PPE. SSL

E TL

Certificate creation and Renewal.

M iddle Ware: I IS 6.0, 7.0 and 8.0.

M aintaining IT Config for server

Platforms: W indows NT / 2000 /

i nformation by adding/deleting roles,

W indows server 2003 / 2008 / 2012.

authorize /notify contacts, off t ime

Tools: L i tespeed, Octopus, MBSA,

i nformation etc.

H PSIM, Security Lockdown Policies in

Good knowledge on M icrosoft Applications

Terminal Servers (SQL & I IS), MOM

2

Services, MSC, Cit r ix, ITSM and like Clarify, Axis and ECI. Service request

SCOM. S LA, STR, TTR and smooth delivery to the

end user.

P rofessional Work Experience:

NAME: N HR (NETWORK HARDWARE RESALE)

ROLE SQL DBA/ SQL Developer

ORGANIZATION Network Hardware Resale

D URATION (04/2014) – Till Date

T OOLS & T ECHNOLOGIES Windows 2008, SQL Server 2008 and 2012, SSIS, SSRS and T-

SQL.

CONTR IBUT IO N

Install and configure MSCS clustering with 2 SQL nodes.

Working extensively on Transactional Replication (Updatable

Subscriptions) and t roubleshooting.

Configuring SQL Server security.

Writing Stored procedures using T-SQL using optimization technics.

Working on Log Shipping.

Configuring and managing DB file sizes.

Creating and deploying SSIS packages.

Extracting and Loading the data from difference sources using

I mport/Export Wizards.

Job Monitoring: Monitoring daily scheduled jobs, working on alerts on job

failures.

Performance Issues: Using SQL profiles and tuning advisor for advice on

queries and stored procedures performance. Running t race on application

issues.

Backing up and Restore SQL Databases.

Working extensively on Database Indexing to make the performance better.

Creating and Working on Linked Servers from SQL and Oracle sources.

Working on Table Backups and restoring table data.

Using Perfmon to t roubleshoot high IO and CPU utilization issues at

w indows level.

Working on high CPU utilization issues using different server level tools.

Optimize existing SQL queries to speed up response t ime; tuning of

database parameters, memory & cache.

H ighly skilled in creating knowledge bases and mentoring team on

technical issues daily basis.

NAME: VL I T (VOLU ME LI CENS ING INFOR MAT ION TECHNOLOGY)

CL IENT M icrosoft.

ROLE SQL DBA

ORGANIZATION Tech Mahindra

D URATION (06/2010) – (11/2013)

T OOLS & T ECHNOLOGIES Windows 2008, 2012, SQL Server 2005/2008 and 2012, SQL

Azure, I IS 6.0, 7.0 and 8.0, SSIS, SSRS and T-SQL.

CONTR IBUT IO N

Installing SQL Server 2000, 2005, 2008 and 2012.

Upgrading SQL Server from 20002005 and 2008 to i ts higher versions.

Install and configure MSCS clustering with 2 SQL nodes.

Set up Always-on with 6 availability groups and managing during

m aintenance.

Configuring Always-on in the upgraded SQL servers and monitoring the

environment on daily basis.

4

H igh Availability/Disaster Recovery: Log shipping, DB M i r roring and

replication are using in our environment. Maintaining the production

environment on daily basis.

Configured Transactional replication and managing.

Configured Database M i r roring and creating DB snapshots periodically.

Job Monitoring: Monitoring daily scheduled jobs, working on alerts on job

failures.

Configuring and monitoring Log-shipping in the production servers.

Working on SQL logins issues (creating logins, managing windows level

permissions as and when required).

Managing security at windows level by managing local admin permissions.

Performance Issues: Using SQL profiles and tuning advisor for advice on

queries and stored procedures performance. Running t race on application

issues.

Creating SQL Azure server in cloud environment and creating Databases

and objects using SSMS and Houston-CTPI tool.

Configuring SQL Azure firewalls.

Creating logins/users on SQL Azure.

M igrated the current applications to SQL Azure using BCP, SAMW and

SSIS.

Backing up and Restore SQL Databases.

Debugging and tuning Azure servers’ performance using DMVs.

C reating a Windows Azure Visual Studio Project

Using Perfmon to t roubleshoot high IO and CPU utilization issues at

w indows level.

Working on high CPU utilization issues using different server level tools.

Working with update, insert script to update production data on daily basis

to adjust the users data.

Writing stored procedures which will call jobs to process the user data.

Screening stored procedures to understand the conditions and logic which

is using to calculate the benefits to users.

Optimize existing SQL queries to speed up response t ime; tuning of

database parameters, memory & cache.

Deploying and managing databases in SQL Azure Cloud.

Creating applications in visual studio for Azure applications.

Monitoring the system performance and alerts using SCOM on daily basis.

Creating linked servers to make the database available to Engineering

teams.

Monitoring SQL/Web servers in maintenance like IPAK/Security patching

etc.by BVT ing at server level and application level.

Participating on quarterly/yearly maintenance activities on production

servers like certificate renewals, password resetting of service accounts etc.

H ighly skilled in creating knowledge bases and mentoring team on

technical issues daily basis.

Apart from this, providing support to the end user as per the metrics in

f unctional perspective using t icketing tool ITSM.

•

• I IS Administration Skills

•

Install and configure all versions of I IS 6, 7, 7.5 and .NET framework 2.0

u p to 4.5

Deploy code, configure application pools and all aspects of I IS

configuration from a website/application perspective

Creating and renewing SSL certificates in windows 2005 and 2008.

Troubleshoot and provide technical solutions to environment related issues

encountered by new and existing applications in the environment.

Actively monitor the I IS hosting environment and SQL databases to

i ncrease efficiency, improve reliability, and minimize operating expenses.

Working when websites are down/slow and not available issues.

6

Maintaining the production web servers/ Web sites.

Taking the servers out of rotation and performing node by node BVTs

w hile monthly maintenance.

Performing App pool reset and I IS Reset as and when required.

•

PROJECT NAME: ASM CHANGE REL EASE

CL IENT M icrosoft

ROLE SQL Server DBA

ORGANIZATION Wipro Technologies

D URATION (12/2009) – (07/2010)

T OOLS & T ECHNOLOGIES Windows 2003/2008, SQL Server 2005/2008, I IS 6.0, 7.0, SQL

L i tespeed.

Performed SQL Server DBA role with 16x5 supports to the SQL Server

s tandalone and cluster environments including Production and UAT servers.

Responsible for installation and configuration of SQL server 2005, 2008

databases on Windows 2003 and 2008 servers.

Implementing stand by servers and Log shipping.

Based on the business need created all three replication models on

d ifferent applications.

Configuring high availability using DB M i r roring and managing on daily

basis.

Creating DB snapshots using DB mi r ror to read the data.

Backup/Restore the production DBs with scheduled jobs and scripting.

Inserting/Updating production data as part of deployments.

Writing stored procedures and joins to read the data.

Using joins and select clauses to ret rieve the data.

Using SQL Profiler to t roubleshoot application issues.

Working on DTA using t race files for Indexing advice.

Troubleshooting blocking and deadlock issues as and when occurs.

Deploying UAT and Production boxes with latest releases.

Creating and Renewing I IS certificates.

Updating production and UAT servers with latest service packs and

security patches.

Updating and maintaining all the SQL Process documents.

• I IS Administration Skills

•

Install and configure I IS

Creating and renewing SSL certificates in windows 2005 and 2008.

Troubleshoot and provide technical solutions to environment related issues

encountered by new and existing applications in the environment.

Actively monitor the I IS hosting environment and SQL databases to

i ncrease efficiency, improve reliability, and minimize operating expenses.

Working when websites are down/slow and not available issues.

Maintaining the production web servers/ Web sites.

•

PROJECT NAME: F I T (FI NANC IAL I T)

CL IENT M icrosoft.

ROLE SQL Server DBA

ORGANIZATION Mahindra Satyam

D URATION (04/2008) – (12/2009)

T OOLS & T ECHNOLOGIES Windows 2000/2003, SQL Server 2000/2005/2008, I IS 6.0, 7.0,

SQL Li te speed, MOM.

• As a SQL Server DBA responsible for 24x7 support which includes:

•

Performance monitoring and tuning for UAT/Production Database

Ensuring regular and timely Backup of databases and jobs status on SQL

Server.

Database files, Users, Indexes and disk space maintenance.

Resolving the t rouble t ickets for SQL Server.

8

Implementing all the changes required by development teams as well to

resolve production data issues.

Installing and Maintaining Replication, Log Shipping, and Database

M i r roring.

Working extensively on DB Mi r roring with H igh Availability.

Working on SQL performance issues and blocking/deadlock.

Working on SQL server security issues.

Creating and t roubleshooting SQL jobs using SQL alerts.

Working on high CPU utilization issues and using Perfmon for other IO

issues.

Creating databases and restoring the backup from staging environment to

p roduction environment.

Ensuring regular and timely Backup of databases on SQL Server and jobs

s tatus.

Creating failover cluster for SQL server 2005 with active/passive nodes.

Making the servers standard to onboard them by scanning using different

tools.

Installing SQL and other monthly patches using different tools.

Installing HPSIM tools to get alerts for hardware failures.

Upgrading SQL and win 2003 service packs as per Client requirements

•

PROJECT NAME: ERP SOLUT IONS

Client TJ Telecom, Hyderabad

Role Associate DBA

Organization Tele Data Systems

Duration (06/2005) – (03/2008).

Tools & Technologies Windows 2000/2003, SQL Server 2000/2005.

Project Description: I t was a Telecom project and getting data on daily basis to the

databases, we were supporting on 24/7 basis.

As a SQL Server DBA responsible for:

Implementation of SQL Logins and Authentication Modes as part of

Security Policy for various categories of user support.

Recovering the database from backups in disaster.

Maintaining High Availabili ty of Database using Mi r roring concepts.

Monitoring SQL Server performance using SQL Profiler.

Maintaining the database consistency with DBCC at regular intervals.

Knowledge in database Transactional Replication.

Configuring and Monitoring Log Shipping.

Export or Import data from other data sources like f lat files using

I mport/Export of DTS.

Rebuilding Indexes for better performance.

Education:

Master of Computer Applications (MCA) from Institute of Loyola Academy,

Secunderabad, India. In June 2007.

Bachelor of Science from Osmania University, Hyderabad (A.P.), India in

J une 2004.

Visa / Work Pe rmit Status

An Indian national currently on H1B Visa authorized to work in the

U nited States of America.

Key Strengths

Zeal to learn new technologies and ideas

Logical, analytical approach backed by ability to evaluate implications of

each action

Strong Troubleshooting skill, even beyond my given area of work

Dedication: I stretch myself and give full t ime and effort to my job

10

Ability to work under pressure with responsibility on 24/7 basis.

Contact this candidate