Sql Server Maintenance

RAMYA RAMALINGAM

**** ***** *** ** *** ***, Redmond WA

Phone: 847-***-****

E-mail: *****.******.***@*****.***

PROFESSIONAL SUMMARY

. Over 3 years of experience in IT as Database Administrator.

. Extensive experience in MS SQL Server 2012/2008/2005 with Business

Intelligence (SSMS, SSIS, SSRS).

. Strong technical background along with the ability to perform business

analysis and write effective documentation and specifications.

. Good understanding of SQL Server Architecture design and Data-Warehousing

Concepts.

. Excellent track record in managing successful large-scale Data Warehouse.

. Proven ability to lead teams in the customization of existing solutions

to specifications and on schedule.

EDUCATION

Bachelor of Engineering, Computer Science and Engineering

July 2005- May 2009

SASTRA University, India

GPA: 3.7/4.0

IT EXPERTISE

Databases MS SQL Server 2012/2008 R2/2008/2005, MySQL

5.6.19, Teradata 12

Tools SQL server Profiler, Performance

Monitor, Database Engine Tuning Advisor, SQL server

Agent, SSMS, SSIS

Operating System Windows 2003/2008 server

EXPERIENCE

SQL DBA, HCL Technologies Ltd

June 2010 -May

2013

Client - Commonwealth Bank of Australia

. Performed requirements gathering while adhering to SDLC industry best

practices.

. Performed server installation and configurations for SQL Server

2012/2008.

. Experience in creating Clustered Indexes and Non-Clustered Indexes to

increase the database performance.

. Played an active role in monitoring the overall performance and tuning

the various performance bottleneck using SQL profiler and Performance

Monitor.

. Assisted Business by analyzing data, execution plan and join strategy and

partitioning large tables to improve performance.

. Experience in index optimization techniques using Database Tuning

Advisor.

. Used DBCC Commands to check physical and logical consistency of the

databases.

. Co-ordinate as an interface between onsite and offshore teams to resolve

critical issues and provide production support to manage business without

major service outage.

. Identifying Index fragmentation using DMVs and Reorganizing/Rebuilding

the indexes at regular intervals for better performance based on the

level of fragmentation.

. Identifying and resolving Blockings, CPU bottleneck, index usage and user

connection details using DMVs.

. Collaborated with cross-functional teams, including system architects,

marketing team, QA and end-users to determine system flow and

implementation. Co-ordinated with business and development team on

release planning, environment plan analysis, resource requirements, and

environment testing for monthly release.

. Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling SSIS

Packages.

. Created Packages using Integration Services (SSIS) for data extraction

from Flat Files, Excel Files OLEDB.

. Created reports like Charts for weekly reports using SSRS.

. Experience in working with Recovery models/Backup and Restore.

. Experience in Transactional replication and Database Mirroring.

. Provided 24x7 production support for SQL Server databases.

. Extensively worked in SQL DBA activities which include DBS

installation/upgrading/ maintenance, Creating Databases, logins, handled

security issues concerning creating and administering roles, object and

system privileges for users, user account creation and maintenance.

. Performed capacity planning for changes in the size of databases due to

business growth by using Compression techniques.

. Proactively worked on tickets related to Database Maintenance in SQL

Server.

References Available

on request

Contact this candidate