SUMMARY

• 9 +years of experience with the 32bit, 64 - bit Microsoft SQL SERVER in Production, Development and Testing in Clustered and Stand alone Server Environment.
• Experience installing MS SQL SERVER 2014, 2012, 2008R2, 2008, 2005, 2000; updating with hot fix and service packs.
• Good knowledge and handful of experience on implementing Always on High availability starting from sql 2012.
• Extensive experience in implementing High availability solutions like different Replication models (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines.
• Extensively worked on Active-Active and Active-Passive Clustering.
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, Event viewer for performance analysis.
• Experience in comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
• Experience in Backing up, restoring the data base manually and also by scheduling the jobs and Maintenance Plans.
• Expert in analyzing the execution plan and index management for better Query Optimization.
• Handful of experience in PowerShell Scripting.
• Implemented In place and Side by Side Migration of MS SQL SERVER 2000/20 .
• Expert in Data Integrity, Performance Tuning, Query Optimization
• Expert level skills in Objects creation such as Tables, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing.
• Expert in creating Views.
• Experience in using DMV and dynamic management functions (DMF) Of Tables, Triggers, Store Procedure etc. for finding out long running queries.
• Explicitly used third party tools like Lite Speed, Fog light and Red gate.
• Auditing of database for users transaction, login and database action and removing orphan users.
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.
• Expert in developing T-SQL (DDL, DML, DCL) statements.
• Expertise in Data Modeling Concepts.
• Good at SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in logical and physical data modeling of the database in ERWIN and MS VISIO.
• Configured the AWE and /3 GB switch for the SQL server 2005 on 32-bit boxes.
• Handling Memory configurations for SQL Server 2000 and 2005 on Windows 2003 Server.
• Experience in handling the Change Data Capture (CDC) with different retention time.
• Experience in SQL Upgrades SQL and Building SQL Clustering.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Experience in using the DMVS, DMFS, SP PROCS, INFORMATION SCHEMA, SYSTEM VIEWS and in-built GLOBAL VARIABLES for the instant analysis.
• Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Worked with a team of business analysts, data architects, application developers, ETL developers and testers. My objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines.
• Experience with Microsoft SQL Server Integration Services or any comparable ETL tool and Reporting tool with SQL Server Reporting Services using Business Intelligence Development Studio (BIDS)
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in creating deployment utility to deploy SSIS packages over Production, QA and Local System.
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Expert in creating SQL Server Reports using SSRS 2005 and 2008.
• Expert in using Version Control Software like Visual SourceSafe (VSS).
• Extensive experience in the development of Reports using SQL Server 2000/2005 Reporting Services (SSRS) and Microsoft Access and developed Custom Report and different types of Tabular Reports, Matrix Reports, Drilldown reports in multiple formats using multi - dimensional objects.
• Strong ability in Scheduling and deploying reports on Report manger.
• Experience working with change control process
• Expert in using Ms Office suite 2007 including Ms Access.
• Knowledge in JAVA, VB.net, C#.
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS

Languages: T-SQL, My SQL, C#, ASP. NET, HTML, XML, C/C++, Java Script

Operating Systems: Windows 2000/2003/2008/ XP/VISTA/7, UNIX (Sun Solar), LINUX

Databases: MS-SQL Server 7.0/ 2000/20, MS Access

ETL Tools: Data Transformation Services, SSIS

Reporting Tools: SSRS, SSAS

DB Utilities: SQL Server Management Utility, Query Analyzer, Profiler

Application Software: Visual Studio 2005/2008, Visual Source Safe, TFS, MS Office Suite

Third party Tools: Erwin, Visio, Red gate, Lite Speed

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

SQL Server DBA

Environment: MS SQL Server 2005, 2008R2, 2012, 2014 TSQL,OLTP,OLAP, Windows 2008, SpotlightLiteSpeed, Fog light, SSIS, SSRS, SSAS, Visio 2007.

Responsibilities:

• Installation of MSSQL Server 2014, 2012, 2008R2 on Production, UAT and Development environment.
• Working on tickets\incidents within the SLA’s, as a part of operations support DBA.
• Maintaining the database consistency with DBCC at regular intervals, Managed Disk space and memory and User connections and Monitored SQL server performance using profiler to find performance and deadlocks.
• Implemented & managed database clustering, failover as per client requirement Active/Passive & executed of any upgrade such as Service Pack, Hot fixes in Active/Passive clustering.
• Mirroring experience with both synchronous and Asynchronous and applying service packs.
• Handful of experience in configuring Log shipping and troubleshooting the related issues.
• Performed Database Integrity Checks, Database Maintenance plans, updated Database Statistics and performed Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
• Assigned for Database Optimization that involved re-engineering the databases, data and index organizing, performance tuning and query tuning.
• As a part of the team, configured Transactional Replication with multiple publishers and centralized subscriber for real time reporting.
• Also implemented Mirroring for DR Plan.
• Created numerous reports using reporting services SSRS and deploying them on SharePoint.
• Created/altered/modified and tuned T-SQL Stored Procedures, Complex Queries, views, tables, and functions on OLTP and OLAP environments.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Handful of experience in PowerShell Scripting.
• Creating Logins and Roles with appropriate permissions. Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Resolving blocking and deadlocks using DMVs, Profiler and killing respective SPIDs and also optimizing the queries, which are involved in blocking and deadlock issues.
• Good knowledge and handful of experience on implementing Always on High availability starting from sql 2012.
• Scheduling SQL Server Agent Jobs for updating statistics, checking fragmentation, checking database integrity and backup plans.
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
• Involved in capacity planning, sizing and database growth projections.
• Monitor and modify performance using execution plans and Index tuning.
• Optimize the performance of queries with modifications in T-SQL queries, remove unnecessary columns, eliminate redundant and inconsistent data, and normalize tables.
• Interacting with development team in writing good standard TSQL queries.
• Applied patches, hot fixes, cleared .NET framework corruption errors.
• Documentation, Training and mentoring the staff.
• As a part of the team, was always involved in production deployment or production release.
• Technical Analysis, Code Review, Implementation, 24 x 7 production support.

Confidential, Omaha, NE

SQL Server DBA

Environment: MS SQL Server 2008R2/2012, TSQL,OLTP,OLAP, Windows 2008, Idera, Erwin, Visio 2007, SSIS, SSAS, SSRS.

Responsibilities:

• Migration of databases from SQL Server 2005 to SQL Server 2008R2.
• Migrated the SCOM (System Center Operations Manager) 2007 R2 and installed required Service packs and cumulative updates to the SQL Server 2008R2 environment.
• Installed SQL Server 2008R2 on windows 2008R2 and migrated SSIS packages.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support via Active Directory.
• Data migration using bulk copy program (BCP) and DTS to Flat files and Expertise in Data Staging.
• Experience in writing scripts like retention of data using batch deletes.
• Export or Import data from other data sources like oracle, flat files using Import/Export, SSIS.
• Developing T-SQL stored procedures, Log on & DDL triggers, views and adding/changing tables for data load and transformation, and data extraction and loading to data ware house.
• Working on different environments and a key resource for deployment of modified objects to production environments.
• Developed, deployed and monitored SSIS Packages, Incremental loading and dynamic SSIS Packages with parent package variables.
• Designed and deployed SQL Server Integration Services (SSIS) Packages, with error handling, environmental and SQL server package configurations.
• Incremental loading of dimensions, facts, error handling in SSIS.
• Created Dynamic SSIS packages, to load Stage tables from text files.
• Created SSIS/DTS packages for Finance application that would transfer data among servers and perform other data transformations and scheduled the same SSIS packages by creating the corresponding job tasks.
• Worked on SQL Server Reporting Services (SSRS), drill down, parameterized reports, and cascading reports deployed them on Report server from Report Manager.
• Performed horizontal data partitioning for efficient management of database tables and indexes, Full text indexes, Using Contains, Tuning LOB, BLOB data types.
• Maintaining the database consistency with DBCC at regular intervals, Managed Disk space and memory and User connections and Monitored SQL server performance using profiler to find performance and deadlocks.
• Implemented & managed database clustering, failover as per client requirement Active/Passive & executed of any upgrade such as Service Pack, Hot fixes in Active/Passive clustering.
• Mirroring experience with both synchronous and Asynchronous and applying service packs.
• Performed Database Integrity Checks, Database Maintenance plans, updated Database Statistics and performed Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Configured and managed virtual Servers and worked on virtualization and clustering environment.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Created DB master key, symmetric keys, asymmetric keys, certificates for encryption.
• Monitored and modified Performance using execution plans with query hints and Index tuning.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Creating views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages and performance testing on stored procedures, indexes, and triggers.
• Experience in using ERWIN tool for Entity Relationship diagrams.

Confidential, Atlanta, GA

SQL Server DBA

Environment: Microsoft Windows 2008 Server, Microsoft SQL Server 2012, 2008 (R2), Microsoft SQL Server 2005, Windows 2003/2008 Server, IIS Server 7, MS Visual Source Safe, IIS 6.0, XML.

Responsibilities:

• Installation and Maintenance of SQL Server 2005/2008(R2)/2012 on Test, Development and Production Environments.
• Create and manage databases across Development and Production instances using SQL Server Management Studio.
• Usage of new compression Techniques in SQL Server 2005/2008(R2) for backup and restore jobs.
• Experience working with TSM Backups and Restore.
• Disaster Recovery Planning, Testing and analyzing and continuous update of documentation.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Creating Logins and Roles with appropriate permissions.
• Creating and Maintaining Database Maintenance Plans.
• Configured Database Mail for failure Job notifications
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Enabling and Disabling Change Data Capture (CDC).
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Tune slow running queries using SQL Server Profiler
• Worked with database tuning advisor, SQL server profiler, Performance monitor and activity monitor for Performance tuning
• Experience working with IDERA in Server Monitoring for Performance Monitoring, Dead Lock, Blocking.
• Import data across multiple instances using BULK INSERT and BCP Utility.
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• Plan, analyze and develop Ad-hoc Reports using SQL Server Reporting Services (SSRS) and Report Manager to support various user requirements.
• Worked with DTS Packages to load the massaged data into Data Warehousing System.
• Create and manage database objects that include Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers to implement Business Logic.
• Create Clustered and Non-Clustered Indexes to improve the performance of database access.
• Extensively worked on performance issues like Update statistics and Autostats
• Involved in Capacity Planning, Database Normalization and De-normalization process.
• Optimized the database server usingDMV’s and DMF’sand performed acode reviewandtuningfor the best performance of the application.
• Involved in Logical and Physical Data Modeling process using MS Visio.
• Use MS Visual Source Safe as a Version Control System.
• Involved in Change Data Capture process.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Avoiding
• Mentored team members to optimize SQL Queries.

Confidential, Atlanta, GA

SQL Server DBA

Environment: MS SQL Server 2000/20, Windows 2003/2008, SSRS, SSIS, SSAS, PL/SQL, MS Access, Perl script, Erwin, companion, Idera, TSM/TDP

Responsibilities:

• Manage and administer SQL server 2000\2005\2008\R2 servers.
• Migrations of databases from SQL 2005 to SQL 2008\R2
• Deployment of databases, jobs, cubes from pre-production to production.
• Building SQL 2005\2008 cluster environments on VMware or Physical windows
• Performed installations of SQL 2005\2008\R2 on clustered and standalone servers
• Upgradations of sql server versions and applying patches and hot fixes.
• Adding nodes to already existing clustered servers as a part of data load\High availability
• Configured Transactional Replication and Log Shipping with SQL Server Management
• Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Work on weekly Issues reports which are generated as a part of infrastructure setup.
• Continuous monitoring server health with Idera
• Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans
• Configured Database mail, linked servers, Transparent Data Encryption (TDE) and Auditing
• Performance tuning of databases by windows performance monitor and SQL Profiler
• Used Index tuning wizard to redesign and created the indexes for better performance.
• Fine tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Documenting the standard procedures on regular basis.
• Working on tickets\incidents within the SLA’s, as a part of operations support DBA
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration
• Resource planning and coordination for application migrations with project managers, application and web app teams
• Involved in capacity planning, sizing and database growth projections.
• Worked in a environment with Change management process (Service-now tool) in place for all kind of production and non production changes
• 24*7 oncall production support

Confidential, Richmond, VA

SQL Server DBA

Environment: TSQL, MS SQL SERVER 2000/2005/2008 , SSRS, QUERY ANALYSER, VISUAL STUDIO 2005, IIS Server 5.0, VB.NET, C#, WINOWS SERVER 2003/2008, SSAS.

Responsibilities:

• Worked on Client/Server tools like SQL Server Management studio 2005/2008, SQL Server Enterprise Manager (2000) and Query Analyzer to Administer SQL Server.
• Migrated SQL server 2000 databases into SQL server 2005 and SQL server 2005 databases into SQL server 2008 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
• Setting up and Monitored transactional replication, Database mirroring on Production, QA and Development servers.
• Migrated DTS packages into SSIS packages.
• Handled up to 2 TB Size databases with clustered and stand alone environment
• Configured Transactional replication on migrated server.
• Wrote the packages using SSIS in SQL2005.
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Integrated SQL traces with Perfmon log to have better graphical analysis to find system bottlenecks.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Used DTS packages to move logins and jobs from one server to another server.
• Used log shipping for synchronization of database.
• Good experience in data modeling and metadata services.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Created Stored Procedures, Triggers, Views and Functions for the Application.
• Extensive testing on the Performance of the Stored Procedures.

Confidential, Columbus, OH

SQL Server Developer/DBA

Environment: MS SQL Server 2000/2005, IIS Server 5.0, Windows 2000/2003 servers, Outlook Express, .NET, MS Access.

Responsibilities:

• Installing and configuring and tuning and providing 24X7 support for SQL Server 2000 and 2005 in development and production environments.
• Created and scheduled jobs to setup log shipping between production servers.
• Implemented Database Mirroring on the SQL Server 2005 production databases.
• Job Monitoring and making sure all jobs run successfully every night.
• Creating databases and logins with permissions in SQL Server 2005 as per the developer’s request.
• Worked extensively on SQL Server Reporting Services to generate reports.
• Created Linked Servers between SQL server 2000 and 2005 servers.
• Involved in Migration from SQL Server .
• Created Database Diagrams using ERWin Data Modeler.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation and data extraction.
• Migrated and tested DTS packages to SQL Server 2005 Integration Services.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Involved in the creation of cubes in the MS SQL Analysis Services.
• Restore Development and Staging databases from production backups as per the requirement.
• Extensively used SSIS to move data from text files to SQL Server.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Prepare daily report on the job failures, backup failures and disk space.
• Extensively used Database Performance Monitoring tools for performance tuning.
• Designed and implemented database maintenance plan.
• Used Index tuning wizard and rebuilding indexes for faster Query Performance.
• Involved in resolving dead lock issues and performance issues.

Confidential

SQL Server Developer

Environment: MS SQL Server 2000/2003, Excel, Query Analyzer windows NT/2000 server & Professional

Responsibilities:

• Installation and configuration of MS SQL Server 2003/2000/7.0
• Created Stored Procedures, User defined functions, Views and Wrote T- SQL codes maintaining query standards for the project.
• Created ER diagrams
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables, added Columns, triggers and configured IIS and Worked on Index tuning, stored Procedure tuning.
• Involved in Optimization and normalization of database and tables.
• Involved in conceptual and physical modeling of data using ERWin tool.
• Developed stored procedures, triggers and functions and added/changed tables for data extraction and transformation, and data loading (ETL).
• Part of team for analyzing and implementing the physical design for database.
• Writing complex Stored Procedures to meet the business requirements.
• Designing logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
• Created new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000\2005.
• Designing and building data load procedures, using MS SQL Server.
• Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files
• Responsible for transferring of database and database objects from Development to Production Server using DTS.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Involved in Analysis and tuning complex Queries/Stored Procedures in SQL Server 2000 for faster execution and developed database structures.