Kassahun Workie

• Providing SQL Server implementation changes requested from application teams.
• Responsible for installing, configuring, and maintaining as per supported LOB applications.
• Writing and improving SQL Server T-SQL queries.
• Created necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.
• Responsible for providing SQL Server problem resolution and 24x7 production support and server outages.
• Responsible for disaster recovery and high availability solutions and large scale database migrations from SQL server 2012/2014 to SQL server 2019.
• Created and migrated partially contained databases within AlwaysOn Availability Groups.
• Created automation of day to day operations, critical SQL server alerts and repetitive tasks.
• Monitored the health and performance of SQL, server instances and home grown applications using Extended Events, SQL server Profiler, PerfMon and other third party tools.
• Tested newly built servers for performance impact with DB load simulators.
• Setup and maintained Log Shipping between various environments.
• Development/Test/Production QA which included documentation of processes, creation of test scenarios and execution of tests, via T-SQL scripts, to ensure UI standards met the required specifications.
• Created necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.
• Operated and oversaw database and log backups and restoration, planning backup strategies, and scheduling.
• Backed up master & system databases and restoring them when necessary.
• Optimized the Indexes, adding/deleting them when necessary for better performance.
• Verified backups and error logs on the servers and troubleshoot any failures or alert problems, and open trouble tickets if necessary to work with technicians from other departments.
• Responsible for Installing, configuring and maintaining SQL failover clustering for production environments.
• Worked with installation, configuration and creation of SSRS.
• Deciding whether clustering, log shipping, mirroring, replication, etc are the right fit to solve a business problem.
• On-call troubleshooting for SQL Server service outages.
• Responsible for securing SQL Server, user management, and taking care of permissions and roles.

Environment: Microsoft SQL Server 2019/2017/2014/2012 Enterprise and Standard Editions, Clustering, Always On, Mirroring, Replication, SQL Server Management Studio, SQL Profiler, Performance Monitor, SSIS, SSRS.

Responsibilities:

• Installed and configured SQLServer2014/2017 with backup jobs, database mail and configuration options.
• Upgraded SQL Servers with latest service packs.
• Migrated SQL Server databases from SQL Server 2012 to SQL Server 2014/2017.
• Created, administered & maintained SQL Server Databases on Production, Test and Staging for various groups and ensured the availability of the database Servers.
• Configured and maintained transnational replication for flow of data from QA and Dev. Server to the replica servers.
• Monitored data activities like database status, logs, space utilization, locks and long transactions.
• Implemented SQL standards in writing stored procedures, Triggers, Views, SQL functions.
• Involved in resolving deadlock and blocking issues for concurrent users. · Worked with developers to optimize the code if required to minimize the duration and look if the indexes were used appropriately.
• Provided appropriate access to users except system databases owners. · Refreshed databases for pre or post data loads activities.
• Supported SQL server developers working on different projects with various requests.
• Converted and redesigned existing DTS packages to SSIS packages.
• Developed SSIS packages to import and export data from existing systems to upgraded system.
• Used database utility programs and 3rd party utilities to monitor database performance, such as Blocking, expensive queries, Memory utilization.Environment: MS SQL Server 2017/2014/2012, T-SQL, Lite Speed, SQL Profiler, Log Shipping, Replication, Mirroring, Clustering.

• Set up new desktop systems and configured laptops for incoming employees, loading required software and server permissions
• Conducted hands-on technology training programs to assist use of newly implemented hardware and software
• Monitored IT use to maintain compliance with established processes, policies, and guidelines
• Delivered local and remote Tier 1 IT support for hardware and software to company personnel
• Documented repair processes and helped streamline procedures for future technical support actions
• Administering Microsoft Windows 2012/2016 Environments, Active Directory, DNS, DHCP,
• Created User accounts by using Active Directory Users and Computers
• Created and managed organizational units
• Created and implemented password policies.