O BJECT I VE :

Seeking a position as a SQL Server DBA in initiatives that utilize state-of-the-art,

software and/or hardware components with a creative, technology-driven organization

and in an environment that encourages innovative thinking, recognition and career

development

C AREER SU M MARY :

Over Five years of experience in Database Administration and Developer for

very complex and large databases in SQL Server 2008 R2 and 2005.

Expertise in Database Administration on Production Server with server

configuration, patch, upgrade, maintain and migrate databases.

Expertise and proficiency in SQL Server Replication with Disaster Recovery

P lanning and Security Management operations.

Expertise in T-SQL, wri ting stored procedures, t r iggers and functions.

Experience with H igh Availability solution such as Cluster, Replication,

M i r roring and Log Shipping.

Worked on upgrading SQL Server 2005 to 2008 R2.

Troubleshoot performance problems, fine-tuning of databases and index

A nalysis.

Maintained individual service accounts for SQL Server services on cluster

w ith different Security groups to raise securi ty mark.

Experience in Data center servers and handling large databases.

Handling Memory configurations for SQL Server 2008 R2.

Experience in Batch processes, Database Moni toring tools and Application

support.

Experience in data migration between the two environments with SSIS and

I mport, Export wizard.

Strong experience in mentoring team members and wri ting documentation.

Designed data Partitioning solutions for tables and indexes; r isk monitoring

and control.

Strong Experience in creating jobs, Alerts, SQL Mail Agent and Scheduling

D TS and SSIS Packages.

Experience in maintenance plans to perform index de-fragmentation,

reorganize index, rebuild index, and update the index statistics.

Experience in implementing different types of Replication Models such as

Peer to Peer, Merge, Transactional and Snapshot on basis of business

specification.

Experience in performing integrity checks, methods includes configuring the

database maintenance plan wizard and DBCC utilit ies.

Expertise in t roubleshooting SQL issues by using SQL Tools, Execution

p lans, Trace, statistics, Index Tuning Wizard.

Experience in using Performance Monitor, SQL Profiler and optimizing the

queries, t racing long running queries and deadlocks.

Experience in applying patches and service packs to keep the database at

current patch level.

Operating Systems: W indows Server 2003/2008 R2, Windows XP/ Vista / 7,

V Mware

Database: M S SQL Server 2012/2008R2/2005

Languages: T-SQL, C++, C#, Java, XML, HTM L, JavaScript, ASP, ASP.net and

Power Shell

R eporting/Analysis Tool: SSRS (SQL Server Reporting Services), Crystal Report

Data Modeling: SQL Server Database Diagram, ER Win, RedGate, VISIO

O ther Tools: SharePoint 2010, Quest L i teSpeed, Remedy Ticketing System, JIRA.

MS Office: Word, Excel, Access, Outlook and Power Point.

E D UCAT IO N :

Bachelor of Computer Information System, City University of New York,

2008

P ROFESSIONAL E XPER I ENCE :

Scholastic, NY

SQL Server DBA M ay 2012 to

P resent

Responsibilities:

Upgraded SQL server 2005 to SQL Server 2008 R2 in Microsoft Windows

Server 2008 R2 Enterprise Edition.

Installed, Configured, and Managed SQL Server 2008, and 2005 in

development, test and production environment.

Installed, Configured, and Managed SQL Server 2012 in development and

test environment.

Checking Database Health by using DBCC Commands and DMVS.

Involved in Analyzing and Upgrading SQL Server 2005 test servers to SQL

Server 2008.

Having experience on SAN and RAID levels and building SQL Cluster servers

on SAN Environments.

Perform SQL Server service pack and Windows Service pack upgrades.

Troubleshoot performance problems and fine-tuning of databases.

Expertise in designing databases and capacity planning.

Rebuilding the indexes at regular intervals for better performance.

Expert working SQL Server H igh Availability solution such as Replication,

Log Shipping and Mi r roring.

Worked extensively in Query analyzer and profiler for tuning queries using

variable for characteristics and query costs.

Designed and Deployed SSIS Packages to Export and Import Data from

various Databases and Files.

Reviewed physical and logical database design; Promote the reliabili ty of

database design by ensuring appropriate referential data integrity is

i mplemented and appropriate data types are used.

Monitored and modified Performance using execution plans and Index

t uning.

Involved in t roubleshooting and fine-tuning of databases for i ts performance

and concurrency.

Designed and implemented comprehensive Backup plan and disaster recovery

s trategies Implemented and Scheduled Replication process for updating our

parallel servers.

Designed and created databases, tables, views, store procedures and t r iggers.

Updating database systems by reviewing, planning, testing and installing

database securi ty patches and service packs.

In conjunction with development teams, define and maintain database and

