Sql Server DBA

Profile:

Around * years of IT experience in Database System Analysis, Design,

Implementation and Administration of MS SQL Server 2012,2008R2,2008, 2005,

**** ** **********, ****, *********** and Replication & Cluster Server

Environments.

Hands on experience in Installing, Configuring, Managing, Monitoring,

Troubleshooting, Upgrading and Migrating SQL Server 2012/2008 &

R2/2005/2000 on Clustered and Standby Environments.

Extensive work experience on system analysis, design, development, testing

and implementation of projects with full SDLC (Software Development Life

Cycle).

Extensively used various transformations in Control Flow tasks, Data Flow

tasks using Visual Studio

Excellent Experience in SQL Server administration, replication, creating

and maintaining Log Shipping and Disaster recovery.

Experience in creating and maintaining SQL Clustering, Optimization,

Backup, restore, Security and disaster recovery.

Experience in developing and monitoring SQL Server Integration Services

(SSIS), Microsoft SQL Server Reporting Services (SSRS), and SQL Server

Analysis Services (SSAS) Packages.

Comprehensively involved in Data Extraction and Transforming and Loading

(ETL) using DTS package in MS SQL Server 2000 and SQL Server Integration

Services (SSIS)

Developed Drill through and Drill down reports using SQL Server Reporting

Services (SSRS). Experience in developing User reports and management

reports using MS SQL Server Reporting Services (SSRS).

Experience in Data Warehouse Modeling with SQL Server Analysis Service

(SSAS).

Experience in Creation and deployment of cubes on SSAS.

Experienced with Star and Snow-flake schema dimensional data modeling.

SQL database design, architecture and data modeling using Erwin.

Excellent knowledge in RDBMS concepts and constructs along with Objects

creation such as Database, Table, Normalization, UDF, User Defined Data

Type, Indexes, SPROC, Views, Cursors and Triggers.

Hands on experience with T-SQL (DDL, DML, DCL) in Implementing & Developing

Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User

Defined Functions, Indexes, User Profiles, Relational Database Models,

Creating & Updating tables and checking the database consistency by

executing DBCC Commands.

Implemented CDC(Change Data Capture) and Change Tracking in SQL Server 2008

for capturing changes for data warehouse environment.

Worked as both Production DBA and Development DBA with 24 x7 support.

Understanding in installing, upgrade, troubleshooting and configuration of

MS SQL Server 2000/2005/2008 Database.

Excellent oral and written communication skills.

Fast learner and adapts quickly to new technology with ability to take new

roles in minimum time and little training.

Ability to work individually as well as in a team with excellent problem

solving and trouble- shooting capabilities.

Education:

Bachelor's in Computer Science from JNTU, India

Technical Skills:

Databases SQL Server 2005, 2008 R2,2012, Oracle 11g, 10g, 9i

Querying/Reportin T-SQL,PL/SQL, SQL * Plus, SQL*Loader, TOAD.

g

Reporting Tools SSRS,Cognos 8, Microsoft Clustering Services (MSCS),

Crystal Reports.

ModellingTools SQL Server Analysis Server 2005(SSAS),ER-win.

ETLTools Microsoft Integration Services (SSIS), Cognos Decision

Stream.

DataMiningTools Microsoft Analysis Services(SSAS),BigBrother, Red Gate

tools

Server Scripting PERL

High Availability FailOver Clustering,Network Load Balancing, Log Shipping

Virtualization VMware 3.1,4,VMware Fusion, MS Virtual Server 2005 R2

MS Terminal Server 2003

ProgrammingLangua C, C++, JAVA, PL/SQL, .Net.

ges

Documentation Latex, MS Office (Including MS Project, VISIO)

Tools

Web Portal HTML, Visual Studio, Ms Front Page,

Technologies,

Front End

Network TCP/IP Named Pipes, SMTP, HTTP. Cisco Routers And

Protocols switches

Internet DNS, DHC

Standards

Other Tools WMI, COM, Microsoft Silver Light, spot light, Share Point

Server,Mom, Scom

Operation Systems Windows Server 2003/2008, UNIX, Solaris, Macintosh, LINUX

PROFESSIONAL EXPERIENCE

Client: APWUHP, Glen Burnie, MD

Jan 14-Till

Date

Role: SQL Server DBA

Upgraded the Existing SQL Server Data base 2005/2008/2008 R2 to SQL Server

2012

Designed and implemented the Clustered Server environment for high

availability both in Physical Environments.

Tested successfully in implementing Fail over SQL Server Clustering in

