PROFESSIONAL SUMMARY:

• 7 years of experience in MS SQL Server Installation, Configuration of Microsoft® SQL Server™ 2005/2008/2012/ 2014
• 7 years of experience in Database Administration and Support of Microsoft® SQL Server™ 2005/2008/2012/ 2014 in Production, QA, Development environments
• 7 years of experience in Administering SQL Server security by creating User Logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups
• Strong Experience in Migration of database from MS SQL Server 2005 to 2008R2 and 2012 to 2014
• Experience in MS SQL Server Performance Tuning, SQL profiler, Query Optimization, Client/Server Connectivity and running Database Consistency checks Using DBCC
• Strong Experience with Database Backup, Recovery and Disaster recovery procedures
• Strong Experience in implementing SQL server high availability features like Database Mirroring, Replication, Log shipping, Clustering and Always on,
• Experience working on Data Extraction/Transformation, Migration of Data from Excel, Flat file to MS SQL using SSIS and BCP
• Experience in MS SQL Server upgrades from 7.0 to MS SQL Server 2000 and from 2000 to MS SQL server 2005 and from 2000 and 2005 to 2008. And from 2012 to 2014
• Experience in SQL Server Reporting Services (SSRS), designing and developing reports.
• Experience in T - SQL Query writing Stored Procedures, Functions and Triggers
• Experience in Creating Packages, Jobs and Sending Alerts using SQL Mail/Database Mail
• Experience in Active Directory in Microsoft Windows Server: Creating and managing Users, Organizational Units (OUs) and Groups, Hyper-V, Virtual Box
• Knowledge in Windows and SQL Server Clustering, Active/Passive and Active/Active
• Knowledge in developing InfoPath forms and SharePoint Designer Workflows
• Provide 24/7 technical support for troubleshooting
• Work flow Analysis, Capacity planning, .NET
• Working Knowledge of Microsoft Azure SQL Server implementation

TECHNICAL SKILLS:

Databases: MS SQL Server 2014/2012/2008/2005 - Backup & Restore, Mirroring, Replication, Log Shipping, Clustering, MS Access, Advance Excel Skill, MYSQL

Tools: SSMS, Erwin, Idera, Visio, Spotlight on SQL server

Operating System: Windows Server 2008, 2003, 2000, Vista/ Window7, Window/98/2000

Web Server: MS Internet Information Server (IIS), Development of training tools, i.e. report building, Share point site upgrade/update.

WORK EXPERIENCE:

SQL Database Administrator/DBA

Confidential, Richmond, VA

• Participating in 24/7 servers support in production test and development environments.
• Resolving Tickets in compliance with meeting client SLA and having effective commination with client customer in in resolving all SQL issue.
• Performing server installation, configuration and Upgrade of MS SQL Server.
• Configured and manage multiple SQL server instances.
• Automate and enhanced daily administrative tasks, including space management, backup and recovery and performance monitoring.
• Created alerts and notification for system errors, insufficient resources, fatal database error, hardware error, security breach, etc.
• Creating User logins with appropriate roles, monitoring the User account, creation of groups, granting the privilege to users and groups.
• Implemented server patches and server upgrades.
• Experiencing on MSSQL Server Performance Tuning and Query Optimization.
• Checked for database consistency, fixed DBCC errors, monitored error logs, database space allocation.
• Performed maintenance activities like analyzing/ rebuilding indexes, update statistics based on business needs.
• Experience in Data migration between SQL Server 2005/2008/2012/2014 and 2016
• Implemented Disaster recovery model like clustering, database mirroring, log shipping and transactional Replication.
• SSIS package development and development from flat file, Excel, Access, etc. as well as setting up SSIS jobs and monitoring.
• Experience in designing and developing Reporting service (SSRS).
• Implementing new SQL features for SQL server 2012, 2014 including Always on High Availability Groups.
• Providing 24/7support to maintain Databases up and running in production environment.

SQL Database Administrator/DBA

Confidential, TROY, MI

• Responsible for installation and configuration of SQL server 2014/2012/2008/2005 database.
• Involved in data modeling for the application and created ER diagram using Erwin.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Implemented database standards and naming convention for the database objects.
• Developed DTS and SSIS packages to extract, transform, and load data into the Campaign database from OLTP database
• Involved in loading the partner flat files into the OLTP database. Also, developed the T-SQL stored procedures/functions to process these data and populate them in the appropriate destination tables.
• Created and configured an OLTP replication database for disaster recovery purpose.
• Worked with developers to tune the SQL queries using SQL Profiler, Execution Plan, Index and Database Tuning Advisor.
• Provided 24/7 Production support for the database and application issues.
• Applied patches and service packs to keep the database at current patch level.
• Suggested Disk Capacity, Processors and Memory based on Capacity planning.
• Implemented backup and recovery strategies; performed Full and Transaction Log Backups and restored them whenever necessary
• Solved critical production problems and performed point in time recovery plans.
• Managing Database constraints and Indexes.
• Experienced in resolving deadlock and blocking issues for concurrent users.
• Managing Database High Availability Solutions (Database Mirroring, Log Shipping, Replication, Always on and Clustering).

MS SQL Server DBA

Confidential, Washington, DC

• Involved in installation and configuration of SQL server 2000/2005/2008 on Dell Servers.
• Applied patches and service packs to keep the database at current patch level.
• Responsible for configuration of Microsoft Server/Client Products and implementation
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Defined relationship between tables and enforced the referential integrity constraints.
• Created Clustered and Non- Clustered Indexes.
• Responsible for General Database Administration and Performance tuning.
• Experienced in resolving deadlock and blocking issues for concurrent users.
• Worked with DTS packages to load the massaged data into Data warehousing system.
• Data Migration from legacy to master tables using DTS-Import and Export wizard.
• Performance tuning of different apps running on SQL Server 2000 and 2005.
• Developed Database Backup Scripts and automated this process.