Sql Server Database

Fasil Kuma

• Silver Spring, Maryland • Email: *********@*****.*** • 443-***-****

• Linkedin- www.linkedin.com/in/fasil-kuma.

PROFESSIONAL SUMMARY

Over a decade of progressive work experience of SQL Database analysis, design, development, test, deployment and Administration on SQL Server 2005/2008/2012/2014/2016/2017/2019.

Involved in data modeling, designing and building relational databases with the development team.

Experienced with AlwaysOn Availability groups, and Windows and SQL Server Failover Clustering installation and Configuration.

Experience with MSBI – SSIS, Power BI, SSRS and SSAS 2008R2/2012/2014/2016.

Diagnosed, monitored, optimized and troubleshoot problems using tools such as SQL Profiler, Database Tuning Advisor, SQL Query Analyzer, extended events, windows performance monitor, task manager and, work with vendors and developers as needed to resolve issues.

Database migration experience from MS SQL Server 2008R2 to MS SQL Server 2012/2014/2016/2017/2019.

Experienced in writing queries on stored procedures, triggers and functions.

Extensive experience in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, log shipping, data integration and synchronization.

Create and configure Azure subscriptions, resources groups and deploy resources such as Azure SQL Databases, Virtual Machines, Azure Storages, Virtual Networks, and Azure Key Vaults.

Configured IaaS (Infrastructure as a service), PaaS (Platform as a service), SaaS (Software as a service) with respect to SQL Server.

Used Azure Migration tools to Migrate on-premises SQL Databases to Azure.

WORK EXPERIENCE AND ACHIEVEMENTS

Provider Partners (Linthicum Heights, MD) Nov 2023 - Present

Sr. SQL Database Administrator

Deployment, administration, and operational support of production, development, and test environments utilizing proper change management and other best practices using ticketing tools.

Implemented data replication solutions like transactional replication and merge replication to ensure data consistency.

Automated migration and replication processes using PowerShell.

Leveraged monitoring tools like SQL Server Profiler and Performance Monitor to proactively identify and troubleshoot performance issues in production environments.

Utilized Azure SQL Database to implement a scalable and cost-effective solution for managing EHR data for PPHP's long-term care facilities.

Optimized query performance and resource utilization by developing stored procedures and functions, leveraging indexing strategies,

Implemented Transparent Data Encryption (TDE) at rest and in transit to protect sensitive patient information.

Managed High Availability (HA) solutions like clustering and log shipping to guarantee uninterrupted data access.

As SQL Server DBA assumed personal responsibility for all corporate SQL Servers both on Windows Azure (SaaS) and SQL Servers on Virtual Machines (PaaS) using MS SQL Servers 2016/2014

Automated SQL database backups, update statistics and index rebuild using PowerShell RunBooks on Azure Automation Services

Minimized disruption to operations through meticulous planning, testing, and rollback strategies.

Main street DBAs (Cincinnati, OH) Sep 2022 - Nov 2023

MS SQL Database Administrator

Provide operational database management tasks for select customers, ensuring database availability, performance, and security.

Perform day-to-day database maintenance duties and implement proactive measures to maximize database availability and performance.

Utilize excellent understanding of SQL to perform performance monitoring, analysis, and tuning of relational databases, including the use of T-SQL, profiler, tuning advisor, indexes, statistics, and query plan analysis.

Develop triggers, stored procedures, and complex join statements to support database functionality and data manipulation.

Manage data migration to/from other sources using DTS/SSIS/SSRS, and deploy/maintain packages and jobs.

Engineer disaster recovery (DR) and backup solutions, including full, differential, and transactional backup, backup mirroring, and automated maintenance jobs with alerting.

Plan and implement High Availability and Disaster Recovery (HADR) environments, ensuring data availability and resilience.

Perform database administration tasks using T-SQL, including capacity planning, installation, upgrading, configuration, patching, and maintenance.

Implement and support housekeeping procedures such as backups, integrity checking, and documentation production.

Set up and support database clustering, mirroring, replication, and log shipping in Windows environments.

Demonstrated knowledge of table partitioning and archiving mechanisms to optimize database performance and storage efficiency.

Union Bank, Seattle, WA (Infosys) July 2018 - Aug 2022

SQL Server DBA

Participate in an on-call support rotation and provide non-standard work hour support.

Restores functionality to database processes that have failed, documents resolutions, and creates and maintains troubleshooting documentation.

