SUMMARY:

• Over 9 years as Database Administrator with extensive experience on SQL Database administration including experience with designing, coding, testing and supporting SQL Server 2016/2014/2012/2008/2005 and Windows Server 2012/2008/2003.
• Extensive hands - on experience in high availability with database mirroring and database log shipping using SQL Server 2008/2008 R2/SQL Server 2012 /SQL Server 2014.
• Installed, configured and maintained Fail-Over Clustering using SQL server 2008 R2/SQL Server 2012, SQL Server 2016.
• Strong programming skills in T-SQL, as well as SAS for data analytics/reporting.
• Extensive working knowledge in SQL Server Reporting Services, SQL Server Integration Service, SQL Server Analysis Services.
• Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.

PROFESSIONAL EXPERIENCE:

Sr. SQL Server Database Administrator/Team Lead

Confidential, Raleigh, NC

• Primarily responsible for managing and administering production SQL Server databases on stand alone\Clustered Servers\Microsoft Azure Cloud infrastructures with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.
• Responsible for monitoring and performance tuning SQL servers for hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Performed daily tasks including backup and restore using native SQL back up tools, SnapManager for SQL server, SQL Lite Speed, and Windows Powershell utilities Database Engine Tuning Advisor
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS, SSAS and SSRS
• Involved in Analyzing and Upgrading SQL Server 2000 servers to SQL Server 2005, SQL server 2005 to SQL Server 2008 R2, SQL server 2008 R2 to SQL server 2012
• Involved in designed and created databases, tables, views, store procedures and triggers.

SQL Database Officer

Confidential, New Rochelle, New York, USA

• Directly responsible for the installation, configuration, and management of over 100 databases across 20 servers (SQL Server 2008/2005) in development, test, and production environments. The largest single database supported was over 1 TB.
• Configured database mirroring for high availability in real-time, as well as used log shipping with mirroring for additional availability.
• Configured SQL Server Reporting Services (SSRS) to generate reports for internal data analysis and for external end users.
• Trained information officers (super users) on the use of the latest versions and features of SQL.
• Used DBCC to check database conditions and rebuilding indexes.
• Creation and maintenance of programs used for data entry, data management, data validation, statistical report generation, and program validation
• Prepared programs for creating analysis data sets and associated tables, listings and graphs used for interim analyses, final analysis, press releases, and presentations and publications.
• Assisted the team of public health professionals to complete the Statistical Analysis Plans required for evaluation of public health projects.
• Reviewed evaluation data for inappropriate, illogical and/or inconsistent values. Develops and programs electronic checks to assist data management
• Installed and configured Windows Server (2003 & 2008).
• Automated and produced Microsoft Access reports via SAS.

SQL Database Administrator

Confidential, Addis Ababa, Ethiopia

• Administration of development and production servers running SQL Server 2008/2005 including creating indexes, tables, stored procedures and security policies.
• Ensured SQL Server replication and mirrored databases operated as planned. Applied patches to SQL servers.
• Executed stored procedures, wrote new stored procedures, T-SQL, UDF, trigger and modified existing ones and tuned them to enhance performance. Scripted stored procedures, ad-hoc queries & triggers. Created proper indexes to support queries.
• Scripted existing embedded SQL code within applications into stored procedures.
• Designed and delivered different reports based on the business requests and ad-hoc requirements using SSRS Participate in full life cycle of SSRS (Authoring, Managing and Delivery reports). Maintained SSRS report servers.
• Assisted application development team to optimize queries to adhere to best practices and deliver better performance.
• Developed reports based on well-defined requirements using complex stored procedures and packages to derive and the data extracted for analysis.

Senior Data Analyst

Confidential, Addis Ababa,, Ethiopia

• Designed, developed, and integrated high complex database systems for internal and external users, clients.
• Created documents and implemented standards and/or complex modeling to monitor and enhance the capacity and performance of the database. Codes complex programs and derives logical processes on technical platforms.
• Performed complex analyses and reviews applications being released into production. Developed and overseas the implementation of test application code in client server environments to ensure that software confirms to build management practices.
• Analyze Import/Export data.
• Prepare Weekly, Monthly, Quarterly and Yearly Reports to Management and Head Quarter Office.

Data Manager

Confidential, Addis Ababa, Ethiopia

• Designed and implemented a computerized database system for tracking and reporting HIV Counseling and Testing (HCT) clients data.
• Created documents and implemented standards and/or complex modeling to monitor and enhance the capacity and performance of the database.
• Periodically generate monthly, quarterly and annual statistical data on service

Researcher and Statistician

Confidential, Addis Ababa, Ethiopia

• Involved in designing sample survey and questionnaire for various national surveys.
• Prepared training manuals, collected follow-up data, prepared editing and coding manuals, prepared tabulation plan for the survey, and processed and analyzed data.
• Assistant market researcher survey conducted by Research International East Africa (NGO) in collaboration with WASS International PLC.
• Participated in Integrated Agricultural Sample Surveys, Producers and Consumers Price Surveys, Welfare Monitoring Survey, Rural and Urban Household Consumption Survey, Income and Expenditure Survey, and the first Ethiopian Agricultural Sample Census Survey.