Database Administrator Sql Server

ELIAS DESALEGN

Database Administrator

Houston, TX 77063 832-***-****

**************@*******.*** linkedin.com/in/elias-desalegn

Experienced Database Administrator III with SQL Server expertise, specializing in HADR solutions, performance tuning, database replication, design, and stored procedures. Possess strong communication skills ensuring top-quality solutions and seamless database performance.

Work Experience

Database Administrator Aug 2021 - Present

US Venture Appleton

●Perform and maintain monthly refresh scheduled jobs from Cloud test to on-prem test.

●Experience working in Azure Cloud, DevOps, Azure Data Factory, Azure Data Lake Storage, and Azure Synapse Analytics.

●Experience in utilizing serverless SQL pools within Azure Synapse to query and analyze data on- demand without needing to provision or manage infrastructure.

●Utilized SolarWinds Monitoring in daily operations for tracking and resolving database issues promptly.

●Work closely with BI engineers, server team, and storage groups to ensure optimal performance and efficiency.

●Familiarity with implementing security best practices, including data encryption, authentication, and authorization within Azure Data Factory.

●Experience moving and transforming data within Azure Synapse, including data movement between data storage services and data transformation using SQL queries and data flows.

●Migration process Oracle database to SQL server database.

●Handled schema conversion and modification on Oracle queries to ensure compatibility with SQL

Server.

●Implemented efficient Recovery Plans to ensure minimal downtime and loss of information during

●unexpected events.

●Successfully tuned and optimized SQL queries, resulting in a 30% improvement in database. response times.

●Implemented indexing strategies that reduced query execution times and enhanced overall

system performance.

●Maintenance and provisioning of all internal environment and integration databases.

●Experience using third-party tools such as SQL Sentry for Performance tuning and optimization.

●Perform daily system health of the SQL server (space, CPU utilization, memory)

●Successfully addressed performance and scalability concerns during Oracle to SQL migration,

●Optimizing database structures and configurations to enhance system efficiency post-migration.

●Manage and optimize system storage with effective Capacity Planning, ensuring optimal performance of databases.

●Performed troubleshooting on SSIS Packages to quickly resolve any issues impacting database performance.

Database Administrator Mar 2018 - Aug 2021

Star Furniture Houston

●Troubleshooting system issues, resolving database-related incidents, attention to detail, and completing maintenance requests.

●Managed the migration process from on-premises into Azure SQL Database.

●Expert using third-party tools such as Lite Speed, Spotlight, and Redgate for tuning and optimization.

●Experienced in setting up and optimizing Access Controls for efficient database management.

●Extensively work with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)

●Managed MongoDB database instances, including installation, configuration, and maintenance to ensure high availability.

●Creating necessary T-SQL scripts, stored procedures, tables, views, functions, triggers, and indexes.

●Designed and implemented scalable NoSQL database solutions to support high-transaction applications.

●Migrated SQL servers from on-prem to Azure environments and AWS.

●Responsible for securing SQL Server, user management, and assigning permissions and roles.

●Implemented & managed database failover as well as load balancing technologies per client's request.

●Optimized database performance by revising and improving existing business processes

●Managed and maintained Database Security protocols to ensure safe storage of vital business information.

●Developing strategies in migrating older to newer SQL servers.

●Monitoring SQL Server CPU, memory, IO, disk spaces, and other resources

●Implemented & managed database failover as well as load balancing technologies per client's request.

●Optimized NoSQL databases for performance and scalability, resulting in a 30% increase in query speed.

●Developed data models and schemas for NoSQL databases to ensure data integrity and efficient storage.

●Responsible for troubleshooting all SQL Server database issues on production, UAT, and testing environments.

●Enhanced business operations by efficiently configuring, installing, and maintaining databases,

●As a Database Administrator, used data masking tools to safeguard private customer data and reduce the risk of unauthorized access.

●Utilized team collaboration in troubleshooting and resolving complex database issues.

Database Administrator Nov 2016 - Mar 2018

Wells Fargo Bank Austin

●SQL Server performance tuning and security management.

●Extensively worked on Dynamic Management Views (DMV).

●Performed regular audits, updates and troubleshooting on the Production Database to optimize its function and efficiency.