Employs general SQL, Microsoft T-SQL, stored procedures, Date Transformation Services (DTS) scripts, and SQL Server Integration Services (SSIS) to manage database systems and to automate data migration and processing.

Designs, develops and implements database tables, views, triggers, indexes, and stored procedures to ensure data integrity for custom applications.

Designs, develops, tests, documents, and implements scripts to automate data importing, exporting, reporting, and analysis to ensure data confidentiality, availability and integrity

Installing, configuring, administering and securing production and non-production servers (clustered and non-clustered).

Upgrading SQL server 2012 to SQL Server 2016 and 2017

Experience in implementing windows cluster across multiple availability zones and Implemented SQL Server 2016 Always On availability group in AWS.

Managed SQL server Logins, Database users & roles and involved in Daily User Maintenance.

Monitor database growth activities & Troubleshoot Transaction Log Issue.

Created and configured mirroring for Disaster Recovery

Wrote and debugged Stored Procedures and (DDL /DML) Triggers, Functions as per client requirements.

Logical and Physical design of database for projects on basis of user requirements using ERWIN

Extensively worked on troubleshooting and fine-tuning of databases for optimal performance.

Worked with Performance Tuning/Query tuning, execution plans, trace flags and SQL Profiler

Installation of Service packs to all environments.

HCA Healthcare (Nashville, TN) Dec 2013 – May 2018

SQL Server DBA

Database High Availability: Installed, Configured and Maintained AlwaysOn High Availability Group using SQL Server 2012. Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2008. Installed, Configured and Maintained Database Mirroring using automatic fail-over option in SQL Server 2008. Configured Log Shipping as Standby database from Production database for Reporting purposes. Configured and Maintained Replications.

Database Upgrade: SQL Server SQL Server 2005 and 2008 R2 to SQL Server 2012.

Database Migration: Migrated MS Access 2003/2005/2008 R2 databases into MS SQL Server. Migrated Oracle 10g, MySQL into MS SQL Server 2012.

Data Modeling: Worked on more than 10 data modeling projects and generated E-R Diagrams. Data modeling tools used using SQL Server Data Diagram.

Database Monitoring/Performance Tuning: Strong on database Monitoring and Performance tuning. Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification. Monitor SQL Server Error Log, space usage.

Database Programming: Wrote T-SQL, Trigger, and Stored-Procedures. Assisted Database Developers to optimize SQL queries and Stored Procedures.

ETL Tools: Used ETL tools like DTS, SSIS, and Import/Export, BCP (Bulk Copy), to import & export data from flat files, and excel to MS SQL Server databases.

Export & Import: Data from Oracle and SQL Server Excel and setup and performed ETL data load from Oracle and other flat files like text, Excel, and CSV files

Backup/Recovery: Proficient in Database Backup and Disaster Recovery. Experienced with Point-in-Time Recovery. Restored Database from backup.

Report Development: Installed, Configured, and administered SQL Server Reporting Services. Developed Reports using SSRS. Deployed Reports. Developed Ad-hoc Reports using Report Builder 3.0, 2.0.

Used DBCC to check database conditions, Rebuilding indexes and other database Maintenance purposes as well.

TECHNICAL SKILLS

Programming and Scripting Languages: T-SQL, Windows CMD.

RDBMS: MS- SQL Server (2005/2008/2012/2014/2016/2017/2019/2022).

Server Operating Systems: Windows Server 2008R2/2012/2016/2019/2022.

Desktop Operating Systems: Windows 7/8/10/11.

Office Software: Microsoft Office.

Development Environment: SQL Server Management Studio, SQL Server Data Tools (SSIS, SSRS, SSAS), Microsoft Visual Studio.

Performance Tools: Database Engine Tuning Advisor, SQL Profiler, Performance Monitor 3rd party tools: Idera, RedGate, SQL Sentry, Servicenow.

Virtualization: VMware, Virtual Box, Hyper-V.

Active directory, DevOps, azure data factory.

EDUCATION

Bachelor BSc, 2011. (Haramaya University)

Postgraduate in Cloud Computing Caltech (California Institute of Technology) 2024.

CERTIFICATIONS

Microsoft Certified: Azure Database Administrator Associate. DP-300

AWS Certified Cloud Practitioner

Microsoft Certified Solutions Associate: SQL 2016 Database Administration.

TS: SQL Server 2008, Implementation and Maintenance (MCTS).

Microsoft Azure Fundamentals AZ-900.

WORK AUTHORIZATION

Authorized to work for any employer

Contact this candidate