Gashaw Kibret

About Gashaw Kibret

o Over 10 years of IT experience in Relational Database Management Systems On-Prem and in the cloud; Administration, Design and Development and Support of MS SQL Server from 2005 to 2022 in Production, Test, Development Environments.o Experienced in RDBMS database performance tuning, optimization, backup and recovery, Index Tuning, Disaster Recovery Planning, Security Management.o Experienced in for DB Security such as creating logins, IAM roles, Options Groups, Parameter Groups, VPC, users, roles, and assigning permission.o Experienced in upgrading and migrating from MSSQL server 2005 to MS SQL server 2008 R2 to MS SQL Server2012, MS SQL 2014 and MSSQL 2016, MSSQL 2022o Experience in SQL server integration services (SSIS)o Installed, configured, and administered SQL Server Reporting Services (SSRS) and created SSRS Reports.o Experienced in implementing high availability and disaster Recovery solutions such as Log shipping, DB mirroring and Replication, Always On Availability Groups.o Excellent analytical, interpersonal, problem-solving and communication skills. o Adaptable to the agile development methodology/ Scrum, Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC.o Experienced in SQL production deployment with Change Control process using Team Foundation Server, Devops practices and CI/CD.o Upgraded and migrated SQL Servers from on - premises data center to another data center and on-premises data center to AWS Cloud.o Designed AWS CloudFormation templates to create custom-sized VPC, subnets, and NAT to ensure successful deployment of Web applications and database templates.o Designed roles and groups for users and resources using AWS Identity Access Management (IAM)o Provided highly durable and available data by using an S3 data store, versioning, lifecycle policies, and Creating AMIs for mission-critical production servers for backup.o Used Amazon RDS to manage, create snapshots, and automate the backup of the database to S3 bucket/Azure Blob Storage.o Utilized CloudWatch to monitor resources such as EC2, CPU memory, Amazon RDS DB services, DynamoDB tables, and EBS volumes; to set alarms for notification or automated actions, and to monitor logs for a better understanding and operation of the system.o Document system configurations, Instance, OS, and AMI build practices, backup procedures, and troubleshooting guides, and keep infrastructure and architecture drawings current with changes.

Experience

1. Sql Server Database Administrator

   Corelogic

   Aug 2016 — Present

   Years of IT experience in Database Administration, Design and Development and Support of MS SQL Server 2018/2008R2/2012 in Production, Test, Development Environments.• Experienced in RDBMS database design, performance tuning, optimization, backup and recovery, Index Tuning, Disaster Recovery Planning, Security Management.• Experience in T-SQL writing views, stored procedures and triggers • Experienced in using SQL Server Tools such as, Import/Export Wizard, Extended Events, SQL Profiler and SQL Query Analyzer.• Experienced in Database Migration from MS SQL Server 2005 to MS SQL Server 2008R2 and from 2008R2 to 2018.• Experienced in for DB Security such as creating logins, users, roles, and assigning permission.• Installed, configured, and administered SQL Server Reporting Services (SSRS), Developed and deployed Reports using SSRS,• Experienced in implementing high availability and disaster Recovery such as Log shipping, DB mirroring and Replication, Always On Availability Groups.• Applied SP (Service Pack) on various SQL server versions• Experienced in creating SSIS packages and scheduling job• Experienced in data extraction, transformation and loading(ETL) across different databases like MS Access and flat files using tools like Import and Export Wizard, and SSIS.• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).• Hands on experience in documentation for installation, monitoring procedures, security policies, configuration changes, migration procedures, and best practices. Experienced in Database deployment using SQL Server Data Tools and Dac Pack. Experienced in Source Control with TFS• Self starter while also enjoying team work