Full name: - Hiwot Endihnew Gergisso
Tel #: 708-***-**** email: - adaebe@r.postjobfree.com
BETHESDA,MD
PROFESSIONAL SUMMARY:
Over 10 years overall of experience and 8 years in Database Administration, Development and Design Extensive experience with SQL Server 2012, and 2014.
Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Serve 2008R2,2012, and 2014.
Good experience in implementing High Availability & Disaster Recovery solutions using Always ON, Clustering, Replication, Mirroring and Log Shipping.
5 years of experience with SQL Database Security.
Experience in planning and implementing Microsoft SQL Server Security and database permissions.
Experience in supporting Very Large OLTP Databases of size 13 TB and troubleshooting the performance bottlenecks.
Expertise in SQL Server 2012/14 Reporting Services (SSRS) and SQL Server 2012/14 Integration Services (SSIS) in Business Intelligence.
Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
Good Knowledge and Experience on Cloud like Azure/AWS.
Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
Identifying the bottlenecks using SQL Server Profiler and Perfmon.
Experience in using Data Partitioning for large tables of data to increase performance.
Expert in implementing business logic by using TSQL, Stored procedures, triggers (DDL, DML) and functions (Inline & Multivalued Table functions.).
Proficient with database backup and recovery models.
Experience in Backup tools like SQL Safe and LITE SPEED for fast and efficient database backups.
Experience in writing complex T-SQL (DDL, DML, and DCL).
Experience in using Dynamic Management views (DMV) to trouble shoot and improve server performance.
Experience with Normalized and de-normalized database design.
Extensively worked on RDBMS concepts to design Relational Database model as per Business requirement.
Extensive experience in using Version control system tools for deploying scripts in various stages of SQL Server.
Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs. Flexible and versatile to adapt to any new environment and work on any project.
To provide 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging above 13 Terabytes to achieve maximum performance and uptime in production environment.
Strong time Management skills and excellent team player.
Ability to adapt quickly to changing environments.
TECHNICAL SKILLS:
Operating Systems : Windows XP/Vista/ Windows7/8/and 10
Databases : MS SQL Server 2012, 2014 and 2016 MS Office Access
ETL Tools : DTS (Data transformation services), Integration Services.
Database Tools : SQL Profiler, SQL Query Analyzer, Index Tuning -Wizard, Import/Export, SSRS, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs, SQL Mail, IP Mon, Lite Speed, TFS
Network Topologies : TCP/IP
TECHNICAL CERTIFICATON:
Microsoft Certified Solutions Associate (MCSA) - Administering Microsoft SQL Server 2012/2014 Databases
.EDUCATION:
Elementary and High School: Nazareth Catholic Girls School
Collage/University: Join and Graduate at ZEGH BUSINESS COLLEGE in Business Administration
Database Administration Training at Addis Ababa University
Advanced Database Administration Training at Compass Technology Training Center
PROFESSIONAL EXPERIENCE
Company: - Joytech PLC October 2015 – August 2019
SQL Server DBA
Responsibilities:
SQL Server Database Administrator.
Installed and configuration SQL Serve 2008R2,2012, and 2014 on windows 2003/2008 and 2010 environment.
Experience in implementing High Availability & Disaster Recovery solutions using Always ON, Clustering, Replication, Mirroring and Log Shipping.
Working with SQL Database Security.
Involved in Monitoring and troubleshooting replication issues
Configured Server Memory for maximum Performance and effective utilization.
Configured Temp DB for to increase the performance of SQL Server.
Monitoring SQL server performance using profiler to find performance and deadlocks.
Worked and generated reports using SQL Server 2008 R2,2012 and 2014 Reporting Services (SSRS), (SSIS), and (SSAS)
Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing through Maintenance Planner
Maintaining the database consistency with DBCC at regular intervals
Creating SQL Server Logins and assigning Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
Created Maintenance Plans that helped in effective disk utilization and index maintenance.
Effectively managed disk space using LITE SPEED for Data base Backups
Created, Scheduled and monitored SQL Server Jobs, making sure jobs run successfully every night.
Tuned stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
Extensively worked on 24X7 Production support and involved in on call rotation.
Extensively worked with Native and SQL SAFE compression Backups.
Extensively worked on Documentation of run books and release documents for production deployments and other processes.
Supra Floritech PLC July 2011 to September 2015
Junior SQL Server DBA
Responsibilities:
SQL Server Database Administrator
Installed SQL Server 2012 and 2014 on windows 2010 on clustered environment.
Worked across 60 servers and more than 600 databases.
Worked extensively on SQL Server 2012 and 2014 Transactional Replication.
Installed and configured and maintained failover clustering for SQL SERVER 2012 and 2014
Migration of Replicated databases from SQL Server 2000 to SQL Server 2012 and 2014.
Involved in Monitoring and involved in trouble shooting replication issues
Configured Server Memory for maximum Performance and effective utilization.
Monitoring SQL server performance using profiler to find performance and deadlocks.
Integrated Performance monitor and SQL traces to have better graphical analysis to find system bottlenecks.
Extensively worked on 24X7 Production support and involved in trouble shooting SQL servers in various levels.
Extensively worked on Documentation of run books and release documents for production deployments and other processes.
Tal Flowers Plc June 2009 – June 2011
Accountant
Responsibilities:
Reconciling account and preparing audit reports
Monitoring and being accountable for the office operations
Preparing and processing export documents
Maintaining adequate filling systems in soft and hard copies for easy identifications, access
Prepaying monthly payrolls
Recording, preparing and making Tax and Bills payments each month
Handling office operations petty cash
Depositing cash and cheque payments
Coordinating purchase for office supplies