Virtual Environment

Configured Alwayson in SQL Server 2012

Implemented and maintained Database Replication and Developed the Stand

alone Database for Reporting Servers.

Worked in Analyzing the Project Scope at an Architect level with Business

and Implemented the Project in time in Budget and Involved in Complete

SDLC.

Developed SSIS packages to Extract, Transform and Load (ETL) data into the

data warehouse database from heterogeneous databases/data sources.

Used various transforms in SSIS to load data from flat files to the SQL

databases.

Designed and developed data load jobs using SSIS package and scheduled in

SQL Agent.

Wrote stored procedures and User Define scalar Functions (UDFs) to be used

in the SSIS packages and SQL scripts.

Created packages with different control flow options and data flow

transformations such as Conditional Split, Multicast, Union all and Derived

Column etc.

Implemented database standards and naming convention for the database

objects and documentation of all the processes involved in maintaining the

database for future reference.

Used Bulk Copy program (BCP) to import and export large amounts of data in

and out of SQL Server databases.

Automated and enhanced daily administrative tasks including space

management, object alteration, database backup and recovery

Designed and built Star and Snowflake dimensional models creating facts,

dimensions, measures, cube and established data granularity.

Worked on multidimensional Datamodeling.

Participated in Databases Architecture and data modeling design.

Reviewed and developed data models and database designs with development

teams

Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and

other T-SQL code and SQL joins for applications.

Monitoring Performance of SQL server using SQL Profiler, Query Analyzer,

Database Engine Tuning Advisor (DTA) and Performance monitoring.

Developed various types of reports like Drill down, Drill through and

parameterized reports using SQL Server Reporting Services 2008 R2.

Inspected the reports and fixed bugs in stored procedures and also tuned

Reporting Services to the T-SQL.

Worked on Change Management Cases to resolve the production change request

issues based on the Specifications provided.

Worked on Agile Methodology and Microsoft Team Foundation Server (TFS)

Configured Log Shipping with SQL Server Management Studio as well as basic

account management and troubleshooting with connectivity, security and

firewall issues.

Worked on different kinds of transformations in SSIS as per the client's

Requirement.

Used Index tuning wizard to redesign and created the indexes for better

performance

Environment: SQL Server 2005/2008 R2 /2012, Windows Enterprise Server

2003, ORACLE 10g, IIS 6.0, .NET,UNIX, Erwin, Microsoft Visio 2003,SSRS,

SFTP, Oracle RAC,DB2,Microsoft Silver light, Microsoft Reporting

Services(SSRS), DB2, Share Point Server, SSIS, DTS, Erwin, Cluster

Environments, Red Gate, Spot light, Solaris, SSIS, Oracle Clustered

Environments, Oracle Replication environments,ADABAS. TCP/IP, Named pipes,

LAN Sockets

Client: Wells Fargo, West Des Moines, Iowa

June 13 - Jan 14

Role: SQL Server DBA

Worked and maintained production and development databases in SQL

2000/2005/2008/2008 R2,2012 and Upgraded the Existing SQL Server Data base

2000/2005/2008/2008 R2 to SQL Server 2012

Worked with DBCC Commands for Consistence Database Integrity.

Configured Transactional Replication and Log Shipping with SQL Server

Management Studio as well as basic account management and troubleshooting

with connectivity, security and firewall issues.

Worked with SQL Server Performance Monitoring Tools like Microsoft

Performance Monitor, SQL Server Profiler and Helped in Database

Consistency.

Experience in Raid technologies and best practices in installing SQL server

Configured Database Mirroring as a part of High Availability Solutions.

Worked in Generating Trace Logs and Counter logs in monitoring the Server

traffic and Run the DB Usage reports in Hourly bases.

Worked in Developing and Tuning Tones of Stored Procedures at different

levels of database security and maintenance

Created database objects like tables and stored procedures through

development and testing environments.

Set up database backup and recovery strategies Created and developed the

stored procedures, triggers to handle complex business rules, history data

and audit analysis.

Automated and enhanced daily administrative tasks including space

management, object alteration, database backup and recovery

Extensively Used third party tools in SQL Server Administration like Red

Gate's SQL Backup Pro 7.3

Fine-tuned Stored Procedures using Execution Plan in T-SQL for best

performance.

Used Erwin to Design and Develop Data model for Migration Projects.

24/7 Production support in multiple environments.

Worked on Off Shore/ON Shore model.

Taking a Snap shot of production database in regular bases and developing a

Data warehouse

Worked as a lead for different Ad hock projects in the On Shore and Off

