Bini Berhane

Email: bin.gedayb @gmail.com

Phone number: 720-***-****

SUMMARY

●Microsoft SQL Server Database Administrator with 9+ years of professional experience in different Microsoft products. As a DBA professional and troubleshooting experience include

●SQL Server database administration, data modeling, gathering, and analyzing business requirements and Operating Systems. Solid working experience in managing large databases, backup/recovery, high availability solution like Mirroring.

●Log shipping, Replication and SQL Failover Cluster and Always On, developing and managing reports using SQL Reporting Services (SSRS), Monitoring

●Performance Tuning, stored procedures, triggers, functions, constraints, and views etc. Working experience entails strong knowledge on using database third party tools like OpNet, SolarWinds, Idera, ERWin, Visio, and Toad Data Modeler.

●Migrated and Managed SQL databases in Azure Cloud Environment include SQL Server, Azure SQL, setup instance, develop and manage databases.

●Strong business and technical vision with effective people skills, ability to manage multiple complex projects, innovative and creative problem solver, results oriented, and has an aptitude for learning and can maximize resources while possessing a sense of urgency.

Education: Bahir Dar University BSC in computer science July 2007 in Bahir Dar, Ethiopia

Certifications: “MS Certified Solution Associate” 2021

SQL Server DBA

Landmark Health AL, Alabama, United States

December 2022- present contract Responsibilities

●Installing, managing, and administering MS SQL server 2012, 2016 and 2019 versions.

●Implemented side-by-side and in-place migration of older to newer SQL server versions.

●Applied Patches and Service packs to update different versions of MS SQL server and windows server.

●Responsible for configuring and administering High Availability and disaster recovery solutions like Always On availability groups, Clustering, Transactional Replication and Log shipping.

●Configuring daily administrative activities like controlling user privileges, roles, monitoring the security and audit issues.

●Planning and applying Backup and restoration activities.

●Creation, configuration, and administration of SQL Servers in a VM on Azure.

●Setup, configuration, administration of SQL Servers Always ON in a VM on Azure.

●Deployed IaaS virtual machines (VMs) and cloud services PaaS role instances) into secure VNets and subnets.

●Configured Database mail, linked servers, Transparent Data Encryption (TDE), Change data capture (CDC).

●Performed Administrative tasks in SQL Server using PowerShell.

●Reorganize and rebuild indexes at a regular interval for better performance.

●Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.

●Routinely evaluate and improve methods for administering and maintaining databases and servers.

●Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans.

●Provide exceptional technical support 24/7 to ensure optimal customer service.

SQL Server DBA

SunTrust Banks Atlanta, Georgia, United States

October 2018 – December 2022 Responsibilities

●Installing, managing, and administering MS SQL server 2012, 2016 and 2019 versions.

●Implemented side-by-side and in-place migration of older to newer SQL server versions.

●Applied Patches and Service packs to update different versions of MS SQL server and windows server.

●Responsible for configuring and administering High Availability and disaster recovery solutions like Always On availability groups, Clustering, Transactional Replication and Log shipping.

●Configuring daily administrative activities like controlling user privileges, roles, monitoring the security and audit issues.

●Planning and applying Backup and restoration activities.

●Creation, configuration, and administration of SQL Servers in a VM on Azure.

●Setup, configuration, administration of SQL Servers Always ON in a VM on Azure.

●Deployed IaaS virtual machines (VMs) and cloud services PaaS role instances) into secure VNets and subnets.

●Configured Database mail, linked servers, Transparent Data Encryption (TDE), Change data capture (CDC).

●Performed Administrative tasks in SQL Server using PowerShell.

●Reorganize and rebuild indexes at a regular interval for better performance.

●Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.

●Routinely evaluate and improve methods for administering and maintaining databases and servers.

●Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans.

●Provide exceptional technical support 24/7 to ensure optimal customer service. SQL Server DBA

Eli Lilly Indianapolis, Indiana, United States

October 2015 – September 2018

Responsibilities

●Installed, Configured, and Managed SQL Server 2016, 2014, 2012, 2008 R2 in development, test, and production environment

●Installed & Configured SQL Server Reporting Services (SSRS)

●Developed Ad-hoc Reports using SSRS.

●Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2012

●Installed, Configured and Maintained Database Mirroring using automatic fail-over option in SQL Server 2008 R2 & 2012

●Configured and Maintained Replications (Transactional)

●Configured and Maintained Always on in SQL Server 2016

●Database Upgraded (development, testing and production environment):

●SQL Server 2008R2 to SQL Server 2014 and 2012

●Database Migrated (development, testing and production environment)

●Oracle 10g databases to SQL Server 2012

●My-SQL 5.0.1 databases to SQL Server 2012

●Backward & Forward Engineering with data modeling

●Applied SP (Service Pack) on SQL Server 2012

●Strong on database Monitoring and Performance tuning

●Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification.

●Monitor SQL Server Error Log, space usage.

●Assisted Database Developers to optimize SQL queries and Stored Procedures

●Export & Import data from Flat file, CSV file to/from SQL Server Database using SSIS,

●Export & Import data from/to databases like Oracle, My-SQL, and Access to/from SQL Server

●Experienced with Point-in-Time Recovery, restored Database from backup.

SQL Server DBA

American Express New York, New York, United States

January 2013 – August 2015

Responsibilities

●Maintains the overall enterprise database architecture including number of instances and how each is used.

●Designs and implements databases in conjunction with the application development and Enterprise Data Analyst teams.

●Provides consultation and troubleshooting for the development team.

●Implements and maintains database security.

●Provides 7X24 database support for production databases.

●Design build, configure, upgrade, and manages database installations.

●Proactively monitor and perform database performance tuning activities.

●Provide input into overall development/implementation plan and document database builds and changes, perform SQL designs, table designs, and stored procedures work.

●Translate logical to physical design, develops comprehensive DB architecture, implementation, and upgrade plans, and assists in definition of database standards, policies, and procedures.

●Extensively worked in designing backup strategy using Full, Differential and Transactional log backups and setting automated jobs.

●Migrated data using Import/Export, bulk, backup-restore, DTS, SSIS, Detach/Attach ● Performed data Extracting, Transforming and Loading (ETL) from different data sources.

●Rebuilding /reorganize indexes to reduce fragmentation and enhance SQL server performance.

●Created triggers, views, and stored procedures,

●Implemented database Maintenance plans, scheduled automated SQL Server jobs, Created Alerts, Operators, Notifications, and configured database Mail.

●Hands on experience monitoring and performance tuning using Tuning Advisor, SQL server Profiler, Activity monitor, Windows performance monitor, DBCC, DMVs, Stored procedures.

●Working with Resource Governor to control and allocate CPU and memory resources depending on the priority of applications.

Contact this candidate