Database Administrator Sql Server

Ermias Wolde

SQL Server Database Administrator

Location: McKinney, Texas Phone: +1-408-***-**** Email: ******.*******@*****.*** LinkedIn

SUMMARY:

SQL Server Database Administration with 5 years of experience in different versions of Microsoft SQL Server Database Installation, Configuration, Administration, Maintenance, Performance Tuning, Security implementation, Backup/Restore, and disaster recovery procedures.

Strategically devised and executed high availability and disaster recovery strategies, encompassing solutions like Replication, Log Shipping, Always On, and Clustering.

Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins, and created indexes whenever necessary.

Performed data migrations to Azure SQL Database using SQL Azure Migration Wizard and Data Migration Assistant, ensuring minimal downtime and data integrity.

Expertise in Database Backup & Recovery for various mission-critical business applications.

Expert in utilizing SQL Server Profiler, Performance Monitor & Database Engine-Tuning Advisor for monitoring and troubleshooting databases & SQL Server performance.

Conducted database tuning, indexing, customization, transformation, data migrations/conversions, installations, troubleshooting, upgrades, patching, user management, and security measures.

Provided guidance and expertise for database performance Tuning and Query optimization using both SQL Server inbuilt and third-party tools.

Experienced in SQL Server Reporting Services Installation, Configuration, and Maintenance using Visual Studio and Reporting Services.

Applied Transparent Data Encryption (TDE) to secure sensitive data at rest. Implemented security best practices to protect data and maintain compliance with industry standards.

Utilized Red Gate tools and Redgate SQL Backup for database backup, recovery, and monitoring. Implemented high availability and disaster recovery solutions.

Knowledge in allocating system storage and planning future storage requirements for the database system.

Embodies excellent communication skills, with the ability to interact effectively with a wide range of technical/business users.

SKILLS:

SQL Server Versions:

Microsoft SQL Server 2012/2014/2016/2017/2019/2022

Scripting/Programming:

T-SQL, PowerShell

Development Tools:

Microsoft Visual Studio 2019/2022, SSMS (SQL Server Management Studio), SSCM (SQL Server Configuration Manager), Red Gate, Redgate SQL Backup

Reporting and Integration:

SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services)

Cloud Services:

Azure Portal, SQL Azure Migration Wizard, Azure SQL Database

Migration Tools:

Data Migration Assistant

Ticketing Systems:

Service Now

High Availability & DR:

Replication, Log-Shipping, Mirroring, HADR Always On, Clustering

Security:

TDE (Transparent Data Encryption)

Maintenance:

Database Consistency Checks (DBCC)

Operating Systems:

Windows Server 2022 /2019/2016/2014/2012

Soft Skills:

Communication, Problem-solving, Critical- Thinking, Adaptability, Team Work

CERTIFICATIONS:

Microsoft Certified IT Professional (MCITP) SQL Server 2014

DP-900: Microsoft Certified: Microsoft Azure Data Fundamentals

WORK EXPERIENCE:

SQL Server Database Administrator Apr 2022 – Present

McKinsey & Company, Dallas, TX

Boost a 15% increase in database performance by optimizing T-SQL queries and streamlining DBA processes.

Configure and maintain SQL Server 2016/2014/2012 in development, non-production, and production environments.

Design a disaster recovery strategy for the company's database, leading to 20% improved business continuity capabilities.

Implement SQL Server Reporting Services (SSRS) to provide a comprehensive analysis demanded by the management, enhancing business intelligence by 35%.

Proactively review security logs, user logins within SQL server, and third-party solutions to prevent breaches or violations.

Execute regular database backup and replication, ensuring data safety and availability at all times.

Investigate and resolve severe performance tuning bottlenecks, improving system performance by 18%.

Configure Transparent Data Encryption (TDE) and backup/Restore strategies on encrypted databases.

Ensure high availability by implementing failover clustering, Log Shipping, database mirroring, or Always on Availability Group Configuration.

Apply various replication and HADR models, including log shipping, database mirroring, Always On, and Clustering.

Led the design and development of database structures, schemas, and objects to align with business requirements, leveraging Azure SQL Database features for scalability and efficiency.

Set up and manage High Availability and Disaster Recovery solutions such as Always on Availability group, log shipping, and replication.

Deploy SSIS packages to change the connection string and update the value of a variable to transform data as per the Business Required Document.

Leverage ticketing services like Service Now to streamline issue tracking and resolution.

Monitor and manage SQL Server instances using SQL Server Management Studio (SSMS) and SQL Server Configuration Manager (SSCM).

SQL Server Database Administrator May 2019 – Mar 2022

DXC Technology, Richardson, TX

Configured and managed database and data security solutions, applying TDE (Transparent Data Encryption), row-level security, column-level encryption, dynamic data encryption, role-based security policy, and security auditing.

Performed data migration of SQL Server 2012 to SQL Server 2016 in development, testing, and production environments.

Managed and maintained HADR technologies such as AlwaysOn, replication, log shipping, mirroring, and clustering.

Designed and implemented ETL processes using SQL Server Integration Services (SSIS) to streamline data integration.

Conducted regular Database Consistency Checks (DBCC) to ensure database integrity and performance.

Utilized Red Gate tools and Redgate SQL Backup for database backup, recovery, and monitoring.

Developed and optimized complex queries, stored procedures, and scripts using T-SQL and PowerShell.

Increased database efficiency by 25% through routine performance tuning.

Installed SQL Server Reporting Services (SSRS) to create a common report template and used SSRS data source connections inside the report.

Reduced database downtime by 20% through regular monitoring and maintaining high availability.

Led the design and deployment of a SQL Azure cloud solution, improving scalability and accessibility by 40%.

Troubleshoot performance issues related to query optimization, tempdb, and log file growing fast, and identified and released locks, blocks, and deadlocks.

Implemented High Availability Disaster Recovery (HA/DR) solutions (Log Shipping, Transactional Replication, Always on Availability Group).

Utilized Azure Monitor and Azure Security Center to enhance the security posture of the databases.

Employed troubleshooting tools such as SQL Profiler, stored procedures, Activity Monitor, DMVs, and wait stats.

Monitored and optimized SQL Server performance using SSMS and other monitoring tools, ensuring efficient database operations.

Contact this candidate