mahlet yared
Phone: 832-***-**** E-mail **************@*******.***
1.Professional Summary
Over 7 years of experience in Microsoft SQL Server Database Installation, Configuration, Administration Maintenance and Performance Tuning, backup/restore and disaster recovery TDE to encrypt data experience in SQL server 2019/2017/2016/2014/2012/2008/2000
Installed and configured SQL server services in standalone and clustered environments.
Worked on SQL server licensing option and optimization based on server requirements.
Involved in Transparent Data Encryption (TDE) For security purpose and data protection.
Expertise in managing and running SQL server on VM aware machines.
Develop various aspect of database creation conversion and modification.
Skilled in writing T- SQL scripting and power shell languages for sending statement
managed sox related database and generated quarterly audit reports
implemented group level security using windows group account.
designed backup and recovery procedures for database security recoverability.
planned and executed database consolidation on multiple and single instance.
Involved in designing and implementing backend database storage for application installation as per the requirement of application installation document.
Migrate numerous databases across multiple environments while coordinating with different teams.
Extensive experience in creating and modifying stored procedures, index, views, triggers, cursers, and function to meet business requirements.
Expertise in implementing different types of high availability and disaster recovery mechanisms such as Log shipping, database mirroring clustering and always on availability group setup and configuration.
Worked on database replication to improve the availability and consistency of data.
Experienced in SQL server Reporting service (SSRS) installation configuration and maintenance using visual studio.
Develop integration service (SSIS)for transformation and movement data from SQL and non-SQL database into SQL server.
Involved in performance tuning and troubleshooting of windows, server and database level issues using SQL server and third-party tools.
Hands on experience in supporting Azure migrating database to Azure cloud.
Evaluated and advised a new hardware and software for purchase.
Demonstrate ownership and good skills on problem management.
Functioned successfully environment within a high pressure to meet deadlines.
Available responsive and accountable for all action made in database.
Addressed customer concerns and issues related to database management.
Helping developers improve their SQL related code writing skill.
Worked and mentor with junior DBA.
Work well 24X7 production database on call support.
Title – MS SQL SERVER DBA
Client – Alcon Medical Equipment –Houston, Texas September 2019 – Present
Responsibilities
Installation, Upgrade, Configuration and Migration of SQL Server in clustered and non-clustered production environments.
Managing Virtual Machine environments linked to MS SQL databases in both physical and VM ware hypervisor.
Setting up the Snapshot, Transactional and merge Replication in between SQL Server
SQL Server upgrades and migration from lower versions to SQL Server higher versions 2012/2014/2016/2017/2019.
SQL Server Performance Tuning and Query optimization- SQL Profiler, Query Execution plan, indexing strategies.
SQL Server High Availability and Disaster Recovery solutions- Always on Availability Groups, Failover Clustering, Mirroring, Log Shipping, Replication.
Experienced in TDE/Transparent Data Encryption.
Data modeling, Azure Data factory, Building Pipeline, SSIS, SSR.,
Capacity Planning, Storage Planning, Hardware Upgrade’s, and Preparing Estimates for database.
Incident and Problem Management focusing on continuous improvements and quality of service.
Involving on SQL Patching.
SQL Server Security Auditing, hardening and remediation.
Design and Implement Database Backup and Restore policies.
Automate routine maintenance tasks using PowerShell.
Build project documentation and troubleshooting guides.
Creates incident (ICM) related performance analysis and reporting for review by IT management
Participated in capacity planning and review database changes for system impact.
Performed backup using backup compression and data compression in SQL server databases on clustered environment.
Worked on database refresh by taking backup from production database to development servers.
Implemented high availability and disaster recovery setup on the various servers using windows clustering, replication, log-shipping, database mirroring and Always on Availability Group setup.
Database and Server Decommission and Consolidations.
Environment: Microsoft SQL Server 2019/2017/2016/2014/2012/2008R2 and Windows server 2016/2012/2012R2/2008R2/2008 Enterprise server, Microsoft Visual Studio, and third-party Redgate, Remedy, Spotlight, fresh service.
Title – SQL DBA
Client – Comcast Cable Houston, TX August 2017 – July 2019
Responsibilities
Design and Implement Database Backup and Restore policies.
Performed backup using backup compression and Data compression in SQL Server 2008R2 on clustered environment.
Involved in scheduling the reports to run on daily and weekly basis in Report Manager.
Maintaining referential integrity, domain integrity and column integrity by using the available options such as constraints.
Administrated and managed the SQL Server from 2008R2 to SQL Server 2019.
Set up SQL Server database configuration parameters for SQL Server High Availability and Disaster Recovery solutions- Always On Availability Groups, Failover Clustering, Mirroring, Log Shipping, Replication.
Design and Implement Database Backup and Restore policies.
Automate routine maintenance tasks using PowerShell.
Build project documentation and troubleshooting guides.
Participated in capacity planning and review database changes for system impact.
Implemented high availability and disaster recovery setup on the various servers using windows clustering, replication, log-shipping, database mirroring and Always on Availability Group setup.
Implemented and tested the point in time recovery of the production databases.
Worked on database refresh by taking backup from production database to development servers.
Automate routine maintenance tasks using PowerShell.
Build project documentation and troubleshooting guides
Environment: Microsoft SQL Server 2017/2016/2014/2012/2008R2 and Windows server 2016/2012/2012R2/2008R2/2008 Enterprise server, Microsoft Visual Studio, and third-party tools, ServiceNow, Remedy Redgate
SILICON LABS Austin Texas March 2015 – July 2017
DATABASE ADMISTRATOR
Maintaining the integrity and performance of databases and make sure the data is stored securely and optimally.
Database and Server Decommission and Consolidations.
Responsible for MS SQL Server 2000,2005 and 2008 and upgrades the servers.
Installation and configuration and apply service packs and hot fixes.
Upgrade databases from lower to higher SQL Server in line with application requirements and version support,
Set up SQL Server database configuration parameters for SQL Server High Availability and Disaster Recovery solutions- Always on Availability Groups, Failover Clustering, Mirroring, Log Shipping, Replication. SQL Server Security Auditing, hardening and remediation. Set up SQL Server database configuration parameters.
SQL Server High Availability and Disaster Recovery solutions- Always On Availability Groups, Failover Clustering, Mirroring, Log Shipping, Replication Involved in scheduling the reports to run on daily and weekly basis in Report Manager.
Maintaining referential integrity, domain integrity and column integrity by using the available options such as constraints.
Design and Implement Database Backup and Restore policies.
Automate routine maintenance tasks using PowerShell.
Build project documentation and troubleshooting guides.
Participated in capacity planning and review database changes for system impact.
Performed backup using backup compression and data compression in SQL server databases on clustered environment.
Worked on database refresh by taking backup from production database to development servers.
Education
Bachelors in computer science, ST. Marry University Addis Ababa, Ethiopia,
Associate in Accounting, Addis Ababa University college of commerce
Microsoft Certified MSSQL Server 2012 Database Administration