Database Administrator Project Manager

Rahwa Asmelash

**************@*****.***

MS-SQL Server DBA

SUMMARY

●A Microsoft SQL server (DBA) with 6+ years IT experience: designing, coding, testing and supporting next-generation database solutions in SQL Server environment.

●Possess strong communication and problem-solving skills developed through a variety of projects. Offer proven ability in teamwork and proactive system support.

●Experience in Installing, configuring, administration and Maintenance of mission critical client databases in SQL server 2016, 2017, 2019 and 2022 versions.

●Extensive Experience in Upgrading SQL Server (In place and Side by side Upgrades) based on application compatibility and fixing the orphan users.

●Experience in implementing SQL Server security and Object permissions like creation of users, granting permissions and assigning roles to users.

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

●Good experience implementing and troubleshooting High Availability of database servers using Replication, Log Shipping, Database Mirroring, failover clustering and Always ON AG.

●Strong experience on understanding and creating the server level and database level roles as per business requirement.

●Experience in Configuring and Scheduling SQL Server agent Jobs, Alerts, operators, Maintenance plans, Database Mail Configuration, facets and Transparent Data Encryption.

●Extensive experience with Monitoring, Performance Tuning and analyzing DB performance issues.

●Strong experience on designing and implementing the backup and disaster recovery strategies as per RPO and RTO values.

●Experience on configuring and maintaining Full backup, Transactional log backup, Differential backup and creating the maintenance plans for index rebuild, index reorganize based on fragmentation.

●Strong experience on identifying and troubleshooting database health, integrity checks and fixing them.

●Excellent T-SQL Programming skills in creating stored procedures, executing, debugging, problem analysis & troubleshooting, functions, triggers, and creating solutions. And SSIS

●Excellent in Created complex stored procedures to generate reports using SSRS and Power BI

Core technical skills

Windows 2012-2019, SQL Server 2012-2019, T-SQL, AWS-RDS, AWS-EC2, IDERA SQL diagnostic Manager, SQL safe 6.0, Red-gate SQL Compare 10 and Data Compare 10, Data Edo, ERWIN,

SSDT, Azure, SSIS(ETL), SSRS, SSMS, DTA, JIRA, RAID, MYSQL, LightSpeed, Power BI

Education

BSc in Engineering from Arbaminch University

Postgraduate Diploma (MSc) in (IDPM) International Diploma in Project Management from University of Cambridge internationals and Zemen Institute (Addis Ababa, Ethiopia)

BSc in Georgia state university

WORK EXPERIENCES

CHAMBER IT INC GA, US Jun 2021– present

SQL Server Database Administrator

Responsibilities:

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

●Upgrading SQL server 2008 to SQL Server 2012, SQL Server2014, SQL Server 2016 and SQL Server 2019

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

●Experience in setting up database transactional replication for reporting servers, Using Backup and restore methods.

●Expert in Database refresh from prod to lower environment as per the business requirements. Automated quarterly/monthly database refresh.

●Managed and involved in SQL performance Tuning, identifying locking and blocking issues using Native and Third-party tools to enhance and boost performance of SQL Dbs.

●Managed and Implemented Industries best SQL server maintenance plan and created schedule for all environments.

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

●Created Database Maintenance jobs to perform full & transaction log Backups and scheduled them with the SQL Server agent job scheduler.

●Monitor database growth activities & Troubleshoot Transaction Log Issue.

●Created and configured mirroring for Disaster Recovery

●Providing weekly status information on all projects to Project Manager

●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

●Reporting on a weekly basis to the project manager.

●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.

●Used log shipping for synchronization of databases.

●Created new tables, stored procedures and triggers using T-SQL.

●Refactored and Fine-tuned the queries and Stored procedures in T-SQL.

●Performing DB backups, DB refresh, DB restores, clean-up, statistics update.

●Installed and configured MS SQL Servers in Virtual Environments using VMWARE.

●Analyze the Execution plans and recommend/implement a better execution plan.

Tools & Technologies: Windows 2012 to 2019, SQL Server 2012-2019, AWS-RDS, AWS-EC2, IDERA SQL diagnostic Manager, SQL safe 6.0, Red-gate SQL Compare 10 and Data Compare 10, Visio 2010, Data Edo, ERWIN.

