Sql Server Ms
Resume:
Professional summary
Over seven years of work experience as DBA in SQL server 2005,and SQL server 2008/2008R2, SQL server 2012, MS SQL Server 2014, SQL 2016 combined with good team work abilities.
Supported 24x7 Microsoft SQL 2005, 2008/2008R2, 2012 Database Administration (DBA) in clustered environment of Production, Dev and Test databases.
Performed server Installation and Upgrade Microsoft SQL Server 2005/2008/2008R2/2012
Administered SQL Server security by Creating User Logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
Scheduled Full, Differential and Transactional log backups in the production environment using the Database Maintenance Plan Wizard.
Setup Database Maintenance Plans to reorganize indexes, re-indexing on the production databases.
Created and implemented SQL server high availability options like AlwaysON, Database Mirroring, Replication and Log shipping
Used System monitor to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database server performance.
Implemented MS SQL Server Performance Tuning, Query Optimization.
Used SQL Server Profiler to monitor and record database activities of particular users and applications.
Hands on experience in SSIS and SSRS
Created Jobs and Sending Alerts using SQL Mail/Database Mail.
Experience in Data Migration between SQL Server 2000/2005/2008/2008R2/2012/2014.
Reviewed DB Scripts from the development team before releasing them into the Production.
Hands on experience in disaster recover options in different environments with setting up RTO and RPO
Interpersonal, analytical and communication skills.
Beginner work experience in mySQL databases
Technologies
Databases: MS-SQL Server 2005/2008/2008R2, 2012
Configuration Tools: SQL Server Configuration Manager, Microsoft Database Upgrade Advisor
Development Environment: SQL Server Management Studio, Query Analyzer, Export / Import wizard,
Performance Tools: Database Engine Tuning Advisor, SQL server Profiler, Activity monitor, SQL Server Management Studio
Server Operating System: Windows Server 2003/Windows 2008/ Windows server 2012
Third party tools: Net backup, Spotlight monitoring tool
Professional Experience
S3/Blue Cross Blue Shield Michigan Aug 2016 to present
Title: SQL DBA
Roles and responsibilities
Supported Microsoft SQL database administration in 2008/2012
Handled very large databases administration (back up, restore…)
Performance tuning of Very large databases
Supported data loading into data-warehouse making use of SSIS
Participated in agent job automation
Supported database migration in different environment of SQL Servers
24/7 Production support including off-shore team support
Set up SQL server security administration
Implemented disaster recovery option (mirroring, log-shipping, …)
TCS/Boeing project, Troy, Michigan Feb 2014 to August 2016
Title: SQL Database Administrator
Achievements as DBA:
Participated in shift rotation 24/7 SQL servers support in production, test and dev environments in a clustered servers
Managed Microsoft SQL 2005, 2008/2008R2, 2012, 2014 Database Administration (DBA) in Production, Dev and Test environments.
Performed server Installation and Upgrade Microsoft SQL Server 2005/2008/2008R2/2012
Handled database Backup and Restore operations
Performed Performance tuning in MSSQL 2008, 2008 R2, 2012 and 2014.
Handled SQL server Job creation/Automation of DBA tasks using SQL server agent
Created SQL server alerts to notify potential failures and implemented actions accordingly.
Reviewed DB Scripts from the development team before releasing them into the Production.
Set up Disaster Recovery options: Database Backup and Restoration, mirroring, AlwaysOn
Handled data migration from different sources
Administered SQL Server security by Creating User Logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
Used System monitor to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database server performance.
Implemented MS SQL Server Performance Tuning, Query Optimization.
Used SQL Server Profiler to monitor and record database activities of particular users and applications.
Experience in Data Migration between SQL Server 2000/2005/2008/2012/2014. Coordinated database migration from 2000 - 2014.
Data Group/Weira, Alexandria, Virginia Dec 2011 to Feb 2014
Title: Database Administrator
Achievements as DBA:
Installed, configured, upgraded and managed MSSQL server 2008/2008R2/2012
Handled database Backup and Restore operations
Performed Performance tuning in MSSQL 2008, 2008 R2 and 2012.
Handled SQL server Job creation/Automation of DBA tasks using SQL server agent
Created SQL server alerts to notify potential failures and implemented actions accordingly.
Recommended changes for queries which may affect the optimum databases performances
Configured and Implemented database failover techniques in Log-Shipping
Set up Disaster Recovery options particularly Database Backup and Restoration jobs
Created and implemented SQL server high availability options like Database Mirroring, Replication, Log shipping
Configured and implemented database mail etc.
Handled data migration from different sources
UNICEF-Ethiopia
Food and Nutrition Security section Feb 2009 to December 2011
Addis Ababa, Ethiopia.
Title: Database administrator
I was part of DBA team. Handled databases of Regional nutrition surveys, Human resources, employee information, Donors information etc.
Main Responsibilities as DBA include:
Configured performance tuning and optimization in SQL server2005, 2008 and 2008 R2
Performed all aspects of data administration including backup.
Designed and implemented disaster recovery options(Log shipping, Backup and Restore)
Created new database users, controlled and monitored user access privileges to the database maintaining system security.
Created alerts and notification for system errors or success
Imported and exported data to and from the SQL server databases
Upgraded multiple databases required for different environments
Handled Transactional Replication from Central Server to Reporting Server Database
Excellent interpersonal communication skills
Technologies:
Database: MS SQL server 2005, MS SQL 2008, MS SQL 2008 R2
Operating System: Windows 2000, Windows 2003, Windows 2008,
Other soft wares: EPIINFO, ENA-SMART, SPSS
Performance tools: MS SQL profiler, database engine tuning advisor
Education
B.Sc in EHE, Jimma University, Ethiopia (July 2001)
B.Sc in IT, Haramaya University, Faculty of Information Technology, Ethiopia. (July 2005)
Certification:
Microsoft Certified Professional: Administering Microsoft SQL server 2012 Databases
MS Certified Technology Specialist (MCTS - DBA) 2008
Contact this candidate