Summary
Overview
Work History
Education
Skills
Timeline
Generic

Lidia G Gebrehiwot

Round Rock,USA

Summary

MS SQL Database Administrator with over 7 years of experience with MS SQL versions 2022/2019/2017/2016/2014/2012. Installed, Configured, monitored, maintained & improved the performance of databases. Designed and implemented comprehensive backup plans and disaster recovery strategies. Conducted regular audit and performance tuning of both system and user databases. Ensured high availability for smooth running of the business by implementing HADR solutions including “Always-on” for High Availability Groups, WSFC and Data Base Mirroring. Scheduled on MSSQL Server Agent, maintained, backup/restore and monitoring tasks. Direct experience with MSSQL Server Business Intelligence (BI) services such as SSIS, SSRS & SSAS. Implemented database security management and permission grant to access data by logins & users. Trouble shot database issues such as space, deadlocks, performance & blocking. Tested and Validated Disaster Recovery and business continuity plans at large projects. Work experience with Software Testing Life Cycle (STLC) processes and provided effective support in the Software Development Life Cycle (SDLC) processes. Direct experience in Database Backup and Restore, Database Refresh and Migration. Always willing to learn innovative technology and easily adapts to unfamiliar environments. Professional SQL specialist with strong track record in database management, optimization, and security. Proven ability to enhance performance and ensure data integrity. Known for effective team collaboration and adaptability in dynamic environments. Skilled in SQL scripting, troubleshooting, and database architecture, delivering reliable and efficient solutions. Knowledgeable [Desired Position] with solid background in managing and optimizing SQL databases. Proven ability to ensure database performance and data integrity, having successfully led multiple database migration projects. Demonstrated skills in troubleshooting and performance tuning, ensuring high availability and reliability. Database professional with extensive experience in SQL database management, providing robust data solutions and ensuring optimal performance. Known for strong collaborative efforts in team projects and consistently delivering reliable results. Proficient in database optimization, query tuning, and maintaining high data integrity standards. Experienced with SQL database management, ensuring high availability and data integrity. Utilizes advanced troubleshooting techniques and performance tuning to enhance system efficiency. Strong understanding of database security measures and disaster recovery planning. Systematic Database Developer with [Number] years of experience in designing, engineering architecture and data modeling. Proven track record managing all phases of software development lifecycle (SDLC). Analytical thinker quickly and effectively identifies and resolves technical problems. SQL Developer with [Number] years of progressive experience in [System], 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. Driven Database Developer with [Number] years of proven success designing and implementing database solutions. Analytical and skilled in understanding business problems to develop systems that improve functionality. Talented at working effectively in collaborative and self-motivated environments. Driven Database Architect with [Number] years of experience in full lifecycle development. Goal-oriented team player succeeds working with various colleagues and clients by maintaining communication. Motivated with keen analytical, problem-solving and task management abilities. Efficient administrator eager to leverage knowledge in cloud-based database management systems. Skilled in database security, backup and recovery with good understanding of automation and containerization tools. Team-oriented with stong work ethic. High-performing professional with extensive experience managing large-scale, complex databases. Skilled in SQL and database management systems. Strong understanding of database design and data modeling with excellent troubleshooting skills. Smart and committed to staying up-to-date with new technologies and advancements. Top-notch [Job Title] with solid background in designing and implementing data management solutions. Strong knowledge of database security, backup and recovery. Collaborative and dedicated to improving and optimizing database performance. Dynamic individual with hands-on experience in [Area of expertise] and talent for navigating challenges. Brings strong problem-solving skills and proactive approach to new tasks. Known for adaptability, creativity, and results-oriented mindset. Committed to making meaningful contributions and advancing organizational goals. Equipped with strong problem-solving abilities, willingness to learn, and excellent communication skills. Poised to contribute to team success and achieve positive results. Ready to tackle new challenges and advance organizational objectives with dedication and enthusiasm. Hardworking and passionate job seeker with strong organizational skills eager to secure entry-level [Job Title] position. Ready to help team achieve company goals. Results-oriented achiever with proven ability to exceed targets and drive success in fast-paced environments. Combines strategic thinking with hands-on experience to deliver impactful solutions and enhance organizational performance. Tech-savvy innovator with hands-on experience in emerging technologies and passion for continuous improvement. Skilled in identifying opportunities for technological enhancements and implementing effective solutions. Adept at leveraging new tools and methods to solve problems and enhance productivity. Excels in adapting to fast-paced environments and driving technological advancements. Proactive and goal-oriented professional with excellent time management and problem-solving skills. Known for reliability and adaptability, with swift capacity to learn and apply new skills. Committed to leveraging these qualities to drive team success and contribute to organizational growth. Recent graduate with foundational knowledge in [Area of study] and hands-on experience gained through academic projects and internships. Demonstrates strong teamwork, problem-solving, and time-management skills. Prepared to start career and make meaningful contributions with commitment and drive. Possesses versatile skills in project management, problem-solving, and collaboration. Brings fresh perspective and strong commitment to quality and success. Recognized for adaptability and proactive approach in delivering effective solutions. Thorough team contributor with strong organizational capabilities. Experienced in handling numerous projects at once while ensuring accuracy. Effective at prioritizing tasks and meeting deadlines. Innovative technology professional with several years of diverse experience. Skilled in enhancing systems and aligning technical solutions with business objectives. Proven success in leading projects from start to finish and contributing to organizational growth and success. Pursuing full-time role that presents professional challenges and leverages interpersonal skills, effective time management, and problem-solving expertise. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals. Demonstrates strong analytical, communication, and teamwork skills, with proven ability to quickly adapt to new environments. Eager to contribute to team success and further develop professional skills. Brings positive attitude and commitment to continuous learning and growth. Experienced leader with strong background in guiding teams, managing complex projects, and achieving strategic objectives. Excels in developing efficient processes, ensuring high standards, and aligning efforts with organizational goals. Known for collaborative approach and commitment to excellence. Detail-oriented individual with exceptional communication and project management skills. Proven ability to handle multiple tasks effectively and efficiently in fast-paced environments. Recognized for taking proactive approach to identifying and addressing issues, with focus on optimizing processes and supporting team objectives.

