Yirgalem k. Dinku

SQL DBA

Maryland USA: Email: ad1o0z@r.postjobfree.com

Cell Phone: 561-***-****

Professional Summary

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

Possess strong communication and problem-solving skill developed through a variety of projects. Offer proven ability in team work and proactive system support.

Experience in Installing, configuring, administration and Maintenance of mission critical client databases in SQL server 2008, 2008R2, 2012, 2014, 2016, 2017 and 2019 versions.

Oracle 12C,11G,19C experience and oracle weblogic

Working knowledge about PostgreSQL, MongoDB and Oracle DB, DB2.

Good experience in configuring the SQL Server in AWS Relational Database Management system and in EC2.

Extensive Experience in Upgrading SQL Server (In place Up and Side by side Up grade) 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 tool.

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.

Experience in Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.

Created reports, sub reports, charts, Tablix, Matrix, Hyperlink reports.

Created jobs, alerts to run SSAS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job

Willing to relocate anywhere Add your headline

Work Experience

Sr. SQL DBA Administrator

Tata consulting services

January 2022 to present

Responsibilities:

Wealth of experience with RDS tools (relational database)

Troubleshot AWS issues and test aurora data

Experience in HIPPA and SOX requirements

Develop, implement, and maintain applications using MangoDB .

Experience in Monitoring and Tuning system resources associated with the database performance I/O and disk.

Validate servers

Involved in patching

Installing and configuration of SQL server

Upgrade SQL SERVERS

Migration of data from different platforms

Sr. SQL DBA Administrator

Community Health Systems

February 2020 to Jan 2022

Responsibilities:

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

Migrating to DB2 data base for 2 years

Have experience in installing oracle 19C and web logic.

Upgrading SQL server 2012 to SQL Server 2016 and 2017

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

Experience in setting up database transactional replication for reporting server, Using Backup and restore method.

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 Ola Hallengren's Industries best SQL server maintenance plan and created schedule for all environment.

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 trouble shooting 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.

Designed and developed ETL process using SSIS to load data from various sources like MS Access and SQL Server 2014, Oracle database

Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS)

Experience in migrating SQL Server 2012 and 2014 to SQL Server 2016 with AlwaysOn Availability

Good understanding in database and data warehousing concepts (OLTP & OLAP).

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases

Worked on BCP for data uploading module and create SSIS packages for data transfer & transform across locations and multiple data source as per requirement.

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.

Experience in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.

Experience supporting AWS DB in production and Development environment

SQL Server Database Administrator

John Deere - Chicago, IL

May 2015 to February 2020

Responsibilities:

working with management documentation such as CAPRS:

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 2008, 2008R2 & 2012.

Applied service packs, hotfixes and cumulative updates

Upgraded SQL Server 2005, 2008 and 2008 R2 Database into SQL Server 2012 and 2014

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 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 dead line before SLA is due.

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

Environment: Windows 2003-2012R2, SQL Server 2008-2014, IDERA SQL diagnostic

SQL DBA/Developer

Ethiopian Airlines

February 2012 to February 2015

SQL DBA

Responsibilities:

working with COTS monitoring system and CAB design

Worked on Sybase migration from SQL server ( 2 years )

Installed and configured SQL server 2008 and 2008/R2.

Created and updated databases, tables, stored procedures, triggers, functions, and views.

Configured, administered, and troubleshoot multiple databases in production and staging environment in clustered and standalone environments.

Planned backup strategies, scheduled backups, and performed restore operations.

Managed security of SQL server databases by creating logins, creating database users, creating roles, assigning proper permissions, creating server and database audits.

Worked on creating, reorganizing, and rebuilding index.

Worked on database space management, performance monitoring, and alert management.

Planned the location of files and increased the size and number of files.

Performed tasks of query optimization, troubleshooting client/server connectivity issues, and performance tuning.

Monitored and troubleshoot database and server performance at system-wide scale and effectively identify network, databases, Memory, CPU, Disk Space, and I/O related bottlenecks.

Extensively worked on SQL Server and T-SQL in constructing database objects.

Hands on experience in creating Maintenance plans, scheduling and Configuration

Experience in implementing SQL Server security and managing permission to users

Applied Service Packs and security updates for SQL server instances

Auditing stored procedures for optimization and improving performance

Developed SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from SQL Server.

Contact this candidate