Getnet Dena
Silver Spring,MD
Summary
Microsoft Certified Professional with 6+ years of IT experience in Maintenance, Automation of jobs, Backup, Recovery and Disaster recovery procedures, Design, Development, Installation, Configuration, Performance Tuning, Query Optimization, Client/Server Connectivity and Consistency Check, security and Implementing HADR solutions like Log shipping, mirroring, Replication, clustering and Always On of MS SQL Servers 2005/2008/ 2008r2/2012/2014/2017 and 2019 in Production, QA, Development environments. Managed SQL Server database management, upgrading, migrations and development in production and non-production environments. I am dedicated and hardworking and have the motivation needed to jump in and take control of my duties to ensure the job is done right and in a timely fashion.
Overview
6
6
years of professional experience
1
1
Certification
Work History
SQL Server DBA
CNA Insurance
Chicago, IL
04.2022 - Current
- Provided database support to business users and restored functionality to database processes that have failed, documented resolutions, and created and maintained troubleshooting documentation
- Employed general SQL, Microsoft T-SQL, stored procedures, Date Transformation Services (DTS) scripts, and SQL Server Integration Services (SSIS) to manage database systems and to automate data migration and processing
- Designed, developed, and implemented database tables, views, triggers, indexes, and stored procedures to ensure data integrity for custom applications
- Created and implemented scripts to automate data importing, exporting, reporting, and analysis to ensure data confidentiality, availability, and integrity
- Installing, configuring, administering, and securing production and non-production servers (clustered and non-clustered)
- Upgrading SQL server 2008 and 2012 to SQL Server 2016, 2017 and 2019
- Participated in an on-call support rotation and provide non-standard work hour support
- Experienced in implementing windows cluster across multiple availability zones and Implemented SQL Server 2016 Always On availability groups in Azure
- Managed SQL server Logins, Database users & roles and involved in Daily User Maintenance
- Consulted and worked with leadership team to drive technical and procedural change relative to best practices in database administration and ensures database high availability and reliability goals are achieved
- Created Database Maintenance jobs to perform full & transaction log Backups and scheduled them with the SQL Server agent job scheduler
- Monitored 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
- Extensively worked on troubleshooting and fine-tuning of databases for optimal performance
- Participated in the preparation, review, and analysis of database design and administration based on requirements and specifications
SQL Server DBA
Molina Healthcare
Long Beach, CA
12.2019 - 04.2022
- Created and updated databases, tables, stored procedures, triggers, functions, and views
- Configured, administered, and troubleshoot multiple databases in production and staging environments in clustered and standalone environments
- Prepared documentation for disaster recovery plan
- Involved in installing, monitoring and troubleshooting failover clustering on multiple nodes
- 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 indexes
- 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 identified network, databases, Memory, CPU, Disk Space, and I/O related bottlenecks
- Transferred data between several servers using BCP and DTS
- Provided resolution to assigned tickets (JIRA, Team Track and Service Now) as per their severity and meet the deadline before SLA is due
- Database High Availability: Installed, Configured, Maintained and Monitored AlwaysOn High Availability Groups on SQL Server 2016, 2017 and 2019
- Configured and implemented Log Shipping as Standby database from Production database for Reporting purposes
- Database Migration: Migrated MS Access 2003/2005/2008 R2 databases into MS SQL Server and Oracle 10g, MySQL into MS SQL Server 2012
- Data Modeling: Worked on more than 10 data modeling projects and generated E-R Diagrams
- Database Monitoring/Performance Tuning: Strong on database Monitoring and Performance tuning
- Skilled in SQL server agents creating jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification
- Database Programming: Wrote T-SQL, Trigger, and Stored-Procedures and assisted Database Developers to optimize SQL queries and Stored Procedures
- ETL Tools: Used ETL tools like DTS, SSIS, Import/Export, BCP (Bulk Copy), to import & export data from flat files, and excel to MS SQL Server databases
- Database Upgrade: Upgraded SQL Server SQL 2008, 2012,2014, and 2017
- Export & Import: Data from Oracle and SQL Server Excel and setup and performed ETL data load from Oracle and other flat files like text, Excel, and CSV files
- Backup/Recovery: Proficient in Database Backup and Disaster Recovery
- Experienced with Point-in-Time Recovery
- Restored Database from backup
- Installed, configured, and administered SQL Server Reporting Services and developed Reports using SSRS and developed Ad-hoc Reports using Report Builder 3.0, 2.0
Education
Bachelors - Computer Science
Hawassa University
Hawassa, Ethiopia01.2016
Skills
- Team member support
- Daily specials memorization
- Team collaboration
- Strong work ethic
Certification
MSCP – Administering SQL Server 2012/2014 and Querying Microsoft SQL Server 2012
Technicalknowledge
T-SQL, Windows CMD, PowerShell, MS-SQL Server (2005/2008/2012/2014/2016/2017/2019), Windows Server 2008R2/2012/2016+, Windows 7/8/10/11, Microsoft Office, SQL Server Management Studio, SQL Server Data Tools (SSIS, SSRS, SSAS), Microsoft Visual Studio, Database Engine Tuning Advisor, SQL Profiler, Performance Monitor, Idera, Redgate, ServiceNow, Jira, VMware, Virtual Box, Hyper-V, Microsoft Azure virtual machines, Active directory, DevOps, Azure data factory
Timeline
SQL Server DBA
CNA Insurance
04.2022 - Current
SQL Server DBA
Molina Healthcare
12.2019 - 04.2022
Bachelors - Computer Science
Hawassa University
Similar Profiles
Lisa BrownLisa Brown
Business Process Consultant at CNA InsuranceBusiness Process Consultant at CNA Insurance
Sarah HarrisSarah Harris
Underwriter Technician at CNA InsuranceUnderwriter Technician at CNA Insurance
GINALY ROCHAGINALY ROCHA
Claim Specialist at CNA InsuranceClaim Specialist at CNA Insurance