Sql Server Manager

*** ******** ********* ****, ***************** Web: w ww.prijbs.com

Tel 636-***-**** Fax 636-***-**** Email:

*****@******.***

Khaja Shaheedulla Baig

SQL Server DBA

Cur rent Location : St Louis, MO Availability : Immediate

Visa Status: H1B from PRI Inc R elocation : Willing to Relocate anywhere in US

Summary:

7+ years of professional work experience in RDBMS design & modeling,

development, implementation, administration, performance tuning & monitoring;

work experience spans across banking/finance, Insurance, and retail/ wholesaling

domains on multi large-scale and highly visible projects. Experienced in SQL Server

versions: 2008 R2, 2008, 2005 & 2000

Technical Expertise:

• Proficient in SQL Server 2008/R2 new features like Activity Monitor,

F il tered Indexes, Data Compression, Resource Governor, Transparent

Data Encryption (TDE) and Backup compression.

• Designed and implemented enterprise-wide database backup &

recovery policies.

• Performed disaster recovery drills to test and validate established

DRpolicies

• Expert in performance tuning/monitoring and query optimization by

monitoring

• execution plans, DMVs, System Monitor (Perfmon counters) DBCC

u tili ties & SQL Profiler

• Expertise in resolving locks, deadlocks, handling isolation level and

concurrency effects, Detect CPU, I/O, Memory bottlenecks

• Installed and configured clustered SQL Server instances

(active/passive &active/active)

• Expertise in upgrading SQL Server 7.0/2000 to SQL Server 2005 and

SQL Server

• 2005 to SQL Server 2008/2008 R2

• Implemented log shipping (used as a warm backup solution for MS

SQL Server

• 2008/2005/2000 databases) and database mi r roring in SQL Server

2005, 2008,

• 2008R2 (in conjunction with snapshots for reporting)

• Experience in scheduling Backups and Restore, Log Shipping and

M aintenance plans using Native & Third-party tools (Li teSpeed5.0 and

Red Gate SQL Backup)

• Applied SQL Server database service packs and hot fixes with minimal

p roduction downtime; both clustered and standalone SQL instances

• Expertise in developing Capacity Planning Reports and involved in

SQL Server

• Consolidation projects

• Experience in T-SQL Development skills including stored procedures,

I ndexed views, User Defined Functions (UDL), and Triggers

• Expertise in extracting and t ransforming data between homogenous

and heterogeneous systems using SSIS packages, I MPORT/EXPORT,

B UL K Insert and BCP

• Experience in controlling the User Privileges, Monitoring the Security

and Audit issues

• as per Enterprise Standards

• Excellent wri ting skills, with the abili ty to conceptualize and effectively

document

• Excellent interpersonal and communication skills; detail oriented,

organized and highly motivated

• 24 x 7 production support availabili ty

Educational Qualifications:

• Bachelor of Technology in Computer Science and Engineering from

J NTU, I ND IA

• Masters of Information Technology (Network Systems) from University

of Sunderland, United Kingdom

Professional Experience:

Citi Financial Group, St. Louis, MO April

2012 – Till Date

D atabase Administrator

Managing approximately 200 SQL Servers (2008, 2008R2) with team of 6 DBAs in

24x7 production environment, provided on-call & day-to-day support, SQL Server

2008 R2/2012 installations and maintenance in a 24x7 environment, setup

p roduction/test/dev environments for multiple databases

• Database Administration for all databases (Production

/Development/UAT), with day to day tasks includes database

monitoring, Backups, Space Management, Resource U tilization on

servers.

• Successfully implemented SQL Server 2008R2 Install/upgrades in

s tandalone as well as multi-node clustered environment

(active/passive) on Windows 2003 and 2008 R2 Server and applying

l atest Service Packs to different versions of SQL Server.

• Installing/managing/troubleshooting SQL Server 2008R2/2008 clusters

(2-node and 3-node clusters)

• Monitoring and making recommendations for performance

i mprovement in hosted databases which involved index creation, index

removal, index modification, file group modifications, code

optimization and adding scheduled jobs to re-index and update

s tatistics in databases.

• Conducting database refresh from PROD to UAT, DEV, and Test

E nvironments.

• Worked on problem management, performance tuning, identifying

locking and blocking for long running queries.

• Capacity planning for the primary assigned servers to ensure adequate

CPU, Disk space and Memory

• Fine-tuning and t rouble shooting for day to day problem or issue raised

by development team

• Monitoring and optimizing the performance of the database through

Database Tuning, Tuning Applications, Tuning Memory, and Tuning

D isk Usage, Implementing Backup and recovery mechanisms.