code standards and naming conventions for the organization to ensure

consistency in database and code development.

E nvironment: SQL Server 2005, 2008 R2,2012, Windows Server 2008/2003

L i teSpeed 4.5, MSE, T-SQL, Oracle PL/SQL, MySQL, JAVA, .Net, SQL, HTM L,

D HTML, Oracle 9i, PL/SQL Developer Tool.

Social Security Administration (SSA), MD

SQL Server DBA February

2009 – May 2012

R esponsibilities:

Installed, configured SQL Server 2005 and 2008 R2 for all environments.

Checking Database Health by using DBCC Commands and DMVS

Experience Upgrading SQL Server 2005 to SQL Server 2008.

Expert working SQL Server H igh Availability solution such as Windows

C lustering, Replication, Log Shipping and Mi r roring.

Perform SQL Server service pack and Windows Service pack upgrades.

Designed and implemented comprehensive Backup plan using SQL

M anagement Studio.

Resolved and tweaked memory pressures caused during product release.

Troubleshoot performance problems and fine-tuning of databases.

Expertise in designing databases and capacity planning.

Rebuilding the indexes at regular intervals for better performance.

Experience working in SharePoint 2010.

Designed and implemented comprehensive Backup plan and disaster recovery

s trategies Implemented.

Worked extensively in Query analyzer and profiler for tuning queries using

variable for characteristics and query costs.

Review of physical and logical database design; Promote the reliability of

database design by ensuring appropriate referential data integrity is

i mplemented and appropriate data types are used.

Monitored and modified performance using execution plans and Index tuning.

Transferring the data from MS Excel to SQL Server 2005 & SQL Server 2008

t hrough SSIS package.

Rebuilding the indexes at regular intervals for better performance.

Involved in t roubleshooting and fine-tuning of databases for i ts performance

and concurrency.

Designed and created databases, tables, views, store procedures and t r iggers.

Updating database systems by reviewing, planning, testing and installing

database securi ty patches and service packs.

In conjunction with development teams, define and maintain database; code

s tandards and naming conventions for the organization to ensure consistency

i n database and code development.

To provide 24x7 production support for SQL Server databases on Clustered

Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum

performance and uptime in production environment.

Environment:

SQL Server 2000, 2005, SQL Server 2008, SharePoint, Windows Server 2003/2008

Servers, Web, T-SQL, Oracle PL/SQL, MySQL, JAVA, .Net, SQL, HTM L, DHTML,

O racle 9i, PL/SQL Developer Tool.

Morgan Stanley, NY

SQL Server DBA June

2008 - February 2009

R esponsibilities:

• Implementation of SQL Logins, Roles and Authentication Modes as a part of

Securi ty Policies for various categories of users

• Technical t rouble shooting and give consultation to development teams.

• Expert Troubleshoot performance problems, fine-tuning of databases and

i ndex Analysis

• Developed, monitor, and maintain backup and recovery for all assigned

databases to include the appropriate t ransaction logging.

Monitoring H igh availability Solutions of the SQL Server Databases.

Responsible to Monitor and t roubleshooting Log Shipping.

Setting up and Monitored t ransactional replication, Database mi r roring on

P roduction and QA servers.

Participate in implementation of new releases into production.

Day-to-day administration of live SQL Servers.

Designed and implemented Security policy for SQL Servers.

Used Stored Procedures, DTS packages, BCP for updating Servers.

Designed and implemented comprehensive Backup plan and disaster recovery

s trategies Implemented and Scheduled Replication process for updating our

parallel servers.

Deploying Administration tools like SQL DB Access, Performance Monitor

and Backup U tili ty.

Table parti tioning to improve I/O access.

Tuning queries which are running slow using Profiler and Statistics by using

d ifferent Methods in terms of evaluating joins, indexes, updating Statistics

and code modifications.

Enforce Database Security by Managing user privileges and efficient resource

management by assigning profiles to users.

Monitored and modified Performance using execution plans and Index

t uning.

Using database level t r iggers code for database consistency, integrity and

securi ty.

Tested and Implemented procedures to detect poor database performance,

collecting required information, and root cause analysis.

Daily routine DBA tasks like handling user's permissions and space issues on

P roduction and Semi-Production Servers and handling maintenance Jobs.

Responsible routine DBA jobs like Backups and Restores.

Environment:

M S SQL Server 2005/2000,T-SQL,DTS, SSIS, Report Builder, ASP.Net, C#, VSS,

A DO.Net, BCP, SQL Profiler, Performance Monitor, Backup Utili ty, OLAP,

Replication, Log shipping, M i r roring, Windows XP/2000, Active Directory and

W indows 2003/2008 Server.

Contact this candidate