Abel Yacob
Aurora,Colorado
Summary
SQL Developer with over 7 years of progressive experience in Ms SQL , databases and application programming. Dedicated to building customized technical solutions in alignment with operational needs and objectives. Critical thinker, analyst and problem solver known for continuous delivery of quality products across diverse business environments.
Overview
9
9
years of professional experience
Work History
SENIOR SQL SERVER DATABASE ADMINISTRATOR
JPMorgan Chase & Co
03.2021 - Current
- Installation, configuration and apply patches of SQL server 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019 versions.
- Migrated the databases and objects from SQL server 2008 to 2012 and 2012 to 2016, 2016 to 2019.
- Implemented database security which includes creating logins, users, and roles, as well as assigning permissions according to the principle of least privilege.
- Develop automated tasks for daily, weekly and monthly database maintenance such as database backup, database integrity verification.
- Designed and created databases objects (tables, views, stored procedure, function and trigger)
- Implemented procedures, packages, triggers, and different Joins and indexes in to retrieve the data base using T_SQL .
- Automated database reorganization procedures, database alerts and monitoring scripts.
- Performance tuning on a daily basis for preventing issues and providing capacity planning.
- Created and managed SQL Reports and SSIS packages.
- Participated in 24/7 on–call rotation and respond to critical database incidents.
- Collaborating with developers, system administrators, and other stakeholders to design and implement database solutions that meet business requirements.
- Providing technical support and training to end-users on database usage and best practices.
SQL SERVER DATABASE ADMINISTRATOR
Verizon
01.2018 - 02.2021
- Installed MS SQL Server 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019,2022 updating with latest service packs and security patches.
- Experience in database migration, integration, and version upgrade.
- Proposed possible improvement areas; developed, and recommended policies as well as new methods, and effective procedures; mentored IT staff.
- Written different T-SQL scripts for automated execution of the tasks, review T-SQL code to verify it meet standards for both performance and error handling.
- Evaluate CPU, Disk I/O and memory related bottlenecks, blocks and deadlocks slow running queries.
- Performing DB security, creating user roles, and assigning permission to them.
- Provided Database support and troubleshooting of issues like connectivity, memory issues, query performance, and server related job failures.
- Experience on configuring and maintaining automation strategies like full backup, transactional log backup, differential backup and creating the maintenance plans for index optimization and index maintenance like index rebuild, index reorganize based on fragmentation.
- Experience on configuring and maintaining automation strategies like full backup, transactional log backup, differential backup and creating the maintenance plans using Ola Hallengren store procedure.
- Experience in creating and collaborating with developers in index, views, complex stored procedures, appropriate user defined functions (UDF).
- Actively participated in interaction with users, team lead, other DBAs, and technical manager to fully understand the requirements of the system.
Assistant Database Administrator
General Motors Co
11.2015 - 12.2017
- Implemented database security which includes creating logins, users, and roles, as well as assigning permissions according to the principle of least privilege.
- Develop automated tasks for daily, weekly and monthly database maintenance such as database backup, database integrity verification.
- Designed and created databases objects (tables, views, stored procedure, function and trigger)
- Implemented procedures, packages, triggers, and different Joins and indexes in to retrieve the data base using T_SQL .
- Extensively worked on Backup procedures, error handling and query optimizations
- Scheduling the DBCC commands to run daily, weekly basis.
- Setup and managed backups, restores, and refreshed DBs as required by using third party tool such as Redgate.
- Configured and managed High Availability solutions (Clustering, database Mirroring, Log shipping, Replication and Always on AG).
Education
Bachelor of Science - Management
Mekelle University
Ethiopia07.2011
Skills
- MS-SQL-Server 2008/2008R2/2012/2014/2016/2017/2019/2022
- Microsoft Azure
- SQL Server Management Studio
- SQL Server Data Tools
- SQL Profiler
- Database Engine
- SSIS
- SSRS
- Import/Export wizard
- T-SQL
- Redgate
- Golden Gate
Timeline
SENIOR SQL SERVER DATABASE ADMINISTRATOR
JPMorgan Chase & Co
03.2021 - Current
SQL SERVER DATABASE ADMINISTRATOR
Verizon
01.2018 - 02.2021
Assistant Database Administrator
General Motors Co
11.2015 - 12.2017
Bachelor of Science - Management
Mekelle University