• Setup and configure SQL Server for other business functions. Index &

Data Management to determine Defragmentation level; whether to

U pdate Statistics or Rebuild Indexes

E nvironment : Clustered SQL server 2008R2/2008, Windows 2008R2/2008/2003,

Active-Active Clustering, i3 Performance Monitoring Tool, Upgrade Advisor, SQL

P rofiler, Performance Monitor, T-SQL, DTS, SSIS, VB.NET 2003/2005, and JAVA,

F TP/SFTP

Saxon Mortgage, I r ving, TX J an 2010 –

M ar 2012

Database Administrator

DBA with responsibilities included: installations, migrating, creating and

monitoring maintenance plans, creating database objects, query optimization, and

job development and monitoring

Responsibilities:

• Installed and configured SQL Server 2008 R2 clustered and standalone

i nstances

• Migrated databases from SQL Server 2005 to SQL Server 2008 R2

• Worked with table partitioning (SQL Server 2008) mechanism to allow

t he SQL Server engine to escalate locks to the partit ion level before the

t able level.

• Worked with Transparent Encryption, table compression, database

compression and merge statements using SQL server 2008.

• Created new database objects like Tables, Procedures, Functions,

I ndexes and Views using T-SQL in Development and Production

environment for SQL Server 2005.

• Tuning queries which are running slow using Profiler and Statistics Io

by using different Methods in terms of evaluating joins, indexes,

u pdating Statistics and code modifications.

• Checking Database Health by using DBCC Commands and DMVS.

• Prepared Documentation for the Disaster Recovery plan

• Daily routine DBA tasks like handling user’s permissions and space

issues on Production and Semi-Production Servers, handling

maintenance Jobs, database refresh from production to lower

environments on demand.

• Installed hot fixes and service packs on clustered and standalone SQL

i nstances

• Managed and created indexes on tables in consultation with

development team to reduce table scans

• Proactively monitored DB server state information by utilizing custom

s tored procedures (with the results stored in a utility DB)

• Implemented file-groups to manage VLDB’s efficiently

• Responded to t rouble t ickets and resolved all support related issues

• Routinely monitored Windows and SQL Server error logs to diagnose

and t roubleshoot any known issues

• Worked on developing Capacity Planning Reports and involved in SQL

Server Consolidation projects.

• Designed many Packages using SSIS which involved data from

d ifferent heterogeneous systems such as Oracle and DB2 Mainframe

systems.

• Responsible for capacity planning, monitoring Disk I/O, CPU and

memory.

• Solved critical production problems, such as database point in t ime

recovery and recovered some corrupted databases.

• Periodic checking of all databases with DBCCcommands for

maintaining data consistency and integrity and Responsible for

keeping system and databases up-to-date by making necessary

changes.

• Provided 24 x 7 on-call support

Environment : MS SQL Server 2008R2/2005/2000, T-SQL, SSIS, Composite

Software 5.0.0, Report Builder, Li te Speed, BCP, SQL Profiler, Log Shipping,

Replication, Mi r roring, Clustering, Windows XP/2000 and Windows 2003 Server.

Blue Cross Blue Shield (BCBS), Richardson, TX A ug

2008 – Dec 2009

Database Administrator

Blue Cross and Blue Shield brands are the nation's oldest and largest family of

health benefits companies and the most recognized brands in the health insurance

i ndustry. The main mission of BCBS is to promote the health and wellness of

communities through accessible, cost-effective, quality health care. Blue Cross and

B lue Shield companies offer a variety of insurance products to all segments of the

population, including large employer groups, small businesses and individuals.

P roject was to upgrade more than 450 Servers from SQL Server 7.0 and 2000 to SQL

Server 2005, involving different applications. I worked on installing SQL 2005

Servers on Clustered and standalone environments, Converted and deployed more

t han 200 packages using DTS Exchange, involving different kinds of tasks, such as

A nalysis processing task, script task, Data f low task etc. Some of the applications

t hat I handled are, Blueview Application, In telligent Call Management, and

B usiness Acquisition Reporting Application involving Analysis services.

R esponsibilities:

• Upgraded SQL Server 7.0/2000 Servers to SQL 2005/2008 Server, 60+

p roduction databases, with database sizes ranging from 100GB to

1.5TB.

• Installed and Configured SQL Server 2005 (64 and 32 bit) on

S tandalone and Microsoft Clustered servers and Applied the latest

Service Packs, Hot fixes and security patches.

• Worked with different application teams, for gathering information and

analyzing the changes before upgrading the databases. .

• Depending upon the application requirement, and the size of the

