SUMMARY:

• Experienced Certified Microsoft Sql Server DBA with over 8 years’ experience in MS Sql Servers 2008, 2008R2 and 2012 in Production.
• Proficient in Performance tuning, Replication, Failover Clustering, Data Migration, Disaster Recovery/High Availability, Database Security, Backup and Recovery.
• Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery in managing clusters of SQL servers.
• Experience in troubleshooting and problem solving of SQL database Servers.
• Maintenance and tuning of the databases.
• Ability to ensure the technical integrity of corporate databases by protecting against the loss or misuse of information and designing backup/recovery strategies.
• Experience in configuring HADR using SQL server 2008R2 and 2012.
• Experience in improvement and maintenance of the databases to include release rollout and upgrades.
• SQL Server Replication
• Experience managing MS SQL server 2005, 2008, 2008r2 and 2012 RDBMS on web - based, transactions.
• Experience with setup and administration of SQL Server Database Security environments using Profiles, database Privileges and Roles.
• Experience working with merge and transactional replication .
• Experience with implementing Database Disaster Recovery and Planning
• Proficient in performance of SQL Server software new installation and upgrades.
• Proficient in Backup/recovery strategies implementation.
• Proficient in maintaining and supporting SQL Server Transactional and Peer -Peer replication.
• Expert in reviewing overall physical database structure for overall stability
• Proficient in use of tools like SQL Server profiler and Windows performance monitor.
• Proficient in SQL SERVER 2008 and 2008R2, 2012 database mirroring.
• Experience with monitoring and troubleshooting 24x7 operations.

TECHNICAL SKILLS:

Databases: SQL 2005, 2008, 2008R2 and 2012

Languages: T-SQL

Tools: SQL Server, Integration Services, Microsoft Office (Access, Excel, Outlook, PowerPoint, Word).

OS and Hardware: Windows 2003/2008/2008 R2/Xp/Vista/7/8, Physical and Servers (DELL) Virtual

Operations support: 7x24, helpdesk, change management, configuration management, SLA management

PROFESSIONAL EXPERIENCE:

Database Administrator - SQL Server

Confidential, Atlanta

Responsibilities:

• Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2005/2008/2008 R2/2012.
• Experience in upgrading SQL Server from version 2008R2 to 2012.
• Good experience with SQL Server 2005 online Indexing and Recoveries features.
• Good experience with implementing DR solution, High Availability of database servers using Database mirroring and replications and Log Shipping.
• Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Created maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
• Experience in Data Migration Management.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Recovering the databases from Backup in Disasters.
• Scheduling of maintenance JOBS (Daily, Weekly, Monthly) as per the client request.
• Administrating high availability solutions like Log shipping and Database Mirroring.
• Identifying and resolving Blocking and Deadlocking issues by using Activity Monitor, System stored procedures and Profiler.
• Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
• Experience in applying patches and service packs to keep the database at current patch level.
• Experience in migrating packages from DTS to SSIS.
• 24 X 7 Production Database on Call Support

Database Administrator - SQL Server

Confidential, Atlanta

Responsibilities:

• Involved in setting up the backup strategy for production, test and development.
• Experience in implementing high availability using Log shipping, and knowledge of DB mirroring in SQL Server 2008r2.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies
• Experience on high availability SQL Server solutions, including Replication Models (Snapshot/Transactional) and SQL Server clustering (Active-Passive)
• Participated in upgrading/Patching SQL Server 2005 to SQL Server 2008 servers.
• Configured the SQL mail/DB Mail to send email alerts to the operators. Participated in quarterly meetings with Senior Management to discuss technical infrastructure and market recommendations assisting in the formation of the technology roadmap.
• Supported client and in-house SQL database systems on various infrastructure projects improving service level agreements by reducing time to deliver database solutions to business.
• Created the maintenance plan for database optimization and integrity checks.
• Experienced in Point-in-time restoring databases in production and in development servers.
• Worked to ensure that changes to production environments were validated and thoroughly tested. This effort reduced the number of outages by over 25%.
• Configured the log shipping in production environment to create the backup server.
• Experienced with SQL Disaster recovery processes and documented the processes.
• Experienced with improving databases performance using execution plan, index tuning wizards and SQL profilers.
• Analyze SQL server deadlocking, locking and blocking and troubleshoot the root of those issue.
• Experienced in securing the SQL Servers and assign the permissions to SQL Server users.
• Actively involved and participated in team meetings and author how-to documents and knowledge base articles for various database related tasks

Database Administrator - SQL Server

Confidential

Responsibilities:

• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.
• Experience in trouble shooting Client connections, viewing error logs and application logs.
• Hands on experience in DR processes including Log Shipping and Database Mirroring.
• Proficiency in SQL Server Replication, Disaster recovery and planning.
• Rebuilding the indexes at regular intervals for better performance.
• Trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance.
• Extensively worked on Enterprise Manager for managing the database.
• Troubleshoot performance problems and fine-tuning of databases.
• Recovering the databases from backup in disasters.