Overview

7
7
years of professional experience

Work History

SQL Database Administrator

Access2care-Timely Route
01.2023 - Current
  • Provides SQL Server Database Administration and monitoring support across production, development, and test environments
  • Installed and configured SQL Server 2014-2019
  • Directs database migration and upgrade from 2014 to 2017 and from 2016 to 2019
  • Monitors databases and resolves any issues that may arise
  • Identify slow-running queries and run performance tuning by examining the execution plans and creating missing indexes to boost the query performance
  • Oversees data migration from Excel, Flat file, Sybase, Oracle to Microsoft SQL Server by using BCP and DTS utilities as well as SSIS with ETL
  • Monitors disk capacity and allocates space according to the overall needs of users, available data storage, and database management system requirements in all environments
  • Tracks database server resources and provides recommendations on hardware and software upgrades to increase overall performance
  • Expert in performance monitoring and tuning, query optimization, client/server connectivity, and database consistency checks using DBCC utilities
  • Utilizes customer requirements to improve functionality (speed, performance, and usability)
  • Provides 24/7 support on weekdays and on a rotational basis on weekends and during production routine tasks

SQL Database Administrator

Curative Labs Inc
11.2020 - 01.2023
  • Prepared, maintained, and modified SQL Server installation and configuration documents
  • Implemented and configured HADR solutions like clustering, always on for high availability groups, mirroring, replication, and log shipping on physical machines
  • Executed on Active-Active/Active-Passive clustering and configured synchronous and asynchronous mirroring for high availability and Disaster Recovery solutions
  • Managed deployment and overseeing maintenance of new databases, schemas, and database objects both in production and lower environments
  • Expert level execution in query optimization and improving database efficiency through maintenance tasks, re-indexing, updating statistics, recompiling stored procedures and cleanup history
  • Database design, development, SQL Query optimization, performance tuning, production support, and maintenance review, disaster recovery planning and ensure high availability
  • Monitored database performance, storage methods and management system software to fine-tune the database optimum response time
  • Monitored capacity and allocate space according to overall needs of users, available data storage and database management system requirements
  • Troubleshot problems related to the availability of data to users, space, database software, data flow and information storage or data access
  • Set-up the Transactional Replication between different SQL Server databases
  • Created maintenance plans and jobs to achieve maximum performance and data integrity

SQL Database Administrator

