Daniel Asfaw

Database Administrator

+1-240-***-****

ad23qi@r.postjobfree.com

www.linkedin.com/in/daniaw1221

Experienced Database Administrator with over 5 years of proficiency, specializing in MS SQL, MySQL management on premise and cloud environments. Adept in the end-to-end process of designing, implementing, and fine-tuning databases to align with strategic business objectives. Profound proficiency in performance enhancement, backup and recovery strategies, security reinforcement, and query optimization. Known for sharp analytical acumen and effective problem-solving capabilities. Exceptional communication is a collaboration skill that fosters seamless teamwork. Dedicated to continuous learning and adapting to cutting-edge technologies and industry best practices. Prepared to make impactful contributions by ensuring streamlined and dependable database operations for organizational success.

Work Experience

Database Administrator

PepsiCo

Nov 2021 to Present Harrison, NY

● Successfully execute upgrades from SQL Server 2016 to SQL Server 2017 and 2019, ensuring seamless transitions.

● Display adeptness in Azure migraƟon and the creaƟon of Azure SQL databases, expertly leveraging Azure data tools to ensure scalability, efficient storage management, and optimized service delivery.

● Proficiently install, configure, and administer producƟon and non-production servers, encompassing both clustered and non-clustered configurations.

● Expertly facilitate the database refresh process from producƟon to lower environments, aligning with business requisites. Implement automated quarterly/monthly database refresh cycles for enhanced efficiency.

● Play an integral role in SQL performance tuning, adeptly idenƟfying and addressing locking and blocking issues. Leverage both Native and Third-party tools to optimize SQL DBS performance, ultimately boosting system responsiveness and to ensure ongoing system health.

. ● MeƟculously manage SQL server Logins, Database users, and roles, acƟvely contribuƟng to daily user maintenance tasks.

● Diligently provide weekly project status updates to the Project Manager, fostering transparent communication, and ensuring project alignment.

● Write and debug Stored Procedures, DDL Triggers, and funcƟons as per client requirements.

● Orchestrate seamless installaƟons, upgrades, and patch management for databases, streamlining backup, recovery, and maintenance workflows.

● Engineer and manage high availability (HA) and disaster recovery (DR) soluƟons, including Clustering, Always On, Log Shipping, Mirroring, and Replication. And periodically test, and execute SQL Server DR strategies, safeguarding data continuity and system stability.

● Exhibit mastery in performance tuning and opƟmizaƟon (PTO), proacƟvely idenƟfying and addressing challenges in existing and new databases.

● Demonstrate familiarity with PostgreSQL, MySQL, SSIS, SSRS, and SSAS, enhancing versaƟlity and adaptability.

Daniel Asfaw

Database Administrator

+1-240-***-****

ad23qi@r.postjobfree.com

www.linkedin.com/in/daniaw1221

SQL Database Administrator

Allstate

Feb 2018 to Oct 2021 Hudson -OH

● Spearheaded the conceptualizaƟon and realizaƟon of intricate database applicaƟons uƟlizing SQL Server 2012, leading to remarkable advancements in performance and scalability.

● Proficiently executed data modeling and schema design to align with business imperaƟves and optimize query efficiency.

● Devised and executed comprehensive ETL strategies leveraging SSIS, effecƟvely extracƟng, transforming, and loading data from diverse sources into the data warehouse.

● Championed the implementaƟon of robust security protocols, safeguarding sensiƟve informaƟon through role-based access control, dynamic data masking and encryption measures.

● Drove performance enhancement iniƟaƟves by conducƟng meƟculous tuning and opƟmizaƟon exercises, resulting in a noteworthy reduction in query execution time.

● Produced insighƞul reports employing Power BI and Tableau, furnishing invaluable business insights into metrics and trends.

● Provided mentorship and technical guidance to junior developers, ensuring adherence to industry best practices and development standards.

● Elevated query performance through diligent SQL tuning and opƟmizaƟon strategies, achieving an impressive efficiency improvement.

● Skillfully designed and maintained ETL workflows employing SSIS to extract, transform, and seamlessly load data from diverse origins.

● Collaborated seamlessly with cross-functional teams to comprehensively gather business requirements and ensure that database solutions intricately aligned with business objectives.

● Demonstrated experƟse in craŌing and implemenƟng reports through SSRS, enabling data- driven business decision-making.

● Diligently executed rouƟne maintenance and backup protocols, assuring the steadfast integrity and availability of critical databases.

● Enabled TDE to protect data at rest.

Education

BSc Degree in Civil Engineering, 2004, Jimma University, Ethiopia MS SQL Server, 2015, New Horizons Techno Brain Training, Ethiopia. Tools

Tools: SSMS, Profiler, Data Studio, SQL Server Migration Assistant (SSMA), Azure Database Migration Service (ADMS), Red Gate, Spotlight, Idera, Solarwinds, IntelliJ, MySQL, SSDT, Power BI Languages: T-SQL, JSON, Java

Operating Systems: Windows 7, 8, 10, 10 Pro, 11, Windows Server 2019, 2012 R2, 2008 R2

Contact this candidate