SUMMARY:

• Around 2+ years hands on experienced in MS SQL Server 2019/2017/2016 Installation, Administration, Monitoring, Query Optimization, Always - On, Replications and
• Security of database Servers, TDE Encryption etc. Strong knowledge in writing TSQL, stored procedures, functions and triggers.Water and Environmental
• Engineer with 10+ years of experience in teaching, research at universities, consulting and supervising wastewater and water treatment projects for city administrations
• I am also committed to provide high quality engineering service to every project with focus on Health, Safety and Environmental issues.

TECHNICAL SKILLS:

• SQL Server, 2019, 2017, 2016, 2014
• Database Administration
• SQL/TSQL Programming
• Database Monitoring
• Installation/Configuration
• Indexing/Optimizing
• Database Security
• Transparent Data Encryption
• Always On Availability Group
• Database Replication
• Database Mirroring
• Database Auditing
• Disaster Recovery
• Backup/Restore
• Data moving using SSIS ETL Tool
• Data Manipulation
• Spreadsheet updating
• Account reconciliation
• Researching and rectifying variances
• Data analysis, research and management
• Equipped IGT Advantage CMS and other Casino systems
• Documentation and recordkeeping
• MS Excel, Word, Outlook, Power Point
• Excel Data Validation
• Customer- and service-oriented
• Excellent communication skills
• Team player mentality
• Quick Learner
• POS system operation
• Excel VLookup
• PivotTable

PROFESSIONAL EXPERIENCE:

Database Administrator

Confidential

Responsibilities:

• SQL Server Database Administration: Responsible for 24x7 technical support - 100+ instances of SQL Server 2019/2017/2016 Enterprise/Standard infrastructure (Production /QA/UAT /Staging/ Perf) with Always on Availability Group and Replication.
• TSQL Programming: Maintain and fine tune Adhoc SQL/ Stored Proc/UDF/Views/Triggers.
• HA/DR Implementation: Configure and Maintain Always on Availability Group, SQL Server Replication and Log Shipping.
• Performance Monitoring/Tuning: Index fine tuning, Analysis Disk, CPU & Memory bottle neck using Query Store, SCOM, SQL Profiler, Extended Events, DMV/DMF, PAL, SolarWinds DPA and Spotlight.
• Implementation of Permission, Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Patching and Code Release.
• Handled 20 TB+ Databases
• Participation in DevOps and adherence to Change/Problem/Incident/Event Management processes and procedures.
• Work closely with offshore development team located in India.

ASSISTANT PROFESSOR

Confidential

Responsibilities:

• Delivered Delivered lecture and conducted research on water and wastewater
• Characterized water and wastewater from different sources
• Development in nanomembrane-based filtration of emerging contaminants
• Aloe steudneri gel as natural flocculant for textile wastewater treatment
• Fate of filter materials and microbial communities during vermifiltration process
• Assessing the Industrial Effluent Effect on Irrigation Water Quality and Farm Soil near Kombolcha Town, Ethiopia
• Designed rainwater harvesting and wastewater treatment technologies for urban green infrastructure development in Ethiopian five (5) cities
• Prepared Specifications and bill of quantities for various new & maintenance projects.
• Assessed Environmental and Social Impact Assessment for different projects
• Organized and attended project progress meetings with contractors, project manager, project Engineer and Supervising Engineers.
• Prepared meeting Agendas and prepared meeting minutes.
• Prepared proposal and manuals for projects

Lecturer

Confidential

Responsibilities:

• Delivered lecture and conducted research on water and wastewater
• Evaluated the performance of water & wastewater treatment plants.
• Assessed environmental and social impact assessment for different projects
• Monitored water supply improvement project for Hawassa City
• Inspected water and wastewater quality for different sources
• Inspected water pressure and chlorination field test
• Prepared proposals and manuals for projects

Environment: al: SPECIALIST

Confidential

Responsibilities:

• Assessed Environmental and Social Impact Assessment for different projects
• Inspected water and wastewater quality from different sources
• Reviewed different new and rehabilitation project documents
• Conducted Environmental Auditing for selected industries
• Delivered s on reuse of wastewater and solid waste management
• Participated in river rehabilitation project (Gabion was also constructed)
• Evaluated the performance of industrial & wastewater treatment plants.
• Prepared and evaluated rehabilitation work schedules.
• Prepared and reported daily project monitoring reports.
• Prepared proposals and manuals for projects

Agricultural Engineer

Confidential

Responsibilities:

• Designed and monitored soil and water conservation techniques
• Studied watershed for selected areas
• Participated on resettlement projects
• Monitored the implementation of different projects to reduce the impact on the environment.
• Prepared and evaluated construction and monitoring work schedules.
• Prepared and reported daily project monitoring reports.