Senior SQL Server DBA and Cloud Migration Expert

Mekdes Tefera

714-***-**** Anaheim, CA ***********@*******.***

PROFESSIONAL SUMMARY

Experienced SQL Server DBA with over 7 years of expertise in database installation, configuration, performance tuning, and disaster recovery. Skilled in high-availability solutions, SQL migrations, and database optimization for scalability and reliability. Proficient in security implementations. Adept at resolving complex database issues and ensuring 24/7 support for production environments. TECHNICAL EXPERTISE

Database Platforms: MSSQL Server (2012–2019), MySQL, Azure SQL Cloud Platforms: Azure SQL Database, AWS RDS, EC2, S3 HA & DR: Always On AGs, FCI, Log Shipping, Mirroring, Replication, ASR, Geo-Replication Performance Tuning: Query & Index Optimization, Execution Plan Analysis, DMVs, Extended Events

Scripting & Automation: T-SQL, SQL, PowerShell(PS) Security: TDE, Always Encrypted, RLS, Dynamic Data Masking, Auditing Tools & Utilities: SSMS, SSCM, Activity Monitor, SQL Profiler, Event Viewer, DTA, SSIS, SSRS, ETL tools, Redgate, Ola Hallengren, GoldenGate

ETL & Reporting: SSIS, ADF, BCP, SSRS

Soft Skills: Communication, Teamwork, Adaptability, Continuous Learning PROFESSIONAL EXPERIENCE

U.S. Bank Jan 2023-Present

Senior SQL Server DBA Anaheim, CA

• Managed 200+ database servers across development, QA, UAT, and disaster recovery environments.

• Successfully migrated data from on-premise infrastructure to Azure SQL Database with zero downtime.

• Implemented side-by-side and in-place upgrades from SQL Server 2016 to 2022.

• Configured high-availability solutions including AlwaysOn and clustering.

• Performed database consistency checks, index maintenance, and performance tuning.

• Developed and deployed SSIS packages for data integration.

• Configured Transparent Data Encryption (TDE) and auditing for security.

• Used tool like Redgate SQL Compare for monitoring and troubleshooting.

• Created a SSIS package from Production servers.

• Experience in SQL Server Reporting Services (SSRS) on SQL Server 2022.

• Created Logins and Roles with appropriate Permissions.

• Configured Transparent Data Encryption (TDE) and Auditing.

• Created Linked Servers between different Servers in SQL Server 2019 Environments.

• Performed database consistency checks using DBCC Utilities and handling data corruption.

• Experience in Rebuilding/ Reorganizing Indexes based on Index fragmentation levels.

• Implemented SQL server logins, Roles and Authentication modes as a part of security policies.

Best Buy Feb 2020 – Dec 2022

SQL Server DBA Fullerton, CA

• Installed and upgraded SQL Server instances in clustered and non-clustered environments.

• Planned and implemented disaster recovery strategies including log shipping and replication.

• Optimized queries using SQL Profiler and Database Engine Tuning Advisor.

• Designed and generated reports using SSRS based on user requirements.

• Conducted migrations from SQL Server 2014 to 2019 and utilized Change Data Capture

(CDC) for data integrity.

• Automated maintenance plans and database monitoring through SQL scripts.

• Worked on Integration services for the purpose of Transforming data from the cubes and storing it into the SQL Server tables.

• Created maintenance plans and jobs to achieve maximum performance.

• Performance monitoring & Tuning, Query Optimization, Client/Server Connectivity and Database Consistency Checks using DBCC Utilities.

• Developed and documented backups, recovery strategies, disaster recovery mechanism and participated in disaster recovery drills for various environments. Successfully implemented Log shipping for DR solutions.

• Proactively managed Microsoft SQL Server instances at the corporate office by developing Microsoft SQL scripts for creation and upgrade of databases.

• Extensively worked on upgrading Microsoft SQL server, failover clustering, log shipping, and replication, using System Monitor and SQL Server Profiler to identify bottlenecks, discovering slow-running queries, performing backup and recovery databases, and implementing database modifications on production servers.

• Developed CI/CD pipelines in Azure DevOps for database deployment automation, streamlining release cycles.

• Configured Dynamic Data Masking and Row-Level Security (RLS) to strengthen data protection and compliance.

Sukut Construction, LLC July 2018 – January 2020

SQL Server DBA Santa Ana, CA

• Created and maintained database maintenance plans for integrity checks, statistics updates, and re-indexing.

• Migrated databases from SQL Server 2012 to 2017.

• Assisted development teams in database design and optimization.

• Configured log shipping for database synchronization and recovery.

• Troubleshoot performance issues and optimized long-running queries.

• Developed functions, procedures, and packages for business requirements.

• Used SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.

• Installed SQL Server 2017 and created a development database for testing, upgrades and development.

• Worked with Application developer to design databases and tables to support Development activities and achieve optimal efficiency.

• Handled numerous change management requests on production servers.

• Configured SQL Server settings using configuration manager.

• Worked on log shipping for synchronization of databases.

• Involved in creating functions to provide custom functionality as per the requirements.

• Recovering the databases from backup in disasters.

• Analyze long running slow queries and tune the same to optimize application and system performance.

EDUCATION

Addis Ababa University, Ethiopia

Bachelor of Computer Science

LEADERSHIP SKILLS

•Strong communication, collaboration, and problem-solving skills, with a focus on promoting productivity, quality, and innovation within teams.

• Motivating and inspiring teams to achieve objectives.

• Cultivating a proactive approach to problem-solving, encouraging teams to identify potential issues before they escalate.

• Collaborated with developers, system administrators, and other IT professionals to ensure databases met organizational needs.

Contact this candidate