Resume

Sign in

GIS Analyst/SQL DBA

Location:
Annandale, Virginia, United States
Posted:
April 25, 2018

Contact this candidate

Resume:

Kebede Bogale DBA/GIS Analyst (Tel.571-***-****)

I have worked on many GIS/Database projects from design to Application development at different capacity for more than 10 years. Have experience in applying GIS/remote sensing for Engineering geology/Hydrogeology jobs. I have Master of Science (MSc), from the Netherlands, in applied Geological Survey with emphasis on Engineering Geology and GIS applications and Bachelor of Science (BSc) in Geology.

I am capable in data collecting using mobile equipment and producing information products. I am very familiar with ESRI products like ArcGIS Desktop/Server environment. I have working experience in GIS database manipulation like geodatabase and managed ArcSDE spatial relational database in Server environment. I was Division Head in water utility government office and worked also as project engineer. At this capacity I managed to map water points (bore holes), water mains (major pipe lines), reservoir locations, manholes etc. As a project engineer I was responsible for deep water well drilling project which consists of client, consultant and contractors and I successfully managed the project. Some of the products were various maps like detailed geological, hydrogeological, and groundwater modeling etc.

Have done detailed geological mapping of 5 km of tunnel, borehole logging, packer tests, strength tests in lab and field and presented it on geotechnical report which was applied for tunnel design.

I am a good team player, hardworking, and able to meet hard deadlines.

Summary of Qualifications:

Extensive experience as DBA and GIS Analyst

Experienced in Database Management, using MS SQL, Excel and Access.

Familiar with interpreting and presenting Remote Sensing GIS and Remote Sensing software packages using ArcGIS, ERDAS Imagine, and IDRISI Andes.

Wide range of experience in applying Remote Sensing and GIS for water resource study. .

Used GIS and remote sensing applications to create information products from Different SQL Databases

Have experience in field data collection using GPS and other mobile equipments.

Worked as Team leader in water resources studies

Professional Experience

Goodcare GIS/Web services ( https://goodcarellc.com/)

Alexandria, VA Sep. 2016 - To date

Started GIS/Web services consulting company.

Do consulting for various GIS projects in planning, design, create, implementation GIS projects

Create GIS web services and application.

Solve complex GIS problems

Write scripts and python codes to automate and prepare responsive web site

Solve complex analysis using open source GIS and ESRI model builder and other Geoprocessing techniques

Authoring real-time GIS eBook for Packt

Blue Pillar Company Falls Church, VA Sep. 2015 - Aug. 2016

MS SQL DBA

Created and administered database in SQL 2008r2 and 2012 environment

Installation and configuration

Data collection from various small and medium size firms

Security

-user account permission

-Server security

Backup & restoring

System monitoring

-CPU usage

-Storage usage

-Network failure

Quality control assurance

Reporting using sequel server reporting service (SSRS)

ONUCI/DPKO/UN- GIS Analyst Abidjan, Ivory Coat April 2015 - June 2015

Responsibilities:

Installed and configured ArcGIS 10.2 for Joint Mission Analysis Center (JMAC)

Analyzed collected incident data to enhance decision making

Used ArcSDE for spatial data manipulation of ONUCI Geodatabase.

Used Versioning for multiple users editing

Produced incident analysis data from vector and raster data

Produced weekly and monthly reports with maps and graphs after geospatial hotspot analysis

Datagroup Alexandria VA Sep. 2010 - May, 2015

Position: SQL DBA

Responsibilities:

Certified Database Administrator.

Worked and trained in SQL server administration

-Reporting Services (SSRS)

-Database clustering, replication, mirroring and log shipping

Data modeling

Integration services (SSIS).

Got Experience on ( DDL, DML, DCL, PL/SQL coding, stored procedures, functions, packages, triggers and Periodically uploading data from flat files using SQL*Loader.

Monitoring and Tuning the CPU, memory usage, I/O contention, paging, network statistics on servers, using SQL profiler, .

Used native and third party database management tools

Applied database best practices

Database upgrade from 2005 to 2008r2

Migration from 2008r2 to 2012

Service pack (SP)

Used windows 2008r2 for database administration

Proactively monitoring, identifying areas that need to be improved in the application and database.

Data transferred using high availabilities.

July 2008 – January, 2009

Addis Ababa Water & sewerage Authority Addis Ababa, Ethiopia

Project Engineer

Worked as project engineer at Addis Ababa Water and Sewerage Authority (AAWSA), in 40 Deep Wells Drilling Project. The objective of the project was to alleviate the serious shortage of water supply for the city of Addis Ababa.

Prepared contract & technical documents and cost estimates for drilling, civil and electromechanical works. Geophysical investigations have been done on ground water potential sites, and test drilling up to the depth of 500 meters was conducted. In addition to the project management duty I also have given training how to apply GIS in ground water development and operations.

Oct, 2006- May 2008

UN/FAO/NILE-project, Entebbe/Uganda

GIS Consultant

Worked on Population Distribution Analysis in the Nile Basin, with the aim of preparing posters which shows population density for the year 2005 and projection for 2030 using LandScan, UNPD and US Census Bureau data. I did Agricultural trade study and prepared a Map poster which shows export and import of Agricultural Commodity of Nile Basin Countries using ArcGIS 9.

Transferring the Africover land cover multipurpose data layer into Agricultural land use and worked on base line survey of Nile Countries on crops, livestock, fishery, forestry, prepare database for preparation of various GIS layer. The methodologies applied were mostly GIS/Remote Sensing techniques.

Dec, 1997-Sep, 2006

Addis Ababa Water and Sewerage Authority Addis Ababa, Ethiopia

Ground Water Production Division Head

Worked as Division Head for Ground Water Production of Addis Ababa. Responsible for operation and monitoring of existing wells and ground water exploration work using GIS and remote sensing techniques. Geophysical methods were executed and finally drilling and testing of water wells for water supply of Addis Ababa City were conducted. Prepared bid and specification documents for bidders of geophysical and drilling companies and did evaluation in order to select the best bidder company. Conducted water point inventory of Addis and the surrounding areas in which more than 500 water points were collected. Participated in ground water modeling of Akaki Well Field South of Addis Ababa City.

TRAINING

Participated ESRI User Conference July 13-17, 2009, at the San Diego convention Center in California USA.

Participated on ESRI Eastern Africa User Conference 13-14 September 2007, Sheraton Hotel Kampala-Uganda.

CERTIFICATION

Microsoft SQL server 2008, Implementation and maintenance April, 2013 Virginia USA

Certificate on Introduction to ArcGIS Server 20-21 September, 2007 Kampala-Uganda.

Certificate in “Project planning, implementation, monitoring & Evaluation”, May 9 – May 27, 2005 – Ethiopian Management Institute.

Certificate in GIS Aug.8-27, 2004- “Design and its application to ground water Resource Management” Addis Ababa Ethiopia. By Japan International Cooperation Agency (JICA)

Certificate in “management of groundwater supply for urban area” Sep.3 – Oct.13, 2000 Goteborg, Sweden

Took a lot of ESRI online trainings like Spatial analyst, Python etc..

Contact address:

Kebede Bogale ( DBA/GIS Analyst)

Cell phone - 571-***-****

Email: ac480y@r.postjobfree.com; ac480y@r.postjobfree.com



Contact this candidate