Sql Server Service
Resume:
S wapna
Mobile: +1-818-***-****
Email: ******************@*****.***
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