Sql Server Data
Resume:
Taye Gidyelew Mengesha
*************@*****.***
Career Objective:
An experienced MS SQL Server Database Admin/Developer with more than 5 years of professional experience in Database Design, administration, ETL Processing, Report Development, Data Modeling, SQL/TSQL scripting, Gathering and analyzing business requirement and Administering Windows Server Operating Systems. Solid working experience in managing and troubleshooting large databases, configuration, backup/recovery, developing and managing reports using SQL Reporting Services (SSRS), Monitoring, Performance Tuning, stored procedures, triggers, functions, constraints and views etc. Experience in building Geo-database and configuring ArcSDE for spatial datasets. Working experience entails strong knowledge on using third party tools like IDERA, ERWin, and Toad Data Modeler. Strong business and technical vision with effective people skills, ability to manage multiple complex projects, innovative and creative problem solver, results oriented, and has an aptitude for learning.
Education:
B.Sc., Hawassa University, Ethiopia.
M.Sc., Geo-Information Science, Wageningen University, the Netherlands.
Technical Proficiency:
Database Expertise:
SQL Server 2016, 2014, 2012, 2008 R2, 2005, 2000, MS Access
Database Migration:
SQL Server to SQL Server, and MS Access/Excel to SQL Server
Operating System:
Windows Server 2012, 2008R2, 2003R2, 2000, UNIX/Linux, VMware
Languages:
SQL, T-SQL, HTML, Python, VB, JavaScript, C++
ETL, Data Warehouse and Reporting Tools:
SSIS/DTS, BCP, SSAS, SSRS, ArcGIS, ENVI, ERDAS, PowerBI, Tableau, SPSS, R
Data Modeling Tools:
ERWin, Toad Data Modeler, Visio, SSDD (SQL Server Database Diagram)
Third Party Tools:
RedGate, IDERA, ERWin and Toad Data Modeler
Networking:
Active Directory, DNS, TCP/IP
Hardware/Storage:
SAN, RAID, iSCSI
Professional Experiences
Dec 2016 – Nov 2017 SQL Database Administrator/SQL DBA, Targeted Technology Institute, Silverspring, MD
Major Responsibilities:
Installed, Configured, and Maintained SQL Server 2014, 2012, and 2008 R2 in development, test, and production environment
Configured and Maintained Fail-Over Clustering using SQL Server 2012
Installed and Configured SQL Server Reporting Services (SSRS)
Developed and deployed different types of Reports using different data sources like SQL Server, Oracle, Excel, CSV files
Delivered reports to users in variety of formats like Report Server (Web based), excel, pdf, html, excel and CSV formats
Configured and Maintained Replications, Log Shipping, and Mirroring for High Availability.
Upgraded/Migrated SQL Server Instances/Databases from older version SQL Server to new version of SQL Server like 2005 to 2008 R2 and 2008 R2 to 2012
Migrated MS Access Databases into MS SQL Server 2008 R2, and 2012
Applied SP (Service Pack)/ Hot Fixes on SQL Server Instances to address security and upgraded related issues
Performed database and SQL/TSQL Performance Tuning
Wrote SQL/T-SQL queries, Stored-Procedures, functions, and Triggers
Scheduled many jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
Developed Different Maintenance Plans for database monitoring
Setup Jobs, Maintenance plans for backups, Rebuilding indexes, check server health, alert, notifications
Create and managed different types of Indexes (Cluster/Non-Cluster), Constraints (Unique/Check)
Worked on Data Modeling projects, Backward Engineering, Developed E-R Diagram and used multiple tools like ERWin, Toad Data Modeler, and SQL Server Data Diagram
Developed SSIS Packages from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources
Deployed SSIS packages to move data across server, move logins, load data from different data sources
Used Imp/Exp Tool to Export & Import data from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources
Manual, on Demand and setup jobs for Database Backup, and design backup strategy
Deployed and Restored database including Point in Time Recovery
Monitor Server Activity, Error Log, space usage and solving problem as needed.
Apr 2014 - Dec 2016, SQL Database Administrator/SQL DBA, Modine Manufacturing Co, Racine, WI
Major Responsibilities:
•Installed, configured, and managed SQL Server 2008/2008R2/2012 in development, test, and production environment
•Upgraded databases (in the development, testing and production environment) fromSQLServer2008/R2 to SQL Server 2012 and 2014 using side by side and In-Place method
•Used upgrade advisor to analyze and detect any issues and used upgrade advisor reports
•Performed patching - applied SPs and Hot Fixes on SQL Server 2008/R2
•Used the SQL Server configuration manager to configure services, network protocols and network connectivity for SQL Server instance
•Installed, configured and maintained Fail-Over Cluster.
•Managed database backups and disaster recovery, restored databases from backup and performed Point-in-Time recovery
•Automated database tasks (created jobs, alerts and schedules for database maintenance tasks)
•Scheduled jobs to automate different database related activities including backup, Index de-fragmentation, re-indexing, update index statistics, maintenance cleanup, history cleanup and notify operator tasks
•Applied DMV and DMF for finding out long running queries and other related activities
•Experienced in Data Extraction, Transforming and Loading (ETL) and migration of database using DTS and SSIS.
•Experienced on producing report and managing and deploying using SQL Server Reporting services (SSRS).
Jan 2011 – Dec 2013, Database Administrator (DBA) Coillte, Dublin, Ireland
Major Responsibilities:
•Developing, configuring and maintaining database objects and related systems 24/7 uptime.
•Installed, configured and managed SQL Server 2008/R2, 2012 in development, test, and production environment.
•Applied SP (Service Pack) on SQL Server 2005 and 2008/R2.
•Upgraded databases from SQL Server 2005 to SQL Server 2008/R2,2012
•Created and modified tables, Stored Procedures, indexes, constraints, views, maintenance plans for database monitoring in SQL Server 2008R2 and 2012.
•Automated database tasks and created jobs, alerts, mails and schedules for database maintenance tasks.
•Managed database backup and disaster recovery, restored database from backup and Point-in-Time recovery.
•Managed and maintained security and permissions for different groups and users.
•Installed, configured and maintained Fail-Over Clustering, log shipping, mirroring, and replication.
•Data migration using DTS services across different databases and server.
•Performed database monitoring and performance tuning using native and third party tools(Spotlight).
•Develop and maintain proper documentation and procedures for database infrastructure, monitoring and security policies.
Jan 2009 – Dec 2010,,SQL Database Administrator (SQL DBA) Tree Metrics, Cork, Ireland
Major Responsibilities:
•Developed, configured and maintained database objects and related systems 24/7 uptime.
•Installed, configured and managed SQL Server 2005/ 2008/R2 development, test, and production environment.
•Applied SP (Service Pack) on SQL Server 2005 and 2008/R2.
•Upgraded databases from SQL Server 2005 to SQL Server 2008/R2
•Created and modified tables, Stored Procedures, indexes, constraints, views, maintenance plans for database monitoring in SQL Server 2008R2
•Automated database tasks and created jobs, alerts, and schedules for database maintenance tasks.
•Managed database backup and disaster recovery, restored database from backup.
•Managed and maintained security and permissions for different groups and users.
•migrated data using DTS services across different databases and server.
•Develop and maintain proper documentation and procedures for database infrastructure, monitoring and security policies.
Oct 2007-Oct 2008, GIS Specialist Food and Agriculture Organization / Inter Governmental Authority for Development-(FAO/IGAD) Addis Ababa, Ethiopia
Major Responsibilities:
Provided hands-on oversight in the full lifecycle development of GIS capacity, from management, sharing and exchange of spatial data within IGAD LPI Office and Member States.
Supported training courses in GIS and image analysis, maintained databases, and prepared GIS reports for project activities.
Mar 2006-Oct 2007, Gis analyst International livestock research institute (ILRI) Addis Ababa, Ethiopia
Major Responsibilities:
Spearheaded GIS service unit of the International Livestock research Institute (ILRI) providing GIS and Remote Sensing related service to researchers and scientists.
Developed Geo-database and provided training on GIS and Remote Sensing.
Sep 2005-Mar 2006, Lecturer, Hawassa University, Wondo Genet College Shashemene, Ethiopia
Major Responsibilities:
Built Geo-database for vector and raster data types
Prepared research proposals on GIS, Remote Sensing and land use land cover changes.
Thought Computer Science courses
Installed, configured and maintained college wide local area network (LAN)
Contact this candidate