Melesse Semegne

Phone#: 310-***-****

Location: Silver Spring, MD

Email:mailto:adblba@r.postjobfree.com adblba@r.postjobfree.com

PROFESSIONAL SUMMARY:

I am a certified Data Base Administrator (DBA) with more than 8 years of experience in Microsoft SQL Database Administration, designing, developing, testing, Server monitoring and configuration, Data replication, index maintenance, implementing security, backups/restores, query optimization, Data Migration to cloud, scheduling jobs/tasks, SSIS and SSRS, HA/DR planning and implementation and working in complex enterprise domains including:

•Performance tuning and optimization

•Implementing robust server and database level security as well as encryption solutions

•Performing database reorganization, extent (space) management and rebuilding indexes based on evaluation,

•Optimized poorly performing stored procedures, views and ad-hoc queries.

•Designing and tuning highly available and high-volume transactional databases.

•Migrating data from various sources using SSIS/ETL, BCP, Import-Export wizard, and T-SQL.

•Configuration and management of HA/DR solutions such as Always On-AG, Failover Clustering, Database Mirroring, Log-Shipping, and Transactional Replication.

•Creating reports using Visual Studio and deploying it to SSRS

•Working on AWS Data platform

•Migrating data to AWS or Microsoft Azure

•Developing, deploying and managing SSIS packages

•Programing databases using stored procedures, views, user-defined functions and create packages using SQL Server Integration Service and develop queries

•Monitoring and optimizing the performance and configuration of databases.

•Configuration and management of HA/DR solutions such as Always On-AG, Failover Clustering, Database Mirroring, Log-Shipping, and Transactional Replication.

•Proactively identifying and fixing potential issues.

•Maintaining database artifacts, integrity and security of databases.

•Working in Microsoft SQL Server Management Studio (SSMS), SQL Server Agent, SQL Server Profiler and Business Intelligence (BI).

•Ensuring the compatibility of hardware and software,

•Provides technical expert /advice/ for IT staff (e.g., network specialists, programmers, systems analysts and database specialists), in the resolution of difficult IT issues.

•Configuring automated jobs and alerts using SQL Server Agent and Database Mail.

•Addressing SQL Server and databases issues with ticketing system.

•Performance tuning and optimization using Perfmon, DMV/DMFs, SQL Server profiler trace, and database engine tuning advisor.

•Performance monitoring using native tools and third-party products like SQLdm and PRTG.

•Ensuring SQL Server Security by creating user logins, assigning roles and least-privilege permissions, certificate-based security authentication, as well as strict monitoring of server and database level object changes through regular audits.

•Implementing Transparent Data Encryption, Column Level Encryption, and Always Encrypted.

•Developing server architectures for High Availability (HA) and Disaster Recovery (DR).

•Installation, configuration, upgrade, patching, and management of SQL Server 2016, 2014, 2012, 2008/R2, hosted by Windows 2016, 2012/R2, 2008/R2 in physical and virtual environments.

•In-house and side-by-side SQL Server database migrations.

•Database administration in production, test, and development systems.

•Designing scalable enterprise level database architecture using agile methodologies.

•Documentation of server and database level configuration settings as well as critical jobs.

•Development of database design and code review guidelines.

•Patching service packs and latest security updates.

•Running DBCC commands for database consistency checks.

•Implementing and documenting robust disaster recovery strategy.

•Extensive use of SSMS, SQL Server Configuration Manager, and Maintenance Plan Tool.

•Working with Windows Server 2016, 2012/R2, 2008/R2, 2003; SAN; SQL Safe, PRTG, LiteSpeed, SQLdm, KeePass, Agent Ransack, Dezign for databases; Hyper-V, TFS, dacpac, database solution, Visual Studio 2013, Visio 2010; CMD, SQLCMD, PowerShell-ISE.

•Excellent interpersonal communication; analytical and leadership skills; highly proactive.

Professional Experience

Exelon Corporation, Baltimore, MD

January 2016 – Present

SQL Database Administrator (remote and onsite)

Responsibilities:

•Implementing robust server and database level security as well as encryption solutions

•Performance tuning and optimization

•Database schema design and maintenance

•Designing and tuning highly available and high-volume transactional databases.

•Upgrading SQL Server from lower version to higher version

•Creating reports using Visual Studio and deploying it to SSRS

•Configured and managed transactional replication, log-shipping, database mirroring, and SQL Server Failover Cluster solutions.

•Troubleshot issues with failover cluster, replication, database connectivity, and job failures.

•Developed and instituted a troubleshooting and recovery procedures for transactional-replication, database-mirroring, log-shipping and failover clustering solutions.

•Migrating data from various sources using BCP, Import-Export wizard, SSIS/ETL, and T-SQL.