Lowes Companies Inc GA, US

SQL Server Database Administrator JAN 2019-MAY 2021

Responsibilities:

●Installed and configured various editions and versions of SQL Server in standalone, and clustered nodes

●Installed, and Configured SQL Server Fail-Over Cluster for SQL Server 2016/2017/2019.

●Applied service packs, hotfixes and cumulative updates

●Upgraded SQL Server 2008 and 2008 R2 Database to SQL Server 2016,2017 and 2019.

●Created and maintained logins, Users, Roles and managed security of the database.

●Implemented Disaster recovery plan by performing routine backups and restore

●Taking Full, Differential and Transactional log backups and setting automated jobs.

●Migrated data using Import/Export, bulk, backup-restore, DTS, SSIS, Detach/Attach

●Performed data Extracting, Transforming and Loading (ETL) from different data sources.

●Rebuilding /reorganize indexes to reduce fragmentation and enhance SQL server performance

●Created triggers, views and stored procedures,

●Implemented database Maintenance plans, scheduled automated SQL Server jobs, Created Alerts, Operators, Notifications and configured database Mail.

●Hands on experience monitoring and performance tuning using Tuning Advisor, SQL server Profiler, Activity monitor, Windows performance monitor, DBCC, DMVs, Stored procedures

●Working with Resource Governor to control and allocate CPU and memory resources depending on the priority of applications.

●Configured and Managed Database High Availability: Replication, Database Mirroring, Log Shipping, Failover Clustering and Always On availability group.

●Scheduled reports using SSRS to generate daily, weekly, monthly, quarterly reports

●Worked in a team with integrated Developers, CAB (Change Approval Board) and Disaster Recovery Planning team.

●Experience in contacting Microsoft and other vendors for product and technical support.

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

●Experience in Agile projects with a solid foundation in Software Development Lifecycle (SDLC).

Tools & Technologies: Windows 2012/2016, SQL Server 2012-2019, IDERA SQL diagnostic Manager, Red-gate SQL Compare 10 and Data Compare 10, Visio 2010, SSDT.

United Airlines GA, US

SQL Database Developer Feb 2016- Dec 2018

Responsibilities

Designing solution for Consolidating Different data sources

Created SSIS package to vendors in which records were loaded daily, also to other data resources such as Excel, Access, flat file and XML in order to create and maintain a centralized database.

Created complex stored procedures to generate reports using SSRS

Applying strategies for data acquisition, ODS implementation, and archive Process

Designed and built relational databases.

Worked in pulling data and deal with heterogeneous sources and optimize the data extraction and conversion process using SSIS.

Migrating Databases from SQL Server 2008 to SQL Server 2012

Created MDS/MDM for master data and also implement Data Cleansing and Data Quality.

Experience in creating Ad hoc reporting universes using Business Objects Universe Designer.

Experience in building and retrieving data using Universes, Personal data files, and creating complex ad-hoc Reports using the Business Objects suite applications.

Installed and Upgraded from SQL Server 2008 to SQL Server 2012 on Various Servers.

Implement Logging to track and create ETL dash boards to monitor the ETL Process

Creating and modifying Business Intelligence analytical reports using Tableau.

Error Handling and Auditing implemented in SSIS to track down the data discrepancies

Experience working with Share Point 2010 lists in using them as interface for users

Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.

Excellent T-SQL Programming skills in creating stored procedures, executing, debugging, problem analysis & troubleshooting, functions, triggers, and creating solutions.

Involved in Performance tuning of databases and help user in efficient reporting

Developed high level design of ETL Package in MS SQL Server 2008 for integrating data from heterogeneous sources such as Excel, CSV, Oracle, flat file and Text Format Data.

Built reports using SSRS and helped develop efficient reporting solutions and setting up subscriptions as needed for SSRS

Optimize SSIS Packages to fine tune the data loads and reduce the data load time and come up with Best Strategies in the data load process

Involved in dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.

Implementing Partitioning and Back up Strategy and security policies

Tools & Technologies: MS SQL server 2012, SSRS, SQL Profiler and T-SQL, Windows 2016 server and Visual Studio 2016 Microsoft Office, SSIS, Index Tuning Wizard, Query Analyzer, SQL profiler.

Contact this candidate