Marta Mengistu

Inver Grove Heights, MN *****

Cell phone: 763-***-****

E-Mail: adw3dr@r.postjobfree.com

EXPERIENCE

A highly qualified, goal-oriented IT professional with 9 plus years of experience in Microsoft SQL Server Database Administration including performance analysis, database design, security, and maintenance. Well versed in development and support of Microsoft SQL Server 2022/ 2019 / 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 in 24x7x365 environments including production, development, testing, cluster and replication server. PROFESSIONAL SUMMARY

• 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 aspects of database creation conversion and modification.

• Skilled in writing T- SQL scripting and power shell languages.

• 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 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.

• Work well 24X7 production database on call support. WORK EXPERIENCE

Title – SQL Database Administrator

Client —Wells Fargo Minneapolis, MN December 2022 – now

• Installation, Upgrade, Configuration and Migration of SQL Server in clustered and non- clustered production environments.

• Setting up the Snapshot, Transactional and merge Replication in between SQL Servers.

• 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.

• Transparent Data Encryption (TDE) For security purpose and data protection

• SQL Sentry to monitor, diagnose, and optimize Microsoft SQL Server environments.

• SQL Server High Availability and Disaster Recovery solutions- Always on Availability Groups, Failover Clustering, Mirroring, Log Shipping, Replication

• Capacity Planning, Storage Planning, Hardware Upgrade’s, and Preparing Estimates for database.

• Incident and Problem Management focusing on continuous improvements and quality of service.

• SQL Server Security Auditing, and SQL Statistics for optimization.

• Design and Implement Database Backup and Restore policies.

• Automate routine maintenance tasks using PowerShell.

• T- SQL creating Functions, Store Procedure, View, triggers.

• Build project documentation and troubleshooting guides.

• Participated in capacity planning and reviewing 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. Environment: Microsoft SQL Server 2022/2019/2017/2016/2014/2012/2008R2 and Windows server 2016/2012/2012R2/2008R2/2008 Enterprise server, Microsoft Visual Studio, and third- party Jira, Remedy, Spotlight, Agile Redgate Monitor, Redgate Data Compare, GoldGate. Title- SQL Server DBA

Client- HP, Houston, TX September 2019- November 2022

• 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.

• Transparent Data Encryption (TDE) For security purpose and data protection

• 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

• SQL Job manager Monitoring, Azure Resources, Auditing and Security Environment: Microsoft SQL Server 2016/2014/2012/2008R2 and Windows server 2016/2012/2012R2/2008R2/2008 Enterprise server, Microsoft Visual Studio, and third-party tools, ServiceNow, Remedy, Redgate

Junior SQL Database Administrator

Center Corporation, Kansas City, MO November 2017 —Augest2019

• Maintaining the integrity and performance of databases and making 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.

• Transparent Data Encryption (TDE) For security purpose and data protection

• 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. Environment: Microsoft SQL Server 2014/2012/2008R2 and Windows server 2012/2012R2/2008R2/2008 Enterprise server, Microsoft Visual Studio, and third-party tools service now, Remedy, Spotlight,

SQL Server DBA

TCF Bank, Minneapolis, MN September 2016 to October 2017

• 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, SSRS.

• Capacity Planning, Storage Planning, Hardware Upgrade’s, and Preparing Estimates for database.

• Incident and Problem Management focusing on continuous improvements and quality of service.

• Index review, database maintenance, Query Optimization, Performance monitoring, Alter management issue resolution.

• Involved on SQL Patching. configuring, administering, and troubleshooting AON technologies

(AOFCI & AOAGs)

• 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.

• T- SQL creating Functions, Store Procedure, View, triggers.

• 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.

Education

• Bachelor’s in marketing Rift Valley University, Adama, Ethiopia,

• Associate degree of Engineering in Computer Science, 2005, SDSU

• Microsoft Certified MSSQL Server 2012 Database Administration References available upon request.

Contact this candidate