SUMMARY

• 8+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2012/2008/2008 R2 and SQL Server 2005/ 2000.
• Experience in installing MS SQL SERVER 2000/2005/2008/2008 R2/2012updating with the hot fix and service packs.
• Documented and good knowledge on SQL SERVER 2014 New Enhanced Features for migration to SQL server 2014.
• Implemented Side by Side Migration of MS SQL SERVER 2000/ /2008R2/2012.
• Experience in implementing DIASTER RECOVERY AND HIGH AVAILABLITY concepts like Native Log Shipping, Custom Log Shipping, Mirroring and Replication (Snap Shot and Transactional).
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• Experience in working and configuring with Windows server 2003/2008/R2/2012.
• Experience in analyzing and resolving Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Implemented the 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, SQLCMD and dedicated admin connection.
• Experience on Always On and T- SQL Enhancements of 2012 features.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, perfmon, activity monitor, Event viewer for performance analysis.
• Experience in administrative activates 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 by scheduling the jobs and Maintenance Plans.
• Experience in using the DMVS, DMFS, SP PROCS, INFORMATION SCHEMA, and SYSTEM VIEWS AND in built GLOBAL VARIABLES for the instant analysis.
• Configured Security at ACTIVE DIRECTORY and SQL SERVER LEVEL by Creating TEMPPrincipals (logins) and Mapping users to roles. (Securables and Permissions)
• Dexterous developer in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors and Dynamic SQL queries.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in logical and physical data modeling of the database in MSVISIO
• Hands on experience in configuring IIS.
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases
• Expertise in analyzing and estimating the Execution Plan for better Query Optimization.
• Configured SMTP Server for Database Mail setup and received Alerts for the 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.
• Validated Data Integrity at various levels of Data Warehouse starting from the source data copies through the end user reports.
• Well versed with Data warehousing life cycle.
• Deployed and Debugged SSIS packages for import, export and bulk insert data with transformations from various data sources.
• Developed SSIS Packages with Custom error handling, Logging using event handlers, Send E-mail Task and Used Checkpoints to rerun Packages from Point of Failure.
• Designed and Deployed several SSRS reports such as Drill down reports, Drill through reports, Parameterized reports, Cascaded reports, Cached reports, Snapshot Reports, linked reports, Sub reports.
• Explicitly used third party tools like LiteSpeed, Fog light, and Spotlight and Red gate.
• 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
• Strong experience in mentoring with team members, documentation and 24/7 on call production support

TECHNICAL SKILLS

Databases: MS SQL Server 2012/2008R2/2005/2000, MS Office Access 2000/2003/2010/2013.

Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio, PowerShell.

Web Servers: IIS 6.0/7.0

Business Intelligence Tools: SQL Server Integration Services (SSIS), Data transformation services (DTS), and SQL Server Reporting Services (SSRS).

Operating Systems: Windows 2000 Advanced Server, Windows 2003/2008/2008 R2 Server, Windows 95/98/XP /Vista/7/Windows 8/8.1

Data Modeling Tools: Lite Speed, Red Gate, Fog Light, Commvault, Idera, Erwin

Reporting Tools: SQL Server Reporting Services, Crystal Reports.

PROFESSIONAL EXPERIENCE

Confidential, Cleveland OH

SQL Server DBA

Environment: TSQL, MS SQL SERVER 2008/2012,SSRS,QUERY ANALYSER, VISUAL STUDIO 2005,WINDOWS SERVER 2008/2012,IIS.

Responsibilities:

• SQL Server 2008/2012 Database Administration.
• Implemented and documented TDE (Transparent Data Encryption) for databases more than4TB.
• SQL 2008,2012 - Performed installation of SQL Enterprise bit version on windows 2008 servers on Enterprise systems of clustered and standalone Dell servers in Enterprise Data Centers. Patch applications.
• Installed and administered two node and three node cluster Active/passive on Microsoft Windows Server 2008 R2 Enterprise Edition SP2 on SAN environment.
• Worked in Active\passive and active\active\passive cluster environments.
• Worked in Huge Replication Environment.
• Good experience with installing Database Mirroring.
• Expert in Using DMV’s, Performance dash board, Mirroring, database snapshot.
• Maintained the database consistency with DBCC at regular intervals
• Used tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and database Engine Tuning Advisor.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Implemented the Data Partitioning for large tables in SQL Server 2008.
• Extensively worked on SQL Server Integration Services (SSIS).
• Implement Snapshot Isolation in SQL Server 2008.
• Used Online Indexing and online Restoring in SQL 2008.
• Implemented new topics like CLR integration on Development server.
• Expert in implementing the DDL triggers.
• Solving the Bugs Reflected by the Testing team.
• Analyzed long running /slow queries and tune the same to optimize application and system performance.
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services.
• Evaluated data storage considerations to store databases and transaction logs.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Creating Packages to transform the data Using MS-SSIS and MS-DTS.
• Developing and Maintaining Cubes, Dimensions in MS-Analysis Services.
• Installed, authored, and managed reports using SQL Server Reporting Services.
• Worked on different third party tools like OEM (Oracle enterprise Manager)Environment: MS SQL server 2008/2012, Windows 2008/2012, VB.Net, Enterprise manager, Query Analyzer, DTS, SQL profiler.

Confidential, Dallas, TX

SQL Server Production DBA/ Developer

Environment: Windows 2003/2008, MS SQL Server 2005/2008, Oracle, .net, VB and ASP, LiteSpeed, MS Visio.

Responsibilities:

