Sql Server Database

DEREJE TAFESSE

******.*******@*******.*** 325-***-**** Dallas TX

Professional Summary

An experienced SQL Server Database administrator with 7 years of expertise in database management, performance tuning, database migration, high availability, and disaster recovery. Excel at optimizing database operations, ensuring data integrity, and managing large-scale projects. Demonstrated success in implementing innovative solutions and improving database efficiency and reliability. Proficient in security protocols, troubleshooting complex issues, and enhancing system performance. Skilled in collaboration with cross-functional teams, contributing to organizational objectives. Committed to operational excellence and continuous professional development. Adept at navigating challenging environments and driving technological advancements. Skills

• Windows Server 2022/2019/2016/2012

• SQL Server 2022/2019/2017/2016/2014/2012/2008R2

• Installation & Troubleshooting

• SQL Server Management Studio

• Database Management

• Performance Tuning

• Database Migration

• Backup and Recovery

• High Availability & Disaster Recovery (HADR)

• Query Optimization

• SSIS

• SSRS

• SSAS

• Extended Events

• Database Mail

• Index Maintenance

• AlwaysOn Availability Groups

• Microsoft Power BI

• T-SQL

• Indexing

• Store Procedures

• Azure

• PowerShell

• Automation

• Auditing

• Monitoring

• Data Cleansing

• Query Execution Plans

• SQL Profile

• Patch Management

• Clustering

• Log Shipping

• Mirroring

• Replication

• Database Security

• Transparent Data Encryption

• Teamwork and collaboration

• Customer Service & Retention

• Leadership

• Problem-Solving

• Cloud Platforms

• Golden-Gate

• Redgate

• Cloud migration

• Optimization

• System performance

• Azure cloud

• Data modeling

• Data warehousing

• ETL

• Query Tuning

• Microsoft PowerShell

• Database migration

• SOP

Experience

Happy State Bank

Senior SQL Server Database

Administrator

01/2022 - Current

• I installed, configured, and maintained MS SQL Server versions 2008 R2

/2012, 2014, 2016, 2017, 2019, and 2022 across production, development, and testing environments.

• I performed troubleshooting for database issues, pinpointing and resolving root causes to optimize performance.

• In collaboration with infrastructure and development teams, I ensured database reliability and provided technical support to developers and end- users.

• I crafted and executed comprehensive backup and recovery strategies, adhering to maintenance schedules for data protection.

• I aligned database backups with business Recovery Point Objectives (RPO) and regularly tested backups to meet Recovery Time Objectives (RTO).

• I managed server logins, database users, and customized roles, assigning users to roles to control data access.

• I proactively monitored security logs and user activities within SQL Server and third-party systems to prevent security threats.

• I implemented and sustained High Availability Disaster Recovery (HADR) strategies, including log shipping, database mirroring, Always On availability groups, and clustering, to ensure data availability and disaster recovery.

• I configured and oversaw SQL Server Replication for data distribution across locations, ensuring data integrity and access.

• I employed Redgate tools and SQL Server utilities for database performance monitoring, guaranteeing efficient operation and quick resolution of issues.

• I managed patch protocols to keep systems updated and secure with minimal downtime.

• I conducted data cleansing to enhance database quality and performance, ensuring data precision and dependability.

• I analyzed query execution plans to refine T-SQL queries, boosting system efficiency and reducing response times. Additionally, I developed and maintained SSIS packages for data integration and transformation. Marathon Oil

SQL Server Database Administrator

01/2019 - 12/2021

• I have installed, configured, and troubleshot SQL Server instances across various environments to ensure peak performance and reliability.

• I have utilized SQL Server Management Studio (SSMS) for database administration, system health monitoring, and performance tuning to boost database efficiency.

• My responsibilities included managing and maintaining database systems with tasks such as schema design, index tuning, and validating data integrity to support business operations.

• I have implemented advanced performance tuning techniques to pinpoint bottlenecks and enhance database operations, which significantly cut down response times and raised user satisfaction.

• . I have taken part in database migration projects, guaranteeing smooth transitions between SQL Server versions with minimal downtime and no data loss.

• I have established robust backup and recovery strategies to protect against data loss and enable swift recovery in case of failures.

• I have developed and sustained High Availability (HADR) solutions, including Always On Availability Groups, ensuring uninterrupted data access and meeting stringent SLAs for disaster recovery.

• I provide thorough support, administration, and maintenance for development, test, and production environments, ensuring consistent performance and reliability across SQL Server platforms.

• I design, create, and meticulously maintain SQL Server Integration Services

(SSIS) packages, enabling efficient data integration and transformation processes that bolster business intelligence and data warehousing solutions.

• I have effectively pinpointed and rectified server and database performance issues using Redgate SQL Monitor, markedly improving system stability and efficiency.

Abilene Regional Medical Center

Junior SQL Server Database

Administrator

06/2017 - 12/2018

• I managed environments for SQL Server 2016/2014/2012/2008R2 ensuring peak performance and reliability across both production and non- production servers.

• My role involved monitoring database performance to identify and resolve any system bottlenecks, guaranteeing optimal operation and user access.

• I assisted in the design and implementation of databases, including structuring, storage allocation, and managing data import/export processes.

• Regular maintenance tasks such as backups, restorations, and integrity checks were performed to ensure data accuracy and security.

• I implemented and maintained security measures for the database, including access controls and encryption, to safeguard sensitive information.

• In collaboration with senior DBAs, I worked on developing and optimizing SQL queries to enhance performance and efficiency.

• I was actively involved in disaster recovery planning and execution to minimize data loss during system failures.

• Additionally, I monitored and adjusted the DBMS settings to align with organizational standards and policies, provided technical support to end- users for database access and performance issues, and participated in database migration projects, specifically upgrading from SQL Server 2012 to 2014, ensuring a smooth transition with minimal downtime. Education

YOM Postgraduate College

Master of Business Administration

09/2021

Debre Berhan University

Bachelors in computer science

07/2012

Websites, Portfolios, Profiles

• www.linkedin.com/in/dereje-tafesse

Contact this candidate