SUMMARY

• Bright and dynamic Database Administrator (DBA) with over 7 years experience in installing, configuring, maintaining, and troubleshooting SQL Server databases.
• Talented learner and problem - solver who recognizes and resolves inefficiencies and champions continuous improvement.
• Excellent communication and interpersonal skills: innate ability to interact with non-technical individuals and translate business requirements.

TECHNICAL SKILLS

• SQL Server 2016, 2014, 2012, 2008R2 &
• Database Migration
• Backup strategy
• Point-in-Time Recovery
• SQL Upgrades and Patches
• Database Design
• Index Tuning
• T-SQL
• SSIS & SSRS 2008
• SQL Server Installation, Configuration & Administration
• Database Security, Backup & Recovery
• High Availability and Disaster Recovery Solutions
• Performance Tuning and Optimization
• Troubleshooting Performance
• Set up SQL Server jobs & alert

PROFESSIONAL EXPERIENCE

Confidential, Warsaw, Indiana

SQL Server DBA

Responsibilities:

• Install and Configure SQL Server 2016, 2014, 2012 and 2008R2 in development, test and production environment
• Install, Configure and maintenance of High Availability and Disaster Recovery solutions: Database Mirroring, Replication, Log Shipping, Failover Clustering and Always On
• Strong experience in Database Backup & Disaster Recovery and database backups and restores
• Create and Update Stored Procedures, Triggers, Functions, Views, Indexes (Clustered/Non­Clustered) and Constraints
• Ensure and maintain new and existing jobs to automate database activities including backup, database monitoring, disk space, backup verification, database statistics, rebuild or reorganize indexes
• Upgrade SQL Servers and Migrate Databases from SQL Server to Oracle, DB2, MySQL, Sybase, Access and vise versa
• Apply Service pack & Hotfixes on SQL Server 2008R2, 2012 and 2014
• Create and deploy codes in T-SQL, Trigger and Stored Procedures
• Export & Import data from Flat file, Excel file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP
• Ensure and maintain Point-in-Time Recovery and restore databases
• Apply DBCC to check database conditions and update statistics
• Set up maintenance plans and jobs for database monitoring
• Ensure SQL Server security & granted appropriate permission on servers and databases
• Perform on Extracting, Transforming and Loading (ETL) of Data from Excel, Flat file, Oracle to MS SQL Server using SSIS
• Experience in SQL Server integration service (SSIS) and SQL Server Reporting Services (SSRS)
• Experience in Change Management System (CMS)
• Strong experience in InfinityQS ProFicient (IQS) to build, review, test, migrate and link databases in IQS
• Migrate databases from quality analysis (QA) environment to the production environment

Environment: Window server 2008R2/2012, MS SQL Server 2008 R 2/2012/2014/2016 , Redgate and Spotlight

Confidential, Alexandria, VA

SQL Server DBA

Responsibilities:

• Installed, configured and managed SQL Server 2014, 2012 and 2008 R2
• Strong experience in Database Backup and Disaster Recovery.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL & SSMS
• Used DBCC to check database conditions, fix database corruption, rebuild indexes and other database maintenance purposes as well
• Configured and maintained High Availability and Disaster Recovery solutions (Database Mirroring, Replication, Log Shipping, Failover Clustering and Always On)
• Installed, Configured, and administered SQL Server Reporting Services (SSRS) and developed reports for different purposes
• Performed on Extracting, Transforming and Loading (ETL) of Data from Excel, Flat file, Oracle to MS SQL Server using SSIS Packages
• Migrated and upgraded databases from SQL Server 2008R2 to 2012 and 2012 to 2014
• Strong experience in performance tuning and troubleshooting skills
• Designed, Tested and deployed new database structures, such as tables, indexes and stored procedures
• Designed and implemented disaster recovery solutions for point in time recovery
• Applied latest Service Packs and Hot fixes to ease migration process
• Implemented and maintained SQL server security
• Performed query optimization, stored procedures tuning and performance monitoring

Environment: Window server 2008R2/2012, MS SQL Server 2008 R2/2012/2014, Microsoft Visual Studio and Idera

Confidential

SQL Server DBA

Responsibilities:

• Installed, configured and administered Microsoft SQL Server 2008 and 2005
• Planned and implemented a backup and recovery strategies
• Monitored SQL Server Performance events and daily activities including database consistency, data compressions and statistical updates
• Configured and maintained High Availability and Disaster Recovery solutions (Database Mirroring)
• Applied Index rebuilding and reorganizing at regular intervals for a better performance
• Implemented SQL Server Security policies and database permissions and monitoring security compliance and policies
• Performed troubleshooting and resolved database issues
• Monitored backup jobs, disk space, backup verification and make sure all scheduled jobs run successfully
• Managed database related Service Request (SR) tickets from internal and external customers in a fast-paced environment
• Documented of coding standards, best practices and technical specifications and procedures

Environment: Window Server 2003/2008, MS SQL Server 2005/2008 and Redgate