databases, used both Side-by-Side and In-place migration

methodologies.

• Used RML Ut ili ties and Upgrade Advisor, for analyzing the

performance improvement of SQL Server 2005 over SQL Server 2000

and the changes that need to be made before and after SQL 2005

Server upgrade.

• Implemented SDLC development and acceptance test environments.

• Created complex t r iggers on tables for logging the data, wrote complex

queries and joins as per the business requirements.

• Involved in Converting, Designing, deploying and maintaining more

t han 250 packages which included lot of data operations and analysis

p rocessing tasks.

• Developed and designed SSIS packages for importing the data from

ODBC sources, MS Access, MS Excel, DB2, Oracle and f lat files etc.

• Involved in migrating DTS packages to SQL Server 2005 In tegration

services packages, using DTS Exchange. For deploying SSIS packages

i n different environments, used configuration files.

• Involved in managing day-to-day DBA activities such as checking SQL

Sever logs, event logs, daily jobs, backup jobs and moving the backup

f iles to SAN, by creating users and roles for login authentication,

validating permissions and removing orphan users.

• Used SQL L i teSpeed v4.8, to backup and restore databases, scheduled

TSM (Tivoli Storage Manager) backup jobs every night to achieve the

backup files from different servers to Data Center in Waukegan.

• Installed and Configured SQL Server Analysis Services processed the

cubes and dimensions after migrating the OLAP databases.

• Resolved various performance issues, by running DBCC commands,

using SQL Tracer and SQL Profiler, to t rack down Dead locks and long

r unning queries.

• Configured Database Mail and scheduled database maintenance tasks,

a lerts to the operator by means of email in case of success/failure of job

and to solve emergency scenarios like server shutdown, when the

database is in emergency/suspect/shutdown mode

• Generated test data and tested database to meet the functionalities

deliverables in the project documentation and specifications.

E nvironment : Clustered SQL server 2000 and 2005 servers placed at Waukegan,

W indows server 2003 R2, Enterprise x64 Edition Service packs 2, OLAP,

T ransactional Replication, Failover Clustering, SQL Li te Speed V4.8, HP Open

v iew, DTS Exchange, RML U tilit ies, Upgrade Advisor, SQL Profiler, SQL Server

Configuration Manager, T-SQL, DTS, SSIS, SSAS, Informatica, VB.NET

2003/2005, Erwin 4.0.

P rocadence Technologies, United Kingdom M ay

2006 – Jul 2008

Database Administrator/Developer

Worked as a SQL Server Database Administrator/Developer for Financial

Accounting System of the company, worked on improving the performance of the

database Systems, I was involved in the tuning of the existing database objects and

i n the upgrade project of SQL Server 2000 to SQL Server 2005

Responsibilities:

• Installed SQL Server 2005 on Windows Server 2003; applied service

packs and hot fixes

• Migrated SQL Server 2000 instances to SQL Server 2005

• Actively participated in both logical modeling and physical modeling

p hases of SDLC

• Established relationships amongst various entities; designed ER

d iagrams

• Normalized data t ill the 3rd NF; de-normalized selected tables, as

necessary

• Designed database schema using third party tools like Erwin

• Researched and presented technical documentation to set standards,

guidelines and best practices for SQL Server database installation,

administration, Backup & restore procedures, database security, and

SQL database development across the enterprise

• Documented and presented capacity planning projections

• Created databases, and database objects that included: tables, views,

i ndexes, stored-procedures, t riggers, functions, cursors.

• Created complex t r iggers on tables for logging the data, wrote complex

queries and joins as per the business requirements.

• Created and managed database users, logins, and administered

database securi ty

• Developed and utilized DTS Packages extensively for ETL

requirements (uploaded data from Oracle, SQL Server, & f lat files)

• Developed T-SQL scripts to enforce business rules

• Setup log shipping between various sites to support planned and

u nplanned application failovers

• Optimized the performance of queries by removing unnecessary

columns, eliminating redundant and inconsistent data, normalizing

t ables, establishing table joins, and creating indexes on the most

f requently queried columns

• Resolved performance related issues due to excessive blocking, and

deadlocking

• Created DTS Packages based on the business requirements and

m igrated some DTS Packages to SSIS Packages

• Rebuilt an existing Data Transformation Services (ETL) system that

supports the BI processes

• 24x7 supports in a Production Environment & On call Support

E nvironment : SQL Server 2000/2005, Windows Server 2003, I IS 6.0, DTS, SSIS,

SSRS, BIDS, SQL Server Profiler, VB Script, Index Tuning Wizard, Database

T uning Advisor, ERWIN

Contact this candidate