Resume

Sign in

Sql Server Office

Location:
Bethesda, Maryland, United States
Salary:
N/G
Posted:
September 20, 2019

Contact this candidate

Resume:

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



Contact this candidate