Birhan Dez

ada3si@r.postjobfree.com

Phone 647-***-****

Education

Bachelor of Arts

Dalhousie University, Halifax, Canada

Diploma in Database Administration

Certification

Administering Microsoft SQL Server 2012/2014 Databases

Summary Statement

Highly motivated certified SQL server database administrator 5 years of experience, in administering and managing multiple MS SQL Servers and Databases in Production and Pre-Production environments, demonstrated record of troubleshooting daily operations as well as system capabilities through enhancing performance or implementing innovative technological solutions.

Professional Summary

Experience on implementing and monitoring of HA and DR solutions including Always On Availability, Replication, clustering, Mirroring and Log shipping.

Experience on Installation, Configuration, Performance Tuning, Security, High Availability and Disaster Recovery solutions on different editions and versions of SQL server.

Experience in database monitoring, troubleshooting, performance tuning and optimization using native and third-party monitoring tools.

Automate Jobs and regular processes, track issues, and document changes.

Experience in SSIS, SSAS, and Microsoft Visual Studio

Experienced in supporting SQL Servers on Amazon Web Service (AWS) and AZURE.

Experienced in patching service packs, applying hotfixes and cumulative updates.

Hands-on experience on managing and administering very large databases (VLDB) that are highly critical and need to be 24X7 available.

Developed backup and recovery strategies and anticipate hardware requirements and storage capacity planning.

Hands on Experience on Power Shell and Shell scripting

Hands-on experience on administering Windows Server, including Active Directory (AD), DNS and clustering WFC.

Storage capacity planning for development, testing, QA and production environments.

Good working knowledge with DacPac, BacPac and IsPac concepts and deployment

Solid experience optimizing Server performance by creating, rebuilding and reorganizing indexes on various tables, updating statistics, analyzing execution plan and corresponding costs.

Working Experience in Python Programming

Working Experience in LUNIX and UNIX

Good Team player, self-motivated with excellent documentation, problem-solving skills and ability to understand and analyze business requirements.

Experience providing on call 24X7 production support.

Work Experience

Infosys May 2016 – Present

Toronto, ON

Implement HA and DR solution in accordance with Business RTO/RPO policy, including Always ON Availability group, Replication, Mirroring, Peer to Peer and Log Shipping

Installation, Configuration, Performance Tuning, Security, High Availability and Disaster Recovery solutions on different editions and versions of SQL server.

Implementing Database Maintenance Plans (Database Integrity Checks, Index Maintenance, Updating Statistics, Monitoring Database and Disk Space) and running SQL Trace (SQL Profiler) and Extended Events.

Develop T-SQL scripts to create stored procedures, user defined functions, constraints, triggers, and views.

Proactively monitor production databases and optimize systems for better performance.

Diagnose system problems, evaluate alternative solutions and take initiative to solve problems.

Working knowledge on LUNIX and UNIX Operating systems.

Automating Jobs and regular processes, track issues and document changes.

Pro-actively monitor servers, analyze logs, and troubleshoot connection problems, SQL Server issues (concurrency problems such as locks, blockings, and deadlocks) and SQL Server Agent job execution problems.

Monitoring, troubleshooting, performance tuning and optimization using native and third-party monitoring tools.

Creating SSIS packages, develop ETL packages from different data sources (SQL Server, Flat Files, Excel, XML files, etc.), and SSRS

Developing Database Standards, Procedures, Policies, Data Dictionaries and Database Documentation

Hands on Experience on Power shell and Shell Scripting.

Pickup, resolve and track daily database incidents and tickets efficiently

Developing backup and recovery strategies and anticipate hardware requirements and storage capacity planning.

Creating SQL server agent jobs, create packages, and send alerts, using SSIS and SQL Server Database Mail.

Monitoring system’s health and performance.

Strong Knowledge using DMV’s and catalogs, Perfmon, SQL Profiler, Extended Events

Upgrade SQL Server using Backup-Restore, Migration Assistant, SSIS packages, Attach and Detach Methods

Migrate databases from SQL Server 2008 and 2008 R2 to SQL Server 2014 and 2016

Supporting SQL Server on Amazon Web Service (AWS) and Azure

Securing SQL Servers and databases in PCI, HIPA and FISMA environments, create and manage logins and roles, grant permissions to users and user defined roles, monitor user accounts, create server and database audit specifications and event notifications.

Create and manage database objects such as tables, store procedures, functions, views, and indexes, using T-SQL, configure OLE DB providers and link servers for complex and distributed queries.

Working with Network and System engineers for optimization of database and related application servers (CPU, Memory, disk space, Network )

MS SQL Server DBA NTI DATA Jan 2014 – Feb 2016

Addis Ababa, Ethiopia

Experienced in Installation, Configuration, Performance Tuning, Security, High Availability and Disaster Recovery solutions on different editions and versions of SQL server.

Experienced in supporting Oracle Database

Experienced in patching service packs, applying hotfixes and cumulative updates.

Experienced in database monitoring, troubleshooting, performance tuning and optimization using native and third-party monitoring tools

Deploy and upgrade application databases,

Configured and automated different database maintenance jobs for MS SQL Server (DBCC CHECKDB, backup, update statistics, index maintenance, monitoring database and disk space).

Resolved technical issues through investigation, research, and debugging.

Administered Server security by enforcing security policy, creating user logins with appropriate roles, monitoring user accounts, granting access privileges to authorized users and groups.

Took and validated backups to ensure business RPO and RTO objectives are met.

Created various SQL Server Agent jobs, packages, and alerts using SSIS and SQL Server database mail.

Developed T-SQL scripts to create stored procedures, user defined functions, constraints, triggers, and views.

Proactively monitored production databases and optimize systems for better performance.

Diagnosed system problems, evaluate alternative solutions and take initiative to solve problems.

Developed backup and recovery strategies and anticipate hardware requirements and storage capacity planning.

Immigration Canada 2010-2012

Halifax, NS

Promoted CIC programs to schools, Immigrant Communities, youth groups

Developed communication products

Managed communication products such as websites, videos, short films, and brochures.

Organized events to promote CIC community outreach programs.

Updated community contacts for outreach purposes

Contact this candidate