●Utilized Azure Cosmos DB SDKs and APIs to integrate Cosmos DB with various applications, enhancing data access and manipulation capabilities.

●Worked on Large Databases over 8TB for OLTP and OLAP using partitioning.

●Utilized XML format and a relational database to store and exchange data migration of SQL Server Databases to Microsoft Azure hosted DB's and managed instances.

●Created various SSIS, SSRS, and SSAS packages to serve company needs.

●Database monitoring, server performance tuning queries, and Stored procedures.

●Managing timelines, prioritizing workload, and supporting a team environment.

●Managed and maintained the company's Cloud Infrastructure, ensuring optimal performance of database systems.

●Coordinated with the offshore DBA Support Team on production support issues.

●Managed security by defining roles and rights.

●Performed Database Migration from On-Premises SQL environment to Azure Database in the cloud.

●Involved in the requirements gathering for new applications and projects.

●Tested programs and databases to identify issues and make necessary modifications.

●Offering flexibility for after-hours and weekend support.

Database Administrator Oct 2015 - Nov 2016

University of Washington Seattle

●Installed and configured with backup jobs, database mail, and configuration options.

●Demonstrating excellent customer service, communication, and organizational skills.

●Upgraded SQL Servers with the latest service packs, Ensuring high performance levels, availability, sustainability, and security.

●Applied Computer Science principles to solve complex database issues and enhance system performance.

●Utilized Power BI to automate database reports, significantly improving efficiency and accuracy in data management tasks.

●Managed and maintained the company's ERP systems, ensuring data accuracy and system efficiency.

●Monitored data activities like database status, log utilization, and long - running transactions.

●Implemented SQL standards in writing Stored Procedures, Triggers, Views, and SQL Functions.

●Applied strong networking expertise to maintain high availability of databases across multiple platforms

●Managed the Development and Maintenance of various databases to ensure optimal

●performance and data integrity in a multi-platform environment

●Implement many automated tasks, which have historically been done manually using PowerShell,

●Managed ETL tools to ensure accurate and timely data extraction, transformation, and loading.

●Hands-on Deploying a new code base released to UAT and Production Environments.

●Managed and facilitated data migration projects ensuring minimal downtime and loss.

●Implemented company-wide database policies and procedures, contributing to improved.

●Managed and optimized company's data using API to improve efficiency and performance.

●Enhanced organizational efficiency through the effective application of Data Privacy principles in managing large scale databases.

Database Administrator Oct 2013 - Sep 2015

Potomac Electric Power Company (PEPCO) Rockville

●Environment: MS SQL Server 2008R2/2012/2014, Windows Server 2012/2012 R2

●Worked extensively on monitoring the database and resolving all the production issues in

response to the alerts.

●Analyzed clustered/non-clustered index allocation and included columns, and optimization of

query plans.

●Troubleshoot hardware bottleneck, system issues and proactively monitoring the

performance of SQL Server databases.

●Experienced in creating a database with project specifications and maintaining them.

●Recovered the databases from backup in disasters. Implementing point-in-time recovery

solutions.

●Implemented SQL Logins, Roles, and Authentication mode as a part of security strategies for

several classifications of users.

●Performance tuning of long-running queries and stored procedures, using SQL Profiler,

server-side traces, Database Tuning Advisor, and query execution plans.

●Performed Export & Import data from Flat file, CSV file, Oracle, and Access to/from SQL

Server database using DTS, SSIS, and BCP.

●Managed a SQL Server Migration from 2008 to 2014 with no data loss within a short period of

time.

Core Skills

•Solar Winds, Idera, Cohesity, Avamar, Logic Monitor, • Azure SQL Database, • PowerApps, •, Azure Active Directory, • Azure Synapse Analytics, •Database systems, • Azure Data Lake, • Azure Data Factory, •Agile, DevOps, Jira, and Confluence, •Visual Studio Code, • T-SQL, PowerShell, • MS SQL 2008/ 2012/2014/2016/2019/2022

Education

Addis Ababa University, Ethiopia Jan 2009

Bachelor of Science Computer and Information Sciences

Languages

English (fluent)

Certificates

Microsoft Certified Database Administrator (MCDBA)

[Issuer]

Certified Azure Associate

[Issuer]

Contact this candidate