SUMMARY

• 10 years of experience wif teh 32bit, 64 - bit Microsoft SQL SERVER in Production, Development and Testing in Clustered and Stand alone Server Environment.
• Experience installing MS SQL SERVER 2000,2005,2008,2008 R2,2012.2014; updating wif hot fix and service packs
• Expertise on RDBMS concepts as well as Data Modeling Concepts.
• 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.
• Strong experience in mentoring wif team members, documentation and 24/7 on call production support.
• Implemented Side by Side Migration of MS SQL SERVER 2000/2005 to 2008.
• Experience wif Microsoft SQL Server Integration Services or any comparable ETL tool and Reporting tool wif SQL Server Reporting Services using Business Intelligence Development Studio (BIDS)
• Expert in developing T-SQL (DDL, DML, DCL) statements.
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Good at SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Experience in using teh DMVS, DMFS, SP PROCS, INFORMATION SCHEMA, SYSTEM VIEWS and in-built GLOBAL VARIABLES for teh instant analysis.
• Expert in Data Integrity, Performance Tuning, Query Optimization
• Expert level skills in Objects creation such as Table, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing.
• Expert in creating Views.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in logical and physical data modeling of teh database in ERWIN and MSVISIO.
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Handling Memory configurations for SQL Server 2000 and 2005 on Windows 2003 Server.
• Experience in SQL Upgrades SQL 2000 to 2005 and Building SQL Clustering.
• Experience in analyzing Locks, Dead Locks and Handling teh Isolation Level and Concurrency TEMPEffects.
• Implemented secure SQL Environment Using SOX Compliance Standards
• Extensively used teh 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 teh data base manually and also by scheduling teh jobs and Maintenance Plans.
• Expert in analyzing teh execution plan and index management for better Query Optimization.
• Configured SMTP Server for Database Mail setup and received Alerts for teh Threshold values.
• 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.
• 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
• Worked wif a team of business analysts, data architects, application developers, ETL developers and testers. My objective was to deliver projects wifin scope, time and costs while following department standards, methodologies and guidelines.
• 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.
• Using VB .Net, Developed new application code using prescribed specifications
• Using VB.NET, maintained and modified existing applications as per requirements.
• Prepared detailed flow charts and diagrams that describe input, output and logical operations
• Experience in integration of various data sources like SQL Server and using written stored procedures in Data Stage jobs
• Used Data modeling techniques and methodologies in a standard, consistent, predictable manner in order to manage it as a resource

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio

Languages: T-SQL, My SQL, C\C++, VB .NET,C#

Operating Systems: Windows 95/98/Me/XP/NT/2000/Vista/7/8, Unix, DOS, Linux, Windows Server 2003 /2008/2008 R2/2012.

Databases: MS-SQL Server 2012, 2008R2/2005/2000, Microsoft SQL Azure Databases

ETL Tools: Data Transformation Services(DTS), SQL Server Integration Services (SSIS)

Scripting: Power shell scripting

Reporting Tools: SSRS, SSIS

DB Utilities: SQL Server Management Utility, Query Analyzer

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

Data Modeling Tools: Erwin, Red gate, Lite Speed, Embarcadero

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, Ohio

SQL Server DBA

Environment: SQL Server 2014/2012/2008 R2/2008/05, SQLAZURE Windows 2003, Windows 2008R2/2008/2005 Server, ASP.NET, VERITAS Net backup, MS Visio, MS Business Intelligence Development Studio 2010

Responsibilities:

• Implementing teh migration methods for teh three different integrated databases systems Visual Foxpro, MicroSoft SQl Server 2008/2008 R2/2012/2014,Oracle.
• Worked on teh Always On Configuration on teh two node Cluster
• Worked on Replication mainly on teh transactional Reliplecation and Database Mirroring
• Worked on teh different types of Clusters Active-Passive Cluster, and Active-Active Cluster
• Installation of New SQL Servers, Configuring and Maintaince of SQL Servers 2012/2008R2/2008.
• Implemented secure SQL Environment Using SOX Compliance Standards
• Experienced in Maintenance of SQL Azure Databases
• Experienced in configuring teh SQL Azure Databases
• Good Knowledge in SQL Azure Power shell
• Experienced in using teh Redgate tool for backups and teh Performance Management
• Have been developing teh SSIS packages for migrating data into teh Microsoft SQL Server for data binding purposes of teh data to a front end application.
• Working on Microsoft CRM and Oracle Databases for Extracting teh Data, Cleaning teh data and loading into a staging databases for migration.
• Responsible for building a staging database which is cleaned out of teh bad data and using teh data in teh migration.
• Implementing and planning teh migration startegies for migrating all teh databases into a newly build integrated database systems.
• Building, Developing and Deploying teh SSIS Packages for extracting teh data from teh three different databases of Visual Foxpro, Oracle and Microsoft SQL Server 2008/2008 R2.
• Using SSIS built high performance data integration solutions, including extraction, transformation and loading (ETL) packages for building a Staging Databases.
• Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Configure and support SQL Server Replication, Database Mirroring and Log Shipping.
• Implementing T-SQL features like Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Implementing new features in Microsoft SQL Server 2008 like teh Merge Join for merging several databases based upon their Referential Integrity.
• Daily routine Developer/DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Created Sub-Reports, Drilldown-Reports, and Cross Tab reports using MS SQL Reporting Services (SSRS).
• Developed Queries for generating drill down, drill through reports in SSRS 2005.
• Good understanding of Microsoft Reporting Service (SSRS) wif Report authoring, Report management, Report delivery and Report security.
• Experience in integrating SharePoint Server wif SSRS and deploying SSRS reports on to SharePoint Server.
• Worked on teh Configuration of teh SSAS, Deploying of Cubes
• Worked on call 24/7 Support on weekly basis.

