Meftihe Walelign
Atlanta,GA
Summary
Experienced and detail-oriented Database Administrator with over 6 years of expertise in configuring, implementing, and maintaining robust database systems. Proven ability to optimize performance, ensure data integrity, and secure sensitive information. Expert with Microsoft SQL Server Maintenance, Performance Tuning, and disaster recovery. Expertise in Database Backup & Recovery for various mission-critical business applications. I prioritize minimizing downtime and maximizing data resilience to safeguard against potential disruptions whether it's setting up failover clustering, AlwaysOn Availability Groups, or log shipping.
Overview
7
7
years of professional experience
Work History
Senior SQL Server DBA
Sam’s Club
Bentonville, AR
03.2021 - Current
- Installation, configuration, and upgrading of SQL Server versions 2019, 2017, 2016, 2014, and 2012
- Performed Performance Tuning of the database, Stored Procedures, and SQL queries
- Involved in designing, configuring, monitoring, and troubleshooting replication methodologies, log shipping and mirroring on critical databases, and quickly resolving issues
- Ensured all database systems meet RPO & RTO policies
- Created tables, views, functions, stored procedures, and other database objects
- Developed PowerShell scripts to automate routine database management tasks, such as backups, restores, and log shipping
- Involved in Day-to-day activities such as Agent Jobs, Backups and Recovery, Services, Index, Database growth, health and consistency checks, and Data maintenance
- Implemented SQL Logins, Roles, and Authentication Modes as a part of Security Policies
- Modified the database structure, as necessary, from information given by application developers
- Extensively worked on upgrading Microsoft SQL server, failover clustering, log shipping, and replication
- Used tools such as System Monitor and SQL Server Profiler to identify blocks, discover slow-running queries, perform backup and recovery databases, and implement database modifications on production servers
- Involved in developing databases including creating new databases, converting old databases to new databases, modifying existing databases, and creating reports to meet business needs.
SQL Server DBA
General Dynamics Information Technology
Atlanta, GA
03.2019 - 02.2021
- Implemented high availability on various servers using Replication, Log-Shipping, and Mirroring
- Experience in performance tuning slow-running queries to reduce resource usage
- Developed and created database objects including tables, views, indexes, stored procedures and functions, advanced queries, and updated statistics using Query Analyzer
- Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, established joins, and created indexes whenever necessary
- Monitored SQL Server logs to ensure backup operations, batch commands, and scripts
- Installed necessary Service Packs on the SQL server
- Administered SQL Server by creating user logins with appropriate roles, monitoring the user accounts, creating groups, and granting privileges to users and groups
- Implemented DB Mirroring and Transactional Replication as part of High Availability and Log Shipping for the Disaster Recovery plan
- Modified Stored Procedures and complex T-SQL Queries to improve query execution process
- Created maintenance jobs by using PowerShell scripting
- Performed backup using backup compression and Data compression in SQL Server on a clustered environment
- Involved in scheduling the reports to run daily and weekly in Report Manager
- Administrated and managed the SQL Server production and non-production servers
- Utilized Redgate, SQL Compare, and Data Compare tools
- Involved in configuring high availability and disaster recovery solutions like replication, database mirroring, and log shipping
- Capable of individual work and an excellent team player, demonstrated through my ability to effectively collaborate with cross-functional teams and contribute to achieving team goals.
Junior SQL Server DBA
Accenture
Atlanta, GA
06.2017 - 03.2019
- Expert in creating and maintaining user security, managing users, their security privileges, and accesses
- Configured and audited SQL Server Security in line with business requirements, managed server logins-user accounts and passwords, and database object permissions- Client/server Connectivity
- Scheduled backups for Databases and Transaction logs and performed restoration operations proficiently in high availability solutions including Always on Availability Solutions
- Set up database Replication models, Log Shipping, Clustering, and Mirroring on Physical and Virtual machines
- Expertise in extracting and transforming data using data transformation services like BCP, Bulk insert, and attach/detach
- Implemented and tested the point-in-time recovery of the production database
- Experienced in creating SSIS packages using proper control and data flow elements.
- Installed and configured The SQL Server Reporting Services (SSRS) and maintenance of the Reporting Servers.
- Expert in analyzing locks, and deadlocks and handling the isolation levels and concurrency effects
- Hands-on experience with SQL Server Always On high availability groups and expert in implementing high availability solutions in SQL Server
- Good understanding of technical trends, and architectures and highly motivated to know more about the latest technology, new software, and products
- Team player with good communication and interpersonal skills
- Responsible for interacting with business partners to identify information needs and business requirements for reports
- Ability to handle multiple tasks concurrently and meet the deadlines.
- Assisted in disaster recovery planning by testing various backup strategies and scenarios.
- Developed and enforced database administration policies and procedures.
- Collaborated with IT team to integrate databases with other applications.
Education
BBA - Computer Information Systems
Georgia State University
Skills
- Database Administration
- Microsoft SQL Server Maintenance
- Performance Tuning
- Disaster Recovery
- Database Backup & Recovery
- Failover Clustering
- AlwaysOn Availability Groups
- Log Shipping
- PowerShell Scripting
- Agent Jobs
- Security Policies
- Database Structure Modification
- System Monitor
- SQL Server Profiler
- Database Development
- High Availability
- Replication
- Mirroring
- T-SQL Queries
- Query Optimization
- Indexing
- SQL Server Logs Monitoring
- Service Packs Installation
- User Management
- Backup and Restoration
- Data Transformation Services
- Point-in-Time Recovery
- Locks and Deadlocks Analysis
- Isolation Levels
- SQL Server Always On
- Technical Trends and Architectures
- Communication Skills
- Interpersonal Skills
- Database Management
- Microsoft SQL
Timeline
Senior SQL Server DBA
Sam’s Club
03.2021 - Current
SQL Server DBA
General Dynamics Information Technology
03.2019 - 02.2021
Junior SQL Server DBA
Accenture
06.2017 - 03.2019
BBA - Computer Information Systems
Georgia State University