SUMMARY:

• 5+ years of IT experience including Database Administration. databases including SQL Server 2014,2012, 2008 R2 and 2008.
• Excellent database administration skills including, but not limited to SQL Server planning, implementation, configuration, troubleshooting, performance tuning, high availability, disaster prevention and recovery.
• Daily routine DBA tasks like Backups and Restores, handling user's permissions and space issues on Production Servers and handling maintenance Jobs.
• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including Database Mirroring, Replication, SQL Server Log shipping, SQL Server clustering(Active/Passive) and Alwayson Availability Groups.
• Experience in Scheduling Jobs and Alerts using SQL Server Agent.
• Created SQL Server Event, Maintenance Plans and Performance Condition Alerts.
• Configured Database mail, linked servers, Transparent Data Encryption (TDE) and Auditing
• Extensively worked on 64 bit Clustered and Standalone server environments.
• Handled multiple SQL Instances on Cluster environment and worked on configuring logical disks and RAID levels
• Implemented troubleshooting of SQL Server performance issues using SQL Tools, execution plans, Trace, statistics, index tuning wizard, SQL profiler, DTA
• Experience in SSIS (SQL Server Integration Services) and SSRS (Reporting Services).
• Used SSIS as an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application
• Experience in writing complex T - SQL (DDL, DML, and DCL) and DBCC commands.
• Created stored procedures, triggers, functions, indexes, tables, views and other T-SQL components in SSMS.
• Flexible, enthusiastic and project oriented team player with excellent written and verbal communication skills to develop creative solutions for challenging client needs.
• Ability to adapt quickly to changing environments.
• Willing to relocate
• Authorized to work in the US for any employer

WORK EXPERIENCE:

SQL Server DBA

Confidential - Silver Spring, MD

Responsibilities:

• Installed, configured, upgraded and monitored SQL Server 2008, 2008R2, 2012 and 2014
• Created and maintained databases on Production and development environments
• Handled multiple SQL Instances on Cluster environment and worked on configuring logical disks and RAID levels
• Configured Server Memory for maximum Performance and effective utilization experience in Partitioning to improve the manageability and availability of table as well as the performance of the queries running against this partitioned table.
• Identified SQL statements with poor performance using Performance Tools and SQL Trace tools
• Responsible for Performance tuning of SQL servers by managing the use of disk space, memory and CPU
• Configured performance tuning and optimization in SQL Server 2008, 2012 and 2014
• Rebuilding the indexes at regular intervals for better performance.
• Implemented troubleshooting of SQL Server performance issues using SQL Tools, execution plans, Trace, statistics, index tuning wizard, SQL profiler, DTA
• Used SSIS as an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application
• Configured Database mail, linked servers, Transparent Data Encryption (TDE) and Auditing

SQL Server DBA

Confidential - Addis Ababa, Ethiopia

Responsibilities:

• Installations and configurations of SQL server 2008, 2008R2 and 2012.
• Performed database migration and upgrade from SQL Server .
• Installed and applied Service Packs (SP) on SQL Server 2008 and 2012
• Administering the SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting privileges to users and groups.
• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including Database Mirroring, Replication, SQL Server Log shipping, SQL Server clustering(Active/Passive) and Alwayson Availability Groups.
• Created SQL Server Event, Maintenance Plans and Performance Condition Alerts.
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Involved in performance tuning, index tuning, analysis in SSMS and optimization of queries and packages. participated in implementing business logic by using T-SQL, Stored procedures, triggers (DDL, DML) and functions (Inline & Multivalued Table functions.)
• Experience in writing complex T-SQL (DDL, DML, and DCL) and DBCC commands.
• Extensively worked on VMware and Implemented SQL Server

Junior SQL Server DBA

Confidential - Addis Ababa, Ethiopia

Responsibilities:

• Installed, Configured, and Managed SQL Server 2005, 2008 and 2008R2 in development, test, and production environment
• Daily routine DBA tasks like Backups and Restores, handling user's permissions and space issues on Production Servers and handling maintenance Jobs implemented Server security by assigning logins, server and database roles and server permissions.
• Created stored procedures, triggers, functions, indexes, tables, views and other T-SQL components in SSMS.
• Used SQL Indexes for improving query performance, lower storage and maintenance cost.
• Installed, configured, monitored and troubleshoot SQL Server database mirroring
• Configured and Managed Log Shipping from Production to Standby Server(running as reporting server)

TECHNICAL SKILLS:

Operating Systems: Windows Server ... ... R2

DBMS: MSSQL Server 2008,2008R2,2012,2014

ETL Tools: Management studio, Profiler, SSIS,TuningAdvisor

Programming Languages: T-SQL,PL/SQL, C++, PowerShell, HTML (Basic)

Office: Access, Excel Third party tool Idera Hardware RAID Virtualization VMWare