Confidential, Tampa, Florida

SQL Server DBA

Environment: Microsoft SQL Azure Databases,Microsoft Windows 2008 Server, Microsoft SQL Server 2012,Microsoft SQL Server 2008 R2, Microsoft SQL Server 2005, MySQL, Microsoft SQL Server 2000, Windows 2005 Server, Windows 2003 Server, VB .NET,Power shell Scripting

Responsibilities:

• Installation and Maintenance of SQL Server2012 /2008 R2 and MySQL on Test, Development and Production Environments.
• Experience in integration of various data sources like SQL Server and using written stored procedures in DataStage jobs
• Used Data modeling techniques and methodologies in a standard, consistent, predictable manner in order to manage it as a resource
• Good Knowledge on SQL Azure Databases Backups and Restores
• Usage of new compression Techniques in SQL Server2012 /2008 R2 for backup and restore jobs.
• Implemented Side-by-side Migration of Databases from SQL Server 2008/2008R2 to 2012.
• Actively worked on teh ALWAYSON and configured teh disaster recovery and high availability solutions for teh environment.
• Using VB .NET Developed new application code using prescribed specifications
• Using VB.NET Maintained and modified existing applications as per requirements.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.
• Creating Logins and Roles wif appropriate permissions.
• Creating and Maintaining Database Maintenance Plans.
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Tune slow running queries using SQL Server Profiler.
• 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.
• 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 teh performance of database access.
• Create and manage databases across Development and Production instances using SQL Server Management Studio.
• Involved in Capacity Planning, Database Normalization and De-normalization process.
• 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.

Confidential, Buffalo, NY

SQL Server DBA

Environment: SQL Server 2000/2005 /2008 /2008 R2Enterprise, MySQL, Windows Enterprise Server 2003/2005, IIS 6.0, T-SQL, Microsoft Reporting Service

Responsibilities:

• Upgrading SQL Server 2000 to SQL Server 2005/2008
• Implemented Side-by-side Migration of Databases from SQL Server 2000/2005 to 2008
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction
• Initiating teh AMLFRAUD/CTF Program wifin teh Division including conducting stakeholder briefings,documenting teh project management plan
• Experience in integration of various data sources like SQL Server and using written stored procedures in Data Stage jobs
• Used Data Modeling Tools like Erwin
• Used Data modeling techniques and methodologies in a standard, consistent, predictable manner in order to manage it as a resource
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Configuring, tuning, and optimizing SQL 2005/2008 and MySQL.
• Performance testing on stored procedures, indexes, and triggers.
• Creating DTS Packages for data import, export, scrubbing and scheduled jobs for backups.
• Data migration using bulk copy program and DTS.
• Helping teh front-end application developers wif their queries.
• Job Monitoring and making sure all jobs run successfully every night.
• Performing low-level scripting, fixing of codes and software enhancement process.
• Administrator tasks like managing users, roles, and profiles
• Performed Database backups wif tools like lite speed.
• Used SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Development of various reports and reporting interfaces utilizing Microsoft SQL Reporting Services.
• Suggest Replication techniques to meet business needs.
• Setting MAX DOP (Max degree of parallelism) to 8 for 28 GB memory.
• Scheduled and monitored all maintenance activities including database consistency check and index fragmentation.
• Analyzed execution plans, and tuned queries and databases for better optimal performance.
• Fixing Missing Indexes and Excess indexes
• Generated script files when changes applied to stored procedures and functions
• Managed schema objects like Triggers, cursors, indexes, procedures.

Confidential, Falls Church, VA

SQL Server DBA

Environment: SQL Server 2000/2005 /2008 Enterprise, Windows Enterprise Server 2003,IIS 6.0, T-SQL, Microsoft Reporting Service.