• Migrated 170 application and 49 servers from SQL SERVER both in place and side by side.
• Used DTSXchange tool for migrating DTS packages to SSIS.
• Involved in all the phases of SDLC including Requirements Collection, Design & Analysis of the Customer Specifications, Development and Customization of the Application.
• Installed couple of SQL Server 2005/2008 on cluster environment.
• Solving the Bugs and issues reflected by the Testing team. SQL Server 2005/2008 Database Administration.
• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
• Involved in data migration and cleaning using ETL tools like Informatica.
• Implemented the new SQL Server 2008/2012 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.
• Daily routine Developer/DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Experience in Database security and integrity planning.
• Successfully implemented the Capacity planning for different servers.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Used VB.NET code in script Task for developing SSIS packages.
• Designed and developed SSIS packages for data migration and cleansing.
• Checked Database Health and consistency by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning.
• Recovered the System and User databases from suspect mode.
• Expert in sizing Temp database.
• Used log shipping for synchronization of databases.
• Prepared Documentation step by step for the migration and Disaster Recovery plan.
• Wrote and debugged Stored Procedures and (DDL /DML)Triggers, Functions as per client requirements
• Assisted on the Adhoc-Query Requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.
• Extensively worked on trouble shooting dead locks and fine-tuning of databases for its performance using native SQL Server tools like profiler and performance monitor.
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation, update statistics and backups.
• Managing the VERITAS net backups and Litespeed backup.
• Hands on experience in trouble shooting database issues.
• Performed code reviews to ensure high Software quality and participated in weekly team meetings.
• Performed all basic Database activities like moving databases between servers, copy databases etc.
• Used SQL server Reporting Services (SSRS) to create reports.
• Worked on call 24/7 Support on weekly basis.

Confidential, St Louis, MO

Technical Database Administrator

Environment: SQL Server 2008R2/2008/2005, Cluster, Reporting Services (SSRS), SharePoint 2010, INFOPATH 2010, Windows 2003, 2008.

Responsibilities:

• SQL Server bit Failover Cluster Installation on Windows Server bit.
• SQL Server 2008 Installation.
• Writing batch scripts to do automation of database tasks.
• Writing scripts to manage different servers for auditing purpose.
• Running packages as for system promotion requirements.
• Solving Memory Problem related with SSIS Packages.
• SQL Server Analysis Services 2000 installation and Reporting Services 2005
• Performance tuning on different Production Servers.
• Extensively worked on Dynamic Management Views (DMV’s).
• Running profiler to troubleshoot Blocking issues, Deadlocks issues and slow running.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication.
• Solving memory related problems by changing server configuration settings.
• Rebuilding indexes with different fill factors and update statistics manually.
• Building Maintenance plans for database maintenance.
• Writing stored procedures as for business requirements.
• Backup and Restore databases.
• Moving Tempdb to different file location.
• Shrinking the data files as the space requirements.
• Effectively used PL/SQL advance features like collections, ref cursors, dynamic sql and Managing users and security.
• Managing schema objects, such as tables, indexes, and views.
• Making database backups and performing recovery when necessary.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, used Team Foundation Server 2010 for maintaining source control, data collection.
• Involved in Configuration and Administration of Share Point 2007 environment.
• 24 X 7 Production Database on Call Support.

Confidential, RICHMOND, VIRGINIA

SQL Server DBA

Environment: SQL Server 2008R2/2008/2005, Cluster, Reporting Services (SSRS), SharePoint 2010, INFOPATH 2010, Windows 2003, 2008.

Responsibilities:

• Installation and Maintenance of SQL Server 2008R2 on Development, Test and Production Environments.
• Responsible for MS SQL Server 2008R2 configuration, tuning and provide 24X7 dedicated support to all Production, development and cluster servers.
• Applied Patches and Service packs to update different versions of MS SQL SERVER.
• Creating Backup strategies and scheduling them as a part of database maintenance plans.
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.
• Documented and performed the data base health checks regularly.
• Used native tools like Database Tuning Advisor, Profiler and Activity Monitor for performance analysis.
• Used Perfmon, DMV’s, SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.
• Created baseline and sampling intervals in the Perfmon considering threshold values of the counters.
• Monitor connections, locks and performance of SQL server.
• Responsible for monitoring and making recommendations for performance improvement inhosted databases.
• Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
• Installed and Upgraded from SQL Server 2005 to SQL server 2008 on Various Production Servers.
• Evaluated data storage considerations to store databases and transaction logs.
• Fixed the failed TEMPPrincipals (logins), User permissions and Security in Active Directory and SQL Server Level.
• Scheduled regular Backup Jobs and kept track of database by receiving the emails on Alerts.
• Expert in Performance Tuning, Analyzed long running queries and tuned them to optimize the system performance.
• Maintaining the database consistency with DBCC utility at regular intervals.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.
• Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard.
• Implemented Data partitioning, Snap shot Isolation, Database Snapshot, DDL triggers, Try-Cache blocks, Online Indexing, DMV’s, DMF’s, DTA, SQLCMD and dedicated admin connection, Common table Expression(CTE).
• Deployed SSIS package for bulk insert and maintained archival data.
• Created SQL Server Database users and Roles. Worked on DTS, Import and Export utility, installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Developed and optimized database structures, stored procedures, Dynamic Management.
• Moved files between the File Groups and partitioned the tables to improve the performance for transferring data, views, DDL triggers and user-defined functions.
• Extensively used litespeed backups. Utilized the new features of 2008 like TCE, EKM, MERGE STATEMENT and Compressed Backups.
• Handled numerous Change Management Requests on production servers.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and Build, synchronize SQL Database Schemas.

Confidential

SQL Server DBA

Environment: SQL Server 2000, 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 the database.
• 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 the Performance of SQL Server, which covers Database Integrity.
• Debugged the T-SQL queries for performance tuning.
• Checked & updated Database Statistics and Re-indexing.
• Created Users and Roles, and managed security and permission of database.