*

ADDINA GEBRETSADIK

***** **** **** ***, ********, MD 21044

Email: ac0g84@r.postjobfree.com

Tell: 202-***-****

Professional Summary

• 6+ years of experience in Database development and Administration.

• Experience in designing and documenting Conceptual, Logical and Physical data models.

• Excellent knowledge in implementing SSIS, SSRS, and SSAS for large scale database.

• Wide range of experience in performance monitoring, tuning and automation using job creation and analyzing database performance.

• Pleasant experience in writing T-SQL queries in creating Tables, stored procedure, performance tuning, triggers, physical and logical design.

• Advanced skill in developing package to Extract, Transform, and Load (ETL data into SQL server database from various kinds of data sources.

• Extensive knowledge and experience in migrating MS SQL 2005 to 2008 and MS SQL 2008 to MS SQL 2012.

• Strong experience in backup/restore, data security, high availability and disaster recovery strategies.

• Knowledge of general networking, hardware, software and OS.

• Good team player, detail oriented, quick learner, interpersonal and analytical skill. Tools and Technology

• Database: SQL Server 2012,2008R2, 2008, 2005 and Access

• Languages: T-SQL, basic C++, basic Java

• Web Technologies: HTML

• Microsoft Office: Word, Excel, Access, MS project & other Tools.

• Operating System: Windows XP/7/8/10, Server 2012/2008/2003/, VMware

• SQL Server Tools: SSIS (SQL Server Integration Services), SSRS (SQL server Reporting Services), SQL Server Profiler, DMV, Window Performance Monitor, and Database Tuning Advisor Professional experience

Adaptive Tech Sphere, Silver Spring, MD, May 2016 - April 2017 SQL Database Administrator

Responsibilities:

• Installed, Configured and Managed SQL Server /2008/2008r2/2012 Databases.

• Worked on data modelling, logical and physical design.

• Controlled access permissions and user privileges.

• Defined report layouts including report parameters, developed reports and synchronized queries.

• Migrated/upgraded MS SQL 2008 to MS SQL 2012.

• Developed and managed backup and recovery plan.

• Monitored and maintained database performance issues.

• Developed T-SQL queries, stored procedures, user defined function, triggers, constraints, indexes and views; tuned database objecties for better performance. Environment: SQL Server 2012, 2008/2005, SSRA, SSIS, Report Publisher Digital Opportunity Trust (DOT), Addis Ababa, Ethiopia, Jan 2013 - Nov 2015 SQL Database Administrator

Responsibilities:

2

ADDINA GEBRETSADIK

11201 Pear tree way, Columbia, MD 21044

Email: ac0g84@r.postjobfree.com

Tell: 202-***-****

• Installed, configured and Managed SQL Server /2008/2008r2/2012 and associated native and third party database tools.

• Created Users and Roles and managed security and permission of database.

• Maintained database performance by calculating optimum values for database parameters and implementing new releases

• Backup/Restore:

- Database Backup and restore

- Point in Time recovery

• Created SQL Server Agent jobs to automate different activities such as monitoring database health, disk space, job alert, index monitoring, status monitoring

• Database programming

- TSQL to create Triggers, view & stored procedures

- Assisted database development in creating, optimizing SQL queries

• Patch management: applied Service Packs and HOT Fixes SQL Server 2008 and 2012

• Configured and maintained database Mirroring and Log shipping

• Upgraded/Migrated SQL Server 2005 to SQL Server 2008/R2

• Design and develop solution regarding ETL through extensive usage of SSIS

• Assisted in establishment and organizing of regional office & business development centres Environment: SQL Server 2012, 2008/2005, SSRA, SSIS Digital Opportunity Trust (DOT), Addis Ababa, Dec 2011 - Nov, 2013Ethiopia Junior SQL Database Administrator

Responsibilities:

• Installed, Configured, and Managed SQL Server 2005, 2008, and 2008R2 in development, test and production environment.

• Designed and developed a full-scale reporting solution for a multi-client environment using MS SQL Server 2008 and MS SSRS 2008/2005.

• Created and modified tables, Rebuilding/Reorganizing Index (Cluster/Non-Cluster), Constraints

(Check/Unique), and view.

• Developed different maintenance plan, performed backup and restore.

• Configure and maintained database Mirroring and log shipping Environment: SQL Server 2008/2005, SSRA, SSIS, SSAS Digital Opportunity Trust (DOT), Addis Ababa, Ethiopia, Feb, 2010 - Nov, 2011 Management Information System /Intern/

Responsibilities:

• Conducted system requirement analysis and establishment of all site offices.

• Designed and implemented new system and trained data encoders, interns & partner organisations on new procedures.

• Delivered ICT capacity building training for partner organizations.

• Coordinated country wide ICT bazars and workshops

• Basic networking troubleshooting and computer maintenance (Hardware and software). Environment: windows XP, MS Office, SPSS

3

ADDINA GEBRETSADIK

11201 Pear tree way, Columbia, MD 21044

Email: ac0g84@r.postjobfree.com

Tell: 202-***-****

Addis Ababa City Administration, Addis Ababa, Ethiopia, May 2009 - Jan 2010 Vital Statistics Coordinator and Database Administrator Responsibilities:

• Coordinate and managed the department activities.

• Configured, Managed and Administered application database in development, test and production environment.

• Monitored day to day server activity, error log, space usage and solving problem as needed Environment: windows XP, MS Office, SQL Server 2008/2005, SSRA, SSIS, SSAS Timret Private Limited Company, Addis Ababa, Ethiopia, Feb. 2008 - Oct 2009 ICT officer

Responsibilities:

• Diagnosed software issues, installed updates/new software and removed malicious programs.

• Installed antivirus on all computer and updated it regularly.

• Introduced new system for end users.

• Provided Onsite computer repair to all branch offices and technical support to other staffs. Environment: windows XP, MS Office, SQL Server 2008/2005 Addis Ababa University, Ababa, Ethiopia, Feb. 2007 - Jan 2008 Data encoder and editor

Responsibilities:

• Developed department based application using Access for Human Resource Management system, include forms, reports and queries

• Reviewed and documented system documentation

• Secretarial services, office management and computer maintenance (Hardware and software) Training and certificates

MCITP: Microsoft Certified Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server2012/2014

Educational background

Bachelor of Art in Marketing Management -June 2015/ Addis Ababa University School of Commerce, Ethiopia. Bachelor of Science in Management Information System- July 2006/ Unity University, Ethiopia. Reference: Available upon request.

Contact this candidate