Shore models.

Worked in Reporting Services (SSRS) to generate various Reports with

Graphical representation of data showing the trends in the business in

regular bases.

Used Index tuning wizard to redesign and created the indexes for better

performance

Worked on Different Operational system like Windows 2008/Solaris and UNIX

Successfully Integrated the SQL SERVER Replication services with the Share

Point Servers.

Managed the products and development databases including performance

tuning, capacity planning, SQL Server clustering, database security

configuration, and database continuity used Third party tool Red gate-SQL

Monitor 3.2

Running Index tuning wizard and rebuilding indexes for faster query

response

Created complex Stored Procedures, triggers, cursors, tables, views and

other SQL joins and statements for applications both on SQL server and

Oracle.

Created multiple Read only servers using the Replication to handle tons of

connections.

Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and

Schedules. Monitor connections, locks and performance of SQL server.

Environment: SQL Server 2000/2005/2008/2008 R2 /2012,.NET,SSRS,SSIS,SSAS,

DB2, DTS, Erwin, Cluster Environments, Red Gate,TFS, Spotlight

Client: HARLAND CLARKE, San Antonio, TX

Nov 11 - May 13

Role: Sr. SQL Server DBA

Harland Clarke is a leading provider of best-in-class integrated payment

solutions, marketing services, security services, and retail products. DBA

team was responsible for database recovery, tuning, monitoring, platform

maintenance/upgrades, and making sure the databases are available.

Responsibilities:

Worked and maintained production and development databases in SQL

2000/2005/2008/2008 R2,2012 in a non-stop heavy transactional and reporting

environments

Implemented DR site and high availability servers for production data

warehouse systems.

Implemented Transaction Replication with multiple subscriptions from

multiple sources.

Provided 24x7 support for OLTP and Datawarehouse environments for both

production and non-production.

Involved in migration of database from MS SQL 2000 to MS SQL 2008.

Upgraded SQL Server from 2000, 2005, 2008, 2008R2 to SQL Server 2012 in

Production, stage and Test Environments.

Implemented Active/Passive and Active/Active clustering based on the

project needs with tight timelines.

Actively involved as part of team for gathering and analyzing the needs of

end user requirement and system specification.

Worked on the Reports module of the project as a developer on MS SQL Server

2008 (using SSRS, T-SQL, scripts, stored procedures and views).

Created database maintenance plans, regular scheduled DBA tasks for

enhancing the performance of SQL Server, some of these tasks included

Database integrity checks and re-indexing.

Generated Monthly and quarterly Reports as bar charts for the management

using different techniques like data filtering, adding interactivity,

deploying reports to report server using SSRS.

Worked as a developer in creating complex Stored Procedures, triggers,

cursors, tables, views and other SQL joins and statements for applications.

Involved in Extracting, Transforming and Loading (ETL) data from Excel,

Flat file to MS SQL Server by using SSIS services.

Worked on SSIS for transferring data from Heterogeneous Database (Access

database and xml format data) to SQL Server.

Use DTS/SSIS and T-SQL stored procedures to transfer data from OLTP

databases to staging area and finally transfer into data marts.

Used Erwin to reverse engineer the existing database design in MS SQL

Server 2005

Worked on different kinds of transformations in SSIS as per the client's

Requirement.

Extensively used various transformations in Control Flow tasks, Data Flow

tasks in SSIS packages using BIDS.

Performance tuning of SQL queries and stored procedures using SQL Profiler

and Index Tuning Wizard

Designed cubes with star schema using SQL Server Analysis Services (SSAS).

Modified existing database by adding tables and relationship to existing

data model.

Wrote custom T-SQL stored procedures and triggers to improve performance,

preserve referential integrity and provide additional application

functionality.

Created complex stored procedures for about SSIS, which are used in the

report to customize the report data and to make data analysis efficient.

Maintained the data, database backups and restoration, backup strategies,

scheduled backups.

Involved in complete backing up of Database and restored the database from

Disaster Recovery.

Involved in testing, bug fixing and documentation for the project.

Environment: Microsoft SQL Server 2000/2005/2008/2008R2/2012, Sharepoint,

SSIS, CDC, SSRS, SSAS, Erwin, TFS, Visual Studio.

Client: CheckFree, Dallas, TX

Jun 09 - Oct 11

Role: SQL Server DBA

CheckFree is leading provider for one Biller Solutions in Third party

payment collection industry. Now merged with FISERV provides one solution

for various clients with payments and other financial services. The project

involved on tuning aspects to achieve efficient and cost effective system.

