KIBREAB FISEHA

• Engineered and implemented 10 advanced database architectures, enhancing data storage and retrieval efficiency
• Optimized 75% of complex T-SQL queries, significantly improving data extraction and manipulation processes
• Spearheaded the implementation of 20 ETL packages using SSIS, streamlining data integration into the data warehouse
• Developed 30 comprehensive reports using SSRS and Power BI, facilitating detailed data analysis and decision-making
• Automated 50 routine tasks, boosting productivity and reducing manual efforts through SQL Server Agent and PowerShell
• Ensured high availability and robust disaster recovery strategies, including clustering and log shipping, to minimize downtime.
• Developed and implemented database security measures to ensure data protection.
• Assisted in disaster recovery planning by testing various backup strategies and scenarios.
• Configured user accounts, privileges, roles, profiles. in the database server.
• Tested application code changes before deploying them into production environment.
• Ensured that all the stored procedures are optimized for better performance of the system.

• Led the design and maintenance of SQL Server databases, applying best practices in database management and security
• Automated 75% of repetitive tasks, enhancing operational efficiency with SQL Server Agent
• Implemented replication between multiple servers to ensure high availability of the system.
• Developed and maintained comprehensive documentation, serving as a crucial reference for database architecture and maintenance
• Mentored team members, fostering a culture of continuous learning and adherence to best practices in database administration.
• Generated reports about server health status for review by senior IT personnel.
• Performed daily maintenance tasks such as backups, restores and log shipping operations.
• Developed and implemented strategies to ensure data integrity, reliability, and availability.
• Reviewed query execution plans to identify inefficient code or recommend index changes for improved performance.
• Troubleshot complex SQL queries to identify problems or potential improvements in performance.
• Tested newly created or modified SSRS reports before deployment into production environment.

• Optimized database performance by implementing tuning recommendations and creating indexed views and optimized stored procedures
• Ensured database security through the implementation of role-based access control and regular vulnerability assessments
• Collaborated with developers to design databases that supported application requirements, improving software development processes
• Provided timely resolution of critical production issues, minimizing downtime and avoiding potential revenue loss
• Developed comprehensive documentation on database architecture, simplifying future upgrades and maintenance tasks
• Collaborated with cross-functional teams to develop custom applications that supported business objectives and met user needs
• Created a robust disaster recovery plan to ensure business continuity in the event of hardware failures or natural disasters
• Served as an internal consultant for application developers, providing guidance on query optimization techniques that improved application performance
• Trained junior team members on best practices for database administration, promoting a culture of continuous learning
• Conducted regular audits of data quality, identifying inconsistencies and implementing corrective actions
• Developed scripts and processes for data integration and maintenance, ensuring data integrity and security
• Skilled in creating SSRS reports directly from data warehouse repositories, enhancing the accessibility and utility of information for informed decision-making
• Managed a high volume of client communications, responding to approximately 30 emails per day.

• Administered SQL Server environments, focusing on performance tuning and security enhancements
• Migrated SQL Server environments from earlier versions to 2012, documenting the process and ensuring seamless transitions
• Configured SQL Server Reporting Services (SSRS), optimizing report performance and security settings.
• Developed and implemented strategies to ensure data integrity, reliability, and availability.
• Automated routine tasks using PowerShell scripting language to streamline processes and reduce manual workloads.
• Created tables, views, functions, stored procedures and other database objects.
• Reviewed query execution plans to identify inefficient code or recommend index changes for improved performance.
• Maintained disaster recovery plans including backup schedules and testing procedures for recovering from unforeseen events.
• Monitored and optimized database performance using indexes, stored procedures, triggers, and other techniques.

• Implemented database partitioning strategies, achieving improved query response times and overall system performance
• Developed over 50 custom scripts for automating routine database tasks, significantly increasing productivity
• Created and managed 75% of Parameterized Reports, enhancing report generation processes and data accessibility.
• Troubleshot complex SQL queries to identify problems or potential improvements in performance.
• Analyzed existing databases for opportunities to improve efficiency through restructuring or re-indexing.
• Designed databases in accordance with industry best practices for scalability, security, reliability, and performance.
• Developed scripts for automating routine maintenance tasks such as index rebuilds and statistics updates.
• Configured user accounts, privileges, roles, profiles. in the database server.