•Developing, deploying and managing SSIS packages

•Migrating data to AWS or Microsoft Azure

•Programing databases using stored procedures, views, user-defined functions and create packages using SQL Server Integration Service and develop queries

•Working in data replication and data migration tools.

•Resolved space issues, long running queries, blocking, and tempdb space issues.

•Collected baseline performance metrics of database servers by running Perfmon.

•Investigated and addressed sudden SQL Server Service shutdowns and node failovers.

•Managed index fragmentations and parallelism problems.

•HA/DR planning and implementation

•Took regular database full, differential and log-backs.

•Refreshed lower database environments on on-demand.

•Developed Standard Operating Procedures for mission critical databases recovery.

•Proactively prevented occurrences of avoidable incidents and ensured a highly stable production server environment with 24/7/365 standby support.

•Optimized poorly performing stored procedures, views and ad-hoc queries.

•Extensively used DMVs, SQL profiler trace, execution plans, query modification, and indexing mechanisms for performance tuning and optimization.

•Configured Always On-AG in Virtual environment using SQL Server 2016.

•Installed, configured, and/or administered SQL Servers 2008R2/2014 in Operational, Offsite/DR, Test, and Development systems hosted by Windows 2008R2/2012 in physical and Virtual environments.

•Working on SSRS and SSIS

•Conducted daily system health checks and report status to immediate supervisor.

•Reviewed T-SQL codes before deployment.

•Successfully migrated databases from SQL Server 2008R2 to SQL Server 2014.

•Documented and regularly updated server and database level configuration settings.

•Instituted a database auditing scheme for critical database tables.

•Applied cumulative updates and service packs to SQL servers.

•Setup maintenance jobs for DBCC checks, index rebuild/reorganize, and statistic updates.

•Developed and deployed a report for visual display using SSRS.

Capital One Bank, Falls Church, VA Nov. 2013 - Dec. 2015

Database Administrator

Responsibilities:

•Maintaining database artifacts, integrity and security of databases.

Database migrations, including upgrades from SQL Server 2008 to SQL Server 2012

•Upgrading from log shipping/mirroring to always on availability groups

•Performing database reorganization, extent (space) management and rebuilding indexes based on evaluation

•Implementing robust server and database level security as well as encryption solutions

•Performance tuning and optimization

•Working on AWS.

•Developing, deploying and managing SSIS packages

•Proactively identifying and fixing potential issues;

•Configured server and database level audits for mission-critical databases.

•Extensively participated with database developers in database design and development.

•Developed stored procedures, functions, views and ad-hoc T-SQL queries.

•Done extensive SQL code reviews and provided constructive feedback to developers.

•Applied Service Packs to different versions of SQL servers.

•On-demand refreshed lower environments with production databases.

•Routinely monitored and troubleshot performance issues using SQL Server Diagnostic Manger.

•Often used SQL server log, error log, windows event viewer for better understanding of issues.

•Managed very large sized transactional and reporting databases.

•Regularly fixed job failure issues, deadlocks, and other performance bottlenecks.

•Administered SQL Server 2000, 2008R2, 2012 hosted by Windows 2003/2008R2/2012.

•Managed an HA/DR environment including AlwaysOn-AG, failover clustering, Mirroring, and log-shipping.

•Successfully migrated SQL Server 2000 databases to SQL Server 2012.

•Developed a detailed Disaster Recovery strategy for critical databases.

•Extensively performed performance tuning using SQL Server profiler, DMV/DMFs, query execution plan, perfmon and database engine tuning advisor.

•Configured Database-Mail for alert system.

•Created master data table and designed a master data repository database

•Extensively optimized stored procedures called by SQL Server jobs.

•Developed and deployed SSIS/ETL packages.

•Resolved space issues, long running queries, blocking, and tempdb space issues.

•Automated DBCC checks, online index rebuild/reorganize, job alerts, failed logins alerts, etc., as well as database backups, backup verifications, and monitoring database and system health.

•Engaged in routine DBA tasks including performance monitoring, alerts follow-up, addressing database permissions and connectivity issues.

•Took regular database full, differential, and log-backs.

•Recovered database to the point of failure after corruption.

•Handled tempdb and log file space issues.

•Managed index fragmentation and parallelism problems.

•Refreshed lower database environments on an on-demand basis.

•Developed and deployed T-SQL stored procedures, views, triggers, indexes.

•Provided 24/7/365 standby support.

Commercial Bank, Addis Ababa, Ethiopia

October 2010 – March 2013

Jr. Database Administrator

Responsibilities:

•Refreshed lower database environments on on-demand.

•Installed, configured and managed MS SQL server 2005.