Responsibilities:

• SQL Server 2000 contains 2 TB of Data and SAN infrastructure of 60 Server. 2 NODE cluster Active / Active and Active passive for different environment.
• Installation & configuration 2005 enterprise Edition.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 2 Terabytes.
• Converting DTS packages to SSIS packages.
• Designed teh reporting databases by using Erwin.
• Transformation of data (Millions of records) to SQL server by SSIS, DTS, BCP.
• Played a key role in business requirements analysis, architecture designs, physical and logical Data modeling, application development by using Erwin.
• Rebuilding teh indexes at regular intervals for better performance.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Migrated databases easily from SQL Server 2000 to SQL Server 2005 by using redgate.
• ETL experience wif SSAS and SSIS.
• Install and upgrade packaged databases remotely by using red gate.
• Managing teh clustering environment.
• Using log shipping for synchronization of database.
• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including replication and SQL Server clustering
• Suggest replication techniques to meet business needs.
• Maintain transactional replication on production SQL Servers.
• Set up transactional, snapshot replication and maintain teh active replication(s).
• Maintaining teh database consistency wif DBCC at regular intervals. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Complete documentation about teh database. To analyze long running slow queries and tune teh same to optimize application and system performance.
• To set up SQL Server configuration settings.
• Performed daily backup and created named backup devices to backup teh servers regularly.
• Generated Script files of teh databases whenever changes are made to stored procedures or views.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
• Performance tuning and optimization of Query of SQL server.
• Supporting programmers for moving objects to different environments.
• Creating and maintaining user’s logins and Roles.
• Tuned teh database to perform efficiently by managing databases using teh options to grow or shrink database files and monitored teh size of teh transaction log. Managed databases on multiple disks using Disk Mirroring and RAID technology.
• Estimated space requirements for a database.
• Converted and imported data from an Oracle Database to a SQL Server Database.
• Worked in tune wif strategic planning for improving teh mapping and data migration.

Confidential, Atlanta, GA

SQL Server DBA/DEVELOPER

Environment: SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003,IIS 6.0, T-SQL, Microsoft Reporting Service.

Responsibilities:

• Managed and Administrated teh SQL Server 2008/2005/2000 production and Non-production servers.
• Tuned aggressively stored procedures in order to increase teh performance wif no cost TEMPeffective.
• Worked as a team following Agile/SCRUM methodology for iterative and incremental development.
• Administered and maintained production/Development servers wif more than 2 TB of database size wif complex structures.
• Performance metrics reports daily, weekly and monthly.
• Designed a report on teh monitoring of SQL Server Performance. This report gives a detail report to teh management on teh Performance of teh server.
• Worked wif SQL Server 2005 side by side upgrade from SQL server 2000
• Installed couple of SQL Server 2005/2008 on cluster environment.
• Integrated SQL server profiler traces wif Performance monitor to have better graphical analysis to find system bottlenecks.
• Created Documentation for steps need to be taken while upgrading teh SQL server 2000 to SQL server 2005.
• Expertise in setting up and troubleshooting Database mirroring.
• Optimized working process.
• Implemented teh new SQL Server 2005 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Implementation of SQL Logins, Roles and Autantication Modes as a part of Security Policies for various categories of users.
• Rebuilding teh indexes at regular intervals for better performance based on level of fragmentation.
• Extensively working on performance issues like update statistics, Auto Stats.
• Created Database Maintenance Planner for teh Performance of SQL Server which covers Database Integrity Checks.
• Configured up to 32 GB of memory.
• 24/7 on call support, created various jobs to check health of teh server and to troubleshoot.
• Huge data of Insurance policies and customer information in XML, Flat file data transforming using SSIS Packages.
• Developed SSIS packages, stored procedures, functions, triggers.
• Tuned servers to teh peak for maximum performance by configuring memory and various server level parameters.
• Hands of experience in writing batch files.
• Extensively worked on extraction, transformation and loading of data from various data sources to SQL Server.

Confidential

SQL Developer

Environment: SQL Server 2000,2005 Windows NT server, SQL Profiler.

Responsibilities:

• Actively participated in gathering of Requirement and System Specification.
• Worked on complex T-SQL statements, and implemented various codes and functions.
• Involved in creating Stored Procedures, views, tables, constrains.
• Created stored procedures and triggers for Data consistency.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into teh database.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables
• Wrote complex stored procedures to process employee’s requirement and generating.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created Database Maintenance Plans for teh Performance of SQL Server, which covers Database Integrity.
• Debugged teh T-SQL queries for performance tuning.
• Checked & updated Database Statistics and Re-indexing.
• Created Users and Roles, and managed security and permission of database.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects