SUMMARY:
I am a Microsoft Certified Professional with 5+ years of IT experience in the SQL Server. I have managed SQL Server database administration, management, upgrading, migrations and development in production and nonproduction environments. I am dedicated and hardworking and have the motivation needed to jump in and take control of my duties to ensure the job is done right and in a timely fashion.
[[
TECHNICAL SKILLS:
Installed & Configured and managed SQL Server instances on SQL Server 2012/2008-R2/2008/2005.
Upgrade and migration of databases from previous versions of SQL Server to new versions.
High availability solutions including clustering, AlwaysOn, mirroring, log shipping, and replication.
Performance tuning, query optimization, client/server connectivity, and DBCC Utilities.
Installed, configured, and deployed SSIS, SSRS, and SSAS.
Managed and configuring databases engaging in the designing and managing files and filegroups.
Created databases, tables, indexes, stored procedures, and views with the developers.
Creating schema and database objects
Query and Index tuning for improving the performance using SQL 2008 and 2012.
Data transformation services like SSIS, DTS, BCP and Bulk Insert.
Implemented the new SQL Server features.
Disaster Recovery Planning and Security Management operations.
24 X 7 Production Database on Call Support
EDUCATION & CERTIFICATION
Bachelor’s Degree
Microsoft Certified Professional – 70-462 Administering Microsoft SQL Server 2012 Databases.
TECHNICAL EXPERTISE:
Databases
MS SQL Server 2012, 2008/R2, 2005, MS-Access
Programming
Transact SQL
SQL Server Tools
Profiler, Query Analyzer, Import and Export, DTA, SSIS, SSRS, SSAS.
Operating System
Windows server 2012/2008/2003, Advanced Server, NT & Windows
Third party Tools
Red gate, Litespeed, spotlight
PROFESSIONAL EXPERIENCE
New York Presbyterian Hospital Dec 2012- June 2015
Role: SQL Server DBA
Description: New York Presbyterian Hospital is committed to excellence in patient care, research, education and community service. I have worked as a SQL DBA and my duties included creating and implementing database applications, writing scripts, and creating views to simplify queries. I am also familiar with some data modeling and creating SSRS reports.
Responsibilities:
Managed the evaluation of the installation requirements and designed the installation.
Installed and configured an operating system and SQL server 2012/2008-R2/2008/2005.
Installed and administered clustered and stand-alone SQL server 2012 and 2008.
Migrated SQL server 2005/2008 to SQL Server 2012.
Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.
Implemented AlwaysOn on the clustered environment.
Configured and deployed additional SQL server components such as SSIS, SSRS, and SSAS,
Managed and configuring databases.
Upgrading SQL Server software to new versions and applying service packs and patch.
Implemented the new SQL Server 2012 new features and mechanisms.
Rebuilding/monitoring the indexes at regular intervals for better performance.
Recovering the databases from disasters.
Implementing Point-In-Time Recovery solutions.
Managed logins and server roles as well as users and database roles.
Experienced in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
Monitoring and making recommendations for performance improvement in hosted databases.
Responsible for reviewing, optimizing and deploying database scripts.
24 X 7 Production Database on Call Support
Environment: SQL Server 2008/2012, Windows Server 2012/2008, Clustered, SSIS, T-SQL
DICT, Addis Ababa, Ethiopia Jan 2009 – Aug 2012
Role: Junior SQL Server DBA
Description: DICT is a consulting company that provides consulting and training services for international institutions with its operations driven by modern information technology platform, spread across length and breadth of Ethiopia.
Responsibilities:
Installed SQL Server 2005 in the multi instances environment and service packs.
Performed and managed the database backup and recovery.
Created database objects including tables, triggers, views, stored procedures, and indexes.
Performed the maintenance of the clustered and non-clustered indexes.
Monitored job history for maximum availability of data and to ensure consistency of the databases.
Implemented and scheduled Replication process for updating our parallel servers.
Designed and implemented the database maintenance plan.
Automated messaging services on server failures for task completion and success.
Enforced database security by managing user privileges and efficient resource management.
Performed and configured mirroring with windows authentication and certificate authentication.
Using database level triggers code for database consistency, integrity and security.
Migrated data from MS Access and MS Excel to SQL Server.
Environment: SQL Server 2005, Windows Server 2003, Performance Monitor, and Backup Utility.
Union college, Hawassa, Ethiopia Jan 2005 – December 2009
Role: Dean and Lecturer
Description: Union College is one the famous colleges is Ethiopia engaged in providing different Long term and short term trainings in the country.
Responsibilities:
Preparing strategic plan and different administrative tasks,
Conducting lecture in different courses,
Advising thesis to senior or graduating class students, and
Conducting different problem-solving researches.