Worked on optimizing the existing SQL queries and improved the performance

of the system.

Responsibilities:

Database planning in relation to physical and logical data architecture.

. Analyzed business requirements and build logical data models that

describe all the data and relationships between the data.

. Created data-related documentation (e.g., file descriptions and

definitions, entity relationships, data dictionaries and attributes).

Deploying new Database objects in production environment.

Designed new SSIS packages and deployed them.

. Migrated data from Oracle to SQL 2005 using Visual studio 2005 package.

Converting SQL Server 2000 DTS packages to SQL Server 2005 SSIS packages.

Modified Data Flow tasks using Visual Studio 2005

. Used SSIS to populate data from various data sources, creating packages

for different data loading operations for applications.

Writing Stored Procedures, Triggers, cursors and creating indexes.

. Created DTS Package designs for Import/Export from different servers like

oracle to SQL Server.

Involved in Extracting, Transforming and Loading (ETL) data from Excel,

Flat file to MS SQL Server by using SSIS services.

Managing the use of disk space, memory and connections.

. Running DBCC consistency checks, and fixing data corruption in

application databases

Monitor and tune SQL scripts. Creating upgrade scripts for production

database and supporting it.

. Exported and imported data from text files and Excel to SQL Server

database using bulk insert and BCP utility.

. Optimized the performance of queries with modification in T-SQL queries,

normalized tables, established joins and created indexes wherever

necessary.

Created user defined data types and added them to model database for future

purpose.

Worked on Authoring Reports and managing reporting services.

Logical and physical database design using Erwin Tool.

Performing query plans and making sure each query is using appropriate

indexes.

Provided on - call 24/7 provide support.

Provided support for in-house and offshore Development Team.

Environment: SQL Server 2000/2005 Enterprise Edition, SQL, Enterprise

Manager, T-SQL,CT, XML, MS PowerPoint, MS Project & Windows 2003 server,

Visual Studio 2005, Redgate SQL toolbelt

Client: State Farm Insurance, Phoenix, AZ

Aug 05 - May 09

Role: SQL DBA

Responsibilities:

Excellent experience configuring and maintaining all three types of

replication like transactional snapshot and merge replication.

Involved in upgrading from SQL Server 2000 to SQL Servers 2005 and test the

application after the upgrade, make sure everything is working fine.

Involved in writing T-SQL programming for implanting stored procedures and

functions for different tasks.

Query Optimization handled by using extensive use of Index implementation

and Index Tuning Wizard SQL Server 2005.

Created Database, creating tables, views, indexes, stored procedures,

triggers and constraints.

Analyze the requirements and fine-tune the stored procedures to improve

performance.

Experienced with improving SQL Server using windows performance monitor to

improve the server performance.

Experienced with SSIS packages, SSRS and SSAS features in SQL Server 2005

servers.

Involved in creating SSIS packages for loading data from data source

(oracle or sql database) to Staging database.

Worked on Client/Server tools like SQL Server 2005 Enterprise Manager and

Query Analyzer to administer SQL Server 2005.

Created Database Maintenance Planner for the performance of SQL Server

2005, which covers Database Integrity checks, Database Statistics update.

Configured and maintained Log shipping architecture to provide backup

server solution for 4 environments.

Created the DTS packages to import the data from MS Access and Oracle

server to SQL Servers.

Created the standard documents for Disaster recovery testing and

implemented them.

Experienced with creating logical and physical database design for

development projects.

Experienced with SQL Server 2005 profiler, SQL Server management studio and

Business intelligent development studio.

Experienced with creating database maintenance plans for efficient

operations.

Involved in tuning SQL Server databases using available tuning methods like

index tuning wizards, profiler and execution plans.

Worked with developers to do the database schema changes and database

restore requests.

Involved in restore operations to refresh the data from production to test

servers.

Involved in creating backup strategy production, test and development

servers.

Experience in improving SQL Server performance by using index tuning

wizards, performance tuning methods, execution plans and profilers.

Experience in setting up security features for MS SQL Servers and maintain

the user access.

Document server and database policies and procedures.

Generated ad-hoc reports using MS-Access and Crystal Reports.

Coordinated post-implementation events such as testing.

Created documentation to install SQL Server, apply service pack and hot

fixes.

Environment: SQL 2000, SQL Server 2005, WINDOWS 2000, 2003, SSRS, SSIS,

SSAS, ASP.NET, Crystal Reports 10.0, MS Access, RedGate SQL toolbelt,

Coldfusion

Contact this candidate