Marta Keberet

Ph :571-***-****

Sterling,Virginia 20164

Email: ad1ww4@r.postjobfree.com

Professional Summary

Accomplished and qualified IT professional with diverse and extensive on-premises and Azure cloud database administration experiences. An effective team member, including work as a Senior Microsoft SQL DBA, database design, and system administration using Microsoft SQL Server 2005,2008,2008 R2,2012,2014,2016,2017 and 2019. I am experienced in the MS-Azure Cloud environment from design to Administering Azure SQL Databases. Key strengths include: problem-solving skills, attention to detail, multitasking, and the ability to build effective business relationships, even during times of high stress deployments. Extensive project management experience and process oriented; deeply experienced in providing solutions to performance issues. Equipped with an excellent work ethic; possesses a strong sense of responsibility and teamwork with a track record of dependability. Possess excellent verbal, written and presentation skills.

MS-SQL Server Experiences

●7+ years 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 development team

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

●Experience with MSBI – SSIS, 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 2005 to MS SQL Server

2005/2008/2012/2014/2016

●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

●Verify backups and error logs on the servers and troubleshoot any failures or alert problems, and open tickets if necessary to work with technicians from other departments

●Defined and enforced database standards, policies, security and documentation

●Created Transparent Data Encryption (TDE), and Always Encryption

●Worked on data mapping and conversion; manage disk space, change control and bug fixes

●Monitored index fragmentation and performed index rebuild or reorganize at regular intervals depending on the fragmentation leve

●Prepared daily report on the job failures, backup failures and disk space

●Created and monitored Change Captured Table(CDC) and Temporal or system versioned table

●Well organized, planned, quality and result oriented with the ability to multitask, prioritize and manage time well

●Outstanding ability to analyze, develop and implement technology solutions.

●Excellent communication skills and team player; also entrusted to work independently

●Significant ability to master new concepts & applications, eager to meet new challenges and assimilate new concepts

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

●Analyzed and evaluated azure pricing, availability options, reliability and security of azure resources before and after deployment through azure adviser

●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

Education

●Bachelor of Computer Science from Jigjiga University

Technical Knowledge

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

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

●Server Operating Systems: Windows Server 2008R2/2012/2016

●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, servicenow

●Virtualization: VMware, Virtual Box, Hyper-V

●Active directory, devops, azure data factory

Work Experiences

PPG Industries, Richmond VA, October 2019 – Present

SQL Server DBA

Installed, Configured, and Maintained SQL Server 2019, 2014 and 2012 in development, test, and production environment.

Partnered with application developers to achieve flawless integration between front and back-end components using T-SQL.

Designed and implemented the robust Backup plan and disaster recovery strategies for OLTP databases.

Optimized queries performance by analyzing and identifying the cause of performance degradation and provide solution (reorganizing/rebuilding indexes, updating statistics or resolving blocks and deadlocks).

Took part in implementation and Troubleshooting High availability scenarios involving SQL server Replication, Database Mirroring, Microsoft Cluster and Always-on .

Tunned database and troubleshoot performance issues based on the reports from both built in (DMV/DMF) and third-party monitoring tools like idera sql diagnostic manager, SolarWinds PA

Regularly monitored server activity, error logs, space usage, troubleshoot any issues as needed.

Identified SQL Server performance blocks and deadlocks, parameter sniffing and implement solutions in collaboration with developers.

Monitor all aspects of the day-to-day server/DB activities, performance evaluation, and assignment to IT Projects and Production Support functions.

Carry out changes to development, QA, and production databases.

Deployed and Promoted SSIS packages throughout different environments.

Built windows servers as per company standard configuration before SQL server is loaded.

Addressing SQL Server and database issues with the ServiceNow ticketing system per their priority level to meet SLA time.

Performed both in-place and side by side upgrades from SQL 2012 servers to SQL server versions that applications connecting databases are compatible to.

Installed\configured SSMA for oracle and Migrated oracle server schemas to MS SQL server for an ongoing project to move oracle database to MSSQL Server and compiled company documentation for future use.

SQL Databases on Azure.

United Airlines Chicago IL, June 2017 – September 2019

SQL Server DBA

●Created and updated databases, tables, stored procedures, triggers, functions, and views.

●Configured, administered, and troubleshoot multiple databases in production and staging environments in clustered and standalone environments.

●Prepared documentation for disaster recovery plan.

●Involved in installing failover clustering on multiple nodes.

●Implemented database mirroring and log shipping

●Planned backup strategies, scheduled backups, and performed restore operations.

●Managed security of SQL server databases by creating logins, creating database users, creating roles, assigning proper permissions, creating server and database audits.

●Worked on creating, reorganizing, and rebuilding indexes.

●Worked on database space management, performance monitoring, and alert management.

●Planned the location of files and increased the size and number of files.

●Performed tasks of query optimization, troubleshooting client/server connectivity issues, and performance tuning.

●Monitored and troubleshoot database and server performance at system-wide scale and effectively identify network, databases, Memory, CPU, Disk Space, and I/O related bottlenecks.

●Transferred data between several servers using BCP and DTS.

●Generated reports extensively using SSRS.

●Providing resolution to assigned tickets (JIRA, Team Track and Service Desk) as per their severity and meet the deadline before SLA is due.

Harborview Medical Center, Seattle WA Sept 2016 – May 2017 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-Procedure Assisted Database

Developers to optimize SQL queries and Stored Procedures.

●ETL Tools: Used ETL tools like DTS, SSIS, 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.

Contact this candidate