The Boeing Company
05.2017 - 11.2020
  • Environment: SQL Server 2017, 2016, 2014, 2012 Enterprise, Windows Enterprise Server, Microsoft Reporting Services (SSRS)
  • Installed & Configured MSSQL Server 2016
  • Migrated & Upgraded MSSQL 2014-2017
  • Tasked for releases from development to test and production environment
  • Involved in designing, configuring, monitoring, and troubleshooting various problems
  • Maintained Database health and growth by implementing regular consistency check, Backup/Restore, shrinking, re-indexing, updating statistics, and maintenance cleanup
  • Managed SQL Server databases access security privileges and permissions for groups, users and logins roles and supported in administration task of SQL Server of schemas
  • Implemented and scheduled jobs with replication process for updating existing parallel servers and automatic messaging services on server failures, task completion and success for 24/7 production support including on call rotation
  • Designed bulk loading of data through BCP and DTS packages, managing replication of data, configured and managed linked servers
  • Designed and developed file loading process by using stored procedures, functions and bind them with DTS package for logical execution, use DTS packages for migration of data from SQL Server to MS Access or Oracle databases
  • Tuned the performance of SQL queries and stored procedures using SQL profiler and Index Tuning Wizard

Education

Certificate - Project Management

California Institute of Technology

Bachelor of Science - Electrical Engineering

University of Texas at Arlington
01.2008

Skills

  • Windows Server 2022/2019/2017/2016/2014/2012,2008R
  • T-SQL
  • Power shell
  • C
  • C
  • Microsoft SQL Server 2012/2014/2016/2017/2019/2022
  • MySQL
  • SSIS
  • SSRS
  • SSAS
  • Erwin
  • SQL Server Management Studio (SSMS)
  • SQL Server Data Tools (SDT)
  • SQL Profiler
  • Performance Monitor
  • DTS/SSIS(ETL)
  • Database Tuning Advisor (DTA)
  • Microsoft Clustering
  • PowerPoint
  • Outlook
  • Cloud Database Services
  • Azure
  • DMA
  • DTA
  • Redgate
  • MS Office (Excel, Outlook)
  • Visio
  • Project
  • SSDT
  • Microsoft Teams
  • M365 Tools
  • Planner
  • Windows and SQL clustering
  • SQL Replication CDC
  • Log Shipping
  • Always-on Availability Groups
  • AWS
  • Oracle Database Management
  • Issue Resolution
  • Best Practices
  • Ethics and Integrity
  • Leadership and Collaboration
  • Communication
  • SQL Server Integration Services
  • Database monitoring
  • SQL Server Analysis Services
  • Stored Procedures
  • Query Optimization
  • Backup and recovery
  • Data Migration
  • Database Design
  • ETL processes
  • Database Security
  • Cloud Database Management
  • Capacity Planning
  • Resource Governor
  • Triggers and functions
  • Disaster Recovery
  • Database Maintenance
  • Data Modeling
  • Performance Tuning
  • Data Warehousing
  • Schema Management
  • SQL Server Reporting Services
  • Index Management
  • Replication Strategies
  • Partitioning Techniques
  • Normalization techniques
  • Server configuration
  • Cross-Platform Compatibility
  • ETL development
  • Agile Methodology
  • System Testing
  • Linux Operating System
  • Relational Database Management
  • Document Management
  • Customer Needs Assessment
  • Python
  • Presentations
  • Root Cause Analysis
  • Data audits
  • Code debugging
  • Patch management
  • End-User Training
  • Systems administration
  • Data Security
  • Database Management
  • Relational databases
  • Transaction Management
  • Database Development
  • Database Administration
  • Continuous Process Improvement
  • Running backups
  • Interdepartmental communication
  • Compiling Data
  • Process Automation
  • Storage virtualization
  • Microsoft NET framework
  • Database locking
  • Data testing
  • Writing queries
  • Microsoft PowerShell
  • Database backup
  • Process scheduling
  • Coding data
  • Continuous integration
  • Database documentation
  • Data integration
  • Microsoft SQL
  • Data utilization
  • Safety protocol
  • Database analysis
  • Security report management
  • Version control
  • Data conversion and migration
  • Teamwork and Collaboration
  • Problem-Solving
  • Time Management
  • Attention to Detail
  • Problem-solving abilities
  • Multitasking
  • Multitasking Abilities
  • Reliability
  • Excellent Communication
  • Critical Thinking
  • Organizational Skills
  • Team Collaboration
  • Team Leadership
  • Active Listening
  • Effective Communication

Timeline

SQL Database Administrator

Access2care-Timely Route
01.2023 - Current

SQL Database Administrator

Curative Labs Inc
11.2020 - 01.2023

SQL Database Administrator

The Boeing Company
05.2017 - 11.2020

Bachelor of Science - Electrical Engineering

University of Texas at Arlington

Certificate - Project Management

California Institute of Technology
Lidia G Gebrehiwot