SUMMARY

• Highly knowledgeable and self - driven individual; Offering significant experience with Microsoft SQL Server backed by extensive familiarity with data management principles; a strong grasp of server development and maintenance, process enhancement, and familiarity with all tools.
• Skilled at maintaining focus on supporting technical systems and applications connected to companies’ operation, service delivery, communication, and data management; Proficient in an assortment of technologies, and well-experienced with migrations of SQL servers from SQL 2005, SQL 2008R2 to SQL Server 2012, 2014 and 2016.
• Skillfully perform proactive maintenance of all mission critical databases, configure/test backup and recovery of database instances and create indexes for the quick retrieval of data from the database.
• Work collaboratively in a Virtual Environment using VMWARE for SQL Server.
• Competently design backup and restore strategies, as well as Disaster Recovery Solutions.
• Configure and manage high availability using Always ON High Availability. Well-experienced with production support of multiple SQL Server databases.
• Control and monitor SQL Server users and applications access to database. Manage and setup SQL Server transactional-replication, log shipping and mirroring.
• Oversee the production and development, Test and Production databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
• Demonstrate proficiency in using DMV's, SQL Server Profiler, and Windows Performance Monitor, for Performance Tuning and Query Optimization.
• Functional knowledge and experience in upgrading SQL Server software to new versions and applying service packs and patches.
• Thoroughly versed with migrations of SQL servers from SQL 2005, SQL 2008R2 to SQL Server 2012, 2014 and 2016.
• Experience in creating database maintenance plans monitored the jobs by generating alerts to be sent to the operators via email notifications using SQL Server Agent.

TECHNICAL SKILLS

• T-SQL
• VMware
• SQL Server Installation & Implementation
• Disaster Recovery
• Performance Tuning
• Database Security
• Backup & Recovery
• Replication
• Database Mirroring
• Transaction Log Shipping
• Database Maintenance
• Data Migration
• Microsoft SQL Server DBA
• Strong Technical Skills
• Detail-Oriented
• Server Administration
• Maintenance & Repair
• Analytical Thinking
• High Availability
• Leadership
• Project Management
• Strong Interpersonal Skills
• Strong Work Ethic
• Excellent communication Skills

PROFESSIONAL EXPERIENCE

Confidential, GA

Microsoft SQL DBA

Responsibilities:

• Responsible for the Production support of more than 150 SQL Server databases.
• Controls and monitors SQL Server users and applications access to database.
• Designing backup and restore strategies and Disaster Recovery Solutions.
• Managed and Setup SQL Server transactional replication, log shipping and mirroring.
• Configured and managed high availability using Always ON High Availability
• Configure and test backup and recovery of database instances.
• Created indexes for the quick retrieval of the data from the database.
• Managed the products and development, Test and Production databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
• Perform proactive maintenance of all mission critical databases.
• Experience in using DMV's, SQL Server Profiler, and Windows Performance Monitor for
• Performance Tuning and Query Optimization.
• Experience in upgrading SQL Server software to new versions and applying service packs and patches.
• Experience with migrations of SQL servers from SQL 2005, SQL 2008R2 to SQL Server 2012, 2014 and 2016.
• Hands on experience in creating database maintenance plans monitored the jobs by generating alerts to be sent to the operators via email notifications using SQL Server Agent.
• Expert working in Virtual Environment using VMWARE for SQL Server.

Confidential

SQL Server Database Administrator

Responsibilities:

• Proactively performed duties including database backups, restores, performance tuning, and capacity analysis.
• Performed DBA duties including Space management, Database Security, Copy/Modification Creating Databases in all environments, Troubleshooting defragmentation of objects and databases.
• Managed the products and development, Test and Production databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
• Created and implemented backup and recovery policies and strategies for all mission critical database systems.
• Automated all maintenance activities (Index rebuilds and reorgs, Stats update, alerts, etc.) for all production systems.
• Troubleshoot databases and custom application issues for OLTP systems.
• Working with Application team to manage SQL Server databases.
• Implemented backup and recovery strategies that ensure that backups meet the recovering requirements using the RESTORE VERIFY option when creating backups
• Performed data refreshes on SQL Server production and test databases
• Responsible for the Production support of more than 200 SQL Server databases
• Managed SQL Server database security by granting permissions on securables to the principals
• Performed several SQL Server database cloning.
• Managed and Setup SQL Server transactional replication, log shipping and mirroring.
• Proactively engaged in various tuning techniques to maintain high performance production database environments and ensuring minimal to zero downtime
• Worked with rest of the team to setup and manage transactional replication and log shipping.
• Work with end users to define, implement, and maintain their reporting requirements
• Participated and coordinated the creation, modification and maintenance of database structures with minimal supervision.
• Assisted in the design, coding, testing and implementation of SQL databases instances
• Taken an important role in a critical situation of restoring a corrupted database from a point in time with zero loss of data
• Resolving Tickets in compliance with meeting clients SLA and having effective communication with client customers in resolving all SQL issues.
• Demonstrated an understanding of database internals and application database components.