•Patched service packs on SQL server 2005.

•Performance tuning and optimization

•Configured and maintained log-shipping and database mirroring as HA/DR solutions.

•Worked with database developers in database design, development, and deployment.

•Created and managed SQL logins and granted permissions to database users.

•Created indexes, views, stored procedures, and triggers.

•Monitored and managed use of disk space, memory, and CPU.

•Developed ad-hoc T-SQL queries, views, and stored procedures.

•Setup maintenance jobs for DBCC checks, index rebuild/reorganize and statistic updates.

•Implemented backup plan and disaster recovery strategy.

•Monitored and enhanced transactions performance using execution plans and index tuning.

•Configured Database-Mail for alert system.

•Consistently addressed deadlocking and blocking issues.

•Migrated data from excel and flat files to MS SQL server 2008 using import-export wizard.

•Created jobs for nightly backup of the database.

Bahirdar University, Bahirdar, Ethiopia

October 2006 – Sep. 2010

System Administrator

Responsibilities:

•Maintains and supports the integrity of the operating system environment and various computer systems.

•Created jobs for nightly backup of the database.

•Performs systems maintenance tasks, such as system back-up, recovery and file maintenance.

•Provide technical support for both hardware and software issues our users encounter

•Manage the configuration and operation of client-based computer operating systems

•Monitor the system daily and respond immediately to security or usability concerns

•Administers, installs and troubleshoots a variety of operating systems.

Achievements

•Documented Server and database level configuration setting info

•Developed database design and code review manual

•Developed DR Procedures for operational databases

•Developed troubleshooting manual

•Completed 2 database design and data migration

Additional Work experiences

Adjunct Professor in Different Universities and Colleges

Trinity Washington University 2018

Morgan State University 2016 and 2017

Marymount University 2017

American College of Commerce and Technology (2014-2017)

Addis Ababa University (2006-2013)

Researcher

Addis Ababa University

Establishing philosophical assumptions and focus problem, deciding on an appropriate research paradigm and methodology with specific purpose, designing a research plan and collecting sufficient data, data analysis and interpretation, which precedes reporting of research. Data analysis is, therefore, a process that involves examining, and molding collected data for interpretation to discover relevant information, draw or propose conclusions and support decision-making to solve a research problem. This involves interpreting data to answer research questions and making research findings be ready for dissemination

Education

Master’s Degree (MA) - 07/2012, Addis Ababa University

Equivalent to MA from an accredited institution in US. Evaluation available upon request.

Professional Certification and Trainings

• Designing Database Solutions for SQL Server 2012, License 290354, Lynda.Com (9/2016)

• Data Science Foundations: Fundamentals, Lynda.Com – 07/ 2016,

• Cybersecurity with Cloud Computing, Certificate No. 846E05, Lynda.Com – 8/2016

• Decision-Making Fundamentals, License 514F12, Lynda.Com – 03/2015

• Problem Solving Techniques, Lynda.Com – 09/ 2017

• Data Base Administration, Addis Ababa, Ethiopia – 02/ 2013

• Sass Essential Training, Certificate No. 03340E, Lynda.Com – 02/2016

• Project Management Fundamentals, License 8925A9, Lynda.Com – 08/2016

Skills

Strong Organizational, Technical and interpersonal Skills to manage large databases.

•T-SQL, C#, PowerShell, Windows Command-line

•

•MS Office suits: Excel, Access, PowerPoint, Word

•SPSS

•Team Foundation server

•SQL Server installation, configuration, and administration

•Database design

•Server and database security, auditing

•Database(data) migration

•SSMS, Configuration Manager

•Database maintenance, automation

•Process documentation

•Recovery from database corruption

•BULK INSERT/BCP, ETL, IE Wizard

•Database backup and restore

•Code review and deployment

•Managing Very Large Databases

•Transparent Data Encryption, Always Encrypted

•SSIS/ETL, SSRS, BIDS/SQL Data Tools

•MS SharePoint admin:

•Troubleshooting, performance tuning and optimization using DMV/DMFs, profiler trace, execution plan, extended events, code analysis

Software and Working Environment

•Windows Servers 2016, 2012,2008,2003

•MSSQL Server 2016, 2014, 2012, 2008, 2005, 2000

•RAID, SAN

•AlwaysOn-AG, failover clustering, mirroring, log-shipping, replication, WSFC

•VM-Ware

•Agent Ransack, KeePass

•Visual Studio 2015, 2013

Third-party tools

•Spot light

•SQLdm, PRTG, SQL Sentry, Litspeed, SQL dependency tracker, SQL Safe

•DeZign for Databases, Erwin

Professional Association Membership.

Member of Professional Association for SQL server (pass), since 2013

Contact this candidate